全局连接池配置方法

1、编辑 tomcat\conf\context.xml
在<Context />标签里面添加一下内容

<Resource 
		name="jdbc/xzy_basic" 
		auth="Container" 
		type="javax.sql.DataSource" 
		factory="org.logicalcobwebs.proxool.ProxoolDataSource" 
		proxool.alias="slaveDB" 
		user="root" 
		password="root" 
		delegateProperties="foo=bar" 
		proxool.driver-url="jdbc:mysql://localhosst:3306/test?useUnicode=true&amp;characterEncoding=UTF-8" 
		proxool.driver-class="com.mysql.jdbc.Driver" 
		proxool.house-keeping-sleep-time="300000" 
		proxool.maximum-active-time="300000" 
		proxool.prototype-count="10" 
		proxool.statistics="1m,15m,1d" 
		proxool.simultaneous-build-throttle="10" 
		proxool.minimum-connection-count="20" 
		proxool.maximum-connection-count="25" 
		proxool.house-keeping-test-sql="select now()" 
		proxool.test-before-use="true"/> 

2、编辑 tomcat\conf\web.xml
<web-app></web-app>标签里添加

  <resource-ref> 
  		<res-ref-name>jdbc/xzy_basic</res-ref-name>
  		<res-type>javax.sql.DataSource</res-type>
  		<res-auth>Container</res-auth>  
 	</resource-ref>

3、 tomcat\lib\中需要以下jar包
commons-logging-1.1.3.jar
commons-logging-api-1.1.jar
mysql-connector-java-5.0.8-bin.jar
proxool-0.9.1.jar
proxool-cglib.jar
以上JAR下载
4、单独获取连接

import javax.naming.Context; 
	import javax.naming.InitialContext; 
	import javax.sql.DataSource; 
	import javax.sql.Connection; 

	 Context ctx = new InitialContext(); 
  	 DataSource dataSource = (DataSource)ctx.lookup("java:comp/env/jdbc/jndidb"); 
   	 Connection connection=dataSource.getConnection();

5、spring获取连接

<bean id="slaveDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<!--<property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver" />-->
		<property name="jndiName" value="java:comp/env/jdbc/xzy_basic"/>
	</bean>