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();} }