JavaDBCoPool是一个Java的数据库连接池组件。
使用示例代码：
publicclassTestPool{publicstaticvoidmai(Strig[]args){DataSourceds=ull;//PritWriterlog=ull;//ucommettoturologgigtry{//log=ewPritWriter(ewFileWriter("dblog"),true);//ucommettoturologgigPropertiesp=ewProperties();p.setProperty("logLevel","1");//debug=4,ifo=3,war=2,error=1,fatal=0p.setProperty("autoCommit","false");p.setProperty("descriptio","Oracle");p.setProperty("driverClass","oracle.jdbc.driver.OracleDriver");p.setProperty("maxCout","2");p.setProperty("miCout","1");p.setProperty("user","test");p.setProperty("password","test");p.setProperty("url","jdbc:oracle:thi:@127.0.0.1:1565:test");p.setProperty("logiTimeout","0");//isecodsp.setProperty("holdTimeout","1000");//isecodsp.setProperty("waitTimeout","10000");//imillisecodsp.setProperty("checkQuery","selectSYSDATEfromdual");p.setProperty("statemetCacheSize","10");//ds=ewRPDataSource(p,log);//usethisisteadoftheextlietoturologgigds=ewRPDataSource(p);Coectioco=ds.getCoectio();Statemets=co.createStatemet();ResultSetrs=s.executeQuery("selectSYSDATEfromdual");if(rs.ext()){System.out.pritl(rs.getStrig(1));}rs.close();s.close();co.close();co=ds.getCoectio();s=co.createStatemet();rs=s.executeQuery("selectSYSDATEfromdual");if(rs.ext()){System.out.pritl(rs.getStrig(1));}}catch(Exceptioe){e.pritStackTrace();}fially{try{RPDataSourcerp=(RPDataSource)ds;rp.destroy();}catch(Exceptioe){e.pritStackTrace();}}}}
评论