testdatasource.jsp

一本jsp自学教材

<%@ page contentType="text/html;charset=GBK"%> 
<%@ page import= "java.sql.* "%> 
<%@ page import= "javax.naming.* "%> 
<%@ page import= "javax.sql.DataSource "%> 
<% 
try{ 
Context initCtx = new InitialContext(); 
Context ctx = (Context) initCtx.lookup("java:comp/env"); 
//获取连接池对象 
DataSource ds =(DataSource)ctx.lookup("jdbc/rot"); 
//创建连接
Connection conn = ds.getConnection(); 
Statement stmt = conn.createStatement(); 
String strSql ="SELECT * FROM product"; 
ResultSet rs = stmt.executeQuery(strSql); 
  out.print("数据源配置并连接成功！<BR>");  
  out.print("<TABLE BORDER=1 bordercolorlight=#000000 >");
  out.print("<TR><TD width=40>序号</TD>");
  out.print("<TD width=60>代码</TD><TD width=80>商品名称</TD>");
  out.print("<TD width=60>品牌</TD>");
  out.print("<TD width=150>产品简介</TD><TD width=80>存货数量</TD>");
  out.print("<TD width=80>价格/元</TD></TR>");
  while(rs.next())
    {
     out.print("<TR>");
     out.print("<TD>"+rs.getInt(1)+"</TD>");
     out.print("<TD>"+rs.getString("pdm")+"</TD>");
     out.print("<TD>"+rs.getString("pname")+"</TD>");     
     out.print("<TD>"+rs.getString("provider")+"</TD>");
     out.print("<TD>"+rs.getString("info")+"</TD>");
     out.print("<TD>"+rs.getString("stock")+"</TD>");
     out.print("<TD>"+rs.getString("price")+"</TD>");
     out.print("</TR>");
   }
  out.print("</TABLE>"); 
rs.close();
}catch(Exception ex){ 
ex.printStackTrace(); 
throw new SQLException("cannot get Connection pool."); 
} 
%>