customer.jsp

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

<%@ page contentType="text/html;charset=gb2312" %> 
<% 
java.sql.Connection conn; 
java.lang.String strConn; 
java.sql.Statement sqlStmt; //语句对象 
java.sql.ResultSet sqlRst; //结果集对象 
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/sample","root",""); 
sqlStmt =conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//执行Sql语句 
String sqlQuery="select customerid,address,phone from customer"; 
sqlRst=sqlStmt.executeQuery (sqlQuery); 
%>
<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(); 
  //关闭语句对象 
  sqlStmt.close (); 
  //关闭数据库连接 
  conn.close(); 

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

}

%>