mybatis逆向工程的创建和使用

末蓝、 2022-06-06 06:52 181阅读 0赞

总结了老师以及网上各位大佬的逆向工程，现终于配置出适合自己的一款了。

1.先在网上下载到zip压缩包

![Center][]

2.解压后是这样子的

![Center 1][]

3.找到解压路径（D:\\Reverse Engineering\\mybatis-generator-core-1.3.2\\lib）下的generator.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="D:\Reverse Engineering\mybatis-generator-core-1.3.2\lib\mysql-connector-5.1.8.jar" />
        <context id="testTables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    		
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/crm?characterEncoding=utf-8" 
                userId="root"
                password="123456">
            </jdbcConnection>
    		
            
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.qfedu.pojo"
                targetProject="D:\Reverse Engineering\mybatis-generator-core-1.3.2\lib">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    		
            
            <sqlMapGenerator targetPackage="com.qfedu.mapper" 
                targetProject="D:\Reverse Engineering\mybatis-generator-core-1.3.2\lib">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    		
            
            <javaClientGenerator type="XMLMAPPER"
                targetPackage="com.qfedu.mapper" 
                targetProject="D:\Reverse Engineering\mybatis-generator-core-1.3.2\lib">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    		
            
    		<table tableName="base_dict" domainObjectName="Dict"
    			enableCountByExample="false"
    			enableUpdateByExample="false" enableDeleteByExample="false"
    			enableSelectByExample="false" selectByExampleQueryId="false">
    		</table>
    		<table tableName="customer" domainObjectName="Customer"
    			enableCountByExample="false"
    			enableUpdateByExample="false" enableDeleteByExample="false"
    			enableSelectByExample="false" selectByExampleQueryId="false">
    		</table>
    		<table tableName="sys_user" domainObjectName="User"
    			enableCountByExample="false"
    			enableUpdateByExample="false" enableDeleteByExample="false"
    			enableSelectByExample="false" selectByExampleQueryId="false">
    		</table>
            
        </context>
    </generatorConfiguration>

需要注意的位置：  
  
  
javaModelGenerator,生成PO类的位置  
sqlMapGenerator,mapper映射文件生成的位置  
javaClientGenerator,mapper接口生成的位置  
table,指定数据库表

操作的表是这三个

![Center 2][]

4.双击cmd.exe  复制下边的代码 mysql就粘贴第一句就行  回车

mysqld的：  java -jar mybatis.jar -configfile generator.xml -overwrite
    
    orcal的：  java -jar mybatis.jar -configfile generatorOracle.xml -overwrite

5.创建完成

![Center 3][]

[Center]: /images/20220606/9cc73829d29249aaafe87a0304a1a9d5.png
[Center 1]: /images/20220606/157d01b7373449899fde4a1d720196c0.png
[Center 2]: /images/20220606/3cdaf1bdb8df48659d2a811004a17260.png
[Center 3]: /images/20220606/098fd62494be4bc0826424d502c38c5e.png