springboot集成generator逆向生成工具

1、本地数据库已经创建好了一个表person，结构如下：

2、打开Idea，用SpringInitialiazer新建一个项目，pom文件添加依赖，如下所示：

<?xml version="1.0" encoding="UTF-8"?>
<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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
   <modelVersion>4.0.0</modelVersion>
   <parent>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-parent</artifactId>
       <version>2.6.7</version>
       <relativePath/> <!-- lookup parent from repository -->
   </parent>
   <groupId>com.javaclimb</groupId>
   <artifactId>generate</artifactId>
   <version>0.0.1-SNAPSHOT</version>
   <name>generate</name>
   <description>Demo project for Spring Boot</description>
   <properties>
       <java.version>1.8</java.version>
   </properties>
   <dependencies>
       <dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-starter</artifactId>
       </dependency>

       <dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-starter-test</artifactId>
           <scope>test</scope>
       </dependency>

       <!--mysql-->
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>8.0.20</version>
       </dependency>
       <dependency>
           <groupId>org.mybatis.spring.boot</groupId>
           <artifactId>mybatis-spring-boot-starter</artifactId>
           <version>2.2.0</version>
       </dependency>

       <!--阿里数据库连接池 -->
       <dependency>
           <groupId>com.alibaba</groupId>
           <artifactId>druid-spring-boot-starter</artifactId>
           <version>1.2.4</version>
       </dependency>

       <!-- mybatis逆向工程依赖 -->
       <dependency>
           <groupId>org.mybatis.generator</groupId>
           <artifactId>mybatis-generator-core</artifactId>
           <version>1.4.1</version>
       </dependency>
   </dependencies>

   <build>
       <plugins>
           <plugin>
               <groupId>org.mybatis.generator</groupId>
               <artifactId>mybatis-generator-maven-plugin</artifactId>
               <version>1.3.2</version>
               <configuration>
                   <overwrite>true</overwrite>
                   <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
               </configuration>
           </plugin>
       </plugins>
   </build>

</project>

3、项目配置文件Application.yml

server:
 port: 8888
spring:
 main:
   allow-circular-references: true
 datasource:
   driver-class-name: com.mysql.cj.jdbc.Driver
   url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8
   username: root
   password: 123456
   hikari:
     max-lifetime: 1000000
 thymeleaf:
   cache: false #关闭缓存
 servlet:
   multipart:
     max-file-size: 100MB
     max-request-size: 100MB

mybatis:
 mApper-locations: classpath:mApper/*.xml
 type-aliases-package: com.javaclimb.entity

pagehelper:
 helper-dialect: mysql
 reasonable: true
 support-methods-arguments: true
 params: count=countSql

authority:
 info: '[]'

logging:
 file:
   path: log
   name: log/my.log
 level:
   com:
     javaclimb:
       dao: debug

4、mybaits逆向工程配置文件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元素用于指定生成一组对象的环境。targetRuntime:此属性用于指定生成的代码的运行时环境。MyBatis3:*这是默认值*-->
   <context id="DB2Tables" targetRuntime="MyBatis3">
       <commentGenerator>
           <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
           <property name="suppressAllComments" value="false" />
           <!-- 阻止注释中包含时间戳 true：是 ： false:否 -->
           <property name="suppressDate" value="true" />
           <!--  注释是否包含数据库表的注释信息  true：是 ： false:否 -->
           <property name="addRemarkComments" value="true" />
       </commentGenerator>
       <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
       <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                       connectionURL="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=GMT%2b8"
                       userId="root"
                       password="123456">
           <property name="useInformationSchema" value="true"/>
       </jdbcConnection>
       <!-- 如使用oracle请参考如下 -->
       <!-- <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
           connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
           userId="test"
           password="test">
       </jdbcConnection> -->

       <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
           NUMERIC 类型解析为java.math.BigDecimal -->
       <javaTypeResolver>
           <property name="forceBigDecimals" value="false"/>
       </javaTypeResolver>

       <!-- targetProject:生成PO类的位置 -->
       <javaModelGenerator targetPackage="com.javaclimb.entity"
                           targetProject=".\src\main\java">
           <!-- enableSubPackages:是否让schema作为包的后缀 -->
           <property name="enableSubPackages" value="false"/>
           <!-- 从数据库返回的值被清理前后的空格 -->
           <property name="trimStrings" value="true"/>
       </javaModelGenerator>
       <!-- targetProject:mApper映射文件生成的位置 -->
       <sqlMapGenerator targetPackage="mAppers"
                        targetProject=".\src\main\resources">
           <!-- enableSubPackages:是否让schema作为包的后缀 -->
           <property name="enableSubPackages" value="false"/>
       </sqlMapGenerator>
       <!-- targetPackage：mApper接口生成的位置 -->
       <javaClientGenerator type="XMLMAppER"
                            targetPackage="com.javaclimb.mApper"
                            targetProject=".\src\main\java">
           <!-- enableSubPackages:是否让schema作为包的后缀 -->
           <property name="enableSubPackages" value="false"/>
       </javaClientGenerator>

       <!-- 指定数据库表 -->
       <table tableName="person" enableCountByExample="false" enableUpdateByExample="false"
              enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"
              enableSelectByPrimaryKey="true" enableUpdateByPrimaryKey="true" enableDeleteByPrimaryKey="true"></table>

       <!-- 有些表的字段需要指定java类型
        <table schema="" tableName="">
           <columnOverride column="" javaType="" />
       </table> -->
   </context>
</generatorConfiguration>

5、生成类

package com.javaclimb.generate;

import org.junit.jupiter.api.Test;
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 org.springframework.boot.test.context.SpringBootTest;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

@SpringBootTest
class GenerateApplicationTests {
   @Test
   void contextLoads() throws Exception {
       List<String> warnings = new ArrayList<String>();
       boolean overwrite = true;
       //下一行中的是存放generator配置的路径，切记不要写错
       File configFile = new File("src/main/resources/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);
   }
}

6、最终效果

百度云盘资源：链接：https://pan.baidu.com/s/10Jmrt5IUtzizRcv7MhkuKA 
提取码：nkqh