java dbcp配置_DBCP连接池配置(DBCPUtils.java)

packagetop.try51.utils;importjava.io.InputStream;importjava.sql.Connection;importjava.sql.SQLException;importjava.util.Properties;importjavax.sql.DataSource;importorg.apache.tomcat.dbcp.dbcp2.BasicDataSource;importorg.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory;public classDBCPUtils {//加载名称为mysqlConn 的配置(src下放置 db_dbcp.properties 配置文件)

private static BasicDataSource ds = null;/*** 定义一个ThreadLocal,绑定Connection，每个线程对应一个Connection,执行事务使用*/

private static ThreadLocal tl = new ThreadLocal();static{

Properties props= newProperties();try{//1.加载Properties文件输入流

InputStream is = DBCPUtils.class.getClassLoader().getResourceAsStream("db_dbcp.properites");//2.加载载配置

props.load(is);

is.close();//3. 创建数据源

ds =BasicDataSourceFactory.createDataSource(props);

}catch(Exception e) {throw newRuntimeException(e);

}

}/***

*@ret