📄 deleteall.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="Checkadmin.asp"-->
<%
dim curpage, i,page,number '显示试题数默认值
subject=trim(request("subject"))
classcode=trim(request("classcode"))
''''''''''''''''''''''''''onle once''''''''
if trim(request("changecode"))<>"" then
set rs=server.createobject("ADODB.recordset")
sql="update score set subjectname='-打字测试-' from score where subjectname='打字测试'"
conn.execute sql
set rs=server.createobject("ADODB.recordset")
sql="update subject set subjectname='-打字测试-' from subject where subjectname='打字测试'"
conn.execute sql
end if
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
if subject<>"" or classcode<>"" then
set rs=server.createobject("ADODB.recordset")
sql="delete from score where subjectname='"&subject&"'"
conn.execute sql
if IsSqlDataBase=1 then
sql="delete from student where substring(studentname,1,4)='"&classcode&"'"
else
sql="delete from student where left(studentname,4)='"&classcode&"'"
end if
conn.execute sql
if err.number <> 0 then
response.write "数据库操作错误：" + err.description
err.clear
else %>
<script language=vbscript>
msgbox "操作成功! 符合条件的纪录已删除!"
</script>
<% end if
end if %>
<html>
<head>
<title>痛快删除纪录</title>
<script language=javascript>
function SureDel(id)
{
if ( confirm("您确定要删除该考试纪录吗？"))
{
window.location.href = "mgscore.asp?action=del&id=" +id
}
}
</script>
<link href="STYLE.CSS" rel="stylesheet" type="text/css">
</head>
<body background=images/backimage.gif >
<a href="primarypage.asp">返回管理界面</a><center>
<p> </p>
<table width="287" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="200"><a href="primarypage.asp"><img src="images/pc.gif" width="200" height="269" border="0"></a></td>
<td width="87"><a href="primarypage.asp" style="font-size: xx-large; font-family: "华文行楷";">痛快删除许多纪录</a></td>
</tr>
</table>
<p> </p>
<table width="76%" border="１" cellpadding="5" cellspacing="5">
<tr>
<td><p align="center" style="font-weight: bold; font-family: "黑体"; font-size: large; color: #000000;"><span style="">删除某一学科的所有考生成绩</span></p>
<p align="center" style="font-weight: bold; font-family: "黑体"; font-size: large; color: #000000;"><span style="">（非常危险，不可恢复，请在无人考试的情况下进行！</span>）</p></td>
</tr>
<tr>
<td><form action="deleteall.asp" method="post" name="form2" style="font-family: "黑体"; font-size: x-large;">
<div align="center"><span style="color: #FFFFFF"><span style="color: #000000">输入学科名称</span>：</span>
<input name="subject" type="text" id="subject" value="00">
<input type="submit" name="Submit2" value="提交">
</div>
</form></td>
</tr>
<tr>
<td bgcolor="#99CC00"> </td>
</tr>
<tr>
<td height="120">
<div align="center" style="font-weight: bold; font-family: "黑体"; font-size: large; color: #000000;">
<p>删除所有学生的基本信息</p>
<p>（非常危险，不可恢复，请在无人考试的情况下进行！）</p>
</div></td>
</tr>
<tr>
<td><form action="deleteall.asp" method="post" name="form1" style="font-family: "黑体"; font-size: x-large; color: #000000;">
<div align="center"><span style="">输入班级代码：</span>
<input name="classcode" type="text" id="classcode" value="00">
<input type="submit" name="Submit" value="提交">
</div>
</form></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><p align="center">批量更改字段值</p>
<p align="center">（非常危险，不可恢复，请在无人考试的情况下进行！）</p></td>
</tr>
<tr>
<td><form name="form3" method="post" action="deleteall.asp">
<input name="changecode" type="text" id="field" value="打字测试">
<input type="submit" name="Submit3" value="提交">
</form></td>
</tr>
</table>
<p> </p>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -