版权声明:本文为博主原创文章,转载注明“龙棠博客”字样和原文链接。
配置Mybatis-generator 插件
#maven依赖,插件部分
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
</plugin>
</plugins>
</build>
#使用MySQL数据库需要添加驱动依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
mybatis-generator配置文件,存放路径spring-boot的resources
#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>
<!--MBG运行时加载额外包的路径,比如JDBC drivers;jar,zip压缩文件或者是加入到classpath的路径-->
<classPathEntry location="D:\02maven_repo\mysql\mysql-connector-java\5.1.43\mysql-connector-java-5.1.43.jar" />
<!--context 严格顺序-->
<!--(property*,plugin*,commentGenerator?,(connectionFactory|jdbcConnection),javaTypeResolver?,
javaModelGenerator,sqlMapGenerator?,javaClientGenerator?,table+)-->
<context id="MySQLTables" targetRuntime="MyBatis3">
<!--插件-->
<plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"></plugin>
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
<plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>
<!--分页-->
<plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"></plugin>
<!--取消注释-->
<commentGenerator>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!--数据库连接信息-->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://172.18.60.121:3306/liujinlong"
userId="root"
password="123qwe!@#QWE">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!--Model生成包路径,项目路径-->
<javaModelGenerator targetPackage="org.playchain.demo4.model" targetProject="D:\01workspace\demo4\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
<property name="constructorBased" value="true" />
</javaModelGenerator>
<!--mapper XML生成信息-->
<sqlMapGenerator targetPackage="mapper" targetProject="D:\01workspace\demo4\src\main\resources">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!--mapper 接口文件-->
<javaClientGenerator type="XMLMAPPER" targetPackage="org.playchain.demo4.mapper" targetProject="D:\01workspace\demo4\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table schema="DB2ADMIN" tableName="user" domainObjectName="User" >
<property name="useActualColumnNames" value="true"/>
<!--主键-->
<generatedKey column="id" sqlStatement="MySql" identity="true" />
<!--重写,忽略字段-->
<columnOverride column="DATE_FIELD" property="startDate" />
<!--忽略字段-->
<ignoreColumn column="FRED" />
<columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" />
</table>
</context>
</generatorConfiguration>
应用新增扫描注解
@SpringBootApplication
@MapperScan("org.playchain.demo4.mapper")
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}