数据库连接池用法

连接池管理器:

package com.itmg.dao.db;

import java.sql.Connection;
import java.sql.DriverManager;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;

import com.itmg.util.TransServerUtil;

/**
 * 数据库连接管理器
 * */
public class ConnectionManager {
    private static  Log log  =  LogFactory.getLog(ConnectionManager.class );
    private static String driver = "com.mysql.jdbc.Driver";
   
	static {
		try {
			JAXPConfigurator.configure(TransServerUtil.PROXOOL_PATH, false);
		} catch (ProxoolException e) {
			e.printStackTrace();
		}
	}
	/**
	 * 获得customer数据库连接,链接池链接

	 * */
	public static Connection openConnection(){
		Connection conn = null;
		try {
			conn = DriverManager.getConnection("proxool.customerdb");
			return conn;
		}catch (Exception e) {
			log.error("customerdb web connect error");
			conn = openDirectCustomerdb();
		}
		return conn;
	}
	
	public static Connection openDirectCustomerdb()
	{
		Connection conn = null;
		String url = "jdbc:mysql://"+TransServerUtil.Customerdb_IP+":3306/"+TransServerUtil.Customerdb_Name+"?characterEncoding=utf8&mysqlEncoding=utf8";
		try {
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(url,TransServerUtil.Customerdb_UserName,TransServerUtil.Customerdb_UserPassword);
			return conn;
		}catch (Exception e) {
			log.error("direct connect customerdb  connect error");
			e.printStackTrace();
		}
		return conn;
	}
	public static void main(String[] args) {
		openConnection();
	}
}

连接池配置文件proxool.xml

<?xml version="1.0" encoding="utf-8"?>
<!-- the proxool configuration can be embedded within your own application's.
    Anything outside the "proxool" tag is ignored. -->
<proxool-configure>
     <proxool>
        <alias>customerdb</alias>
        <driver-url>
            jdbc:mysql://192.168.0.3:3306/customerdb?characterEncoding=utf8&amp;mysqlEncoding=utf8
        </driver-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <driver-properties>
                 <property name="user" value="lifunet" />
            <property name="password" value="lifunet" />
        </driver-properties>
        <maximum-connection-count>5</maximum-connection-count>
        <minimum-connection-count>2</minimum-connection-count>
    </proxool>
</proxool-configure>