customer.jsp

来自「servlet初学者最好的例子……希望能对大家有所帮助」· JSP 代码 · 共 44 行

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
   
<% request.setCharacterEncoding("UTF-8"); %> 
<%
  
   java.sql.Connection  conn;
   //java.lang.String strConn;
   java.sql.Statement sqlSta;
   java.sql.ResultSet sqlRes;
   try
   {
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
        conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","luo");
        sqlSta=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
        String sqlQuery="select id,address,phone from customer";
        sqlRes=sqlSta.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(sqlRes.next()){//取得下一条记录 %>
   <tr>
     <td align="center"><%=sqlRes.getString("id")%></td>
     <td align="center"><%=sqlRes.getString("address")%></td>
     <td align="center"><%=sqlRes.getString("phone")%></td>
   </tr>
   <%} %>
 </table>
 <%
    //关闭结果集对象
    sqlRes.close();
    //关闭语句对象
    sqlSta.close();
    //关闭数据库链接
    conn.close();
 }catch(java.sql.SQLException e){
    out.println(e.toString());
 } %>