Mybatis更换连接池Druid

Mybatis更换连接池Druid

一、导入依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.6</version>
</dependency>

二、创建DruidDataSourceFactory

package wangda.datasource;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.datasource.pooled.PooledDataSourceFactory;

public class MyDruidDataSourceFactory extends PooledDataSourceFactory {

    public MyDruidDataSourceFactory() {
        this.dataSource = new DruidDataSource();  //替换数据源
    }
}

三、安装Druid连接池到Mybatis

将Mybatis核心配置文件的dataSource标签换成自己创建的DruidDataSourceFactory

注意需要修改属性名称driver——>dirverClass,url——>jdbcUrl

<environments default="kuang_config">
    <!-- 数据库相关配置 -->
    <environment id="kuang_config">
        <!-- 事务控制类型 -->
        <transactionManager type="jdbc"/>
        <!-- 数据源 (mysql8.0.24) -->
        <dataSource type="wangda.datasource.MyDruidDataSourceFactory">
            <property name="driverClass" value="${jdbc.driver}"/>
            <!-- &转义&amp;-->
            <property name="jdbcUrl" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </dataSource>
    </environment>
</environments>