Tomcat下DB2连接池xml文件配置

<?xml version="1.0"encoding="gb2312"?>

<Context>
   <Resource name="jdbc/hfbank" auth="Container"type="javax.sql.DataSource"
              maxActive="10" maxIdle="5" maxWait="-1"
              username="utan" password="utan"driverClassName="COM.ibm.db2.jdbc.app.DB2Driver"
              url="jdbc:db2:hfbank"/>
</Context>

测试文件 test.jsp

<%@pageimport="javax.naming.InitialContext"%>
<%@pageimport="java.sql.*"%>
<%@pageimport="javax.sql.DataSource"%>
<%@ page language="java" contentType="text/html;charset=utf-8"%>
<%
try{
 InitialContext ctx=new InitialContext();
//lookup方法找到连接要在jndi前增加前面增加java:/comp/env/
 DataSourceds=(DataSource)ctx.lookup("java:/comp/env/jdbc/hfbank");
 Connection conn = ds.getConnection();
 Statement stmt = conn.createStatement();
 ResultSet rs=stmt.executeQuery("select * fromps_user");
 while (rs.next()){
  out.println(rs.getString("userid"));
 }
 //out.println("Connection = " + conn);
 //out.println("Statement = " + stmt);
}catch(Exception ex) {
 out.print(" error , info = "+ex.getMessage());
 ex.printStackTrace();
}
%>