修改资料代码(测试成功)

来源：互联网发布：手机淘宝找同款在哪里编辑：程序博客网时间：2024/04/18 09:24

数据库的字段看上面的...

tch_tch.asp文件

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>教师资料修改</title>
<LINK href="css.css" rel=stylesheet>
<script language="JavaScript" type="text/JavaScript">

</script>
</head>

<table width="500" height="214" border="0" align="center" cellpadding="5" cellspacing="1">
<tr>
    <td height="214" colspan="3" align="center"><form name="form1" method="post" action="tch_tch_ok.asp">
      <table width="480" border="0" align="center" cellpadding="5" cellspacing="1">
        <tr>
          <td align="center">教师编号：</td>
          <td width="361"><label>
            <input name="tch_no" type="text" value="<%= Session("tch_no")%>" maxlength="8" readonly="true">
          </label></td>
        </tr>
        <tr>
          <td align="center">教师姓名：</td>
          <td><input name="tch_name" type="text" value="<%= Session("tch_name")%>" maxlength="9" readonly="true"></td>
        </tr>
        <tr>
          <td align="center">教师性别：</td>
          <td><input name="tch_sex" type="text" value="<%= Session("tch_sex")%>" maxlength="9" readonly="true"></td>
        </tr>
  <tr>
          <td align="center">教师职称：</td>
          <td><input type="text" name="tch_zc">
              <font color="#FF0000">*</font></td>
        </tr>
        <tr>
          <td align="center">教 研 室：</td>
          <td><input type="text" name="tch_jys">
              <font color="#FF0000">*</font></td>
        </tr>
        <tr>
          <td align="center">研究方向：</td>
          <td><input type="text" name="tch_yjfx">
              <font color="#FF0000">*</font></td>
        </tr>
        <tr>
          <td align="center">学历(位)：</td>
          <td><input type="text" name="tch_lev">
              <font color="#FF0000"> *</font></td>
        </tr>
        <tr>
          <td align="center">学院职务：</td>
          <td><input type="text" name="tch_zw">
              <font color="#FF0000">*</font></td>
        </tr>

      <tr>
          <td align="center">输入密码：</td>
          <td><input type="text" name="tch_pwd">
              <font color="#FF0000">*(请输入您的密码以确认)</font></td>
        </tr>

        <tr>
          <td align="right"> </td>
          <td> </td>
        </tr>
        <tr>
          <td colspan="2" align="center"><input type="submit" name="Submit" value="提交">     <input type="reset" name="Submit2" value="重置"></td>
          </tr>
        <tr>
          <td> </td>
          <td> </td>
        </tr>
        <tr>
          <td> </td>
          <td>如需帮助请与管理员联系QQ：64591732</td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
        </tr>
      </table>
      </form></td>
</tr>
</table>
<p> </p>
</body>
</html>

tch_tch_ok.asp文件

tch_no=request.form("tch_no")
tch_sex=request.form("tch_sex")
tch_zc=request.form("tch_zc")
tch_jys=request.form("tch_jys")
tch_yjfx=request.form("tch_yjfx")
tch_zw=request.form("tch_zw")
tch_lev=request.form("tch_lev")

      Sql="select * from tch where tch_no='"&tch_no&"' "
    set rs=server.createobject("adodb.recordset")
    rs.open sql,conn,1,3

      rs("tch_zc")=tch_zc
      rs("tch_jys")=tch_jys
      rs("tch_yjfx")=tch_yjfx
      rs("tch_zw")=tch_zw
      rs("tch_lev")=tch_lve
   rs.update
   rs.close
   set rs=nothing

response.write "ok"