📄 109e3fdc7054001d16abea021d8fc215
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<jsp:useBean class="bb.db" id="py" scope="page"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>guestquery.jsp</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="img/42.jpg"><br><br><body>
<form method="post"name="house" action="guestquery.jsp">
<input type="text" name="guestname">
<input type="submit"value="查询">
<a href="guestsubs.jsp">返回</a>
<%String a=request.getParameter("guestname");
if (a!=null)
{
String sql="select * from guestsubs where guestname='"+a+"'";
ResultSet rs=py.executeQuery(sql);
if(rs.next())
{
%>
<table width="300"" border="1" align="center" cellpadding="1" cellspacing="0">
<tr>
<td colspan="2"><center>客户查询操作</center>
</tr>
<tr>
<td width="80"><div align="right">客户姓名:</div></td>
<td width="80"><label>
<input type="text" name="guestname"value="<%=rs.getString("guestname")%>">
</label></td>
</tr>
<tr>
<td width="80"><div align="right">客户性别：</div></td>
<td width="80"><label>
<input type="text" name="sex" value="<%=rs.getString("sex")%>">
</label></td>
</tr>
<tr>
<td width="80"><div align="right">证件号码：</div></td>
<td width="80"><label>
<input type="text" name="cardnum" value="<%=rs.getString("cardnum")%>">
</label></td>
</tr>
<tr>
<td><div align="right">联系电话:</div></td>
<td width="80"><label>
<input type="text" name="link"value="<%=rs.getString("link")%>">
</label></td>
</tr>
<tr>
<td width="80"><div align="right">房间编号:</div></td>
<td width="80"><label>
<input type="text" name="houseid"value="<%=rs.getString("houseid")%>">
</label></td>
</tr>
<tr>
<td><div align="right">房间类型:</div></td>
<td><label>
<input type="text" name="housetype" value="<%=rs.getString("housetype")%>">
</label></td>
</tr>
<tr>
<td width="80"><div align="right">入住时间:</div></td>
<td width="80"><label>
<input type="text" name="cometime"value="<%=rs.getString("cometime")%>">
</label></td>
</tr>
<tr>
<td><div align="right">预订时间:</div></td>
<td width="80"><label>
<input type="text" name="gotime"value="<%=rs.getString("gotime")%>">
</label></td>
</tr>
<tr>
<td width="80"><div align="right">保存时间:</div></td>
<td width="80"><label>
<input type="text" name="keeptime"value="<%=rs.getString("keeptime")%>">
</label></td>
</tr>
<tr>
<td><div align="right">备注:</div></td>
<td width="80"><label>
<input type="text" name="memo"value="<%=rs.getString("memo")%>">
</label></td>
</tr>
<tr>
</table>
<center>
<input type="reset"value="清除"></center>
</form>
<%} }%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -