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

<%@page import="javax.naming.InitialContext"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@ page language="java" contentType="text/html; charset=utf-8"%>
<%
try{
 InitialContext ctx=new InitialContext();
//lookup方法找到连接要在jndi前增加前面增加java:/comp/env/
 DataSource ds=(DataSource)ctx.lookup("java:/comp/env/jdbc/hfbank");
 Connection conn = ds.getConnection();
 Statement stmt = conn.createStatement();
 ResultSet rs=stmt.executeQuery("select * from ps_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();
}
%>

 

<script type="text/javascript" id="wumiiRelatedItems"> </script>