SpringBoot整合MyBatis逆向工程
1.添加依赖
<!-- 声明版本号 -->
<properties>
<!-- 1.MyBatis -->
<mybatis.version>3.4.5</mybatis.version>
<!-- 2.MyBatis整合Spring -->
<mybatis-spring.version>1.3.1</mybatis-spring.version>
<!-- 3.MyBatis逆向工程 -->
<mybatis-generator.version>1.3.6</mybatis-generator.version>
</properties>
<!-- 添加依赖 -->
<dependencies>
<!-- SpringBoot-MyBatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis-spring.version}</version>
</dependency>
<!-- SpringBoot-MyBatis逆向工程 -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>${mybatis-generator.version}</version>
</dependency>
<!-- DB2数据库驱动 -->
<dependency>
<groupId>com.ibm.db2.jcc</groupId>
<artifactId>db2jcc4</artifactId>
<version>4.15.82</version>
</dependency>
</dependencies>
2.添加插件
<build>
<plugins>
<!-- MyBatis逆向工程插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>${mybatis-generator.version}</version>
<!-- 指定数据库驱动包 -->
<dependencies>
<dependency>
<groupId>com.ibm.db2.jcc</groupId>
<artifactId>db2jcc4</artifactId>
<version>4.15.82</version>
</dependency>
</dependencies>
<configuration>
<!-- 指定配置文件位置 -->
<configurationFile>${project.basedir}/src/main/resources/generatorConfig.xml</configurationFile>
<!-- 是否覆盖原有文件 -->
<overwrite>true</overwrite>
<!-- 是否允许移动生成的文件 -->
<verbose>true</verbose>
</configuration>
</plugin>
</plugins>
</build>
3.配置application.properties
#数据源相关
c3p0.driverClass=com.ibm.db2.jcc.DB2Driver
c3p0.jdbcUrl=jdbc:db2://ip:50003/xx;
c3p0.user=root
c3p0.password=root
c3p0.minPoolSize=2
c3p0.maxPoolSize=10
c3p0.maxIdleTime=1800000
c3p0.acquireIncrement=3
c3p0.maxStatements=1000
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=60
c3p0.acquireRetryAttempts=30
c3p0.acquireRetryDelay=1000
c3p0.breakAfterAcquireFailure=false
c3p0.testConnectionOnCheckout=false
#MyBatis逆向工程
generator.targetProject=src/main/java
generator.javaModel-targetPackage=com.xx.entity
generator.sqlMap-targetPackage=com.xx.sqlMap
generator.javaClient-targetPackage=com.xx.mapper
4.配置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>
<!-- 引入application.properties中的相关配置 -->
<properties resource="application.properties"/>
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- 添加实体类toString方法 -->
<plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>
<!-- 去掉注释 -->
<commentGenerator>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!-- 连接数据库 -->
<jdbcConnection
driverClass="${c3p0.driverClass}"
connectionURL="${c3p0.jdbcUrl}"
userId="${c3p0.user}"
password="${c3p0.password}">
</jdbcConnection>
<!-- 1.false: JDBC DECIMAL/NUMERIC 类型解析为Integer,
2.true: JDBC DECIMAL/NUMERIC 类型解析为java.math.BigDecimal -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- 1.指定实体类生成的位置 -->
<javaModelGenerator
targetPackage="${generator.javaModel-targetPackage}"
targetProject="${generator.targetProject}">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false"/>
</javaModelGenerator>
<!-- 2.指定SQLXML文件生成的位置 -->
<sqlMapGenerator
targetPackage="${generator.sqlMap-targetPackage}"
targetProject="${generator.targetProject}">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!-- 3.指定Mapper文件生成的位置 -->
<javaClientGenerator
targetPackage="${generator.javaClient-targetPackage}"
targetProject="${generator.targetProject}"
type="XMLMAPPER">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<!-- 对应数据库中的表 -->
<!-- schema:数据库名,tableName:数据库表名,domainObjectName:生成文件名 -->
<table schema="DB2INST1" tableName="XXX" domainObjectName="Xxx"></table>
</context>
</generatorConfiguration>
5.使用Maven build命令进行生成
5.1 项目名右键-->Run As-->Maven build
5.2 Goals: mybatis-generator:generate,点击run