📄 search.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<title>航空售票系统</title>
<link rel="stylesheet" href="ticket.css">
</head>
<body bgcolor="#F4F4FF">
<%
date1=trim(request.form("date1"))
flight1=trim(request.form("flight1"))
num1=trim(request.form("num1"))
set rs=server.CreateObject ("ADODB.Recordset")
str="select ID,flight,num,name,idcard,flag from "&date1&" where num="&num1&" and flag=1 and flight='"&flight1&"'"
rs.open str,conn,3
if date1="" or flight1="" or num1="" then%>
<script language=vbscript>
MsgBox "请完整填写查询内容！"
location.href = "javascript:history.back()"
</script>
<%else
%>
<p align="center">日期是<b><font color=red><%=date1%></font></b>班次是<b><font color=red><% =flight1%></font></b>座位号是<b><font color=red><%=num1%></font></b>的查询结果：</p>
<table width="50%" border="0" align="center" cellspacing="1" bgcolor="#C0C0C0">
<tr><th>日期</th><th>订票号</th><th>班次</th><th>座位号</th><th>姓名</th><th>身份证号</th></tr>
<%
if rs.EOF then
response.write "<center><font color=red>对不起,没有符合条件的乘客信息！</font></center>"
else
do while not rs.eof
for i=0 to rs.fields.count-1 step 6
%>
<tr valign="middle" bgcolor="#F4F4FF" align="center">
<td><%=date1%></td><td><%=rs(i)%></td><td> <%=rs(i+1)%></td><td><%=rs(i+2)%></td><td><%=rs(i+3)%></td><td><%=rs(i+4)%></td>
</tr>
<%next
rs.movenext
loop
end if
end if
%>
</table>
<br>
<center>
<a href="logout.asp">☆确定☆</a></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -