Springboot mybatis generate 自动生成实体类和Mapper

- 日理万妓 2022-05-23 09:54 218阅读 0赞

# 一、数据库 #

数据库使用的是禅道项目管理软件的数据表。

![20180606194546465][]

二：使用IDEA 创建Spring boot 项目

2.1：选择Spring Initializ

![20180606194652335][]

下一步后：

![20180606195023199][]

点击下一步后，分别在Web选项中勾选Web，在Template Engines选项中勾选 Thymeleaf,在SQL选项中勾选MySQL和MyBatis。然后一直下一步到完成。

# 三、项目结构为： #

![20180606202850359][]

# 四、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>dd.springboot.demo</groupId>
        <artifactId>dd-demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <packaging>jar</packaging>
        <name>dd-demo</name>
        <description>Demo project for Spring Boot</description>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.2.RELEASE</version>
            <relativePath/> 
        </parent>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
                <version>5.1.46</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.5</version>
            </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.5</version>
                    <configuration>
                        
                        <configurationFile>src/main/resources/mybatis-generator/generatorConfig.xml</configurationFile>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                    <executions>
                        <execution>
                            <id>Generate MyBatis Artifacts</id>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                            <phase>generate-sources</phase>
                        </execution>
                    </executions>
                    
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <scope>runtime</scope>
                            <version>5.1.46</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    
    </project>

application.properties 文件配置如下

#mysql drive
    spring.datasource.driverClassName = com.mysql.jdbc.Driver
    spring.datasource.url = jdbc:mysql://localhost:3306/zentao?useUnicode=true&characterEncoding=utf-8
    spring.datasource.username = root
    spring.datasource.password =root
    # view
    #spring.mvc.view.prefix=classpath:/templates/
    #spring.mvc.view.suffix=.html
    #
    spring.thymeleaf.cache=true
    spring.thymeleaf.prefix=classpath:/templates/views/
    spring.thymeleaf.suffix=.html
    spring.thymeleaf.mode=HTML5
    spring.thymeleaf.encoding=UTF-8

五、在resources目录下创建mybatis-generator文件夹，并mybatis-generator文件夹中创建generatorConfig.xml文件和mybatisGeneratorinit.properties文件

mybatisGeneratorinit.properties配置如下

jdbc_driver=com.mysql.jdbc.Driver
    jdbc_url=jdbc:mysql://localhost:3306/zentao?useUnicode=true&characterEncoding=utf-8&useSSL=true
    jdbc_user=root
    jdbc_password=root
    models=E:\\CodeTest\\dd-demo\\src\\main\\java
    resources=E:\\CodeTest\\dd-demo\\src\\main\\resources
    dao=E:\\CodeTest\\dd-demo\\src\\main\\java

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>
        
        
        <properties resource="mybatis-generator/mybatisGeneratorinit.properties"/>
        
        
    
        
        
        <context id="MysqlTables" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            
            <property name="autoDelimitKeywords" value="true" />
            
            <property name="javaFileEncoding" value="utf-8" />
            
            <property name="beginningDelimiter" value="`" />
            <property name="endingDelimiter" value="`" />
    
            
            <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
            
            <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
    
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin" />
    
            
            <commentGenerator >
                <property name="suppressAllComments" value="false"/>
                <property name="suppressDate" value="true" /> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc_driver}" connectionURL="${jdbc_url}" userId="${jdbc_user}" password="${jdbc_password}" />
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="dd.springboot.demo.models" targetProject="${models}" >
                <property name="enableSubPackages" value="false"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mapper" targetProject="${resources}" >
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator targetPackage="dd.springboot.demo.dao" targetProject="${dao}" type="XMLMAPPER" >
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
            
            
            <table tableName="%"
                   enableCountByExample="true"
                   enableUpdateByExample="true"
                   enableDeleteByExample="true"
                   enableSelectByExample="true"
                   selectByExampleQueryId="true">
                <property name="useActualColumnNames" value="false" />
                
                <generatedKey column="id" sqlStatement="Mysql" identity="true" />
            </table>
        </context>
    </generatorConfiguration>

六、生成实体类、映射XML和Dao

![20180606203748967][]

结果如下：

![20180606204145461][]

[20180606194546465]: /images/20220523/0baf2a98233b42c6833d44112d2bd0d6.png
[20180606194652335]: /images/20220523/72a01c479b704bf5b1b80684159deaa9.png
[20180606195023199]: /images/20220523/5ef3284221184ee3aeb23eeab04f0108.png
[20180606202850359]: /images/20220523/1c41c9c968be43fa8332c7e76bee2b87.png
[20180606203748967]: /images/20220523/c65f4ebb45904bb2a6a4e536f930ff01.png
[20180606204145461]: /images/20220523/c466d5ad39724da59359bef910a285ea.png