Mybatis自动生成代码插件generator

Mybatis自动生成代码插件generator

1.pom maven依赖

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <!-- 使用Mapper专用的MyBatis Generator插件,对应配置文件在generatorConfig.xml,生成文件目录见本pom里面的属性配置。
                 执行mvn mybatis-generator:generate 来进行相关生成 -->
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml
                    </configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>

                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>8.0.11</version>
                    </dependency>
                </dependencies>
            </plugin>
        </plugins>

    </build>

2.数据库连接配置generator.properties

#Database
jdbc.driverClassName=com.mysql.cj.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/cool?userSSL=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
jdbc.username=root
jdbc.password=123456

3.执行文件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="generator/generator.properties"/>

  <context  id="mysqlTables"   targetRuntime="MyBatis3Simple">
    <!--去除注释  -->
    <commentGenerator>
      <property name="suppressAllComments" value="true" />
    </commentGenerator>

    <jdbcConnection  driverClass="${jdbc.driverClassName}" connectionURL="${jdbc.url}"  userId="${jdbc.username}"  password="${jdbc.password}">
      <!--只生成用户创建的表-->
     <property name="nullCatalogMeansCurrent" value="true"/>
    </jdbcConnection>

    <!--指定生成的类型为java类型，避免数据库中number等类型字段 -->
    <javaTypeResolver>
      <property name="forceBigDecimals"  value="false"/>
    </javaTypeResolver>

    <!--自动生成的实体的存放包路径 -->
    <javaModelGenerator  targetPackage="com.ssm.study.pojo" targetProject="src/main/java">
        <property  name="enableSubPackages"  value="true"/>
        <property  name="trimStrings"  value="true"/>
    </javaModelGenerator>

    <!--自动生成的*Mapper.xml文件存放路径 -->
    <sqlMapGenerator  targetPackage="mapper" targetProject="src/main/resources/mappering">
      <property  name="enableSubPackages"  value="true"/>
    </sqlMapGenerator>

    <!--自动生成的*Mapper.java存放路径 -->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.ssm.study.dao" targetProject="src/main/java">
      <property  name="enableSubPackages"  value="true"/>
    </javaClientGenerator>

      <!--指定具体生成哪些表-->
    <!--
    <table  tableName="tbl_log">
      <generatedKey  column="ID"  sqlStatement="selectuuid_short()"
                     identity="false"/>
    </table>-->
   <!-- <table  tableName="user_t" domainObjectName="User">
      <generatedKey  column="ID"  sqlStatement="selectuuid_short()"
                     identity="false"/>
    </table>-->
    <table tableName="%" >
      <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
    </table>

  </context>

</generatorConfiguration>

4.使用maven命令执行

创建maven执行。

mybatis-generator:generate -e