Mybatis配置数据源-druid

单独使用mybatis框架（不使用spring）配置数据源，按照以下步骤：

1、添加数据源依赖（修改pom.xml)

2、实现datasourceFactory类

3、配置mybatis配置文件（mybatis-config.xml）

示例：以alibaba的druid连接池为例，配置mybatis数据源

step1:添加druid依赖

 
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.21</version>
    </dependency>

step2:实现datasourceFactory类

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;
import javax.sql.DataSource;
import java.sql.SQLException;
 
//自定义DruidDataSourceFactory,需要继承UnpooledDataSourceFactory
public class DruidDataSourceFactory extends UnpooledDataSourceFactory {
    // 数据源初始化
    @Override
    public DataSource getDataSource() {
        try {
            ((DruidDataSource)this.dataSource).init();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
        return this.dataSource;
    }
 
    public DruidDataSourceFactory() {
        this.dataSource = new DruidDataSource();
    }
}

3、配置mybatis配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
 
<configuration>    
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="com.test.datasource.DruidDataSourceFactory">
                <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/> 
                <property name="url" value="jdbc:mysql://localhost:3306/yourdb"/>
                <property name="username" value="yourusername"/>
                <property name="password" value="yourpassword"/>
                <property name="initialSize" value="20"/>
                <property name="maxActive" value="20"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

重点：把数据源的类型修改为自定义的DruidDataSourceFactory