springboot 集成 mybatis-generator

- 日理万妓 2022-12-30 10:45 87阅读 0赞

### springboot 集成 mybatis-generator ###

*   *  1、mybatis-geneator简介
     *  2、springboot 集成 mybatis-generator
     *   *  1.添加pom配置
         *  2.添加application.properties配置
         *  3.添加mybatis-generator-config.xml（mybatis-generator）配置
     *  3、自动生成

## 1、mybatis-geneator简介 ##

mybatis-geneator 是一款 mybatis 自动代码生成工具，MyBatis 属于半自动化的 ORM 框架，需要手动书写 Mapping 映射文件，mybatis-gennerator 可以帮助我们自动生成 mybatis 所需要的 Model、Dao、mapper xml 文件。

## 2、springboot 集成 mybatis-generator ##

### 1.添加pom配置 ###

在pom.xml中加入配置

<plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.7</version>
                    <configuration>
                        
                        <configurationFile>src/main/resources/mybatis-generator-config.xml</configurationFile>
                        
                        <overwrite>true</overwrite>
                        
                        
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>8.0.22</version>
                        </dependency>
                    </dependencies>
                </plugin>

注意：对于 mysql-connector-java 这个依赖上面的 dependency 也要加上，版本应该与上面的一致。

整个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.4.1</version>
            <relativePath/> 
        </parent>
        <groupId>com.xxx</groupId>
        <artifactId>xxxxx</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>xxxxx</name>
        <description>bighomework</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
                <exclusions>
                    
                    <exclusion>
                        <groupId>org.springframework.boot</groupId>
                        <artifactId>spring-boot-starter-logging</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-log4j2</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <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.7</version>
                    <configuration>
                        
                        <configurationFile>src/main/resources/mybatis-generator-config.xml</configurationFile>
                        
                        <overwrite>true</overwrite>
                        
                        
                    </configuration>
                    <dependencies>
                        
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>8.0.22</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    
    </project>

### 2.添加application.properties配置 ###

### mysql连接信息
    spring.datasource.url=jdbc:mysql://localhost:3306/xxx?serverTimezone=UTC
    spring.datasource.username=root
    spring.datasource.password=xxxxx
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

### 3.添加mybatis-generator-config.xml（mybatis-generator）配置 ###

它的位置如图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70]

<?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"/>
    
        
        <context id="myContext" targetRuntime="MyBatis3" defaultModelType="flat">
    
            
            
    
            
            <commentGenerator>
                
                <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="true"/>
                
                
            </javaTypeResolver>
            
            
            <javaModelGenerator targetPackage="com.xxxx.xxxxx.model" targetProject="src/main/java">
                
                
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
    
            
            <sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources">
                
            </sqlMapGenerator>
    
            
            <javaClientGenerator targetPackage="com.xxxx.xxxxxx.dao" targetProject="src/main/java" type="XMLMAPPER">
                
            </javaClientGenerator>
    
            
            <table schema="" tableName="user" domainObjectName="User" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false">
                
                
            </table>
        </context>
    </generatorConfiguration>

## 3、自动生成 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70 1]  
控制台最后输出的信息，成功！  
![在这里插入图片描述][20201225000245720.png]  
自动生成了如下代码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70]: /images/20221120/a749495356d04da38ee681254145b46a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201225000146472.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA==,size_16,color_FFFFFF,t_70
[20201225000245720.png]: https://img-blog.csdnimg.cn/20201225000245720.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201225000513966.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzUyMDY3MA==,size_16,color_FFFFFF,t_70