11_逆向工程

àì夳堔傛蜴生んèń 2023-09-30 19:46 1阅读 0赞

MyBatis的一个主要的特点就是需要程序员自己编写SQL，那么如果表太多的话，难免会很麻烦，所以MyBatis官方提供了一个逆向工程，可以针对单表自动生成MyBatis执行所需要的代码（包括mapper.xml，mapper.java，pojo）。一般在开发中，常用的逆向工程方式是通过数据库的表生成代码。

创建maven项目导入逆向工程依赖

![a2de3a4c1baf64941dcd44109b52ab59.png][]

<dependencies>
      
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>
        
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.6.1</version>
        </dependency>
        
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.2</version>
        </dependency>
    </dependencies>

![4e7818c64bee436ca238dfbadcb7b950.gif][]

![01c2871ee785912d715721ffad998d78.gif][]

配置逆向工程配置文件 在resources目录下放置一个名为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="testTables" targetRuntime="MyBatis3">
          <commentGenerator>
             
             <property name="suppressAllComments" value="true" />
          </commentGenerator>
          
          
           <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
             connectionURL="jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"
             userId="root"
             password="root">
          </jdbcConnection> 
          
          <javaTypeResolver>
             <property name="forceBigDecimals" value="false" />
          </javaTypeResolver>
          
          <javaModelGenerator targetPackage="com.msb.pojo"
             targetProject=".\src">
             
             <property name="enableSubPackages" value="false" />
             
             <property name="trimStrings" value="true" />
          </javaModelGenerator>
            
          <sqlMapGenerator targetPackage="com.msb.mapper"
             targetProject=".\src">
             
             <property name="enableSubPackages" value="false" />
          </sqlMapGenerator>
          
          <javaClientGenerator type="XMLMAPPER"
             targetPackage="com.msb.mapper"
             targetProject=".\src">
             
             <property name="enableSubPackages" value="false" />
          </javaClientGenerator>
          
          
          <table tableName="dept" domainObjectName="Dept"
           enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                   enableSelectByExample="false" selectByExampleQueryId="false" >
                   <columnOverride column="id" javaType="Integer" />
             </table>
          
       </context>
    </generatorConfiguration>

![8c1100815ac174384add1221ce6ca59c.gif][]

![945bc7820c6fc712c24cddc3cc19d594.gif][]

在resources目录下放置一个名为log4j.properties的配置文件,文件内容如下

log4j.rootLogger=debug,stdout
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.Target=System.err
    log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout
    log4j.appender.logfile=org.apache.log4j.FileAppender
    log4j.appender.logfile.File=d:/msb.log
    log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
    log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %l %F %p %m%n

![570a161eab0f63669c7ffe046279d84a.gif][]

![d0f434aa80275c96f32ad1c4898f9087.gif][]

运行逆向工程代码

package com.msb.gennerator;
    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.File;
    import java.util.ArrayList;
    import java.util.List;
    /**
     *
     */
    public class GeneratorSqlmap {
        public void generator() throws Exception{
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            File configFile = new File("D:\\ideaProjects\\reverse\\target\\classes\\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);
        }
        public static void main(String[] args) throws Exception {
            try {
                GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();
                generatorSqlmap.generator();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

![b9806d6a062d8d743a05771f05bf8f55.gif][]

![4f160c70bcb3d94e9fe844875ddbedb2.gif][]

生成的实体类和Mapper接口和Mapper映射文件,包含了基本的CURD功能,哪里需要文件就放哪里

![bf9e2b27d21db7fe29cb4b3db84bd715.png][]

[a2de3a4c1baf64941dcd44109b52ab59.png]: https://img-blog.csdnimg.cn/img_convert/a2de3a4c1baf64941dcd44109b52ab59.png
[4e7818c64bee436ca238dfbadcb7b950.gif]: https://img-blog.csdnimg.cn/img_convert/4e7818c64bee436ca238dfbadcb7b950.gif
[01c2871ee785912d715721ffad998d78.gif]: https://img-blog.csdnimg.cn/img_convert/01c2871ee785912d715721ffad998d78.gif
[8c1100815ac174384add1221ce6ca59c.gif]: https://img-blog.csdnimg.cn/img_convert/8c1100815ac174384add1221ce6ca59c.gif
[945bc7820c6fc712c24cddc3cc19d594.gif]: https://img-blog.csdnimg.cn/img_convert/945bc7820c6fc712c24cddc3cc19d594.gif
[570a161eab0f63669c7ffe046279d84a.gif]: https://img-blog.csdnimg.cn/img_convert/570a161eab0f63669c7ffe046279d84a.gif
[d0f434aa80275c96f32ad1c4898f9087.gif]: https://img-blog.csdnimg.cn/img_convert/d0f434aa80275c96f32ad1c4898f9087.gif
[b9806d6a062d8d743a05771f05bf8f55.gif]: https://img-blog.csdnimg.cn/img_convert/b9806d6a062d8d743a05771f05bf8f55.gif
[4f160c70bcb3d94e9fe844875ddbedb2.gif]: https://img-blog.csdnimg.cn/img_convert/4f160c70bcb3d94e9fe844875ddbedb2.gif
[bf9e2b27d21db7fe29cb4b3db84bd715.png]: https://img-blog.csdnimg.cn/img_convert/bf9e2b27d21db7fe29cb4b3db84bd715.png