第三方连接池c3p0

第三方连接池c3p0

标准的连接池要求实现一个类：javax.sql.DataSource

在dataSource里面有一个方法：getConnection();

步1：导入c3p0.jar

步2：创建c3p0-config.xml配置文件

<c3p0-config>
	<!-- 默认配置，如果没有指定则使用这个配置 -->
	<default-config>
		<!-- 连接超时时间 -->
		<property name="checkoutTimeout">10000</property>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">
			<![CDATA[jdbc:mysql://localhost:3306/test]]>
		</property>
		<property name="user">root</property>
		<property name="password">123456</property>
		<!-- 初始化时有几个连接 -->
		<property name="initialPoolSize">3</property>
		<!-- 最少连接池里面有几个连接 -->
		<property name="minPoolSize">3</property>
		<property name="maxPoolSize">3</property>
	</default-config>
</c3p0-config> 

步3：创建一个工具类来读取这个文件创建一个唯一的DataSouce

public class DSutil {
	// 只要维护一个DataSource
		private static DataSource dataSource;//List<COnnection> pool
		static {
			dataSource = new ComboPooledDataSource();// 默认就会读取c3p0-config.xml
		}

		// 返回ds
		public static DataSource getDataSource() {
			return dataSource;
		}

		// 返回connect
		public static Connection getConnection() {
			Connection con = null;
			try {
				con = dataSource.getConnection();
			} catch (Exception e) {
				throw new RuntimeException(e);
			}
			return con;
		}
}

步4：测试连接能不能回收

@Test
	public void test1() throws Exception{
		Connection c1 = DSUtils.getConnection();
		System.err.println(">>>:"+c1);
		//NewProxyConnection包装类包装了：T4CConnection
		//com.mchange.v2.c3p0.impl.NewProxyConnection@1efea79 [wrapping: oracle.jdbc.driver.T4CConnection@1aa5492]
		
		c1.close();
	}


	@Test
	public void test1() throws Exception{
		Connection c1 = DSUtils.getConnection();
		System.err.println(">>>:"+c1);
		
		
		Connection c2 = DSUtils.getConnection();
		System.err.println(">>>:"+c2);
		c2.close();
		
		
		Connection c3 = DSUtils.getConnection();
		System.err.println(">>>:"+c3);
		
		
		Connection c4 = DSUtils.getConnection();
		System.err.println(">>>:"+c4);
	}

 

转载于:https://my.oschina.net/saysuqi/blog/1154260