导包:
commons-dbcp.jar:连接池的实现commons-pool.jar:链接池实现的依赖库
配置文件属性 dbcp.properties ,放在 src 根目录下:
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc
username=root
password=
示例代码:
public class DBCPDemo1{
public static void main(String[] args){
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
//因为配置信息写死了,所以已淘汰
// BasicDataSource source = new BasicDataSource();
// source.setDriverClassName("com.mysql.jdbc.Driver"); //加驱动
// source.setUrl("jdbc:mysql:///day11"); //加路径
// source.setUsername("root"); //加用户名
// source.setPassword("root"); //加密码
Properties prop = new Properties();
prop.load(new FileReader("dbcp.properties"));
BasicDataSourceFactory factory = new BasicDataSourceFactory();
DataSource source = factory.createDataSource();
try{
conn = source.getConnection();
ps = conn.prepareStatement("select * from account");
rs = ps.executeQuery();
while(rs.next()){
String name = rs.getString("name");
s.o.p(name);
}
}catch(Exception e){
e.printStackTrace();
}finally{
if( rs!= null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
rs = null;
}
}
if( ps!= null){
try{
ps.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
ps = null;
}
}
if( conn!= null){
try{
pool.retConn( conn);
}catch(SQLException e){
e.printStackTrace();
}finally{
ps = null;
}
}
}
}
}