updata.asp

一个用ASP编写的 关于火车售票的系统 写得还很详细的值得借鉴阿

<%if session("password")<>"" then%>
<!--#include file="inc/conn1.asp"-->

<!-- #include file="inc/top.asp" --> 

<%if request.querystring("kind")="admin" then%>

<%
    id=trim(Request("id"))
    sqlcmd = ("select  * from admin where id="&id)          '查询id(ID号)这条记录
    rs.Open sqlcmd,newconn,1,1
session("user")=rs("username")
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><form method="POST" action="modify.asp">
        <table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr>
            <td height="25" align="center">&nbsp;</td>
            <td height="25">&nbsp;</td>
            <td height="25">&nbsp;</td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">用户名</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="username" size="25" maxlength="30"  class="editbox1" value="<%=rs("username")%>">
            </td>
          </tr>
          <tr>
            <td height="25" align="center">密码</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
              <input name="password" type="password" size="25" maxlength="30" class="editbox1" value="<%=rs("password")%>"></td>
          </tr>

          <tr>
            <td height="25" colspan="3">　　　　　　　　
                <div align="center">
                  <!-- <input class=bottom name=B12 type=submit value="修改记录"> -->
                  <input class=bottom name=B22 type=reset value="重新填写">
                  <input type="hidden" name="kind" value="0">
                  <input type="hidden" name="id" value="<%=rs("id")%>">
              </div></td>
          </tr>
        </table>
</form>
</td>
  </tr>
</table>

<%end if%>
<%if request.querystring("kind")="user" then%>

<%
    id=trim(Request("id"))
    sqlcmd = ("select  * from user where id="&id)           '查询id(ID号)这条记录
    rs.Open sqlcmd,newconn,1,1
session("xh")=rs("xh")
session("return")="admin_user.asp"
%> 

	<form method="POST" action="modify.asp">
	
        <table border="0" cellspacing="0" cellpadding="0" align="center">
		
          <tr>
            <td width="57" height="25" align="center">班级</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="bj" size="25" maxlength="30"  class="editbox1" value="<%=rs("bj")%>">
            </td>
          </tr>
		  
          <tr>
            <td height="25" align="center">学号</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
              <input name="xh" size="25" maxlength="30" class="editbox1" value="<%=rs("xh")%>"></td>
          </tr>
		  
          <tr>
            <td width="57" height="25" align="center">姓名</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="xm" size="25" maxlength="40" class="editbox1" value="<%=rs("xm")%>">
            </td>
          </tr>
		  
          <tr>
            <td width="57" height="25" align="center">密码</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input type="text" name="mm" size="25" class="editbox1" value="<%=rs("mm")%>">
            </td>
          </tr>
		  
          <tr>
            <td height="25" align="center">性别&nbsp;</td>
            <td height="25">&nbsp;</td>
            <td height="25">        
			 <select name="sex">
            <option<%if rs("sex")="男" then response.write(" selected")%>>男</option>
            <option<%if rs("sex")="女" then response.write(" selected")%>>女</option>&nbsp;   
</td>
          </tr>
		  
          <tr>
            <td width="57" height="25" align="center">&nbsp;</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
			&nbsp;
            </td>
          </tr>
		  
          <tr>
            <td width="57" height="25" align="center">住址</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
			<input name="addr" size="25" maxlength="100" class="editbox1" value="<%=rs("addr")%>">
            </td>
          </tr>
		  
          <tr>
            <td width="57" height="25" align="center">邮编</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
			<input name="yb" size="25" maxlength="100" class="editbox1" value="<%=rs("yb")%>">
            </td>
          </tr>
		  
          <tr>
            <td height="25" colspan="3">　　　　　　　　
                <div align="center">
                  <input class=bottom name=B12 type=submit value="修改记录">
                  <input class=bottom name=B22 type=reset value="重新填写">
                  <input type="hidden" name="id" value="<%=rs("id")%>">
                  <input type="hidden" name="kind" value="1">
              </div>
			  </td>
          </tr>
		</table>  
		  
</form>


<%end if%>


<%if request.querystring("kind")="date" then%>
<%
    id=trim(Request("id"))
    sqlcmd = ("select  * from bbs1 where id="&id)           '查询id(ID号)这条记录
    rs.Open sqlcmd,newconn,1,1
%> 

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
	<form method="POST" action="modify.asp">
	
        <table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr>
            <td width="57" height="25" align="center">班级</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="bj" size="25" maxlength="30"  class="editbox1" value="<%=rs("bj")%>">
            </td>
          </tr>
          <tr>
            <td height="25" align="center">序号</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
              <input name="xh" size="25" maxlength="30" class="editbox1" value="<%=rs("xh")%>"></td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">日期</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="user" size="25" maxlength="40" class="editbox1" value="<%=rs("user")%>">
            </td>
          </tr>
          <tr>
            <td height="25" align="center">车次</td>
            <td height="25">&nbsp;</td>
            <td height="25"><input name="user" size="25" maxlength="40" class="editbox1" value="<%=rs("beizhu")%>"></td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">中转站</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input type="text" name="kc" size="25" class="editbox1" value="<%=rs("kc")%>">
            </td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">终到站</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
              <input name="cj" size="25" maxlength="100" class="editbox1" value="<%=rs("cj")%>">
            </td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">学期</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
                <select name="xq" class="editbox1">
                  <option<%if rs("xq")="莲华校区" then response.write(" selected")%>>莲华校区</option>
                  <option<%if rs("xq")="第二学期" then response.write(" selected")%>>第二学期</option>
                  <option<%if rs("xq")="第三学期" then response.write(" selected")%>>第三学期</option>
                  <option<%if rs("xq")="第四学期" then response.write(" selected")%>>第四学期</option>
                  <option<%if rs("xq")="第五学期" then response.write(" selected")%>>第五学期</option>
                  <option<%if rs("xq")="第六学期" then response.write(" selected")%>>第六学期</option>
                  <option<%if rs("xq")="第七学期" then response.write(" selected")%>>第七学期</option>
                  <option<%if rs("xq")="第八学期" then response.write(" selected")%>>第八学期</option>
                </select>
            </td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">类型</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
            <select name="lx" type="lx">
               <option<%if rs("lx")="必修课" then response.write(" selected")%>>必修课</option>
               <option<%if rs("lx")="选修课" then response.write(" selected")%>>选修课</option>
               <option<%if rs("lx")="限修课" then response.write(" selected")%>>限修课</option>
            </select>

            </td>
          </tr>
          <tr>
            <td height="25"><div align="center">备注</div></td>
            <td height="25">&nbsp;</td>
            <td height="25"><input name="user" size="25" maxlength="40" class="editbox1" value="<%=rs("xxx")%>"></td>
          </tr>
          <tr>
            <td height="25" colspan="3">　　　　　　　　
                <div align="center">
                  <input class=bottom name=B12 type=submit value="修改记录">
                  <input class=bottom name=B22 type=reset value="重新添写">
                  <input type="hidden" name="id" value="<%=rs("id")%>">
                  <input type="hidden" name="kind" value="2">
              </div></td>
          </tr>
        </table>
</form>
</td>
  </tr>
</table>
<%end if%>

<%if request.querystring("kind")="bj" then%>

<%
    id=trim(Request("id"))
    sqlcmd = ("select  * from bjb where id="&id)          '查询id(ID号)这条记录
    rs.Open sqlcmd,newconn,1,1
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><form method="POST" action="modify.asp">
        <table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr>
            <td height="25" align="center">&nbsp;</td>
            <td height="25">&nbsp;</td>
            <td height="25">&nbsp;</td>
          </tr>
          <tr>
            <td width="57" height="25" align="center">班级</td>
            <td width="16" height="25">　</td>
            <td width="225" height="25">
              <input name="bj" size="25" maxlength="30"  class="editbox1" value="<%=rs("bj")%>">
            </td>
          </tr>
          <tr>
            <td height="25" align="center">学号代码</td>
            <td width="16" height="25">&nbsp;</td>
            <td width="225" height="25">
              <input name="xhf" type="text" size="25" maxlength="30" class="editbox1" value="<%=rs("xhf")%>"></td>
          </tr>

          <tr>
            <td height="25" colspan="3">　　　　　　　　
                <div align="center">
                  <input class=bottom name=B12 type=submit value="修改记录">
                  <input class=bottom name=B22 type=reset value="重新填写">
                  <input type="hidden" name="kind" value="3">
                  <input type="hidden" name="id" value="<%=rs("id")%>">
              </div></td>
          </tr>
        </table>
</form>
</td>
  </tr>
</table>

<%end if%>

<%if request.querystring("kind")="kc" then%>
<%
    id=trim(Request("id"))
    sqlcmd = ("select  * from kcb where id="&id)           '查询id(ID号)这条记录
    rs.Open sqlcmd,newconn,1,1
%> 
<table width=100% border="0" align=center cellpadding="0" cellspacing="0">
  <td align="center" width="50%"><br>
<form name="form1" method="post" action="modify.asp">
<table width="50%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
  <tr align="center">
    <td height="32" colspan="2">修改与班级相对应的课程及类型</td>
    </tr>
  <tr>
    <td width="26%" align="center">班级</td>
    <td width="74%"><input type="text" name="bj" size="30" value="<%=rs("bj")%>">
          </td>
  </tr>
  <tr>
    <td align="center">课程</td>
    <td><input name="kc" type="text" size="30" value="<%=rs("kc")%>"></td>
  </tr>
    <tr>
    <td align="center">学期</td>
    <td><select name="xq">
                        <option<%if rs("xq")="莲华校区" then response.write(" selected")%>>莲华校区</option>
                        <option<%if rs("xq")="第二学期" then response.write(" selected")%>>第二学期</option>
                        <option<%if rs("xq")="第三学期" then response.write(" selected")%>>第三学期</option>
                        <option<%if rs("xq")="第四学期" then response.write(" selected")%>>第四学期</option>
                        <option<%if rs("xq")="第五学期" then response.write(" selected")%>>第五学期</option>
                        <option<%if rs("xq")="第六学期" then response.write(" selected")%>>第六学期</option>
                        <option<%if rs("xq")="第七学期" then response.write(" selected")%>>第七学期</option>
                        <option<%if rs("xq")="第八学期" then response.write(" selected")%>>第八学期</option>
                      </select></td>
  </tr>
  <tr>
    <td align="center">类型</td>
    <td><select name="lx">
                        <option>必修课</option>
                        <option>选修课</option>
                        <option>限修课</option>
                      </select></td>
  </tr>

  <tr align="center">
    <td colspan="2">
    <input name="kind" type="hidden" value="4">
    <input type="submit" name="Submit" value="提交">&nbsp;
      <input type="reset" name="Submit2" value="重置">
      <input type="hidden" name="id" value="<%=rs("id")%>"></td>
    </tr>
  <tr>
    <td colspan=2><table width=100% cellspacing="0" cellpadding="0">
    <tr><td width=15% align=center>
    注意</td><td>1.填写完后请到课程管理一栏进行确认。
    </td>
    </tr>
</table>
</form>

</td>
</tr>
</table>
<br><br>
<%end if%>



<!--#include file="inc/copyright.asp"-->