huoche.asp

机票订票系统,使用ASP

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="inc/showpage.asp"-->
	<%
set rs=server.createobject("adodb.recordset")
sql="select * from train order by id desc"
rs.open sql,conn,1,1 %>
<% if rs.bof and rs.eof then
response.write"<table><tr><td>还没发部信息！</td></tr></table>"
else %>
	<table width="108%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="#999999">
  <TR>
    <TD height=20 colspan="11" align="center" bgColor=#ffffff><font color="#FF0000" size="+1"><strong>[火车&nbsp;航&nbsp;线&nbsp;维&nbsp;护] </strong></font></TD>
    </TR>
  <TR>
    <TD width=70 align="center" bgColor=#ffffff>ID</TD>
    <TD width=70 bgColor=#ffffff height=20>
      <DIV align=center>出发城市</DIV></TD>
    <TD width=57 bgColor=#ffffff height=20>
      <DIV align=center>到达城市</DIV></TD>
    <TD width=59 bgColor=#ffffff height=20>
      <DIV align=center>车次</DIV></TD>
    <TD width=69 bgColor=#ffffff height=20>
      <DIV align=center>开车时间</DIV></TD>
    <TD width=75 bgColor=#ffffff height=20>
      <DIV align=center>到达时间</DIV></TD>
    <TD width=68 bgColor=#ffffff height=20>
      <DIV align=center>硬座价格</DIV></TD>
    <TD width=73 bgColor=#ffffff height=20>
      <DIV align=center>软座价格</DIV></TD>
    <TD width=67 bgColor=#ffffff height=20>
      <DIV align=center>硬卧价格</DIV></TD>
    <TD width=64 bgColor=#ffffff height=20>
      <DIV align=center>软卧价格</DIV></TD>
    <TD width=116 align="center" bgColor=#ffffff>操作</TD>
  </TR>
	  <% do while not rs.eof %>
  <TR bgColor=#ffffff>
    <TD align="center"><%= rs("id") %></TD>
    <TD height=20>
      <DIV align=center><%= rs("cfcs") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("ddcs") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("sc") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("kcsj") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("ddsj") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("yzjg") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("szjg") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("ywjg") %></DIV></TD>
    <TD height=20>
      <DIV align=center><%= rs("rwjg") %></DIV></TD>
    <TD align="center">[<a href=huoche_e.asp?id=<%= rs("id") %>>修改</a>][<a href=huoche_d.asp?id=<%=rs("id")%>>删除</a>]</TD>
  </TR>
	  <% rs.movenext
	  loop %>
    </table>
	<% end if %>

<table width="938" border="0" cellpadding="0" cellspacing="0" bgcolor="#f5f5f5">
  <tr>
    <td width="893" height="22" align="center"><input type="button" name="Submit2" value="刷 新" onclick="window.location.reload();"></td>
  </tr>
</table>