C3P0连接池例子

package com.ln.weizhi.wenda.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import org.apache.log4j.Logger;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Test {

	static Logger logger = Logger.getLogger(C3P0Test.class);

	public static void main(String[] args) {

		try {
			// 创建一个数据源
			ComboPooledDataSource cpds = new ComboPooledDataSource();
			// 设置数据库的相关信息
			cpds.setDriverClass("oracle.jdbc.driver.OracleDriver");
			cpds.setJdbcUrl("jdbc:oracle:thin:@211.137.23.66:1521:orcl");
			cpds.setUser("hello");
			cpds.setPassword("1234");
			cpds.setMaxStatements(180);
			cpds.setMaxPoolSize(100);

			Connection con = null;
			Statement stmt = null;
			ResultSet rs = null;
			con = cpds.getConnection();
			stmt = con.createStatement();
			rs = stmt.executeQuery("select * from te_operator ");
			while (rs.next()) {
				logger.info("ID : " + rs.getString("id") + " , NAME : "
						+ rs.getString("name"));
			}

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

}