📄 class_change.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="const.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.STYLE1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<%
action=request("action")
if action="change" then
class_id=SafeChar(Request("class_id"))
class_name=SafeChar(Request("class_name"))
class_mng=SafeChar(Request("class_mng"))
class_mngpwd=Request("class_mngpwd")
truename=Request("truename")
Dim d
Set d = Server.CreateObject("ADODB.Recordset")
d.ActiveConnection = dbconn
d.Source = "SELECT class_id FROM class where (class_name='"&class_name&"' or class_mng='"&class_mng&"') and class_id<>"&class_id&" "
d.CursorType = 0
d.CursorLocation = 2
d.LockType = 1
d.Open()
if not d.eof then
Response.Write("<script language='javascript'>alert('班级名称名或管理帐号已被占用');history.go(-1);</script>")
else
set e=Server.CreateObject("ADODB.Command")
e.ActiveConnection=dbconn
e.CommandText= "update class set class_name='"&class_name&"', class_mng='"&class_mng&"', class_mngpwd='"&class_mngpwd&"', truename='"&truename&"' where class_id="&class_id&""
e.CommandType=1
e.CommandTimeout=0
e.Prepared=true
e.Execute()
Response.Write ("<script language='javascript'>alert('班级："&class_name&"修改成功');location=('class.asp');</script>")
end if
d.Close()
set d=nothing
%>
<%else
class_id=Request("class_id")
Dim rs1
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = dbconn
rs1.Source = "SELECT * FROM class where class_id="&class_id&""
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 1
rs1.Open()
if rs1.eof then response.Write("系统错误") end if
%>
<script language="javascript">
function chk()
{
if(document.form.class_name.value=="")
{alert("班级名称不能为空");return false;}
if(document.form.class_mng.value=="")
{alert("管理员不能为空");return false;}
if(document.form.class_mngpwd.value=="")
{alert("管理员密码不能为空");return false;}
return true;
}
</script>
<p> </p>
<form name="form" action="" method="post" onsubmit="return chk()">
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="0" class="atable1">
<tr>
<td colspan="6" bgcolor="#333"><span class="STYLE1"> 班级资料修改</span></td>
</tr>
<tr>
<td width="13%" height="30" class="tdmenu"><div align="center"></div></td>
<td width="31%" class="tdmenu"><div align="center"></div></td>
<td width="13%" class="tdmenu"><div align="center"></div></td>
<td width="15%" class="tdmenu"><div align="center"></div></td>
<td width="13%" class="tdmenu"><div align="center"></div></td>
<td width="15%" class="tdmenu"><div align="center"></div></td>
</tr>
<tr>
<td class="tdmenu"><div align="center">班级名称:</div></td>
<td class="tdmenu">
<div align="left">
<input name="class_name" type="text" class="atable1" id="class_name" value="<%=rs1(1)%>" size="30" />
</div></td>
<td class="tdmenu"><div align="center">管理员帐号：</div></td>
<td class="tdmenu"><div align="center">
<input name="class_mng" type="text" class="atable1" id="class_mng" value="<%=rs1(2)%>" size="14" maxlength="14" />
</div></td>
<td class="tdmenu"><div align="center"> 姓名：</div></td>
<td class="tdmenu"><div align="center">
<input name="truename" type="text" class="atable1" id="truename" value="<%=rs1(4)%>" size="10" maxlength="10" />
</div></td>
</tr>
<tr>
<td height="30" colspan="2" class="tdmenu"><div align="center">注：名称、管理员帐号不能和已<br />
存在的其他班级名称、帐号同名 </div>
<div align="center"></div>
<div align="center"></div>
<div align="center"></div></td>
<td height="30" class="tdmenu"> 密码：</td>
<td height="30" class="tdmenu"><div align="center">
<input name="class_mngpwd" type="text" class="atable1" id="class_mngpwd" value="<%=rs1(3)%>" size="14" maxlength="14" />
</div></td>
<td class="tdmenu"><div align="center">
<input name="提交" type="submit" class="tdmenu" id="提交" value="提交" />
</div></td>
<td class="tdmenu">
<div align="left">
<input name="重填" type="reset" class="tdmenu" id="重填" value="重填" />
<input type="hidden" name="action" value="change" />
<input name="class_id" type="hidden" id="class_id" value="<%=rs1(0)%>" />
</div></td>
</tr>
</table>
</form>
<%end if%>
</body>
</html>
<%dbconn.close%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -