?? resaultb.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<%
dim s,sql,rs,i,page,rowcount
s=request("s")
if s="" then
response.Redirect("find.asp")
end if
if s<>"" then
's=ReplaceBadChar(s)
end if
page=request("page")
if isempty(page) then
page=1
end if
sql="select ID,linenum,ftime,ltime,kongtiao,yuepiao from content where station LIKE '%%" & s & "%%'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.RecordCount<1 then
response.write "對不起！數(shù)據(jù)庫中暫時未收錄您所查找的信息。"
response.write "<a href='find.asp'>返回查詢頁面...</a>"
else
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="sty.css" rel="stylesheet" type="text/css">
<script language="Javascript">
<!--
function opens(Id)
{
surl="cnshow.asp?Id=" + Id;
window.open(surl,"","width=535,height=225,location=0,menubar=0,toolbar=0,scrollbars=1,resizable=yes");
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<style type="text/css">
<!--
a:link {
color: #0000FF;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #B5B5FF;
}
a:hover {
text-decoration: none;
color: #FF9966;
}
a:active {
text-decoration: none;
color: #636563;
}
.style5 {font-size: 12px}
-->
</style></head>
<body bottommargin="0" leftmargin="0" rightmargin="0" topmargin="0">
<table width="760" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#999999" style="font-size:12px ">
<tr bgcolor="#FAFAFA">
<td width="6%"><div align="center"><span class="ddCopy"> </span>序號</div></td>
<td width="28%" height="20"><div align="left"><span class="ddCopy"> </span>車次</div></td>
<td width="37%"><div align="left"><span class="ddCopy"> </span>首末車時間</div></td>
<td width="7%"><div align="center">空調(diào)</div></td>
<td width="9%"><div align="center">月票</div></td>
<td width="13%"><div align="center">詳細(xì)信息</div></td>
</tr>
<%
i=1
rs.pagesize=200
if request("page")<>"" then
rs.absolutepage=request("page")
else
rs.absolutepage=1
end if
rowcount=rs.pagesize
if rs.recordcount=0 then
response.write "沒有你要查找的文檔。"
response.end
else
do while not rs.eof and rowcount>0 %>
<tr bgcolor="#FAFAFA">
<td width="6%" height="20" class="ddCopy">
<div align="center">
<% =i%>
</div></td>
<td width="28%" height="25" class="dd">
<span class="ddCopy"></span>
<% =rs(1)%> </td>
<td width="37%" height="20" class="dd">
<span class="ddCopy"> </span>
<% =rs(2)%> </a> -
<% =rs(3)%></td>
<td width="7%" height="20" class="dd"><div align="center">
<% =rs(4)%>
</a> </div></td>
<td width="9%" height="20" class="dd">
<div align="center">
<% =rs(5)%>
</a> </div></td>
<td width="13%" height="20" class="dd"><div align="center"><a href='JavaScript:opens(<% =rs(0)%>)' >查看</a></div></td>
</tr>
<% rs.movenext
rowcount=rowcount-1
i=i+1
loop
end if %>
</table>
<table width="498" height="25" border="0" align="center">
<tr>
<td width="492"><div align="center" class="style5">711網(wǎng)絡(luò) www.tc711.com </div></td>
</tr>
</table>
<p> </p>
</body>
</html>
<%
end if
%>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -