tomcat6 数据库连接池

<Resource  name="jdbc/mysql_pool" auth="Container"
			        type="javax.sql.DataSource"
			        driverClassName="com.mysql.jdbc.Driver"
			        url="jdbc:mysql://localhost:3306/test?autoReconnect=true"
			        username="root" password="root" maxActive="20" maxIdle="10"
			        maxWait="-1" />

 

package com;

import java.sql.Connection;


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




public class ConnectionPool {
          public static Connection getConnection(){
        	   
        	  Connection conn=null;
        	  DataSource ds;
			try {
				InitialContext ctx=new InitialContext();   
				ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql_pool");
				  conn = ds.getConnection();    
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}    
        	   
        	  

           return conn;
          }
}