maven插件生成

  1. <build>
  2.       <plugins>
  3.           <plugin>
  4.               <groupId>org.mybatis.generator</groupId>
  5.               <artifactId>mybatis-generator-maven-plugin</artifactId>
  6.               <version>1.3.7</version>
  7.               <dependencies>
  8.                   <dependency>
  9.                       <groupId>mysql</groupId>
  10.                       <artifactId>mysql-connector-java</artifactId>
  11.                       <version>8.0.15</version>
  12.                   </dependency>
  13.               </dependencies>
  14.               <executions>
  15.                   <execution>
  16.                       <id>Generate MyBatis Artifacts</id>
  17.                       <goals>
  18.                           <goal>generate</goal>
  19.                       </goals>
  20.                   </execution>
  21.               </executions>
  22.               <configuration>
  23.                   <!-- 输出详细信息 -->
  24.                   <verbose>true</verbose>
  25.                   <!-- 覆盖生成文件 -->
  26.                   <overwrite>true</overwrite>
  27.                   <!-- 定义配置文件 -->
  28.                   <configurationFile>${basedir}/src/main/resources/generator-configuration.xml</configurationFile>
  29.               </configuration>
  30.           </plugin>
  31.       </plugins>
  32.   </build>
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  4. <!-- 配置生成器 -->
  5. <generatorConfiguration>
  7.     <context id="testTables" targetRuntime="MyBatis3">
  9.         <property name="beginningDelimiter" value="`"/>
  10.         <property name="endingDelimiter" value="`"/>
  12.         <property name="javaFileEncoding" value="UTF-8"/>
  14.         <!-- 生成注释配置 -->
  15.         <commentGenerator>
  16.             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
  17.             <property name="suppressAllComments" value="true"/>
  18.             <property name="javaFileEncoding" value="UTF8"/>
  19.             <!--生成的注释包含时间戳(避免重复提交SVN,设为true)-->
  20.             <property name="suppressDate" value="true"/>
  21.         </commentGenerator>
  22.         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
  23.         <!--
  24.         <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
  25.             connectionURL="jdbc:oracle:thin:@150.16.17.22:1521/wsbs" userId="hr"
  26.             password="hr123">
  27.         </jdbcConnection>-->
  28.         <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
  29.                         connectionURL="jdbc:mysql://localhost:3306/fzs?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC"
  30.                         userId="root"
  31.                         password="123456">
  32.         </jdbcConnection>
  34.         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
  35.             NUMERIC 类型解析为java.math.BigDecimal -->
  36.         <javaTypeResolver>
  37.             <property name="forceBigDecimals" value="false"/>
  38.         </javaTypeResolver>
  40.         <!-- targetProject:生成PO类的位置 -->
  41.         <javaModelGenerator targetPackage="com.hikktn.domain"
  42.                             targetProject="src\main\java">
  43.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  44.             <property name="enableSubPackages" value="false"/>
  45.             <!-- 从数据库返回的值被清理前后的空格 -->
  46.             <property name="trimStrings" value="true"/>
  47.         </javaModelGenerator>
  48.         <!-- targetProject:mapper.xml映射文件生成的位置 -->
  49.         <sqlMapGenerator targetPackage="mapper"
  50.                          targetProject="src\main\resources">
  51.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  52.             <property name="enableSubPackages" value="false"/>
  53.         </sqlMapGenerator>
  54.         <!-- targetPackage：mapper.java接口生成的位置 -->
  55.         <javaClientGenerator type="XMLMAPPER"
  56.                              targetPackage="com.hikktn.dao"
  57.                              targetProject="src\main\java">
  58.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  59.             <property name="enableSubPackages" value="false"/>
  60.         </javaClientGenerator>
  63.         <!-- 指定数据库表 -->
  64.         <!--  enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  65.         enableSelectByExample="false" selectByExampleQueryId="false"-->
  66.         <!--不生成example-->
  67.         <!--<table tableName="items"></table> -->
  68.         <table schema="distribute" tableName="distribute_lock" domainObjectName="DistributeLock"
  69.                enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  70.                enableSelectByExample="false" selectByExampleQueryId="false">
  71.             <!--下划线转驼峰命名-->
  72.             <property name="useActualColumnNames" value="false"/>
  73.             <!--指定自动生成主键的属性-->
  74.             <generatedKey column="id" sqlStatement="MySql" identity="true"></generatedKey>
  75.             <!--元素从将某些属性默认计算的值更改为指定的值。-->
  76.             <!--<columnOverride  column="message_content" javaType="List&lt;Teacher&gt;"></columnOverride >-->
  77.             <!--忽略字段-->
  78.             <!--<ignoreColumn column="file_id"></ignoreColumn>-->
  79.             <!--<ignoreColumn column="lyric_id"></ignoreColumn>-->
  80.         </table>
  83.     </context>
  84. </generatorConfiguration>

测试类生成

  1.    <!--自动生成bean-->
  2.     <dependency>
  3.         <groupId>org.mybatis.generator</groupId>
  4.         <artifactId>mybatis-generator-core</artifactId>
  5.         <version>1.3.6</version>
  6.     </dependency>

