jsp中的测试代码为
try{
InitialContext ctx = new InitialContext();
javax.sql.DataSource connectionPool = (javax.sql.DataSource) ctx.lookup("java:comp/env/jdbc/mytest");
Connection conn = connectionPool.getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from testconnpool");
while(rs.next()){
     out.print(rs.getInt(1));
     out.print(rs.getString(2));
}}
catch(Exception ex){
out.print(ex.getMessage());
ex.printStackTrace();
}