DBCP使用例子

概述Apache Tomcat7.02 集成了DBCP连接池，JAR文件为tomcat-dbcp.jar，以下是一个使用例子： 1package myBean; 2 3import java.sql.*; 4import javax.sql.DataSource; 5 6//DBCP原版包为org.apache.commons.dbcp.BasicDataSource; 7i @H_403_0@ @H_403_0@

Apache Tomcat7.02 集成了DBCP连接池，JAR文件为tomcat-dbcp.jar，以下是一个使用例子：
1package myBean; 2 3import java.sql.*; 4import javax.sql.DataSource; 5 6//DBCP原版包为org.apache.commons.dbcp.BasicdataSource; 7import org.apache.tomcat.dbcp.dbcp.BasicdataSource; 8 9public class test {10 public test() {1112 }1314 public voID haha() {15 DataSource dataSource = setupDataSource("jdbc:sqlserver://LOCALHOST:1433;Databasename=BBS");16 Connection conn = null;17 Statement stmt = null;18 ResultSet rset = null;19 try {20 System.out.println("Creating connection.");21 conn = dataSource.getConnection();22 System.out.println("Creating statement.");23 stmt = conn.createStatement();24 System.out.println("Executing statement.");25 rset = stmt.executequery("select * from tblUserInfo");26 System.out.println("Results:");27 int numcols = rset.getMetaData().getColumnCount();28 while (rset.next()) {29 for (int i = 1; i <= numcols; i++) {30 System.out.print("/t" + rset.getString(i));31 }32 System.out.println("");33 }34 } catch (sqlException e) {35 e.printstacktrace();36 } finally {37 try {38 if (rset != null)39 rset.close();40 } catch (Exception e) {41 }42 try {43 if (stmt != null)44 stmt.close();45 } catch (Exception e) {46 }47 try {48 if (conn != null)49 conn.close();50 } catch (Exception e) {51 }52 }53 }5455 public static DataSource setupDataSource(String connectURI) {56 BasicdataSource ds = new BasicdataSource();57 ds.setDriverClassname("com.microsoft.sqlserver.jdbc.sqlServerDriver");58 ds.setUsername("sa");59 ds.setPassword("******");60 ds.setUrl(connectURI);61 return ds;62 }6364 public static voID printDataSourceStats(DataSource ds) {65 BasicdataSource bds = (BasicdataSource) ds;66 System.out.println("NumActive: " + bds.getNumActive());67 System.out.println("NumIDle: " + bds.getNumIDle());68 }6970 public static voID shutdownDataSource(DataSource ds) throws sqlException {71 BasicdataSource bds = (BasicdataSource) ds;72 bds.close();73 }7475}

@H_403_0@ 总结

以上是内存溢出为你收集整理的DBCP使用例子全部内容，希望文章能够帮你解决DBCP使用例子所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。