MyBatis反向生成（IDEA+Maven）

﹏ヽ暗。殇╰゛Y 2022-05-21 03:37 195阅读 0赞

# MyBatis反向生成（IDEA+Maven） #

## 一、什么是反向生成工程 ##

反向生成工程，可以针对数据库表自动生成MyBatis执行所需要的代码，比如实体类代码、mapper.xml、mapper接口等，可以提高开发效率。

本文将介绍如何使用IDEA+Maven实施反向生成工程。

## 二、使用方法 ##

### 1、创建Maven项目 ###

创建好的项目目录结构如下：

![70][]

### 2、配置Maven的pop.xml文件 ###

下载反向工程说需要的jar包，pop.xml文件代码如下：

<project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
       xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4\_0\_0.xsd">  
   <modelVersion>4.0.0</modelVersion>  
   <groupId>MyBatisGenerator1</groupId>  
   <artifactId>MyBatisGenerator1</artifactId>  
   <packaging>war</packaging>  
   <version>1.0-SNAPSHOT</version>  
   <name>MyBatisGenerator1 Maven Webapp</name>  
   <url>http://maven.apache.org</url>  
  
   <properties>  
     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  
        
      <mybatis-version>3.4.5</mybatis-version>  
   </properties>  
  
   <dependencies>  
      <dependency>  
         <groupId>junit</groupId>  
         <artifactId>junit</artifactId>  
         <version>3.8.1</version>  
         <scope>test</scope>  
      </dependency>  
  
        
      <dependency>  
         <groupId>org.mybatis</groupId>  
         <artifactId>mybatis</artifactId>  
         <version>$\{mybatis-version\}</version>  
      </dependency>  
        
     <dependency>  
         <groupId>org.mybatis.generator</groupId>  
         <artifactId>mybatis-generator-core</artifactId>  
         <version>1.3.5</version>  
      </dependency>  
        
      <dependency>  
         <groupId>org.mybatis</groupId>  
         <artifactId>mybatis-spring</artifactId>  
         <version>1.3.1</version>  
      </dependency>  
        
      <dependency>  
         <groupId>mysql</groupId>  
         <artifactId>mysql-connector-java</artifactId>  
         <version>5.1.30</version>  
      </dependency>  
  
  
   </dependencies>  
   <build>  
      <finalName>MyBatisGenerator1</finalName>  
   </build>  
</project>

### 3、反向工程配置文件 ###

这个配置文件就是generatorConfig.xml，里面配置了数据库的连接属性、需要反向生成的数据库表及其属性。操作步骤有：

（1）添加要生成的数据库表

（2）实体类、mapper接口Java类所在的包路径

（3）SQL语句的mapper.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="default" targetRuntime="Mybatis3" >
    
            
            <commentGenerator type="generator.MyCommentGenerator">
                
                
            </commentGenerator>
    
            
            
                    
                    
                    
                    
                
                
                
                
            
    
            
            <jdbcConnection
                    driverClass="com.mysql.jdbc.Driver"
                    connectionURL="jdbc:mysql://localhost:3306/testmysql"
                    userId="root"
                    password="root">
            </jdbcConnection>
    
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
    
            
            <javaModelGenerator targetPackage="com.charlie.ssm.demo.entity"
                                targetProject="src/main/java">
    
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="false"/>
                
                <property name="trimStrings" value="true"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper"
                             targetProject="src/main/resources">
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
    
            
            <javaClientGenerator targetPackage="com.charlie.ssm.demo.entity"
                                 targetProject="src/main/java" type="XMLMAPPER" >
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
    
            
            
                   
                   
                   
            
    
            <table tableName="tb_user" domainObjectName="UserEntity" mapperName="UserDao"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
    
    
        </context>
    </generatorConfiguration>

### 4、运行程序生成代码 ###

运行MainGenerator的main方法，就可运行反向工程，注意反向工程的配置文件路径要正确。

运行代码如下：

/**  * 运行此方法重新生成mybatis相关的文件，慎用  * 运行之后会覆盖com.dao 以及com.entity的类，但是对应的mapper/*.xml中的数据库操作  */ public class MainGenerator {
    
        /**      * MyBatis反向生成工程      * @param args      */     public static void main(String[] args) {
            try {
                System.out.println("MyBatis反向生成");
                List<String> warnings = new ArrayList<>();
                boolean overwrite = true;
                //配置文件
                File configFile = new
                        File("./src/main/resources/generator/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);
                System.out.println("执行完毕");
            } catch (IOException e) {
                e.printStackTrace();
            } catch (XMLParserException e) {
                e.printStackTrace();
            } catch (InterruptedException e) {
                e.printStackTrace();
            } catch (InvalidConfigurationException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

### 5、运行结果 ###

![70 1][]

## 三、下载地址 ##

[https://download.csdn.net/download/qq\_33721382/10506541][https_download.csdn.net_download_qq_33721382_10506541]

[70]: /images/20220521/874381e0be594291a787a337c6cfb62d.png
[70 1]: /images/20220521/b8a434f1deee4017ac5dc96de103f08f.png
[https_download.csdn.net_download_qq_33721382_10506541]: https://download.csdn.net/download/qq_33721382/10506541