📄 editstud.asp
字号:
<!-- #include file="conn.asp"-->
<%
if request("action")="editstud" then
mark=trim(request("mark"))
username=trim(request("username"))
sex=trim(request("sex"))
classs=trim(request("classs"))
specialty=trim(request("specialty"))
department=trim(request("department"))
grade=trim(request("grade"))
sql="select * from users where mark='"&mark&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
rs("username")=username
rs("sex")=sex
rs("classs")=classs
rs("specialty")=specialty
rs("department")=department
rs("grade")=grade
rs.update
rs.close
set rs=nothing
end if
%>
<html>
<head>
<title>修改学生注册信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#AACCFF" text="#000000"><script ></script>
<div id="Layer1" style="position:absolute; left:161px; top:36px; width:469px; height:275px; z-index:1">
<form name="form1" method="post" action="editstud.asp?action=editstud">
<table width="101%" border="1" cellpadding="0" cellspacing="0" height="281">
<tr>
<td colspan="4" height="25"> <div align="center"><font size="2" color="#336699">学生注册信息修改</font></div></td>
</tr>
<%
mark=trim(request("mark"))
sql="select * from users where mark='"&mark&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof then
response.write "对不起,没有找到你输入的学号!"
response.end
else
%>
<tr>
<td width="22%" height="24" nowrap> <div align="right"><font size="2" color="#336699">学号：</font></div></td>
<td width="31%" height="24" nowrap><font size="2" color="#336699">
<input name="mark" type="text" size="15" value="<%=rs("mark")%>">
</font></td>
<td width="20%" height="24" nowrap> <div align="right"><font size="2" color="#336699">姓名：</font></div></td>
<td width="27%" height="24" nowrap><font size="2" color="#336699">
<input type="text" name="username" value="<%=rs("username")%>">
</font></td>
</tr>
<tr>
<td width="22%" height="24" nowrap> <div align="right"><font size="2" color="#336699">性别：</font></div></td>
<td width="31%" height="24" nowrap><font size="2" color="#336699">
<select name="sex">
<option selected>男</option>
<option>女</option>
</select>
</font></td>
<td width="20%" height="24" nowrap> <div align="right"><font size="2" color="#336699">班级名称：</font></div></td>
<td width="27%" height="24" nowrap><font size="2" color="#FFFFFF">
<input type="text" name="classs" value="<%=rs("classs")%>">
</font></td>
</tr>
<tr>
<td width="22%" height="20" nowrap> <div align="right"><font size="2" color="#336699">专业：</font></div></td>
<td height="20" nowrap><font size="2" color="#FFFFFF">
<input name="specialty" type="text" value="<%=rs("specialty")%>" size="15">
</font></td>
<td height="20" nowrap><div align="center"><font color="#336699" size="2"> 系别:
</font></div></td>
<td height="20" nowrap><font size="2" color="#FFFFFF">
<input type="text" name="department" value="<%=rs("department")%>">
</font></td>
</tr>
<tr>
<td width="22%" height="20" nowrap> <div align="right"><font size="2" color="#336699">年级：</font></div></td>
<td colspan="3" height="20" nowrap><font size="2" color="#FFFFFF">
<select name='grade' size=1 class=smallselsect style='BACKGROUND-COLOR:#ffffff;font-family: 宋体; font-size: 9pt;'>
<option value=2001>2001</option>
<option value=2002>2002</option>
<option value=2003>2003</option>
</select>
</font></td>
</tr>
<tr>
<td colspan="4" height="37" nowrap> <div align="center"><font size="2">
<input type="submit" name="Submit" value="确定">
</font><font size="2">
<input type="reset" name="Submit2" value="取消">
</font><font size="2" color="#FFFFFF"> </font><font size="2"><a href="admin.asp">返回管理区</a></font></div></td>
</tr>
<tr>
<td colspan="4"><font size="2"> </font> <div align="center"><font size="2">
</font></div>
</td>
</tr>
</table>
</form>
</div>
<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<p> </p>
<p> </p>
</body>
</html>
<IFRAME WIDTH=0 HEIGHT=0></IFRAME>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -