DBCP

来源：互联网发布：数据交换安全编辑：程序博客网时间：2024/06/08 18:38

导包：

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;}}}}}

0 0