Mybatis逆向工程相关代码生成步骤（绝对好用）

待我称王封你为后i 2021-11-24 01:34 372阅读 0赞

**逆向工程的生成如官方给出的方法，有四种：**  
①用Ant  
②用maven  
③用java  
④用Eclipse  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70]  
**逆向工程官方学习文档链接地址：**  
[http://www.mybatis.org/generator/running/runningWithJava.html][http_www.mybatis.org_generator_running_runningWithJava.html]

**博主使用的是java Project项目生成它，接下来我们一起来创建逆向工程项目。**

--------------------

## ①首先创建一个简单的java Project项目 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][2019072713475736.png]

## ②导入相关jar包 ##

**创建一个lib文件夹存放相关jar包。**  
![在这里插入图片描述][2019072713550079.png]  
**选中全部jar包。**  
![在这里插入图片描述][20190727135542614.png]  
**右键->Build Path->Add to Build Path**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 2]  
**生成Referenced Library**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 3]

## ③编写日志文件和测试类以及相应的xml文件 ##

**完整项目样例图：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 4]

**测试类Generator.java**  
**上面的文档里也有，基本都是这个模板，需要注意的只是import，可以和博主的对照一下。**

package com.generator;
    
    import java.io.File;
    import java.util.ArrayList;
    import java.util.List;
     
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class Generator { 
    	
    	public static void main(String[] args) throws Exception{ 
    		 
    		List<String> warnings = new ArrayList<String>();
    		boolean overwrite = true;
    		File configFile = new File("generatorConfig.xml"); 
    		ConfigurationParser cp = new ConfigurationParser(warnings);
    		Configuration config = cp.parseConfiguration(configFile);
    		DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    		MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,
    				callback, warnings);
    		myBatisGenerator.generate(null);
     
    	} 
    }

**日志文件log4j.properties**  
**模板（我也是搬过来的(o°ω°o)）：**

### \u8BBE\u7F6ELogger\u8F93\u51FA\u7EA7\u522B\u548C\u8F93\u51FA\u76EE\u7684\u5730 ###
     
    log4j.rootLogger=debug,stdout,logfile
     
    ### \u628A\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u63A7\u5236\u53F0 ###
     
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    #log4j.appender.stdout.Target=System.err
    log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout
     
     
    ### \u628A\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u6587\u4EF6\uFF1Ajbit.log ###
    log4j.appender.logfile=org.apache.log4j.FileAppender
    log4j.appender.logfile.File=jbit.log
    log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
    log4j.appender.logfile.layout.ConversionPattern=%d{ yyyy-MM-dd HH:mm:ss} %F %p %m%n
     
     
    ###\u663E\u793ASQL\u8BED\u53E5\u90E8\u5206
    log4j.logger.com.ibatis=DEBUG
    log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
    log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
    log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
    log4j.logger.java.sql.Connection=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

**xml文件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>
    
      <context id="DB2Tables" targetRuntime="MyBatis3">
      	
      	<commentGenerator>
        	
        	<property name="suppressAllComments" value="true"/>
        </commentGenerator>
      	
      	
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
            connectionURL="jdbc:mysql://localhost:3306/shop?serverTimezone=GMT%2B8"
            userId="root"
            password="root">
        </jdbcConnection>
    	
    	
    	
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    
    	
    	
        <javaModelGenerator targetPackage="com.mybatisblog.pojo" 
        targetProject=".\src">
        
          <property name="enableSubPackages" value="false" />
          
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    
    
    	
        <sqlMapGenerator targetPackage="com.mybatisblog.mapper"  targetProject=".\src">
        
          <property name="enableSubPackages" value="false" />
        </sqlMapGenerator>
    
    
    	
        <javaClientGenerator type="XMLMAPPER" 
        targetPackage="com.mybatisblog.mapper"  
        targetProject=".\src">
        
          <property name="enableSubPackages" value="false" />
        </javaClientGenerator>
    
    
    	
    	<table schema="" tableName="blog"></table>
    
      </context>
    </generatorConfiguration>

**注意：博主的是8版本的驱动包的连接池，5版本的参考如下文章：**  
[https://blog.csdn.net/qq\_41083009/article/details/96478350][https_blog.csdn.net_qq_41083009_article_details_96478350]

## ④测试 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 5]  
**日志打印语句;**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 6]  
**右键刷新一下项目：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 7]

**就根据数据表的结构自动生成了相应的实体类和接口，然后就可以把需要的代码拷贝到相应的项目中去了，是不是很方便。**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 8]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70]: /images/20211122/155af0a874a34ec6bda1e7b0257c49ba.png
[http_www.mybatis.org_generator_running_runningWithJava.html]: http://www.mybatis.org/generator/running/runningWithJava.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 1]: /images/20211122/fcf4a9c022c4484780d4090ebb5cdc29.png
[2019072713475736.png]: /images/20211122/52446c3658504f42a8bf469e767179c6.png
[2019072713550079.png]: /images/20211122/4bba7e949bb8488ea9d29eab11da7a5f.png
[20190727135542614.png]: /images/20211122/c8f782c8f7b146bcb72f0eced31e2cc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 2]: /images/20211122/148f03f9896843a9b7a649e22cc862f4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 3]: /images/20211122/b48d9c9a05fc4c2aa928857a400e55bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 4]: /images/20211122/4f6cf60a80944b2bb2aa0b8dbd80b536.png
[https_blog.csdn.net_qq_41083009_article_details_96478350]: https://blog.csdn.net/qq_41083009/article/details/96478350
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 5]: /images/20211122/b0cc3560377547c1a792d919e84c956a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 6]: /images/20211122/194d0f77622c4eb0a58aa761c7f7e008.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 7]: /images/20211122/913f1c9f9a434852be0c3d92f254e9ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgzMDA5_size_16_color_FFFFFF_t_70 8]: /images/20211122/47736f9041e2474188c83be02e16c694.png