注意要用DataSourceFactory配合配置文件,而不是直接使用DataSource
犯了个傻:如果pros.load出现问题,记得配置文件一定要放到src文件夹下
配置文件写法mysql实例(其他自己查文档):
package com.cls1277.connectionpool;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import org.junit.Test;
import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
public class DruidTest {
//使用德鲁伊进行数据库连接线程池
@Test
public void getConnection() throws Exception {
Properties pros = new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
DataSource source = DruidDataSourceFactory.createDataSource(pros);
Connection conn = source.getConnection();
System.out.println(conn);
}
}