史上最全最简单 SpringBoot + maven + mybatis-generator 逆向生成工具

本是古典何须时尚 2024-04-18 23:06 31阅读 0赞

# 注意注意注意：本文章为 MAC 开发环境，如果小伙伴们用的 Windows 开发环境。请将配置中所有有关于路径的 \[ / 替换为 \\ 并在路径开头加上 .\\ \]（注意是所有的所有的所有的） #

例:
    src/main/resources/mybatis-generator/generatorConfig.xml
    修改为: 
    .\src\main\resources\mybatis-generator\generatorConfig.xml

## 话不多说，直接开撸！！！ ##

**一、环境搭建，我这里默认大家都是会搭建环境的，所以直接跳过**

**二、上代码：**

1、pom.xml 配置：![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70]

<build>
        <plugins>
            <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.2</version>
                <configuration>
                    <configurationFile>src/main/resources/mybatis-generator/generatorConfig.xml</configurationFile>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.34</version>
                    </dependency>
                    <dependency>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <version>1.3.2</version>
                    </dependency>
                </dependencies>
            </plugin>
        </plugins>
    </build>

2、generatorConfig.xml 配置：

里面注释都已经非常详细了，我就不一一介绍啦，原谅我偷个小懒，哈哈哈哈。。。。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 1]

<?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>
    
    <properties resource="mybatis-generator/generator.properties"/>
    
    
    <classPathEntry location="${jdbc.driverLocation}"/>
    
    <context id="default" targetRuntime="MyBatis3">
        
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
    
        
        <jdbcConnection driverClass="${jdbc.driverClass}"
                        connectionURL="${jdbc.host}"
                        userId="${jdbc.user}"
                        password="${jdbc.password}"/>
    
        
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
    
    
        
        
        
        <javaModelGenerator targetPackage="com.pph.demo.model" targetProject="src/main/java">
            
            <property name="enableSubPackages" value="false"/>
            
            <property name="constructorBased" value="true"/>
            
            <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.pph.demo.mapper" targetProject="src/main/java" type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
    
        
        <table tableName="login_log_info" domainObjectName="LoginLogInfo"
               enableCountByExample="false" enableUpdateByExample="false"
               enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false"/>
    </context>

3、generator.properties 配置：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 2]

# mybatis-generator-core maven 仓库中 mybatis-generator-core.jar 包绝对路径
    jdbc.driverLocation=/这里咱俩不可能同名啦/org/mybatis/generator/mybatis-generator-core/1.3.2/mybatis-generator-core-1.3.2.jar
    #mysql driver
    jdbc.driverClass=com.mysql.jdbc.Driver
    # mysql jdbc host
    jdbc.host=jdbc:mysql://localhost:3306/pph
    # mysql 用户名
    jdbc.user=root
    # mysql 密码
    jdbc.password=pph123

4、配置启动 mybatis-generator：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 4]

【C V】大法秘籍在此
    
    Name: mybatis-generator
    Commond line:mybatis-generator:generate -e

5、实践检验真理：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 6]

我 mysql 的版本：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 7]  
**最后跟大家来个小总结： maven 依赖包里面的版本尽量和我上面的保持一致，有时候可能因为版本问题导致生成失败的。**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/34498b0382a344f7be3e3066910cece2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/319c6dbaa14745f1bbe31b4b09bb4fa8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/248f2ca1c15d4378bcea178c7537464e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/43ef819139f749deafb4e19845035145.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c4d7bc3ffba64fc0b0e78ff57b47a952.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/69d0456d68c341f8b4413165a92075b0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c2727973f69b4840ae63768caf058c9a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY3MDQ1NQ_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/ae55e1ef93f947558f0793023243fc5e.png