Springboot集成mybatis-generator

逃离我推掉我的手 2023-09-26 16:14 77阅读 0赞

**一、mybatis-generator介绍**

mybatis-geneator 是一款 mybatis 自动[代码生成][Link 1]工具，生成的文件包含三类：

（1）Model实体文件，一个数据库表对应生成一个 Model 实体；  
（2）Mapper接口文件Dao，数据数操作方法都在此接口中定义；  
（3）Mapper 和 XML 配置文件

二、mybatis-generator集成

1.在pom.xml文件中添加依赖

![5fa6ec497d6e4b1588b9db8b430a2869.png][]

pom.xml文件

<?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.7.5</version>
            <relativePath/> 
        </parent>
        <groupId>com.hng</groupId>
        <artifactId>example</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>example</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>17</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>com.mysql</groupId>
                <artifactId>mysql-connector-j</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.4</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>15</source>
                        <target>15</target>
                    </configuration>
                </plugin>
                
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.7</version>
                    <configuration>
                        <configurationFile>${basedir}/src/main/resources/mybatis-generator-config.xml</configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>8.0.26</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    
    
    </project>

2.创建mybatis-generator-config.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>
        
        <properties resource="application.properties"></properties>
        
    
    
        
        <context id="default">
            
            <commentGenerator>
                
                <property name="suppressDate" value="true" />
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="${spring.datasource.driver-class-name}" connectionURL="${spring.datasource.url}" userId="${spring.datasource.username}" password="${spring.datasource.password}">
                 <property name="nullCatalogMeansCurrent" value="true" />
            </jdbcConnection>
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
            
            
            <javaModelGenerator targetPackage="com.hng.example.entity" 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" />
                
                <property name="trimStrings" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.hng.example.repository" targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            
            
            
            <table schema=""  tableName="${tableName}" domainObjectName="${entityName}" enableCountByExample="false"
                   enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false"/>
        </context>
    </generatorConfiguration>

三、编写application.properties

> \# 数据库
> 
>     spring.datasource.url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/hng
>     spring.datasource.username=root
>     spring.datasource.password=password
>     spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
>     
>     # mybatis-generator 表
>     tableName = user
>     entityName = User

四、生成代码

IDEA右侧Maven，项目名->Plugins->mybatis-generator:generates双击运行，即可生成代码

![3a0bbca1e58648c99d51367f29791ac5.png][]

至此，集成完毕。

若报以下错误：

![a08edc999f564eb596a3e0577aec51dc.png][]

说明是数据库信息获取失败，最简单的方法就是在mybatis-generator-config.xml中把数据库信息直接写上，不使用引用获取的方式

![8ce4cad45ccf4776bbb4cd26400d0409.png][]

[Link 1]: https://so.csdn.net/so/search?q=%E4%BB%A3%E7%A0%81%E7%94%9F%E6%88%90&spm=1001.2101.3001.7020
[5fa6ec497d6e4b1588b9db8b430a2869.png]: https://img-blog.csdnimg.cn/5fa6ec497d6e4b1588b9db8b430a2869.png
[3a0bbca1e58648c99d51367f29791ac5.png]: https://img-blog.csdnimg.cn/3a0bbca1e58648c99d51367f29791ac5.png
[a08edc999f564eb596a3e0577aec51dc.png]: https://img-blog.csdnimg.cn/a08edc999f564eb596a3e0577aec51dc.png
[8ce4cad45ccf4776bbb4cd26400d0409.png]: https://img-blog.csdnimg.cn/8ce4cad45ccf4776bbb4cd26400d0409.png