Proxool连接池使用方法

Connection con = DriverManager.getConnection("proxool.mysql");

这一句就可以了，Class.forName也不需要了。

注：别名是可以设置多个的，我们在连接多种数据库的时候就可以设置多个别名方便访问了！！

查看proxool的状态

在工程的web.xml里添加

<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/admin</url-pattern>
</servlet-mapping>


就可以通过/admin来访问proxool的状态了。

import java.sql.*;
import org.apache.log4j.*;

public class InitAction
{
  private Connection conn;
  Logger log  = Logger.getLogger("InitAction");

  public Connection getConnection()
  {
   try
   {
   conn = DriverManager.getConnection("proxool.xml-db");
   }
   catch(Exception ex)
   {
     log.error("数据库连接异常:"+ex.toString());
   }
   if(conn==null)
   {
    log.error("连接无效...");
   }
   return conn;
  }
 
}

而每次在使用时只需要:

Connection conn = new InitAction().getConnection();

即可，真是太方便了！

注:使用完之后需要一定得conn.close(),不然连接很快会被用光..

 

－－－－－－－－－－－－－－－－－－－－－－

           if (conn != null) {
                System.out.println("数据连接测试成功！");
            }
            Stmt = conn.createStatement();
            //Rst = Stmt.executeQuery("select * from t_function t");
            Rst = Stmt.executeQuery("select * from nodetype t");
            //Rst = Stmt.executeQuery("select * from insurecorp t");

            while (Rst.next()) {
                System.out.println(Rst.getString(1));
            }
        } catch (SQLException e) {
            System.out.println("error" + e);
        } catch (ProxoolException e1) {
            System.out.println(e1);
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                    Stmt.close();
                    Rst.close();
                }
            } catch (SQLException e2) {
                System.out.println(e2);
            }
        }
    }

    public static void main(String[] args) {
        test databean = new test();
        databean.TestReadPro();
        //databean.TestReadXML();
    }
}

 

XML配置文件如下：

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>Fee</alias>
<driver-url>jdbc:oracle:thin:@90.0.12.112:1521:ORCL</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="feemanager"/>
<property name="password" value="1"/>
</driver-properties>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>select sysdate from DUAL</house-keeping-test-sql>
</proxool>
</something-else-entirely>

 

properties文件配置：

//网上查车数据库
jdbc-1.proxool.alias=WEBGIS
jdbc-1.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-1.proxool.driver-url=jdbc:oracle:thin:@192.168.0.1:1521:ORCL
jdbc-1.user=gis
jdbc-1.password=1
jdbc-1.proxool.maximum-connection-count=20
jdbc-1.proxool.prototype-count=4
jdbc-1.proxool.house-keeping-test-sql=select sysdate from DUAL
jdbc-1.proxool.verbose=true
jdbc-1.proxool.statistics=10s,1m,1d
jdbc-1.proxool.statistics-log-level=ERROR
//标准版数据库
jdbc-2.proxool.alias=Navtech
jdbc-2.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-2.proxool.driver-url=jdbc:oracle:thin:@192.168.0.2:1521:orcl
jdbc-2.user=Nav
jdbc-2.password=1
jdbc-2.proxool.maximum-connection-count=20
jdbc-2.proxool.prototype-count=4
jdbc-2.proxool.house-keeping-test-sql=select sysdate from DUAL
jdbc-2.proxool.verbose=true
jdbc-2.proxool.statistics=10s,1m,1d
jdbc-2.proxool.statistics-log-level=ERROR
//计费数据库
jdbc-3.proxool.alias=Fee
jdbc-3.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-3.proxool.driver-url=jdbc:oracle:thin:@192.168.0.3:1521:ORCL
jdbc-3.user=fee
jdbc-3.password=1
jdbc-3.proxool.maximum-connection-count=20
jdbc-3.proxool.prototype-count=4
jdbc-3.proxool.house-keeping-test-sql=select sysdate from DUAL
jdbc-3.proxool.verbose=true
jdbc-3.proxool.statistics=10s,1m,1d
jdbc-3.proxool.statistics-log-level=ERROR

特别注意：

1、在用main类测试时可以直接将XML或properties文件放置于工程目录下。

2、如果将以上文件放于classes目录下时必须给出绝对路径，当然也可以使用变通做法，我是这样做的：

        try {
            InputStream is = getClass().getResourceAsStream("/Proxool.properties");
            Properties properties = new Properties();
            properties.load(is);
            PropertyConfigurator.configure(properties);
        } catch (IOException ex) {
            ex.printStackTrace();
        } catch (ProxoolException e1) {
            e1.printStackTrace();
        }