java dbcp连接池 使用_Java dbcp连接池基本使用方法详解

1、依赖api的使用

导入jar包

org.apache.commons

commons-dbcp2

2.7.0

导入dbcp.properties配置文件

获取连接

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

Properties properties=new Properties();

//获取dbcp配置文件对应输入流

InputStream inputStream=DbcpServlet.class.getClassLoader().getResourceAsStream("dbcp.properties");

//加载dbcp配置文件

properties.load(inputStream);

​

BasicDataSource basicDataSource=null;

try {

//数据源对象

basicDataSource=BasicDataSourceFactory.createDataSource(properties);

//获取数据库连接

Connection connection=basicDataSource.getConnection();

System.out.println(connection);

} catch (Exception e) {

e.printStackTrace();

}

​

}