生成类

  1. package org.lanqiao.test;
  3. import org.mybatis.generator.api.MyBatisGenerator;
  4. import org.mybatis.generator.config.Configuration;
  5. import org.mybatis.generator.config.xml.ConfigurationParser;
  6. import org.mybatis.generator.internal.DefaultShellCallback;
  8. import java.io.File;
  9. import java.util.ArrayList;
  10. import java.util.List;
  12. /**
  13.  * @ClassName TestGenerator
  14.  * @Description TODO
  15.  * @Author lisonglin
  16.  * @Date 2018/12/5 17:00
  17.  * @Version 1.0
  18.  */
  19. public class TestGenerator {
  21.     /***
  22.      * 功能描述:
  23.      *  调用generatorConfig.xml
  24.      * @param: []
  25.      * @return: void
  26.      * @auther: 李松林
  27.      * @date: 2018/12/8 19:50
  28.      */
  29.     public void generator(){
  30.         List<String> warnings=new ArrayList<String>();
  31.         //更新数据库时，请修改项目的xml配置绝对路径
  32.         File file=new File("E:\\MyJAVA\\SpringMakeup\\src\\main\\conf\\generatorConfig.xml");
  33.         ConfigurationParser cp = new ConfigurationParser(warnings);
  34.         Configuration config = null;
  35.         try {
  36.             config = cp.parseConfiguration(file);
  37.             DefaultShellCallback shellCallback = new DefaultShellCallback(true);
  38.             MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, shellCallback, warnings);
  39.             myBatisGenerator.generate(null);
  40.             System.out.println(warnings);
  41.         } catch (Exception e) {
  42.             e.printStackTrace();
  43.         }
  44.     }
  46.     /**
  47.      *
  48.      * @param args
  49.      * @throws Exception
  50.      */
  51.     public static void main(String[] args) throws Exception {
  53.         try {
  54.             TestGenerator generatorSqlmap = new TestGenerator();
  55.             generatorSqlmap.generator();
  56.         } catch (Exception e) {
  57.             e.printStackTrace();
  58.         }
  59.     }
  61. }

生成配置

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  4. <!-- 配置生成器 -->
  5. <generatorConfiguration>
  7.     <context id="testTables" targetRuntime="MyBatis3" defaultModelType="flat">
  9.         <property name="beginningDelimiter" value="`"/>
  10.         <property name="endingDelimiter" value="`"/>
  12.         <property name="javaFileEncoding" value="UTF-8"/>
  14.         <!-- 生成注释配置 -->
  15.         <commentGenerator>
  16.             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
  17.             <property name="suppressAllComments" value="true"/>
  18.             <property name="javaFileEncoding" value="UTF8"/>
  19.             <!--生成的注释包含时间戳(避免重复提交SVN,设为true)-->
  20.             <property name="suppressDate" value="true"/>
  21.         </commentGenerator>
  22.         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
  23.         <!--
  24.         <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
  25.             connectionURL="jdbc:oracle:thin:@150.16.17.22:1521/wsbs" userId="hr"
  26.             password="hr123">
  27.         </jdbcConnection>-->
  28.         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
  29.                         connectionURL="jdbc:mysql://localhost:3306/sys?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"
  30.                         userId="root"
  31.                         password="123">
  32.         </jdbcConnection>
  34.         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
  35.             NUMERIC 类型解析为java.math.BigDecimal -->
  36.         <javaTypeResolver>
  37.             <property name="forceBigDecimals" value="false"/>
  38.         </javaTypeResolver>
  40.         <!-- targetProject:生成PO类的位置 -->
  41.         <javaModelGenerator targetPackage="org.lanqiao.model"
  42.                             targetProject="E:/MyJAVA/SpringMakeup/src/main/java">
  43.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  44.             <property name="enableSubPackages" value="false"/>
  45.             <!-- 从数据库返回的值被清理前后的空格 -->
  46.             <property name="trimStrings" value="true"/>
  47.         </javaModelGenerator>
  48.         <!-- targetProject:mapper.xml映射文件生成的位置 -->
  49.         <sqlMapGenerator targetPackage="org.lanqiao.mapper"
  50.                          targetProject="E:/MyJAVA/SpringMakeup/src/main/conf">
  51.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  52.             <property name="enableSubPackages" value="false"/>
  53.         </sqlMapGenerator>
  54.         <!-- targetPackage：mapper.java接口生成的位置 -->
  55.         <javaClientGenerator type="XMLMAPPER"
  56.                              targetPackage="org.lanqiao.mapper"
  57.                              targetProject="E:/MyJAVA/SpringMakeup/src/main/java">
  58.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  59.             <property name="enableSubPackages" value="false"/>
  60.         </javaClientGenerator>
  63.         <!-- 指定数据库表 -->
  64.         <!--  enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  65.         enableSelectByExample="false" selectByExampleQueryId="false"-->
  66.         <!--不生成example-->
  67.         <!--<table tableName="items"></table> -->
  68.         <table tableName="hobbys" mapperName="HobbysMapper" domainObjectName="Hobbys"
  69.                enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  70.                enableSelectByExample="false" selectByExampleQueryId="false">
  71.             <!--下划线转驼峰命名-->
  72.             <property name="useActualColumnNames" value="false"/>
  73.             <!--指定自动生成主键的属性-->
  74.             <generatedKey column="id" sqlStatement="MySql" identity="true"></generatedKey>
  75.             <!--元素从将某些属性默认计算的值更改为指定的值。-->
  76.             <!--<columnOverride  column="message_content" javaType="List&lt;Teacher&gt;"></columnOverride >-->
  77.             <!--忽略字段-->
  78.             <!--<ignoreColumn column="file_id"></ignoreColumn>-->
  79.             <!--<ignoreColumn column="lyric_id"></ignoreColumn>-->
  80.         </table>
  83.     </context>
  84. </generatorConfiguration>