c3p0连接池

c3p0连接池xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
	<default-config>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/shopping?useSSL=true&amp;characterEncoding=UTF-8</property>
		<property name="user">root</property>
		<property name="password">root</property>
		<property name="checkoutTimeout">30000</property>
		<property name="initialPoolSize">10</property>
		<property name="maxIdleTime">30</property>
		<property name="maxPoolSize">100</property>
		<property name="minPoolSize">10</property>
	</default-config> 
	
</c3p0-config>

c3p0Utils

public class C3P0Utils {
	//获取数据源 C3P0配置文件信息 自动获取
	private static DataSource ds = new ComboPooledDataSource();
	//对外提供一个get方法 可以通过外部访问到DataSource
	public static DataSource getDataSource(){
		return ds;
	}
	//获取连接
	public static Connection getConnection(){
		try {
			return ds.getConnection();
		} catch (SQLException e) {
			throw new RuntimeException("服务器繁忙....");
		}
	}
	//释放资源
	public static void release(ResultSet rs,Statement stmt,Connection conn){
		try {
			if(rs!=null){
				rs.close();
			}
			if(stmt!=null){
				stmt.close();
			}
			if(conn!=null){
				conn.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());