customer.jsp

来自「介绍了j2ee开发常用的学习知识,如servlet,javamail,EJB等知」· JSP 代码 · 共 44 行

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<% 
java.sql.Connection conn=null; 
java.lang.String strConn; 
java.sql.Statement sqlStmt=null; //语句对象 
java.sql.ResultSet sqlRst=null; //结果集对象 
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/sample","root","javaee"); 
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> 
<%
 
} catch (java.sql.SQLException e){
out.println(e.toString());
}finally{
    //关闭结果集对象 
  if(sqlRst!=null)sqlRst.close(); 
  //关闭语句对象 
  if(sqlStmt!=null)sqlStmt.close (); 
  //关闭数据库连接 
  if(conn!=null)conn.close(); 
}
%>