conpool.jsp

来自「电子书店管理系统」· JSP 代码 · 共 26 行

<%@ page import="javax.naming.Context" %> 
 <%@ page import="javax.sql.DataSource"%> 
 <%@ page import="javax.naming.InitialContext"%> 
 <%@ page import="java.sql.*"%> 

 <% 
   DataSource ds = null; 
   try{ 
Connection conn = com.jspdev.util.DatabaseConn.getConnection();
if(conn!=null)
{
out.println("Connection is OK!"); 
out.println("<br>");
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery("select * from user_info");
while(rst.next())
{
out.println(rst.getString("userId"));
out.println("<br>");

}
}
else 
 out.println("Fail!"); 
   }catch(Exception ne){ out.println(ne);} 
 %>