在pom中添加依赖
<!--用来代替 mybatis 连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.16</version>
</dependency>
创建Druid数据源工厂
import javax.sql.DataSource;
import java.sql.SQLException;
public class DruidDataSourceFactory extends UnpooledDataSourceFactory {
@Override
public DataSource getDataSource() {
try {
((DruidDataSource) this.dataSource).init();
return this.dataSource;
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
public DruidDataSourceFactory() {
this.dataSource = new DruidDataSource();
}
}
更改mybatis-config.xml中的配置
type中写你创建Druid数据源工厂的类路劲
<dataSource type="com.wu.oa.datasource.DruidDataSourceFactory">
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://localhost:3306/oa?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"/>
<property name="username" value="root"/>
<property name="password" value="password"/>
</dataSource>
测试
使用之前写的测试类,成功执行