翻看17年笔记整理的,分享一下。
springboot下mybatis实现自动生成。
pom设置:
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<configuration>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
//生成seriable 不建议使用,会有不必要的问题
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
etc mybatis.gernerate.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">
<!-- this files was used to generate java bean & mapper interface & sql xml automatically -->
<generatorConfiguration>
<!-- the path of the db driver -->
<classPathEntry location="F:\文档\32.中移项目\0.maven.m2\repository\mysql\mysql-connector-java\5.1.40\mysql-connector-java-5.1.40.jar"/>
<context id="nmc" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<property name="autoDelimitKeywords" value="true"/>
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<property name="javaFileEncoding" value="UTF-8"/>
<commentGenerator>
<property name="suppressAllComments" value="false"/>
<property name="suppressDate" value="true"/>
</commentGenerator>
<!-- remember to change the database connection -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://10.139.6.161:3306/nmc"
userId="nmc"
password="123456"/>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- remember to change the target project folder for 'java bean' -->
<javaModelGenerator targetPackage="com.chinamobile.cmss.model"
targetProject="E:\Users\IdeaProjects\pms\nmc\src\main\java">
<property name="enableSubPackages" value="false"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<!-- remember to change the target project folder for 'mapper interface' -->
<sqlMapGenerator targetPackage="com.chinamobile.cmss.persistence"
targetProject="E:\Users\IdeaProjects\pms\nmc\src\main\java">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!-- remember to change the target project folder for 'sql xml' -->
<javaClientGenerator targetPackage="com.chinamobile.cmss.persistence"
targetProject="E:\Users\IdeaProjects\pms\nmc\src\main\java"
type="XMLMAPPER">
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<table tableName="tablename"
enableInsert="true"
enableSelectByPrimaryKey="true"
enableSelectByExample="false"
enableUpdateByPrimaryKey="false"
enableDeleteByPrimaryKey="false"
enableDeleteByExample="false"
enableCountByExample="false"
enableUpdateByExample="false"
modelType="flat"
delimitIdentifiers="true"
delimitAllColumns="true">
<!-- set the primary key of all tables -->
<!-- if different tables have different primary key, then you should add several tables with different 'tableName' attribute -->
<generatedKey column="id" sqlStatement="JDBC"/>
</table>
</context>
</generatorConfiguration>