mybatis-generator逆向工程生成model dao mapping

╰半橙微兮° 2022-06-13 02:16 190阅读 0赞

mybatis-generator逆向工程实现具体步骤

generatorConfig.xml

mybatis-generator-core-1.3.2.jar

mysql-connector-java-5.1.7-bin.jar

上面三个文件放到项目目录下  src之上    运行完命令后 F5刷新下

[![image][]][image 1]

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="mysql-connector-java-5.1.7-bin.jar"/>    
        <context id="DB2Tables"  targetRuntime="MyBatis3">    
            <commentGenerator>    
                <property name="suppressDate" value="true"/>    
                    
                <property name="suppressAllComments" value="true"/>    
            </commentGenerator>    
                
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1/gaokao" userId="root" password="root">   
            </jdbcConnection>    
            <javaTypeResolver>    
                <property name="forceBigDecimals" value="false"/>    
            </javaTypeResolver>    
                
            <javaModelGenerator targetPackage="com.ma.model" targetProject="src\main\java">   
                <property name="enableSubPackages" value="true"/>    
                <property name="trimStrings" value="true"/>    
            </javaModelGenerator>    
                
            <sqlMapGenerator targetPackage="com.ma.mapping" targetProject="src\main\java">   
                <property name="enableSubPackages" value="true"/>    
            </sqlMapGenerator>    
                
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.ma.dao" targetProject="src\main\java">   
                <property name="enableSubPackages" value="true"/>    
            </javaClientGenerator>    
                
            <table tableName="admin" domainObjectName="Admin" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> 
              <table tableName="student" domainObjectName="Student" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> 
                <table tableName="university" domainObjectName="University" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> 
        </context>    
    </generatorConfiguration>

targetProject写的是相对路径  前面可能不加项目名称也对    只要是相对路径就行

在eclipse里面打开控制台     项目右键—>Show In --->Terminal

当以上这些完成之后，只需要打开控制台，进入与     第一步加入的三个文件  同级目录下，执行脚本

[Java][] \-jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml –overwrite

如果出现Unknown argument: ––overwrite 这个报错

试试去掉–overwrite：[Java][] -jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml

出现下面就是成功了

[![image][image 2]][image_image 2][![image][image 3]][image_image 3]

[image]: /images/20220613/1c06ca1f512b4f5a85ea2a5c710c68a1.png
[image 1]: https://img-blog.csdn.net/20170623174216999
[Java]: http://lib.csdn.net/base/javase
[image 2]: https://img-blog.csdn.net/20170623174218045
[image_image 2]: https://img-blog.csdn.net/20170623174217910
[image 3]: https://img-blog.csdn.net/20170623174218820
[image_image 3]: /images/20220613/42879b7bc83b482bb4d2cc5fd1704029.png