Java应用中使用Proxool

<? xml  version ="1.0"  encoding ="UTF-8" ?> 
< something-else-entirely > 
         < proxool > 
                 < alias >timalias </ alias > 
                <!-- 数据源的别名--> 
                 < driver-url >jdbc:oracle:thin:@192.168.104.192:1521:tim </ driver-url > 
                <!-- url连接串--> 
                 < driver-class >oracle.jdbc.driver.OracleDriver </ driver-class > 
                <!-- 驱动类--> 
                 < driver-properties > 
                         < property  name ="user"  value ="tim" /> 
                        <!-- 用户名--> 
                         < property  name ="password"  value ="tim_8968888" /> 
                        <!-- 密码--> 
                 </ driver-properties > 
                <!-- 最大连接数(默认5个),超过了这个连接数,再有请求时,就排在队列中等候,最大的等待请求数由maximum-new-connections决定 --> 
                 < maximum-connection-count >100 </ maximum-connection-count > 
                <!-- 最小连接数(默认2个)--> 
                 < minimum-connection-count >10 </ minimum-connection-count > 
                <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 默认30秒--> 
                 < house-keeping-sleep-time >90000 </ house-keeping-sleep-time > 
                <!-- 没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受--> 
                 < maximum-new-connections >10 </ maximum-new-connections > 
                <!-- 最少保持的空闲连接数(默认2个)--> 
                 < prototype-count >5 </ prototype-count > 
                <!-- 在使用之前测试--> 
                 < test-before-use >true </ test-before-use > 
                <!-- 用于保持连接的测试语句 --> 
                 < house-keeping-test-sql >select sysdate from dual </ house-keeping-test-sql > 
         </ proxool > 
</ something-else-entirely >

import org.logicalcobwebs.proxool.configuration.JAXPConfigurator; 

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.Statement; 

/** 
* Created by IntelliJ IDEA. 
* 
* @author leizhimin 2009-10-10 17:59:47 
*/ 
public  class TestProxool { 
         public  static String dburl =  "jdbc:oracle:thin:@192.168.104.192:1521:tim"; 
         public  static String user =  "tim"; 
         public  static String password =  "tim_8968888"; 

         /** 
         * JDBC方式测试 
         * 
         * @throws Exception 
         */ 
         public  static  void test1()  throws Exception { 
                String testsql =  "select * from village t where lastid = 346"; 
                 //1：注册驱动类 
                Class.forName( "oracle.jdbc.driver.OracleDriver"); 
                 //2：创建数据库连接 
                Connection conn = DriverManager.getConnection(dburl, user, password); 
                 //3：创建执行SQL的对象 
                Statement stmt = conn.createStatement(); 
                 //4：执行SQL，并获取返回结果 
                ResultSet rs = stmt.executeQuery(testsql); 
                 //5：处理返回结果，此处打印查询结果 
                 while (rs.next()) { 
                        System.out.print(rs.getLong( "id") +  "\t"); 
                        System.out.print(rs.getString( "name") +  "\t"); 
                        System.out.println(); 
                } 
                 //6：关闭数据库连接 
                conn.close(); 
        } 

         /** 
         * proxool方式测试 
         * 
         * @throws Exception 
         */ 
         public  static  void test2()  throws Exception { 
                 //Java应用中先要加载配置文件，否则谁知道你配置给谁用的 
                JAXPConfigurator.configure( "F:\\_test\\synorg\\src\\proxool.xml",  false); 
                String testsql =  "select * from village t where lastid = 346"; 
                 //1：注册驱动类，这次这个驱动已经不是Oracle的驱动了，是Proxool专用的驱动 
                Class.forName( "org.logicalcobwebs.proxool.ProxoolDriver"); 
                 //2：创建数据库连接，这个参数是一个字符串，是数据源的别名，在配置文件中配置的timalias，参数格式为：proxool.数据源的别名 
                Connection conn = DriverManager.getConnection( "proxool.timalias"); 
                 //3：创建执行SQL的对象 
                Statement stmt = conn.createStatement(); 
                 //4：执行SQL，并获取返回结果 
                ResultSet rs = stmt.executeQuery(testsql); 
                 //5：处理返回结果，此处打印查询结果 
                 while (rs.next()) { 
                        System.out.print(rs.getLong( "id") +  "\t"); 
                        System.out.print(rs.getString( "name") +  "\t"); 
                        System.out.println(); 
                } 
                 //6：关闭数据库连接 
                conn.close(); 
        } 


         public  static  void main(String[] args)  throws Exception { 
                test2(); 
        } 
}

2009-10-14 18:13:05    - INFO    org.logicalcobwebs.proxool.ProxoolFacade         - Proxool 0.9.1 (23-Aug-2008 11:10) 
2009-10-14 18:13:05    - WARN    org.logicalcobwebs.proxool.timalias         - Use of proxool.maximum- new-connections is deprecated. Use more descriptive proxool.simultaneous-build-throttle instead. 
5411  张一村    
5412  张二村    
5413  张三村    
5414  张四村    
5415  南原村    
5416  辛庄村    
5417  凡村    
5418  西阳村    
5419  人马村    
5420  前关村    
5421  后关村    
5422  赵村    
5423  水淆村    
5424  沟东村    
5425  陈村    
5426  窑店村    
5427  坡头村    
20588  大安头    
20589  涧里村    
20590  人马寨    
20591  白草村    
20592  窑院村    
20593  寺下村    
20594  反上村    
33651  小安头     
33652  五花岭     
33653  东沟     
33654  西沟    
33655  南沟     
33656  王村     
33657  营前    
33659  东阳    
33661  太阳     
33663  丰阳    
33665  宜村    
33667  窑头    
32225  石原村    
32226  庙上村    
32227  庙洼    
38739  丁管营    
38841  涧西    
2009-10-14 18:13:06    - INFO    org.logicalcobwebs.proxool.timalias         - Shutting down 'timalias' pool immediately [Shutdown Hook] 
2009-10-14 18:13:07    - INFO    org.logicalcobwebs.proxool.PrototyperController         - Stopping Prototyper thread 
2009-10-14 18:13:07    - INFO    org.logicalcobwebs.proxool.HouseKeeperController         - Stopping HouseKeeper thread 

Process finished with exit code 0