test2.jsp

来自「J2EE 技术 源码 书籍源代码（j2ee编程技术）」· JSP 代码 · 共 56 行

<%@ page contentType="text/html;charset=gb2312" %> 
<% 
java.sql.Connection conn; 
java.lang.String strConn; 
java.sql.PreparedStatement preparedStmt; //语句对象 
java.sql.ResultSet sqlRst; //结果集对象 

try{
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
        javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/MySqlDS");
       
        conn = ds.getConnection();

//Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
//conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/sample","root",""); 
preparedStmt =conn.prepareStatement("select customerid,address,phone from customer  ");

//执行Sql语句 

sqlRst=preparedStmt.executeQuery (); 

%>
<center>顾客信息表</center>
<table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0"> 
<tr> 
  <td align="center">&nbsp;ID</td> 
  
  <td align="center">地址</td> 
  
  <td align="center">电话</td> 
  
</tr> 
<% while (sqlRst.next()) { //取得下一条记录 %> 
<tr><!--显示记录--> 
  <td><%=sqlRst.getString("customerid")%></td> 
  <td><%=new String(sqlRst.getString("address").getBytes("iso-8859-1"))%></td> 
  <td><%=sqlRst.getString("phone")%></td> 
  
</tr> 
<% } %> 
</table> 

<%
 //关闭结果集对象 
  sqlRst.close(); 
  //关闭语句对象 
  preparedStmt.close (); 
  //关闭数据库连接 
  conn.close(); 

} catch (java.sql.SQLException e){
out.println(e.toString());

}
%>