test.jsp

来自「公司员工登录和身份认证。员工信息管理子系统的主要功能。公司财务信息管理子系统的主」· JSP 代码 · 共 25 行

<%@ 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);
%>