CP30连接池。
关键代码:
(1) C3P0JdbcUtil.java
packageex4;
importjava.beans.PropertyVetoException;
importjava.sql.Connection;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importcom.mchange.v2.c3p0.ComboPooledDataSource;//重要
publicclass C3P0JdbcUtil {
public static Connection getConnection()throwsSQLException, PropertyVetoException{//完成初始化
ComboPooledDataSourcecpds = new ComboPooledDataSource();
cpds.setDriverClass("com.microsoft.sqlserver.jdbc.SQLServerDriver");
cpds.setJdbcUrl("jdbc:sqlserver://localhost:1433");
cpds.setUser("sa");
cpds.setPassword("123456");
cpds.setAcquireIncrement(5);
cpds.setInitialPoolSize(10);
cpds.setMaxPoolSize(20);
returncpds.getConnection();
}
public static void release(Connection conn,Statementst,ResultSet rs){
if(rs!=null){
try{