SpringBoot Mybatis配置generator插件

一、在maven下添加插件坐标

<!--配置Generator插件-->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.16</version>
                    </dependency>
                </dependencies>
                <!--指定配置文件路径-->
                <configuration>
                    <configurationFile>${project.basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>
        </plugins>
<!--配置资源拷贝插件-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
            </resource>
        </resources>

二、添加配置文件

resources 下添加 generatorConfig.xml 文件

配置数据库连接信息和mapper以及实体类生成路径。

<?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>

    <context id="DB2Tables" targetRuntime="MyBatis3">
        <commentGenerator>
            <!--去掉自动生成的注释-->
            <property name="suppressAllComments" value="true"></property>
        </commentGenerator>
        <!--数据库连接信息-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql:///day17?serverTimezone=UTC"
                        userId="root"
                        password="root">
            <!--防止生成多张同名表-->
            <property name="nullCatalogMeansCurrent" value="true"/>
        </jdbcConnection>

        <javaTypeResolver >
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
		<!--生成PO类位置-->
        <javaModelGenerator targetPackage="com.example.springbootmybatis.pojo"
                            targetProject=".\src\main\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
		<!--mapper映射文件生成位置-->
        <sqlMapGenerator targetPackage="com.example.springbootmybatis.mapper"  targetProject=".\src\main\java">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
		<!--mapper接口生成位置-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.springbootmybatis.mapper"  targetProject=".\src\main\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
		<!--指定数据库表-->
        <table schema="" tableName="user" >
        </table>

    </context>
</generatorConfiguration>

三、添加DTD文件

*http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd *复制链接到浏览器下载 dtd 文件

在 IDEA 中 ctrl+alt+s 打开设置，在 Languages & Frameworks | Schemas and DTDs 中增加http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd，并选择 dtd 保存路径

四、运行插件生成代码

在 maven 中选择Plugins–>mybatis-generator–>mybatis-generator:generate双击运行

五、启动类中添加注解

@SpringBootApplication
@MapperScan("com.example.springbootmybatis.mapper")//指定扫描接口与映射配置文件的包名
public class SpringbootmybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootmybatisApplication.class, args);
    }

}