D3P0实践小例子

首先导入包：c3p0-0.9.1.2.jar

然后实现代码：

	package star.july.c3p0Util;

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

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Util {
	private static String driverClass = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://localhost:3306/day18";
	private static String user = "root";
	private static String password = "root";
	
	
	//连接池对象
	private static ComboPooledDataSource ds = new ComboPooledDataSource();
	
	//设置连接池参数
	static{
		try{
			//1.连接数据库参数
			ds.setDriverClass(driverClass);
			ds.setJdbcUrl(url);
			ds.setUser(user);
			ds.setPassword(password);
			
			//2.连接池参数
			//初始化连接数
			ds.setInitialPoolSize(5);
			//最大连接数
			ds.setMaxPoolSize(10);
			//最长等待时间
			ds.setCheckoutTimeout(3000);
		}catch(Exception e){
			e.printStackTrace();
		}
	}
		public static Connection getConnection(){
			try{
				//从c3p0连接池程序获取连接
				Connection con = ds.getConnection();
				return con;
			}catch(SQLException e){
				e.printStackTrace();
				throw new RuntimeException();
			
			}
	}
}

主类:

package star.july.c3p0Util;

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

public class c3p0Dao {
	public static void main(String[] args) throws Exception {
		for(int i =1;i<=11;i++){
			//获取连接
			Connection conn = C3P0Util.getConnection();
			System.out.println(conn);
			
			//如果i==3，则关闭连接
			if(i==3){
				conn.close();
			}
		}
	}
}