tea_edit.asp

来自「C# SQL 齐齐哈尔职业学院学生成绩管理系统」· ASP 代码 · 共 82 行

ASP
82
字号
<!--#include file="chkadmin.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<title>学生成绩管理系统</title>
</head>

<body>

<%
Dim id
id=Request("id")
set rs=server.createobject("adodb.recordset")
rs.open "select * from [teacher] where id="&id,conn,1,3
%>
<div align="center">
  <center>
 
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#ffffff" width="100%">
  <form method="post" action="tea_edit_ok.asp?id=<%=rs("id")%>">   
    <tr>
      <td width="100%" background="../Images/admin_table_bg.gif" height="25" colspan="2">
      <p align="center"><font color="#FFFFFF"><b>教师信息修改</b></font></td>
    </tr>
    
    <tr>
      <td width="11%" height="15" bgcolor="#D9E6FF">姓&nbsp;&nbsp;&nbsp; 名:</td>
      <td width="89%" height="15" bgcolor="#D9E6FF">
      <input type="text" name="name" size="20" value="<%=rs("name")%>" tabindex="1"></td>
    </tr>
    <tr>
      <td width="11%" height="15" bgcolor="#D9E6FF">教学科目:</td>
      <td width="89%" height="15" bgcolor="#D9E6FF">
      <select name="subid" tabindex="2">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from [sub]",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option>没有科目</option>"
Else
Do While Not fs.EOF
  If fs("id")=rs("subid") Then
    Response.write "<option selected value="&fs("id")&">"&fs("sub")&"</option>"
  Else

%>      
      <option value=<%=fs("id")%>><%=fs("sub")%></option>
<%
End If
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
      </select></td>
    </tr>
    
    <tr>
      <td width="11%" height="15" bgcolor="#D9E6FF">管理密码:</td>
      <td width="89%" height="15" bgcolor="#D9E6FF">
      <input type="text" name="pwd" size="20" value="<%=rs("pwd")%>" tabindex="3"></td>
    </tr>
    
    <tr>
      <td width="11%" bgcolor="#D9E6FF" height="15">
       </td>
      <td width="89%" bgcolor="#D9E6FF" height="15">
      <input type="submit" value="修 改" name="B1"></td>
    </tr>
 </form> 
 </table>
   </center>
</div>

</body>

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?