Context ctx=new InitialContext();
//从JNDI树上取得连接池实现
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/drp");
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="Select * from t_user";
try{
conn=ds.getConnection();
pstmt=conn.preparedstatement(sql);
rs=pstmt.executeQuery();
while(rs.next()){
out.println("rs.getString(user_name)");
}
}catch(Exception e){
e.printstacktrace();
}finally{
if(rs!=null){rs.close();}
if(pstmt!=null){pstmt.close();}
//将连接放入连接池
if(conn!=null){conn.close();}
}