| 机票查询 |
<%
set rs=server.createobject("adodb.recordset")
sqlcmd="select * from aviation where step='5' or step='2' order by id desc"
rs.open sqlcmd,conn,1,2,1
if rs.eof then
response.write "现在还没有记录"
response.end
end if
%>
| 起飞地点
| 到达地点
| 优惠票价 |
<%for ipage=1 to rs.pagesize%>
| <%=rs("start")%>
| <%=rs("theend")%>
| <%=rs("ourprice")%>
<%
rs.movenext
if rs.eof then exit for
next
rs.close
set rs=nothing
%>
|
随时查询，现场出票. |
| 更多>> |
|
<%
dim thisPage,RPP,thisURL
RPP=20 '每页显示的记录数 record per page
'获取由网址?传来的page的值
if not isempty(request("page")) then
thisPage=cint(request("page"))
else
thisPage=1
end if
'取得本页当前URL
thisURL="http://"&request.serverVariables("server_name")&request.serverVariables("URL")
%>
<%
set rs=server.createobject("adodb.recordset")
sqlcmd="select * from aviation order by id desc"
rs.open sqlcmd,conn,1,1,1
rs.pagesize=RPP
if rs.eof then
response.write "现在还没有记录"
response.end
end if
%>
| 页次:<%=thisPage%>/<%=rs.pagecount%> |
<%if thisPage>1 then%>
|<
<<
<%else%>
|<
<<
<%end if%>
<%
startNO=thisPage-2
if startNO<1 then startNO=1
endNO=thisPage+2
if endNO>rs.pagecount then endNO=rs.pagecount
%>
<%for i=startNO to endNO%>
<%if i=thisPage then%>
[<%=i%>]
<%else%>
<%=i%>
<%end if%>
<%next%>
<%if thisPage
>>
>|
<%else%>
>>
>|
<%end if%>
|
总数:<%=rs.recordcount%> |
| 起飞地点 |
到达地点 |
航空公司 |
参考票价 |
优惠票价 |
起飞时间 |
到达时间 |
<%
i=1
if not (rs.eof or err) then rs.move (thisPage-1)*RPP
do while not (rs.eof or err)
%>
| <%=rs("start")%> |
<%=rs("theend")%> |
<%=rs("company")%> |
<%=rs("price")%> |
<%if rs("ourprice")="" then response.write "无" else response.write rs("ourprice") end if%> |
<%=rs("starttime")%> |
<%=rs("endtime")%> |
<%
i=i+1
if i>RPP then exit do
rs.moveNext
loop
%>
<%
rs.close
set rs=nothing
conn=close
set conn=nothing
%>
|
|
|
|
随时查询，现场出票
|
|
