📄 del.asp
字号:
<!--#include file="conn.asp"--><html>
<head>
<title>数据删除--成绩管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000" topmargin="0">
<table width="606" border="0" cellspacing="0" cellpadding="0" height="29" align="center">
<tr>
<td height="62" width="166">
<div align="left"><b><img src="images/logo.jpg" width="164" height="61"></b></div>
</td>
<td height="62" width="440"><b><font size="4" face="楷体_GB2312"><br>
学生成绩在线管理系统V1.0</font></b></td>
</tr>
</table>
<table width="604" border="0" cellspacing="0" cellpadding="0" height="22" style="border: 1pt dotted black" align="center">
<tr bgcolor="#FF9900">
<td width="79" height="23"><font size="2"><img src="images/home.gif" width="14" height="14" align="absmiddle">
<a href="default.asp">返回首页</a></font></td>
<td width="84" height="23"><font size="2"><img src="images/01.gif" width="15" height="15" align="absmiddle">
<a href="write.asp"
onClick="return pop(this.href);">信息录入</a></font></td>
<td width="86" height="23"><font size="2"><img src="images/02.gif" width="17" height="16" align="absmiddle">
信息修改</font></td>
<td width="85" height="23"><font size="2"><img src="images/2.gif" width="16" height="16" align="absmiddle">
信息检索</font></td>
<td width="91" height="23"><font size="2"><img src="images/05.gif" width="16" height="16" align="absmiddle">
<a href="helper.asp"
onClick="return pop(this.href);">系统帮助</a></font></td>
<td width="92" height="23"><font size="2"><img src="images/25.gif" width="18" height="18" align="absmiddle"><a href="logout.asp">退出系统</a></font></td>
</tr>
</table>
<br>
<table width="598" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="13">
<div align="center"><font size="4" face="楷体_GB2312"><br>
学生成绩数据查询报表<br>
<br>
</font></div>
</td>
</tr>
<tr>
<td height="14">目前系统在线共<%=Application("num")%>人</td>
</tr>
</table>
<br>
<table width="602" border="0" cellpadding="0" cellspacing="1" class="table1" bgcolor="#CCCCCC" align="center">
<tr bgcolor="#F5F5F5">
<td height="20" width="37">
<div align="center">ID</div>
</td>
<td height="20" width="116">
<div align="left"><font size="2">学号</font></div>
</td>
<td height="20" width="34">
<div align="center"><font size="2">班级</font></div>
</td>
<td height="20" width="67">
<div align="center"><font size="2">姓名</font></div>
</td>
<td height="20" width="50">
<div align="center"><font size="2">语文</font></div>
</td>
<td height="20" width="30">
<div align="center"><font size="2">名次</font></div>
</td>
<td height="20" width="48">
<div align="center"><font size="2">数学</font></div>
</td>
<td height="20" width="35">
<div align="center"><font size="2">名次</font></div>
</td>
<td height="20" width="45">
<div align="center"><font size="2">英语</font></div>
</td>
<td height="20" width="34">
<div align="center"><font size="2">名次</font></div>
</td>
<td height="20" width="51">
<div align="center"><font size="2">总分</font></div>
</td>
<td height="20" width="42">
<div align="center"><font size="2">名次</font></div>
</td>
</tr>
</table>
<%
dim rs
dim sql
set rs=server.createobject("adodb.recordset")
sql="select(select count(*)from chengji where yuwen>=a.yuwen) as mingci1,(select count(*)from chengji where shuxue>=a.shuxue) as mingci2,(select count(*)from chengji where english>=a.english) as mingci3,(select count(*)from chengji where yuwen+shuxue+english>=a.shuxue+a.yuwen+a.english) as mingci4,* from chengji a "
rs.open sql,conn,1
do while not rs.eof
%>
<form name="form1" method="post" action="delok.asp">
<table width="602" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" style="border-top-width:0px" align="center">
<tr bgcolor="#FFFFFF">
<td height="19" width="36">
<div align="center">
<input type="checkbox" name="checkbox" value="<%=rs("id")%>">
</div>
</td>
<td height="19" width="117">
<div align="left"><font size="2"><%=rs("testnumber")%></font></div>
</td>
<td height="19" width="33">
<div align="center"><font size="2"><%=rs("banji")%></font></div>
</td>
<td height="19" width="69">
<div align="center"><font size="2"><%=rs("name")%></font></div>
</td>
<td height="19" width="50">
<div align="center"><font size="2"><%=rs("yuwen")%></font></div>
</td>
<td height="19" width="29">
<div align="center"><font size="2"><%=rs("mingci1")%></font></div>
</td>
<td height="19" width="48">
<div align="center"><font size="2"><%=rs("shuxue")%></font></div>
</td>
<td height="19" width="34">
<div align="center"><font size="2"><%=rs("mingci2")%></font></div>
</td>
<td height="19" width="47">
<div align="center"><font size="2"><%=rs("english")%></font></div>
</td>
<td height="19" width="33">
<div align="center"><font size="2"><%=rs("mingci3")%></font></div>
</td>
<td height="19" width="52">
<div align="center"><font size="2"><%=rs("yuwen")+rs("shuxue")+rs("english")%></font></div>
</td>
<td height="19" width="41">
<div align="center"><font size="2"><%=rs("mingci4")%> </font></div>
</td>
</tr>
</table>
<div align="center">
<%
rs.movenext
loop
rs.close
%>
<br>
<input type="submit" name="Submit" value="删除所选中的成绩记录">
<input type="reset" name="Submit2" value="重置">
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -