文章目录
SpringBoot 整合MyBatis
SpringBoot版本:2.4.1
1 dao子模块创建并设置层级
介绍:
dao.auto:逆向工程生成的interface xxxMapper接口存放路径
dao.entity:逆向工程生成的表映射类及xxxExample查询类存放路径
dao.ex:每个xxxMapper接口都要定义子类xxxMapperExt,存放在该路径,便利开发
resources/conf:myBatis逆向工程的配置文件
resources/mappers.auto:逆向工程生成的xxxMapperExt.xml文件存放于该路径
resources/mappers.ex:每个xxxMapperExt均要创建对应的xxxMapperExt.xml,新增的sql在当前文件中,便利开发
2 dao子模块的pom.xml中配置
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<!-- 父工程的依赖根据自己的模块替换 -->
<artifactId>xxx</artifactId>
<groupId>xxx.xxx.xxxx</groupId>
<version>0.0.1</version>
</parent>
<properties>
<mysql.connector.version>5.1.47</mysql.connector.version>
<com.alibaba.druid.version>1.1.12</com.alibaba.druid.version>
<mybatis.springboot.version>1.3.2</mybatis.springboot.version>
<mybatis.generator.core.version>1.3.2</mybatis.generator.core.version>
<org.mybatis.version>3.2.2</org.mybatis.version>
</properties>
<modelVersion>4.0.0</modelVersion>
<artifactId>dao</artifactId>
<dependencies>
<!--mybatis与spring boot依赖包-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis.springboot.version}</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.version}</version>
</dependency>
<!-- druid驱动 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${com.alibaba.druid.version}</version>
</dependency>
</dependencies>
<!-- MyBatis逆向工程插件 version不可以随意改,会造成版本不兼容 -->
<build>
<plugins>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<executions>
<execution>
<id>Generate MyBatis Artifacts</id>
<goals>
<goal>generate</goal>
</goals>
</execution>
</executions>
<configuration>
<configurationFile>src/main/resources/config/generatorConfig.xml</configurationFile>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>${mybatis.generator.core.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${org.mybatis.version}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
</project>
3 MyBatis逆向工程文件资源配置
- datasource.properties 配置数据库访问信息
db.driverClassName=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/test1?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false
db.username=root
db.password=123456
- 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>
<!--导入属性配置-->
<properties resource="config/datasource.properties"></properties>
<context id="default" targetRuntime="MyBatis3">
<property name="autoDelimitKeywords" value="true"/>
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<property name="javaFileEncoding" value="utf-8"/>
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
<plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
<!-- 一些工具 生成的实体类时的一些方法 -->
<plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"></plugin>
<!--<plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>-->
<!--<plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>-->
<!-- optional,旨在创建class时,对注释进行控制 -->
<commentGenerator>
<!-- 插入一个日期字段 -->
<property name="suppressDate" value="true"/>
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressAllComments" value="false"/>
</commentGenerator>
<!--jdbc的数据库连接 -->
<jdbcConnection
driverClass="${db.driverClassName}"
connectionURL="${db.url}"
userId="${db.username}"
password="${db.password}">
</jdbcConnection>
<!-- 非必需,类型处理器,在数据库类型和java类型之间的转换控制-->
<javaTypeResolver>
<!-- This property is used to specify whether MyBatis Generator should
force the use of java.math.BigDecimal for DECIMAL and NUMERIC fields, -->
<!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer,为 true时把JDBC DECIMAL 和
NUMERIC 类型解析为java.math.BigDecimal -->
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- Model模型生成器,用来生成含有主键key的类,记录类 以及查询Example类
targetPackage 指定生成的model生成所在的包名
targetProject 指定在该项目下所在的路径
-->
<!--<javaModelGenerator targetPackage="com.mmall.pojo" targetProject=".\src\main\java">-->
<javaModelGenerator targetPackage="com.sifisense.dao.entity" targetProject="./src/main/java">
<!-- 是否允许子包,即targetPackage.schemaName.tableName -->
<property name="enableSubPackages" value="false"/>
<!-- 是否对model添加 构造函数 -->
<property name="constructorBased" value="true"/>
<!-- 是否对类CHAR类型的列的数据进行trim操作 -->
<property name="trimStrings" value="true"/>
<!-- 建立的Model对象是否 不可改变 即生成的Model对象不会有 setter方法,只有构造方法 -->
<property name="immutable" value="false"/>
</javaModelGenerator>
<!--mapper映射文件生成所在的目录 为每一个数据库的表生成对应的SqlMap文件 -->
<!--<sqlMapGenerator targetPackage="mappers" targetProject=".\src\main\resources">-->
<sqlMapGenerator targetPackage="mappers.auto" targetProject="./src/main/resources">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!-- 客户端代码,生成易于使用的针对Model对象和XML配置文件 的代码
type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象
type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象
type="XMLMAPPER",生成SQLMap XML文件和独立的Mapper接口
-->
<!-- targetPackage:mapper接口dao生成的位置 -->
<!--<javaClientGenerator type="XMLMAPPER" targetPackage="com.mmall.dao" targetProject=".\src\main\java">-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.sifisense.dao.auto" targetProject="./src/main/java">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<!-- 要生成哪些表 -->
<table tableName="tb_user" domainObjectName="TbUser" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true">
<property name="useActualColumnNames" value="false" />
<!-- 逆向工程返回主键设置 -->
<generatedKey column="id" sqlStatement="MySql" identity="true"/>
</table>
</context>
</generatorConfiguration>
4 application.properties配置 mybatis xml映射文件路径
注意:该路径配置必须正确,否则加载xml会找不到而造成运行异常
## MyBatis模块配置
# 配置MyBatis xml文件扫描目录
mybatis.mapper-locations=classpath*:mappers/**/*.xml
5 逆向工程最终生成的结果
5 单元测试验证
- 单元测试类
@SpringBootTest(classes = Application.class)
public class UserTest {
@Autowired
private TbUserMapperExt tbUserMapperExt;
@Test
public void test1() {
// 新增30个用户
int size = 30;
for(int i = 0; i < size; i++) {
TbUser user = new TbUser();
user.setName("gateway");
user.setAge(i);
tbUserMapperExt.insert(user);
}
// 查询age>10
TbUserExample example = new TbUserExample();
example.createCriteria().andAgeGreaterThan(10);
List<TbUser> userList = tbUserMapperExt.selectByExample(example);
System.out.println(userList.toString());
}
}
- 结果