一、知识点准备
MyBatis-Plus(简称 MP)是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。详细情况,可参考https://mybatis.plus/
Mybatis-plus默认使用HikariCP连接池,推荐使用H2内存数据库
1,HikariCP连接池https://www.jianshu.com/p/15b846107a7c
H2数据库介绍https://www.jianshu.com/p/1e0fb830cbe4
二、项目示例
1,创建项目Mybatis-demo-mybatis-plus
引入依赖,包括HikariCP、druid连接池的依赖,mybatis-plus默认HikariCP连接池。
```markup
<properties>
<failOnMissingWebXml>false</failOnMissingWebXml>
<packaging>war</packaging>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>5.2.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.5.RELEASE</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<exclusions>
<exclusion>
<groupId>com.baomidou</groupId>
<artifactId>mybatis</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.3.0</version>
</dependency>
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
</dependency>
</dependencies>```
注意必须引入mybatis-plus-boot-starter依赖包,并排除mybatis依赖。
2,添加配置
与spring整合,这里分别配置了HikariCP、druid,可根据项目选择需要的连接池。
<context:annotation-config />
<!-- spring2. 自动扫描的包 -->
<context:component-scan base-package="cn.yyt" />
<!-- 1、配置数据库相关参数properties的属性:${url} -->
<context:property-placeholder location="classpath:jdbc.properties" />
<!-- spring3. 数据源,注入需要的数据源 -->
<bean id="dataSource2" class="com.ali