conpool.jsp

《电子商店管理系统》——采用JSP、Servlet和JavaBean开发,实现了商品管理、 商品分类、订单处理、会员管理等功能

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