test.jsp

Java项目开发实用案例之公司办公信息管理系统 本系统为公司办公信息管理系统EIMS

<%@ page contentType="text/html;charset=gb2312"  language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>

<%int i = 0;  
  Context initCtx = new InitialContext();
  if (initCtx == null){
  	throw new Exception("不能获取Context!");
  }
  DataSource ds = (DataSource) initCtx.lookup("java:comp/env/eims");
  Connection conn = ds.getConnection();
  Statement stmt = conn.createStatement();
  PreparedStatement ps=conn.prepareStatement("select * from PSLogins");
  ResultSet rs=ps.executeQuery();
  while(rs.next()){
      out.println(rs.getString("Name")+"<BR>");
      i++;
  }
//rs.close();
//stmt.close();
//conn.close();
out.println("连接池测试成功了"+i);
%>