📄 edit_student.asp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%if session("zzteacher")=false then
response.redirect("user_student.asp")
end if%>
<!--#include file="open.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="inc/css.css" -->
<title>修改学生信息</title>
</head>
<body topmargin="1">
<!--#include file="inc/top.asp" -->
<!--#include file="inc/menu.asp" -->
<%
edit_id=request.querystring("id")
edit_bj=trim(request.form("edit_bj"))
edit_name=trim(request.form("edit_name"))
edit_xj=trim(request.form("edit_xj"))
yn=request.querystring("yn")
if yn=1 then
str="select * from bj where bj_name='"&edit_bj&"'"
set rs=conn.execute(str)
if rs.eof then
msg="没有这个班级"
yn=0
else
if edit_name="" then
msg="姓名不能为空"
yn=0
else
if edit_xj="" then
msg="学籍卡号不能为空"
yn=0
else
str="update user_st set class='"&edit_bj&"',xj_id='"&edit_xj&"',name='"&edit_name&"' where id="&edit_id&""
conn.execute(str)
msg="信息已修改"
end if
end if
end if
end if
str="select * from user_st where id="&edit_id&""
set rs=conn.execute(str)
%>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="ff99cc" bgcolor="edebeb">
<tr>
<td width="200" valign="top"><div align="center">
<table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed6"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_46.gif" class="unnamed10"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed14">
<div align="center">管理员已登录</div></td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed10"> </td>
</tr>
<tr>
<td height="25" background="images/nxmt_lj_44.gif" class="unnamed12">
<div align="center">在此可修改学生信息</div></td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed10"> </td>
</tr>
<tr>
<td background="images/nxmt_lj_44.gif" class="unnamed12">
<div align="center" class="unnamed14"><a href="user_student.asp">返回</a> <a href="quit.asp">退出</a></div></td>
</tr>
<tr>
<td background="images/nxmt_lj_45.gif" class="unnamed10"> </td>
</tr>
<tr>
<td class="unnamed6"> </td>
</tr>
</table>
</div></td>
<td width="570" valign="top"> <form name="form1" method="post" action="edit_student.asp?yn=1&id=<%=rs("id")%>">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed6"> </td>
</tr>
</table>
<table width="500" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="40" colspan="2" bgcolor="#CCCCCC" class="unnamed14"> <div align="center">增加学生操作</div></td>
</tr>
<tr>
<td width="50%" height="30" class="unnamed12"><div align="center">班 级：</div></td>
<td width="50%" height="30">
<input name="edit_bj" type="text" id="edit_bj" value="<%=rs("class")%>"></td>
</tr>
<tr>
<td height="30" class="unnamed12"><div align="center">姓 名：</div></td>
<td height="30">
<input name="edit_name" type="text" id="edit_name" value=<%=rs("name")%>></td>
</tr>
<tr>
<td height="30" class="unnamed12"><div align="center">学籍卡号：</div></td>
<td height="30">
<input name="edit_xj" type="text" id="edit_xj" value=<%=rs("xj_id")%>></td>
</tr>
<tr>
<td height="40" colspan="2"><div align="center">
<input type="submit" name="Submit" value=" 修 改 ">
<input type="reset" name="Submit2" value=" 重 填 ">
</div></td>
</tr>
</table>
</form>
<div align="center"> <font color="#FF0000"> <span class="unnamed14">
<%if msg<>"" then response.write msg end if%>
</span></font></div></td>
</tr>
</table>
<!--#include file="inc/bottom.asp" -->
<%conn.close%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -