lxmain.asp

这是我个公交查询系统,用ASP+SQL做的,经过多次调试了 能够很好运行.

<!--#include file="conn.asp"-->
<table width="780" border="0" align="center">
<tr>
<td width="157" valign="top"><form id="form1" name="form1" method="post" action="edition.asp?action=addlxmain"><br><br>
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" style="font-size:14px">
    <tr>
      <td height="36" style="background-color:#6699FF; font-size:16px; color:#FFCC66">&nbsp;添加路线</td>
    </tr>
    <tr>
      <td height="30" align="center" style="border-bottom:none">路&nbsp;线：
        <input type="text" name="luxian" size="10"/></td>
    </tr>
    <tr>
      <td height="30" align="center" style="border-bottom:none; border-top:none">起点站:        
        <input type="text" name="fzhandian" size="10" /></td>
    </tr>
    <tr>
      <td height="30" align="center" style="border-bottom:none; border-top:none">终点站:
        <input type="text" name="ezhandian" size="10" /></td>
    </tr>
    <tr>
      <td height="30" align="center" style="border-bottom:none; border-top:none">
        类 型:
		<select class="select" name="leixing" size="1">
					<option value="">选择 类型</option>
					<option value="环形">环形</option>
					<option value="上下">上下</option>
			        <option value="上行">上行</option>
			        <option value="下行">下行</option>
			</select></td>
    </tr>
    <tr>
      <td height="30" align="center" style="border-bottom:none; border-top:none">总站数:
        <input type="text" name="allzhandian" size="10"/></td>
    </tr>
    <tr>
      <td align="right" height="30" style="background-color:#6699FF"><input type="submit" name="Submit2" value="提交" />&nbsp;</td>
    </tr>
  </table>
</form>
</td>
      <td width="613">
<table width="100" border="1" align="center"> 
<% 
   set rs=server.CreateObject("adodb.recordset") 
   sql="select * from lx "
   rs.open sql,conn,1,1
      set rsc=server.CreateObject("adodb.recordset") 
      sqlc="select count(*) from lx "
      rsc.open sqlc,conn,1,1
	  all_luxian=rsc(0)
%>
  <tr>
       <td colspan="6" height="36" style="background-color:#6699FF; color:#FFCC99"> &nbsp;九江公交 共<span style="font-size:18px; color:#FF0000"> <%=all_luxian%></span> 路 基本情况如下:</td>
  </tr>
  <tr>
        <td  height="23" align="center" width="125">路线</td>
        <td  height="23" align="center" width="145">起点站</td>
        <td  height="23" align="center" width="151">终点站</td>
		<td  height="23" align="center" width="151">类型</td>
        <td  height="23" align="center" width="105">总站数</td>
		<td  height="23" align="center" width="42">修改</td>
  </tr>
  <tr>

<%   
   do while not rs.eof
%>		
<form name="<%=rs(0)%>" method="post" action="edition.asp?action=lxmain">
<td><input type="text" name="luxiang" value="<%=rs(0)%>" style="border:none" size="10">
<input type="hidden" name="luxian" value="<%=rs(0)%>"></td>
<td><input name="fzhandian" type="text" style="border:none" value="<%=rs(1)%>" size="16"></td>
<td><input type="text" name="ezhandian" value="<%=rs(2)%>"style="border:none" size="16"></td>
<td><input type="text" name="leixing" value="<%=rs(3)%>"style="border:none" size="15"></td>
<td><input type="text" name="allzhandian" value="<%=rs(4)%>"style="border:none" size="15"></td>
<td width="42"><input type="submit" name="Submit" value="修改" style="background-color:#FFFFFF; border:none"></td>
</form>

  </tr><tr>
<%
   rs.movenext
   loop
   rs.close
   set rs=nothing
%>
</table></td></tr></table>
<%  
    conn.close
	set conn=nothing 
%>