Idea中Mybatis逆向工程生成domain、mapper以及mapper.xml（多插件配置）

秒速五厘米 2022-11-27 07:29 467阅读 0赞

**前言：本篇博客主要说明如何使用mybatis逆向工程快速生成domain，mapper以及mapper.xml，还添加了多个插件来使得逆向工程生成的Dao层更加的强大，基本上涵盖了单表操作所需要的方法。**

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

### 文章目录 ###

*   *  一。环境配置
     *  二。数据库表示例
     *  三。逆向工程配置与启动
     *  四。生成代码截图。

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

## 一。环境配置 ##

**1.在pom.xml文件中引入mybatis逆向工程以及各个插件的配置：**

<plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.7</version>
                    <configuration>
                        <configurationFile>
                            mybatis-generator/generatorConfig.xml
                        </configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.46</version>
                        </dependency>
                        <dependency>
                            <groupId>com.itfsw</groupId>
                            <artifactId>mybatis-generator-plugin</artifactId>
                            <version>1.2.12</version>
                        </dependency>
                    </dependencies>
                </plugin>

**2.注意，该插件配置是放在`<build>`标签下的`<plugins>`标签中：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center]

## 二。数据库表示例 ##

**1.以下是一个新建的学生表（student）示例：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 1]

## 三。逆向工程配置与启动 ##

**1.配置文件的配置：新建generatorConfig.xml逆向工程配置文件，在该配置文件中配置多插件配置信息，数据库连接信息，domain、mapper以及mapper.xml生成位置，需要逆向生成Model层和Dao层的数据表等：**

<?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="mysqlgenerator" targetRuntime="MyBatis3">
            <property name="autoDelimitKeywords" value="true"/>
            
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
            
            <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"/>
    
            
            
            <plugin type="com.itfsw.mybatis.generator.plugins.SelectOneByExamplePlugin"/>
            
            <plugin type="com.itfsw.mybatis.generator.plugins.SelectSelectivePlugin"/>
            
            <plugin type="com.itfsw.mybatis.generator.plugins.ExampleEnhancedPlugin"/>
            
            <plugin type="com.itfsw.mybatis.generator.plugins.ModelColumnPlugin"/>
            
            <plugin type="com.itfsw.mybatis.generator.plugins.LogicalDeletePlugin">
                
                
                <property name="logicalDeleteColumn" value="deleted"/>
                
                <property name="logicalDeleteValue" value="1"/>
                
                <property name="logicalUnDeleteValue" value="0"/>
            </plugin>
    
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
            </commentGenerator>
    
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/interact?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&verifyServerCertificate=false&useSSL=false" userId="root" password="root"/>
    
            <javaTypeResolver>
                <property name="useJSR310Types" value="true"/>
            </javaTypeResolver>
    
            <javaModelGenerator targetPackage="com.hdyanfa.interact.domain" targetProject="src/main/java"/>
            <sqlMapGenerator targetPackage="com.hdyanfa.interact.mapper" targetProject="src/main/resources"/>
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.hdyanfa.interact.mapper" targetProject="src/main/java"/>
            
            <table tableName="student">
                <generatedKey column="id" sqlStatement="MySql" identity="true"/>
            </table>
    
        </context>
    </generatorConfiguration>

**2.generatorConfig.xml所在位置：**

![在这里插入图片描述][2020081417522972.png_pic_center]

**3.配置maven命令运行该generatorConfig.xml文件：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 2]

**4.点击添加maven指令：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 4]  
**5.选择项目地址，添加`mybatis-generator:generate -e`指令：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 5]

**6.选择刚刚新建的maven指令，点击运行：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 6]

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

**7.maven指令运行成功，代码已自动生成：**

![在这里插入图片描述][20200815092157614.png_pic_center]  
![在这里插入图片描述][20200815092223646.png_pic_center]

![在这里插入图片描述][20200815092252907.png_pic_center]

## 四。生成代码截图。 ##

**1.Student：**

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

**2.StudentExample：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 9]

**3.StudentMapper：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 10]

**4.StudentMapper.xml:**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 11]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221124/815bcf705caf42f4996d7b339b73bfda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221124/3f9e566773cf406686ca969b90b21920.png
[2020081417522972.png_pic_center]: /images/20221124/dadff51837f64dbfbcaca1033ae9a151.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221124/8b7c00fdaca04d0b8de923e80862421b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221124/d8dcda93c8174d1e932599152fcc9755.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221124/f62253d6696c4c4ea4d8e1403e5582d6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221124/1f29ac7fe0c140acbef1e81e7644671a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221124/bba6a3e56fd04095be800781a7af082a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 7]: /images/20221124/f8c223b8e75541c382a1e6a035cf0813.png
[20200815092157614.png_pic_center]: /images/20221124/d2926ac1154946169bb8c1d894ceb63e.png
[20200815092223646.png_pic_center]: /images/20221124/c8ca89c95c55427abf7982d8382e97c8.png
[20200815092252907.png_pic_center]: /images/20221124/788da7a107ac43efa35218b06ab0ea85.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 8]: /images/20221124/50bc98c568ec46e19d68e0a4812323d4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 9]: /images/20221124/ecc9f51b9db347178487368277602fa3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 10]: /images/20221124/19a057e2780f4dea813fd8d2918fc07a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwOTQ0Nw_size_16_color_FFFFFF_t_70_pic_center 11]: /images/20221124/c508b943aefe48bb99a6498b157feede.png