mac下使用mybatis-generator命令行生成mapper、model、xml

向右看齐 2022-03-26 07:10 399阅读 0赞

由于新开迁移项目，所以需要将ibatis改为mybatis，原项目的表多的不行，sql改造工作量很大。因此想到使用mybatis-generator，但是由于公司内网不方便搭建，最后决定使用直接运行jar来生成文件，无需在IDEA中配置项目。

1.首先下载两个jar包

mybatis-generator-core-1.3.5.jar

mysql-connector-java-6.0.6.jar

地址：

http://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core

http://mvnrepository.com/artifact/mysql/mysql-connector-java

2.创建文件夹存放这些文件  
![20190116110741794.png][]

3.配置generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
      PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
      "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
     
    <generatorConfiguration>
        
        <classPathEntry location="/Users/xxxx/Desktop/mybatis/mysql-connector-java-5.1.47.jar" />  
        <context id="context1" targetRuntime="MyBatis3">
     
            
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
                <property name="suppressDate" value="true" />
            </commentGenerator>
     
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/数据库名?useSSL=false" 
                userId="用户名"
                password="密码" />
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
     
            
            
            
            <javaModelGenerator targetPackage="model"
                targetProject="/Users/xxxx/xxx/mybatisFile">
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
                
            </javaModelGenerator>
            
            
            <sqlMapGenerator targetPackage="mapper"
                targetProject="/Users/xxxx/xxxx/mybatisFile">
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
     
            
            
            <javaClientGenerator targetPackage="mapper"
                targetProject="/Users/xxxx/xxxx/mybatisFile" type="XMLMAPPER">
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
     
            
            
            
             <table  tableName="表名" domainObjectName="do名字" enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
        </context>
    </generatorConfiguration>

4.命令行运行jar

java -jar /Users/XXX/Desktop/audomake/mybatis-generator-core-1.3.5.jar -configfile /Users/XXX/Desktop/audomake/generatorConfig.xml -overwrite

参考文章：[https://blog.csdn.net/hdfqq188816190/article/details/77868809][https_blog.csdn.net_hdfqq188816190_article_details_77868809]

[20190116110741794.png]: /images/20220326/a91fafca6a94490eb5e81e247b014777.png
[https_blog.csdn.net_hdfqq188816190_article_details_77868809]: https://blog.csdn.net/hdfqq188816190/article/details/77868809