关于DBCP及使用。纯JDBC架构。

DBCP(DataBase connection pool),数据库连接池。

是 apache 上的一个 java 连接池项目，也是 tomcat 使用的连接池组件。单独使用dbcp需要3个包：common-dbcp.jar,common-pool.jar,common-collections.jar由于建立数据库连接是一个非常耗时耗资源的行为，所以通过连接池预先同数据库建立一些连接，放在内存中，应用程序需要建立数据库连接时直接到连接池中申请一个就行，用完后再放回去。

目前hibernate默认的连接方式就是DBCP，可见其重要性。不过话说hibernate只是一个框架，效率低多了，基础的才是笑到最后的。使用DBCP的连接池可以快速取存连接。进行一系列操作。

不说了，土豆我就直接上代码了。纯JDBC效率肯定比hibernate高哦。说不定哪天hibernate没落了。它只是工具，底层才是王道。

package com.sinoglobal.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Locale;
import java.util.ResourceBundle;

import org.apache.commons.dbcp.ConnectionFactory;
import org.apache.commons.dbcp.DriverManagerConnectionFactory;
import org.apache.commons.dbcp.PoolableConnectionFactory;
import org.apache.commons.dbcp.PoolingDriver;
import org.apache.commons.pool.ObjectPool;
import org.apache.commons.pool.impl.GenericObjectPool;

@SuppressWarnings("unchecked")
public class PoolManager {
	private static String driver = "net.sourceforge.jtds.jdbc.Driver"; // 驱动
	private static String url = ""; // URL
	private static String name = "sa"; // 用户名
	private static String password = ""; // 密码
	private static Class driverClass = null;
	private static ObjectPool connectionPool = null;
	private static String poolname = "";
	private static ResourceBundle rb;

	/**
	 * 初始化数据源
	 */
	private static synchronized void initDataSource() {
		if (driverClass == null) {
			try {
				driverClass = Class.forName(driver);
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * 装配配置文件 initProperties
	 */
	private static void loadProperties() {
		rb = ResourceBundle.getBundle("config", Locale.getDefault());
		driver = rb.getString("jdbc.sql.driverClassName");
		url = rb.getString("jdbc.sql.url");
		name = rb.getString("jdbc.sql.username");
		password = rb.getString("jdbc.sql.password");
		poolname = rb.getString("jdbc.sql.poolname");
	}

	/**
	 * 连接池启动
	 * 
	 * @throws Exception
	 */
	public static void StartPool() {
		loadProperties();
		initDataSource();
		if (connectionPool != null) {
			ShutdownPool();
		}
		try {
			connectionPool = new GenericObjectPool(null);
			ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(
					url, name, password);
			new PoolableConnectionFactory(connectionFactory, connectionPool,
					null, null, false, true);
			Class.forName("org.apache.commons.dbcp.PoolingDriver");
			PoolingDriver driver = (PoolingDriver) DriverManager
					.getDriver("jdbc:apache:commons:dbcp:");
			driver.registerPool(poolname, connectionPool);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 释放连接池
	 */
	public static void ShutdownPool() {
		try {
			PoolingDriver driver = (PoolingDriver) DriverManager
					.getDriver("jdbc:apache:commons:dbcp:");
			driver.closePool(poolname);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	/**
	 * 取得连接池中的连接
	 * 
	 * @return
	 */
	public static Connection getConnection() {
		Connection conn = null;
		if (connectionPool == null)
			StartPool();
		try {
			conn = DriverManager.getConnection("jdbc:apache:commons:dbcp:"
					+ poolname);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	/**
	 * 获取连接 getConnection
	 * 
	 * @param name
	 * @return
	 */
	public static Connection getConnection(String name) {
		return getConnection();
	}

	/**
	 * 释放连接 freeConnection
	 * 
	 * @param conn
	 */
	public static void freeConnection(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * 释放连接 freeConnection
	 * 
	 * @param name
	 * @param con
	 */
	public static void freeConnection(String name, Connection con) {
		freeConnection(con);
	}

	/**
	 * 例子 main
	 * 
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			Connection conn = PoolManager.getConnection();
			System.out.println(conn.isClosed());
			if (conn != null) {
				Statement statement = conn.createStatement();
				ResultSet rs = statement
						.executeQuery("select * from test2..log");
				int c = rs.getMetaData().getColumnCount();
				while (rs.next()) {
					System.out.println();
					for (int i = 1; i <= c; i++) {
						System.out.print(rs.getObject(i));
					}
				}
				rs.close();
			}
			PoolManager.freeConnection(conn);
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

}