searchresult.jsp

J2EE 技术 源码 书籍源代码（j2ee编程技术）

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

try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/sample","root",""); 
preparedStmt =conn.prepareStatement("select customerid,firstname,lastname,address from customer where firstname like ? ");
//设置参数
String parm= request.getParameter("parm");
preparedStmt.setString(1,"%"+parm+"%");
//执行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()) { //取得下一条记录
String name=new String(sqlRst.getString("firstname").getBytes("iso-8859-1"));
name+=new String(sqlRst.getString("lastname").getBytes("iso-8859-1"));
 %> 
<tr><!--显示记录--> 
  <td><%=sqlRst.getString("customerid")%></td> 
  <td><%=new String(sqlRst.getString("address").getBytes("iso-8859-1"))%></td> 
  <td><%=name%></td> 
   </tr> 
<% } %> 
</table> 
<%
 //关闭结果集对象 
  sqlRst.close(); 
  //关闭语句对象 
  preparedStmt.close (); 
  //关闭数据库连接 
  conn.close(); 
} catch (java.sql.SQLException e){
out.println(e.toString());
}
%>