C3P0管理Oracle连接池

import java.sql.Connection;
import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;
public class DataBasePool{
	public static final String url = PropertiesUtils.getProperty("pcd_url") ;
	public static final String user = PropertiesUtils.getProperty("pcd_user") ;
	public static final String password = PropertiesUtils.getProperty("pcd_password") ;

	
    private static DataBasePool instance  ;

    private ComboPooledDataSource dataSource;
    
    static{
        instance = new DataBasePool();
    }

    private DataBasePool() {
        try {
            dataSource = new ComboPooledDataSource(); 
            dataSource.setDriverClass("oracle.jdbc.driver.OracleDriver");
            dataSource.setJdbcUrl(url);
            dataSource.setUser(user);
            dataSource.setPassword(password);
            dataSource.setInitialPoolSize(10) ;
            dataSource.setMaxIdleTime(30) ;
            dataSource.setMinPoolSize(10) ;
            dataSource.setMaxPoolSize(100) ;
        } catch (Exception e) { 
        }
    }
    
    public static DataBasePool getInstance(){
        return instance;
    }
    
    public Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
  
public class OracleDBHelper {  
  
    public Connection conn = null ;
    public PreparedStatement pst = null;  
  
    public OracleDBHelper(String sql) {  
        try {   
            conn = DataBasePool.getInstance().getConnection() ;  
            pst = conn.prepareStatement(sql); 
        } catch (Exception e) {   
        }  
    }  
  
    public void close(ResultSet rs) {  
        try {  
        	if (rs != null) {
				rs.close();
			}
        	if (this.conn != null) {
        		this.conn.close();  
			}
        	if (this.pst != null) {
        		this.pst.close();  
			}
        } catch (SQLException e) {   
        }  
    } 
   
    
}

String sql = "  " ;
		OracleDBHelper dbHelper = new OracleDBHelper(sql) ;
		ResultSet rs = null;
		try {
			rs = dbHelper.pst.executeQuery();
			while (rs.next()) {  
				 ruleIds.add(rs.getInt("")) ; 
			}
		} catch (SQLException e) {
		} catch (Exception e) {
		} finally {
			dbHelper.close(rs);
		}