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

川长思鸟来 2023-06-19 11:13 32阅读 0赞

# 一、数据库 #

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

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70]

# 二：使用IDEA 创建Spring boot 项目 #

*  选择Spring Initializ  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 1]
 *  下一步后：  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 2]
 *  点击下一步后，分别在Web选项中勾选Web，在Template Engines选项中勾选 Thymeleaf,在SQL选项中勾选MySQL和MyBatis。然后一直下一步到完成。

# 三、项目结构为： #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 3]

# 四、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 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 4]

*  结果如下：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191206105407374.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191206105343417.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191206105507134.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2019120610555950.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191206110026278.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191206110044739.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTcxNDE1,size_16,color_FFFFFF,t_70