DBPool连接池

package com;

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

import snaq.db.ConnectionPool;

public class DBConn {
	public static Connection conn = null;
	public static ConnectionPool pool = null;

	public static void main(String[] args) {
		System.out.println(getConn());
		free(conn,null,null);
	}

	public static Connection getConn() {
		try {
			Class<?> c = Class.forName("oracle.jdbc.driver.OracleDriver");
			Driver driver = (Driver) c.newInstance();
			DriverManager.registerDriver(driver);
			pool = new ConnectionPool("db", 10, 100, 4,
					"jdbc:oracle:thin:@localhost:1521:orcl", "system", "root");
			long timeOut = 3000;
			conn = pool.getConnection(timeOut);
		} catch (Exception e) {
			// TODO: handle exception
			System.out.println("获取连接对象异常！！");
			e.printStackTrace();
		}
		return conn;
	}

	public static void free(Connection conn,
			Statement stmt, ResultSet rs) {
		try {
			if (rs != null) {
				rs.close();
			}
			if (stmt != null) {
				stmt.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			// TODO: handle exception
			System.out.println("关闭连接异常！！");
			e.printStackTrace();
		}
		if (pool != null) {
			pool.release();
		}
	}
}