C3P0连接池应用

package zyl.dao.jdbc.pool;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import zyl.utility.PubFun;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Pool {
	public C3P0Pool() {

	}

	public static void main(String[] args) {
		Properties p = PubFun
				.getProperties("src_dao\\zyl\\dao\\jdbc\\pool\\c3p0.properties");

		ComboPooledDataSource dataSource = new ComboPooledDataSource();

		dataSource.setDataSourceName("myDataSource");

		dataSource.setJdbcUrl(p.getProperty("c3p0.jdbcUrl"));

		try {
			dataSource.setDriverClass(p.getProperty("c3p0.driverClass").trim());
		} catch (PropertyVetoException e1) {
			System.out.println(e1.getMessage());
		}
		dataSource.setUser(p.getProperty("c3p0.user"));
		dataSource.setPassword(p.getProperty("c3p0.password"));
		dataSource.setMaxPoolSize(Integer.valueOf(p.getProperty(
				"c3p0.maxPoolSize").trim()));
		dataSource.setMinPoolSize(Integer.valueOf(p.getProperty(
				"c3p0.minPoolSize").trim()));
		dataSource.setAcquireIncrement(Integer.valueOf(p.getProperty(
				"c3p0.acquireIncrement").trim()));
		dataSource.setInitialPoolSize(Integer.valueOf(p.getProperty(
				"c3p0.initialPoolSize").trim()));
		dataSource.setMaxIdleTime(Integer.valueOf(p.getProperty(
				"c3p0.maxIdleTime").trim()));

		// 获取连接池，连接
		try {
			Connection conn = dataSource.getConnection();

			PreparedStatement ps = conn.prepareStatement("select * from dual");

			ResultSet rs = ps.executeQuery();

			while (rs.next()) {
				System.out.println(rs.getString(1));
			}
			rs.close();
			ps.close();
			conn.close();

		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

 

c3p0.driverClass=oracle.jdbc.driver.OracleDriver 
c3p0.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcl 
c3p0.user=coin 
c3p0.password=coin 
c3p0.minPoolSize=5 
c3p0.maxPoolSize=20
c3p0.acquireIncrement=5 
c3p0.initialPoolSize=5 
c3p0.maxIdleTime=240