SpringBoot整合MyBatis逆向工程

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