连接池配置方法(proxool)

连接池配置方法:
1、下载个proxool-0.9.0RC3.jar类,放到工程中的WebRoot/WEB-INF/lib/
2、WebRoot/WEB-INF/的Web.xml最前面加入:
<!-- start pool-->
<servlet>
       <servlet-name>proxoolServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
     <init-param>
       <param-name>xmlFile</param-name>
       <param-value>WEB-INF/config/proxoolconf.xml</param-value>
     </init-param>
     <load-on-startup>1</load-on-startup>
   </servlet>
   <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>/viewConnection</url-pattern>
   </servlet-mapping>
<!-- end pool-->

3、WebRoot/WEB-INF/下新建个config目录，在此目录建立proxoolconf.xml文件，写入如下内容:

<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>
<proxool>
<alias>cityrcPool</alias>
<driver-url>jdbc:mysql://localhost:3306/test</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="root"/>
<property name="useUnicode" value="true"/>
<property name="characterEncoding" value="GBK"/>
</driver-properties>
<!--
<house-keeping-sleep-time>150000</house-keeping-sleep-time>

<maximum-new-connections>0</maximum-new-connections>
<prototype-count>5</prototype-count>-->
<maximum-connection-count>150</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
</proxool>
</something-else-entirely>
4、调用：
 package connectionPools;
 
 import javax.naming.Context;
 import javax.sql.DataSource;
 import javax.naming.InitialContext;
 //import org.apache.log4j.Logger;
 import org.apache.*;
 import java.sql.*;
 public  class Dbconn{
  private static Logger log=Logger.getLogger(Dbconn.class);
  public static Connection conn = null; 
  public Context initCtx = null;
  public static  Connection getConn() {
    try {
     conn = DriverManager.getConnection("proxool.cityrcPool");
     log.info("============获取Connection===========");
    } catch (Exception e) {
     log.info("============不能获取Connectiot========");
     e.printStackTrace();
    }
    finally{
    }
    return conn;
 
  }
 }