mybatis代码生成器

1.引入pom依赖

<dependencies>
        <!-- mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>

        <!--mybatis generator生成器-->
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.4.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
</dependencies>        

<build>
        <plugins>
            <!-- mybatis generator 自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.4.0</version>
                <configuration>
                    <configurationFile>src/main/resources/generator/generator-config.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.15</version>
                    </dependency>
                </dependencies>
            </plugin>
        </plugins>
    </build>

2.编写数据库连接信息和生成的文件包路径(generator.properties)

spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.url=jdbc:mysql://192.168.159.100:3306/ssm?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#生成的文件路径(mapper、xml、model)
generator.mapper.package=com.linging.mapper
generator.xml.package=com.linging.mapper
generator.model.package=com.linging.model

3.生成代码配置文件(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="generator/generator.properties"/>
    <!-- context 一般是一个数据源一个context -->
    <context id="mysql_tables" targetRuntime="MyBatis3" defaultModelType="flat">
        <property name="beginningDelimiter" value=""/>
        <property name="endingDelimiter" value=""/>
        <property name="javaFileEncode" value="UTF-8"/>

        <!-- 生成序列化方法 -->
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
        <!-- 生成序列化toString -->
        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin">
            <property name="useEqualsHashCodeFromRoot" value="true"/>
        </plugin>
        <!-- 生成序列化equals和hashcode -->
        <plugin type="org.mybatis.generator.plugins.ToStringPlugin">
            <property name="useToStringFromRoot" value="true"/>
        </plugin>
        <!-- 直接覆盖生成的mapper.xml -->
        <plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />

        <!-- 注释 -->
<!--        <commentGenerator type="com.example.mybatisgenerator.CommentGenerator">-->
<!--            &lt;!&ndash; 添加 db 表中字段的注释 &ndash;&gt;-->
<!--            <property name="addRemarkComments" value="true"/>-->
<!--            &lt;!&ndash; 是否不生成注释 &ndash;&gt;-->
<!--            <property name="suppressAllComments" value="true"/>-->
<!--            &lt;!&ndash; 不希望生成的注释中包含时间戳 &ndash;&gt;-->
<!--            <property name="suppressDate" value="true"/>-->
<!--        </commentGenerator>-->

        <!--jdbc的数据库连接 -->
        <jdbcConnection
                driverClass="${spring.datasource.driver-class-name}"
                connectionURL="${spring.datasource.url}"
                userId="${spring.datasource.username}"
                password="${spring.datasource.password}">
        </jdbcConnection>

        <!-- 类型解析器 -->
        <javaTypeResolver>
            <property name="forceBigDecimals" value="true"/>
        </javaTypeResolver>

        <!-- 实体类 -->
        <javaModelGenerator targetPackage="${generator.model.package}"
                             targetProject="src\main\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!-- xml -->
        <sqlMapGenerator
                targetPackage="${generator.xml.package}"
                targetProject="src\main\resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <!-- Mapper接口 -->
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="${generator.mapper.package}"
                             targetProject="src\main\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!-- 指定数据库表 -->
        <table tableName="student"
               enableCountByExample="true"
               enableUpdateByExample="true"
               enableDeleteByExample="true"
               enableSelectByExample="true"
               selectByExampleQueryId="true"
               enableSelectByPrimaryKey="true"
               enableUpdateByPrimaryKey="true"
               enableDeleteByPrimaryKey="true"
               enableInsert="true"
        >
        </table>
    </context>
</generatorConfiguration>

4.相关文件放置位置及结果展示