proxool代码创建数据库连接与获取监控状态

package com.originalsoft.Test; import java.net.URL;import java.sql.*;import org.logicalcobwebs.proxool.ProxoolException;import org.logicalcobwebs.proxool.ProxoolFacade;import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;import org.logicalcobwebs.proxool.admin.SnapshotIF; /** * @author tank * @date:Apr 15, 2013 6:14:08 PM * @description: * @version : */public class DBConnection {     private static boolean initialized = false;     private static int activeCount = 0;    public static void state()throws ProxoolException{        SnapshotIF snapshot = ProxoolFacade.getSnapshot("mySqlProxool",true);        int curActiveCount = snapshot.getActiveConnectionCount();// 获得活动连接数        int availableCount = snapshot.getAvailableConnectionCount();// 获得可得到的连接数        int maxCount = snapshot.getMaximumConnectionCount();// 获得总连接数//      if (curActiveCount != activeCount)// 当活动连接数变化时输出信息//      {            System.out.println("----------------------------------");            System.out.println(curActiveCount + "(active)  " + availableCount + "(available)  " + maxCount + "(max)");            System.out.println("----------------------------------");            activeCount = curActiveCount;//      }    }     public static Connection getConnection() throws SQLException {        Connection connection = null;        if (!initialized) {             init();        }         connection = DriverManager.getConnection("proxool.mySqlProxool");        try {            SnapshotIF snapshot = ProxoolFacade.getSnapshot("mySqlProxool",true);            int curActiveCount = snapshot.getActiveConnectionCount();// 获得活动连接数            int availableCount = snapshot.getAvailableConnectionCount();// 获得可得到的连接数            int maxCount = snapshot.getMaximumConnectionCount();// 获得总连接数            if (curActiveCount != activeCount)// 当活动连接数变化时输出信息            {                System.out.println("----------------------------------");                System.out.println(curActiveCount + "(active)  " + availableCount + "(available)  " + maxCount + "(max)");                System.out.println("----------------------------------");                activeCount = curActiveCount;            }         }catch (ProxoolException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        if (connection != null) {             return connection;        }else {            throw new NullPointerException("Didn't get connection, which probably means that no Driver accepted the URL");        }     }     private static void init() {        String fileName = "proxool.xml";        URL resourceURL = null;        try {            if (Thread.currentThread().getContextClassLoader() != null) {                resourceURL = Thread.currentThread().getContextClassLoader().getResource(fileName);            }             if (resourceURL == null) {                resourceURL = DBConnection.class.getClassLoader().getResource(fileName);            }             JAXPConfigurator.configure(resourceURL.getFile(),false);            Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");        }catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }catch (ProxoolException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        initialized = true;    }}

注: mySqlProxool为注册proxool的别名

<?xml version="1.0" encoding="UTF-8"?><something-else-entirely>    <proxool>        <alias>mySqlProxool</alias>                             <driver-url>jdbc:mysql://127.0.0.1:3306/db</driver-url>        <driver-class>com.mysql.jdbc.Driver</driver-class>        <driver-properties>            <property name="user" value="XXX" />            <property name="password" value="XXX" />            <property name="autoReconnect" value="true" />        </driver-properties>        <!--        <jndi-name>jdbc-mahout</jndi-name>        <jndi-java.naming.factory.initial>            org.apache.naming.java.javaURLContextFactory        </jndi-java.naming.factory.initial>        <jndi-java.naming.factory.url.pkgs>org.apache.naming</jndi-java.naming.factory.url.pkgs>         -->        <test-before-use>true</test-before-use>        <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>        <house-keeping-sleep-time>90000</house-keeping-sleep-time>        <simultaneous-build-throttle>100</simultaneous-build-throttle><!-- old name maximum-new-connections -->        <maximum-connection-count>300</maximum-connection-count>        <minimum-connection-count>20</minimum-connection-count>        <!-- <maximum-connection-lifetime>3600000</maximum-connection-lifetime>             <maximum-active-time>120000</maximum-active-time>-->        <prototype-count>5</prototype-count><!-- mini keep connection -->        <maximum-active-time>1200000</maximum-active-time>    </proxool></something-else-entirely>