📄 student_edit.asp
字号:
<!--#include file="open.asp" -->
<!--#include file="inc/md5.inc" -->
<%self_name="student_edit.asp"%>
<%
doing=request.querystring("doing")
if doing="login" then '用户登录
user_id=trim(request.form("user_id"))
pass=trim(request.form("pass"))
if user_id<>"" and pass<>"" and instr(user_id,"'")=0 and instr(user_id,"&")=0 then
pass=ucase(md5(pass))
str="select * from user_teacher where teacher_user='"&user_id&"' and teacher_pass='"&pass&"'"
set rs=conn.execute(str)
if not rs.eof then
session("zzteacher")=true
session("name")=rs("teacher_name")
session("teacher_user")=user_id
if rs("teacher_class")="超级管理员" then session("zzadmin")=true end if
else
str="select * from user_student where 学籍号='"&user_id&"' and 密码='"&pass&"'"
set rs=conn.execute(str)
if not rs.eof then
session("zzstudent")=true
session("student_id")=user_id
session("name")=rs("姓名")
session("student_bj")=rs("班级")
end if
end if
end if
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><!--#include file="inc/css.css" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>编辑修改学生信息</title>
</head>
<body topmargin="1">
<!--#include file="top.asp" -->
<!--#include file="menu.asp" -->
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
<%if session("zzteacher")=true or session("zzstudent")=true then%>
<tr>
<td height="20" class="unnamed12"><div align="center">用户已登录 用户类别：
<%if session("zzstudent")=true then%>学生 学籍号：<%=session("student_id")%> 姓名：<%=session("name")%> 班级：<%=session("student_bj")%><%end if%>
<%if session("zzteacher")=true then%>教师 姓名：<%=session("name")%><%end if%>
<%if session("zzadmin")=true then%><a href=system_setup.asp>系统设置</a><%end if%>
<a href="quit.asp">退出</a></div></td>
</tr>
<%else%>
<tr>
<td height="20" class="unnamed12"> <form name="form1" method="post" action="<%=self_name%>?doing=login">
<div align="center">用户登录 输入学籍号或用户名：
<input name="user_id" type="text" id="user_id" value=<%=id_disp%> size="20">
密码：
<input name="pass" type="password" id="pass" size="16">
<input type="submit" name="Submit" class="unnamed12" value="登录">
<input type="reset" name="Submit2" class="unnamed12" value="重填">
<a href="reg.asp?back=<%=self_name%>">注册</a> <a href="rereg.asp">忘记密码</a></div>
</td></form>
</tr>
<%end if%>
</table>
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed4"> </td>
</tr>
</table>
<%if session("zzteacher")=true then%>
<% '修改信息
edit_id=request.querystring("edit_id")
if doing="change" then
bj=request.form("bj")
xjh=trim(request.form("xjh"))
xm=trim(request.form("xm"))
mm=trim(request.form("mm"))
if xjh="" or xm="" then
msg="学籍号、姓名不能为空，请输入正确信息"
else
str="select 学籍号 from user_student where 学籍号='"&xjh&"' and id<>"&edit_id&""
set rs=conn.execute(str)
if not rs.eof then
msg="学籍号重复，请输入正确的学籍号"
else
if mm="" then
str="update user_student set 班级='"&bj&"',学籍号='"&xjh&"',姓名='"&xm&"' where id="&edit_id&""
conn.execute(str)
msg="学生信息已修改"
doing=""
else
mm=ucase(md5(mm))
str="update user_student set 班级='"&bj&"',学籍号='"&xjh&"',姓名='"&xm&"',密码='"&mm&"' where id="&edit_id&""
conn.execute(str)
msg="学生信息已修改"
doing=""
end if
end if
end if
end if
%>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
<tr>
<td width="200" valign="top"><table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed10"> </td>
</tr>
<tr>
<td background="images/top01.gif" class="unnamed10"> </td>
</tr>
<tr>
<td height="30" background="images/mid01.gif" class="unnamed14"> <div align="center"><strong>学生信息操作</strong></div></td>
</tr>
<tr>
<td height="30" background="images/mid01.gif" class="unnamed12"> <div align="center"><a href="student_insert.asp" class="unnamed12wu">增加学生</a></div></td>
</tr>
<tr>
<td height="30" background="images/mid01.gif" class="unnamed12"><div align="center"><a href="student_list.asp" class="unnamed12wu">浏览编辑</a></div></td>
</tr>
<%if session("zzadmin")=true then%>
<tr>
<td height="30" background="images/mid01.gif" class="unnamed12"> <div align="center"><a href="teacher_edit.asp" class="unnamed12wu">增删教师</a></div></td>
</tr>
<%end if%>
<tr>
<td background="images/bottom01.gif" class="unnamed10"> </td>
</tr>
<tr>
<td class="unnamed10"> </td>
</tr>
</table></td>
<td width="570" valign="top">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed10"> </td>
</tr>
</table>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
<%
str="select * from user_student where id="&edit_id&""
set rs=conn.execute(str)
student_class=rs("班级")
%>
<tr>
<td><form name="form2" method="post" action="student_edit.asp?doing=change&edit_id=<%=edit_id%>">
<table width="500" border="1" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#CCCCCC">
<td height="40" colspan="2" class="unnamed18"><div align="center"><strong>修
改 学 生 信 息</strong></div></td>
</tr>
<%str="select * from bj"
set rs=conn.execute(str)%>
<tr class="unnamed14">
<td width="30%" height="30"><div align="right">班 级：</div></td>
<td> <select name="bj" id="bj">
<%do while not rs.eof
response.write rs("bj_name")
%>
<option value=<%=rs("bj_name")%> <%if rs("bj_name")=student_class then%> selected<%end if%>><%=rs("bj_name")%></option>
<%rs.movenext
loop%>
</select></td>
<% str="select * from user_student where id="&edit_id&""
set rs=conn.execute(str)%>
</tr>
<tr class="unnamed14">
<td width="30%" height="30"><div align="right">学籍号：</div></td>
<td>
<input name="xjh" type="text" id="xjh" value="<%=rs("学籍号")%>"></td>
</tr>
<tr class="unnamed14">
<td width="30%" height="30"><div align="right">姓 名：</div></td>
<td>
<input name="xm" type="text" id="xm" value="<%=rs("姓名")%>"></td>
</tr>
<tr class="unnamed14">
<td width="30%" height="30"><div align="right">密 码：</div></td>
<td>
<input name="mm" type="password" id="mm"></td>
</tr>
<tr>
<td height="40" colspan="2"><div align="center">
<input type="submit" name="Submit3" value=" 修 改 ">
<input type="reset" name="Submit4" value=" 重 填 ">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%if msg<>"" then%>
<table width="499" border="0" align="center" cellpadding="4" cellspacing="0" class="unnamed14">
<tr>
<td width="491"><div align="center"><font color="#FF0000"><%=msg%></font>
</div>
</td>
</tr>
</table>
<%end if%>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed10"><font color="#FF0000"> </font></td>
</tr>
</table>
</td>
</tr>
</table>
<%end if%>
<!--#include file="inc/bottom.asp" -->
<%conn.close%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -