使用Tomcat6连接池

1, Tomcat6根目录下， conf文件夹下面：修改context.xml文件；

 在<Context>中加入：

< Resource  name ="jdbc/test"    
       auth ="Container"    
       type ="javax.sql.DataSource"    
       driverClassName ="oracle.jdbc.driver.OracleDriver"    
       url ="jdbc:oracle:thin:@172.29.96.23:1521:ahdb"    
       username ="ahdbs"
       password ="ahdbs"
       maxActive ="10"    
       maxIdle ="3"    
       maxWait ="10000"   />   

2,项目文件架下：WEB-INF目录下：修改web.xml文件：

 在<web-app>中加入：

   < resource-ref >
     < description > DB Connection </ description >
     < res-ref-name > jdbc/test </ res-ref-name >
     < res-type > javax.sql.DataSource </ res-type >
     < res-auth > Container </ res-auth >
   </ resource-ref >

3,

 

<% @ page language = " java "  contentType = " text/html; charset=UTF-8 "  pageEncoding = " UTF-8 " %>
<% @ page  import = " java.sql.* " %>
<% @ page  import = " javax.sql.* " %>
<% @ page  import = " javax.naming.* " %>
<%
    try   ... {
      Context initCtx = new InitialContext();
      Context envCtx = (Context) initCtx.lookup("java:comp/env");
      DataSource ds = (DataSource) envCtx.lookup("jdbc/test");
      Connection conn = ds.getConnection();


      Statement stmt = conn.createStatement();
      ResultSet rst = stmt.executeQuery("describe host");
      while (rst.next()) ...{
         out.println(rst.getString(1));
      }
      conn.close();
   }   catch  (Exception e)  ... {
      e.printStackTrace();
   }
%>

4,OK!!!!!!