Tomcat6下配置数据连接池

1.在tomcat的安装目录下修改conf文件下的server.xml文件在server.xml中的<host></host>之间增加以下配置:

<context path="/liangku" docbase="liangku"></context>  <context path="/liangku" docbase="liangku"></context>    <  Context path="/liangku" docBase="liangku"
               debug="5" reloadable="true" crossContext="true">
               <  Resource name="jdbc/DBUtil" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="sa" password="" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
               url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=barn" />
      < /Context>

2.在webapps/项目名/WEB-INF中的web.xml中之前增加以下配置:
       <description></description><resource-ref></resource-ref>
      < resource-ref>
         < description>SQL Server Datasource
         < res-ref-name>jdbc/DBUtil
         < res-type>javax.sql.DataSource
        < res-auth>Container
    < /resource-ref>        
3.把以下几个.jar文件复制到tomcat安装目录下的lib文件夹中(jar可到网上下载)
      commons-collections-3.1.jar
      commons-dbcp-1.2.1.jar
      commons-pool-1.2.jar
      msutil.jar
      msbase.jar
      mssqlserver.jar     

 4.例子:      

import java.sql.Connection;

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

public class DBUtil {
 
 public static Connection getConnection() {
 
  try{
            Context initContext = new InitialContext();
            if(initContext == null )
                throw new Exception("No Context");
            Context envContext  = (Context)initContext.lookup("java:/comp/env");
            DataSource ds = (DataSource)envContext.lookup("jdbc/DBUtil");
            if (ds != null) {
                Connection conn = ds.getConnection();    
                if(conn != null) {
                    return conn;
                }
            }
        }catch(Exception e) {
         
            e.printStackTrace();
        }
        return null;
 }
 
 public static void main(String[] args) {
  Connection con = DBUtil.getConnection();
  if(con == null){
   System.out.println("连接不成功");  
  }
  else{
   System.out.println("连接成功");
  }
 }
}