Springboot使用MyBatis Generator代码生成器

Springboot使用MyBatis Generator代码生成器

1 新建springboot初始项目

``
选择springboot向导器

取个名字

这里可以什么都不选 然后就一直下一步直到完成

项目结构如上，下面步入正文

2添加依赖和maven配置

<plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <configurationFile>C:\Users\ZC\workspace\gather\src\main\resources\generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
                <dependencies>
                    <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->
                    <dependency>
                        <groupId>org.springframework.boot</groupId>
                        <artifactId>spring-boot-starter-jdbc</artifactId>
                        <version>2.1.3.RELEASE</version>
                    </dependency>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.13</version>
                    </dependency>
                </dependencies>
            </plugin>

把这段代码添加到pom的build的plugins的标签里面即可 注意修改 configurationFile标签的路径

3在application.properties配置数据库信息

#数据库驱动如果是5版本可以改为com.mysql.jdbc.Driver
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver      

#连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/Test?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

4，配置generatorConfig.xml文件

4.1 在resources下新建generatorConfig.xml文件

4.2 配置生成策略

<?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="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <!--处理sql中的`符号-->
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        <!--数据源配置-->
        <jdbcConnection driverClass="${spring.datasource.driver-class-name}"
                        connectionURL="${spring.datasource.url}"
                        userId="${spring.datasource.username}"
                        password="${spring.datasource.password}">
        </jdbcConnection>

        <!--model包路径-->
        <javaModelGenerator targetPackage="com.xp.gather.entity" targetProject="src/main/java"/>
        <!--mapper.xml包路径-->
        <sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources"/>
        <!--mapper包路径-->
        <javaClientGenerator targetPackage="com.xp.gather.mapper" targetProject="src/main/java"
                             type="XMLMAPPER"/>
        <!--表配置，tableName支持%，表示全部生成-->
        <table tableName="lamp" domainObjectName="Lamp"></table>
        <table tableName="lampstate" domainObjectName="LampState"></table>

    </context>
</generatorConfiguration>

table标签有很多属性可以配置，每一个table对应数据库的每一个表，具体属性详见MyBatis Generator官网

5，运行

点开idea左边的MavenProperts,双击运行mybatis-gengerator:generate

到此就已经弄好了

需要注意的几个地方

1，各个包生成的路径

 <!--model包路径-->
        <javaModelGenerator targetPackage="com.gather.springbootmbg.entity" targetProject="src/main/java"/>
        <!--mapper.xml包路径-->
        <sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources"/>
        <!--mapper包路径-->
        <javaClientGenerator targetPackage="com.gather.springbootmbg.mapper" targetProject="src/main/java"
                             type="XMLMAPPER"/>

2，依赖， dependencies标签里面的依赖一定不能少，否则会找不到

 <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <configurationFile>C:\Users\ZC\workspace\springboot-mbg\src\main\resources\generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
                <dependencies>
                    <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->
                    <dependency>
                        <groupId>org.springframework.boot</groupId>
                        <artifactId>spring-boot-starter-jdbc</artifactId>
                        <version>2.1.3.RELEASE</version>
                    </dependency>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.13</version>
                    </dependency>
                </dependencies>
            </plugin>

3，configurationFile里面指定generatorConfig.xml的路径

最后附上主要代码

如有误解或bug可以联系我