Tomcat连接池配置

context.xml配置如下，放入META-INF目录下，在eclipse中即可完成连接池的配置

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/">  
<Resource auth="Container" 
driverClassName="com.mysql.jdbc.Driver" 
type="javax.sql.DataSource"
name="jdbc/datasuourcePool"
url="jdbc:mysql://127.0.0.1:3306/hngjc?useUnicode=true&characterEncoding=GBK&autoReconnect=true"
username="hn"
password="123456"
logAbandoned="true" 
maxActive="5" 
maxIdle="2" 
maxWait="5000" 
removeAbandoned="true" 
removeAbandonedTimeout="300"
testOnReturn="true" 
testWhileIdle="true" 
validationQuery="select now()"/>
</Context>

<!-- 
url="jdbc:mysql://127.0.0.1:3306/hainangaojiao_net?useUnicode=true&amp;characterEncoding=GBK&amp;autoReconnect=true"
 -->

java代码获取连接池的连接

	public Connection Creatconn() { 
		conn = null;
		try {  
			Context initCtx = new InitialContext();
			Context ctx = (Context) initCtx.lookup("java:comp/env");
			// 获取连接池对象
			javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("jdbc/datasuourcePool");
			conn = ds.getConnection();
			return conn;
 
		} catch (Exception fe) {
			System.err.println("Creatconn(): " + fe.getMessage());
			return null;
		}
 
	}