/**//*
*@author 我为j狂 建立日期 2007-4-18
*
*/
package net.blogjava.lzqdiy;

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;

public class dbconnection
{

    private static boolean initialized = false;

    private static int activecount = 0;

    public static connection getconnection() throws sqlexception
    {
        connection connection = null;
        if (!initialized)
        {

            init();
        }

        connection = drivermanager.getconnection("proxool.develop");
        try
        {
            snapshotif snapshot = proxoolfacade.getsnapshot("develop", 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;
    }
}

<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>
  <proxool>
    <alias>develop</alias>
    <driver-url>jdbc:oracle:thin:@(description=(address_list=(address=(protocol=tcp)(host=192.168.0.6)(port=1521)))(connect_data=(sid=lzqdiy)(server=dedicated)))
    </driver-url>
    <driver-class>oracle.jdbc.driver.oracledriver</driver-class>
    <driver-properties>
      <property name="user" value="lzqdiy"/>
      <property name="password" value="lzqdiy"/>
    </driver-properties>
    <maximum-connection-count>120</maximum-connection-count>
    <minimum-connection-count>20</minimum-connection-count>
    <house-keeping-test-sql>select current_date</house-keeping-test-sql>
  </proxool>
</something-else-entirely>