图解 IDEA 中 springboot 项目 MyBatis Generator 逆向生成实体类及 mapper 配置文件

妖狐艹你老母 2022-03-30 02:16 257阅读 0赞

[前些天发现了一个巨牛的人工智能学习网站，通俗易懂，风趣幽默，忍不住分享一下给大家。点击跳转到教程。][Link 1]

一、准备工作：

1. 新建一个 配置文件：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>
    
        
        <classPathEntry location="D:\gentle\gentle\mysql-connector-java-5.1.39.jar"/>
    
        <context id="Mysql" targetRuntime="MyBatis3" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
            <property name="javaFileEncoding" value="UTF-8"/>
    
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://47.98.162.28:3306/gentle"
                            userId="root"
                            password="123456">
            </jdbcConnection>
    
            
            <javaModelGenerator targetPackage="gentle.entity"
                                targetProject="src/main/java">
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="gentle.mapper.xml"
                             targetProject="src/main/java">
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="gentle.mapper"
                                 targetProject="src/main/java">
            </javaClientGenerator>
    
            
            <table tableName="sys_user" domainObjectName="User">
                <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
            </table>
    
            <table tableName="sys_resources" domainObjectName="Resources">
                <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
            </table>
    
            <table tableName="sys_role" domainObjectName="Role">
                <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
            </table>
    
        </context>
    </generatorConfiguration>

2. pom.xml 中增加包、插件依赖：

<dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>2.0.4</version>
            </dependency>

<plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>8.0.11</version>
                        </dependency>
                        <dependency>
                            <groupId>tk.mybatis</groupId>
                            <artifactId>mapper</artifactId>
                            <version>4.0.4</version>
                        </dependency>
                    </dependencies>
                </plugin>

二、生成：（有 2 种生成方式，第 2 种生成的启动方式见第 6 点。个人觉得第2种方式更简单。）

3. idea 最右侧 `maven project` ：点击 `Plugins `\->  `mybatis-generator`,  再点击  `mybatis-generator:generate `即可。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70][]

4. 自动生成实体类和 mapper，这一步是点击后自动运行的，效果如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 3][]

5. 生成成功后的文件，如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 4][]

附：对于自动生成的 Example 类的使用说明见文章：[mybatis 逆向工程生成的 Example 类的使用][mybatis _ Example]

6. 第 2 种启动生成代码的方式：

1）点击如图位置，开启设置窗口

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 5][]

2）添加 maven选项：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 6][]

3）设置生成命令：**mybatis-generator:generate -e **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 7][]

最后点击 OK，保存。

4）启动生成，点击运行按钮即可。

![20190104150746896.png][]

生成后的效果同于上面方法。

[Link 1]: https://www.captainai.net/jiangyu1013/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70]: /images/20220330/e39b123972d641d8830d394f1f2811ac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 1]: /images/20220330/f81f83bcaaa34b9ca07fc47efd1b3a16.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 2]: /images/20220330/780e8f3073424a63bf850073f436487e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 3]: /images/20220330/3f02087b5b0c43e2bcb0386874447162.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 4]: /images/20220330/8e8b12953c1a4294a6576adcb1c071f7.png
[mybatis _ Example]: https://blog.csdn.net/jiangyu1013/article/details/85777905
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 5]: /images/20220330/a629db3b80374623b3cfa14fbf3e5124.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 6]: /images/20220330/6bf107f928f9447bb94175fe1104e9bb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEzMTQ0NDI_size_16_color_FFFFFF_t_70 7]: /images/20220330/af61d84e02204da6aa6a81e6a868453b.png
[20190104150746896.png]: /images/20220330/4c738a51de6a4effb41fb3f4d54c161e.png