jdbc+proxool

要注意的是如果是src下的proxool，hibernate .cfg.xml中用到了也不需要在web.xml中配置了

 

package cache.task.connection;

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

public class ConnectionFactory {
 private String driver = "com.mysql.jdbc.Driver";
 
 private static ConnectionFactory factory = new ConnectionFactory();
 
 private ConnectionFactory(){ }
 public static ConnectionFactory getFactory(){
  return factory;
 }
 
 public Connection getProxoolConnection(String pool) throws Exception{
  Class.forName(driver);
  Connection conn = DriverManager.getConnection("proxool."+pool);
  return conn;
 }
 =========

还有一个直接用jdbc的

public Connection getConnection() throws Exception{
  
  dburl = "jdbc:mysql://localhost:3306/lazycdn1";
  Class.forName(driver);

  Connection conn=DriverManager.getConnection(dburl,"root","123456");
  
  return conn;
 }

 

================
 public static void closeAll(ResultSet rs,Statement stam,Connection conn){ 
  try {
   if(rs!=null){
    rs.close();
   }
   if(stam!=null){
    stam.close();
   }
   if(conn!=null){
    conn.close();
   }   
  }catch (SQLException e) {
    e.printStackTrace();
  }
 }
 
 public static void closeAll(Statement stam,Connection conn){ 
  try {
   
   if(stam!=null){
    stam.close();
   }
   if(conn!=null){
    conn.close();
   }   
  }catch (SQLException e) {
    e.printStackTrace();
  }
 }
 
}

====================

 

proxool.xml内容 ：

 

 

<?xml version="1.0" encoding="gb2312"?>
<!-- the proxool configuration can be embedded within your own application's.
        Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
        <proxool>
         <alias>localhost</alias>
         <driver-url>jdbc:mysql://121.11.66.60:3306/lazycdn</driver-url>
         <driver-class>com.mysql.jdbc.Driver</driver-class>
         <driver-properties>
             <property name="user" value="iamcdn" />
             <property name="password" value="cdnisme@!$#" />
         </driver-properties>
         <house-keeping-sleep-time>90000</house-keeping-sleep-time>
         <maximum-connection-count>50</maximum-connection-count>
         <minimum-connection-count>10</minimum-connection-count>
         <test-before-use>true</test-before-use>
         <house-keeping-test-sql>select now()</house-keeping-test-sql> 
     </proxool>
 
   
   

</something-else-entirely>

 

===================

hibernate.cfg.xml中内容

 

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

 <session-factory>

   <property name="proxool.pool_alias">localhost</property>
   <property name="proxool.xml">proxool.xml</property>
   <property name="dialect">
   org.hibernate.dialect.MySQLDialect
   </property>
   <property name="connection.provider_class">
   org.hibernate.connection.ProxoolConnectionProvider
   </property>
 
 <!-- <property name="connection.driver_class">
   com.mysql.jdbc.Driver
  </property>
  <property name="myeclipse.connection.profile">
   jdbc:mysql://121.11.66.60:3306/lazycdn
  </property>
  <property name="connection.url">
   jdbc:mysql://121.11.66.60:3306/lazycdn
  </property>
  <property name="connection.username">iamcdn</property>
  <property name="connection.password">cdnisme@!$#</property>
 -->
  <property name="show_sql">false</property>
  <mapping
   resource="com/dnion/lazycdn/transPort/storage/entity/TransMgr.hbm.xml" />
  <mapping
   resource="com/dnion/lazycdn/transPort/storage/entity/TransUser.hbm.xml" />
  <mapping
   resource="com/dnion/lazycdn/transPort/storage/entity/Tfrtask.hbm.xml" />
  <mapping
   resource="com/dnion/lazycdn/transPort/storage/entity/TranTaskDetail.hbm.xml" />

 </session-factory>

</hibernate-configuration>

 

注意：如果要生成新的实体对像：（aa.hbm.xml）,那就得用注释的那一段才行。

 

 

=========web.xml配置

 

 

   <servlet>
  <servlet-name>ServletConfigurator</servlet-name>
  <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
  <init-param>
   <param-name>xmlFile</param-name>
   <param-value>WEB-INF/proxool.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>/admin</url-pattern>
 </servlet-mapping>