mysql代码生成器

项目 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 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.example</groupId><artifactId>mysql_generator</artifactId><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-dependencies</artifactId><!--java8能支持的最高版本,从2.6.x开始,不在支持java8--><version>2.5.15</version><relativePath/> <!-- lookup parent from repository --></parent><dependencies><!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-web --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><version>3.3.0</version></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-generator</artifactId><version>3.5.9</version></dependency><!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter --><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.9</version></dependency><!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-core --><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-core</artifactId><version>3.5.9</version></dependency><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.33</version></dependency><!-- https://mvnrepository.com/artifact/org.freemarker/freemarker --><dependency><groupId>org.freemarker</groupId><artifactId>freemarker</artifactId><version>2.3.33</version></dependency><!-- https://mvnrepository.com/artifact/org.projectlombok/lombok --><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.34</version><scope>provided</scope></dependency><!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger2 --><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger2</artifactId><version>3.0.0</version></dependency><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger-ui</artifactId><version>3.0.0</version> <!-- 请根据需要使用最新版本 --></dependency></dependencies>
</project>

方式一：

java 代码

方式三：后面补

插件操作;
首先在工程的pom.xml中，根节点project下添加build节点，如下：
在这里插入图片描述

<build><resources><resource><directory>src/main/resources</directory><filtering>true</filtering></resource></resources><plugins><plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.7</version><configuration><verbose>true</verbose><overwrite>true</overwrite></configuration><dependencies><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.21</version></dependency></dependencies></plugin></plugins>
</build>

生成配置 generatorConfig.xml

在 src/main/resources 下添加配置文件： generatorConfig.xml ，用于配置生成风格，数据库连接、生成代码包路径、生成哪些表等等，各配置参数详解参考注释：

<!DOCTYPE generatorConfiguration PUBLIC"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration><!-- MyBatis3Simple风格 --><context id="simple" targetRuntime="MyBatis3Simple"><property name="javaFileEncoding" value="UTF-8"/><!--生成mapper.xml时覆盖原文件--><plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin"/><commentGenerator><!-- 是否去除自动生成的注释 true：是 ： false:否。 自动生成注释太啰嗦，可以编码扩展CommentGenerator --><property name="suppressAllComments" value="true"/></commentGenerator><!-- 数据库连接 --><jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/db_book?useUnicode=true&amp;characterEncoding=utf8&amp;tinyInt1isBit=true&amp;serverTimezone=UTC"userId="root" password="root"><!-- 设置为true就只读取db_book下的表, 否则会优先读取到mysql的user表  --><property name="nullCatalogMeansCurrent" value="true"/></jdbcConnection><!-- 生成PO的包名和位置 --><javaModelGenerator targetPackage="org.tg.book.dal.po.mbg" targetProject="src/main/java"/><!-- 生成XML映射文件的包名和位置 --><sqlMapGenerator targetPackage="org.tg.book.dal.mapper.mbg" targetProject="src/main/resources"/><!-- 生成Dao/Mapper接口的包名和位置 --><javaClientGenerator type="XMLMAPPER" targetPackage="org.tg.book.dal.mapper.mbg" targetProject="src/main/java"/><!--        &lt;!&ndash; 要生成那些表(更改tableName和domainObjectName就可以) &ndash;&gt;&lt;!&ndash; 如果要生产Example类，则将下面的false改为true &ndash;&gt;<table tableName="%"  enableCountByExample="false"enableUpdateByExample="false"enableDeleteByExample="false"enableSelectByExample="false"selectByExampleQueryId="false" />
--><!-- 要生成对应表配置 --><table tableName="user" domainObjectName="User" ><!-- 自增主键列 --><generatedKey column="id" sqlStatement="MYSQL" identity="true"/><!-- tinyint映射为Integer --><columnOverride column="role" javaType="Integer" jdbcType="TINYINT"/></table></context>
</generatorConfiguration>