C3p0 和 DBCP连接池
package com.enhance.jdbc;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.sql.Blob;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import org.apache.commons.dbcp.BasicDataSource;//DBCP 下载地址:http://commons.apach.org///需要 commond-dbcp.jar commons-pool.jarpublic class DBCPConnectionPool {private static BasicDataSource ds=new BasicDataSource();private PreparedStatement pstmt;private ResultSet rs;static{Properties prop=new Properties();try {prop.load(new FileInputStream("src/mysql.ini"));} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}ds.setDriverClassName(prop.getProperty("driver"));ds.setUrl(prop.getProperty("url"));ds.setUsername(prop.getProperty("user"));ds.setPassword(prop.getProperty("pass"));ds.setInitialSize(Integer.parseInt(prop.getProperty("initialSize")));ds.setMaxActive(Integer.parseInt(prop.getProperty("maxActive")));ds.setMinIdle(Integer.parseInt(prop.getProperty("minIdle")));}public Connection getConenction() throws SQLException{return ds.getConnection();} //下面一样}