MyBatis整合druid连接池:
1,引入druid依赖pom.xml
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.14</version>
</dependency>
2,创建新类DruidDataSourceFactory
import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;
import javax.sql.DataSource;
import java.sql.SQLException;
public class DruidDataSourceFactory extends UnpooledDataSourceFactory {
public DruidDataSourceFactory(){
this.dataSource = new DruidDataSource();
}
//根据选用连接池不同,查看是否需要重写getDataSource方法
@Override
public DataSource getDataSource() {
try {
((DruidDataSource)this.dataSource).init();//初始化Druid数据源
} catch (SQLException e) {
throw new RuntimeException(e);
}
return this.dataSource;
}
}
3,mybatis-config.xml文件配置
<environments default="dev">
<!--开发环境配置-->
<environment id="dev">
<!--事务管理器采用JDBC方式-->
<transactionManager type="JDBC"></transactionManager>
<!--利用Mybatis自带连接池管理连接
<dataSource type="POOLED">-->
<!--MyBatis与Druid的整合-->
<dataSource type="com.imooc.oa.datasource.DruidDataSourceFactory">
<!--JDBC连接属性(Druid连接池drive的name不同)-->
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
<!--连接池初始连接数-->
<property name="initialSize" value="10"/>
<!--连接池最大连接数-->
<property name="maxActive" value="20"/>
</dataSource>
</environment>
</environments>
4,测试连接池是否正常使用,
方法一:查看日志
方法二:Navacat查看链接数量