MyBatis代码生成器（反向工程）使用示例

Dear 丶 2023-10-04 10:31 5阅读 0赞

## MyBatis Generator (MBG) ##

MyBatis的代码生成器（反向工程），通过数据库表自动生成Entity、Dao代码。

> http://mybatis.org/generator/index.html

## 使用 ##

创建一个maven工程  
![MyBatisGeneratorRunner][]

*  pom.xml

<dependencies>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.4.0</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
        </dependencies>

*  MyBatisGeneratorRunner.java

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;
    
    import java.io.InputStream;
    
    /**
     * @author markix
     *
     * http://mybatis.org/generator/index.html
     * http://mybatis.org/generator/configreference/xmlconfig.html
     */
    public class MyBatisGeneratorRunner {
        
    
        private static final String CONFIG_XML = "generatorConfig.xml";
    
        public static void main(String[] args) throws Exception {
        
            InputStream configFile = MyBatisGeneratorRunner.class.getClassLoader().getResourceAsStream(CONFIG_XML);
            ConfigurationParser cp = new ConfigurationParser(null);
            Configuration config = cp.parseConfiguration(configFile);
            DefaultShellCallback callback = new DefaultShellCallback(true);
    
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, null);
            myBatisGenerator.generate(null);
        }
    
    }

*  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="context" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/test_db?useSSL=true"
                            userId="root"
                            password="root">
            </jdbcConnection>
    
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.markix.entity" targetProject=".">
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="com.markix.mapper.xml" targetProject=".">
            </sqlMapGenerator>
    
            
            <javaClientGenerator targetPackage="com.markix.mapper" targetProject="." type="XMLMAPPER">
            </javaClientGenerator>
    
            
            <table tableName="sys_user"></table>
    
    
    
    
    
        </context>
    </generatorConfiguration>

*  log4j.properties

log4j.rootLogger=DEBUG, Console
    #Console
    log4j.appender.Console=org.apache.log4j.ConsoleAppender
    log4j.appender.Console.layout=org.apache.log4j.PatternLayout
    log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
    log4j.logger.java.sql.ResultSet=INFO
    log4j.logger.org.apache=INFO
    log4j.logger.java.sql.Connection=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

根据项目需要，调整generatorConfig.xml配置，运行MyBatisGeneratorRunner的main方法即可。

[MyBatisGeneratorRunner]: https://img-blog.csdnimg.cn/20210411234919424.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMxNzcyNDQx,size_16,color_FFFFFF,t_70