📄 searchresult.jsp
字号:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%request.setCharacterEncoding("UTF-8"); %>
<%
java.sql.Connection conn;
//java.lang.String strConn;
java.sql.PreparedStatement preSta;
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");
preSta=conn.prepareStatement("select id,firstname,lastname,address,phone from customer where firstname like?");
String param=request.getParameter("param");
preSta.setString(1,"%"+param+"%");
sqlRes=preSta.executeQuery();
%>
<center>顾客信息表</center>
<table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td align="center"> ID</td>
<td align="center">地址</td>
<td align="center">电话</td>
</tr>
<%while(sqlRes.next()){//取得下一条记录
String name=sqlRes.getString("firstname");
name+=sqlRes.getString("lastname"); %>
<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();
//关闭语句对象
preSta.close();
//关闭数据库链接
conn.close();
}catch(java.sql.SQLException e){
out.println(e.toString());
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -