📄 modify.asp
字号:
<!--#include file="conn.asp"-->
<% if session("user")="" then
response.write"<script>alert('对不起，您还没有登陆，如果您已经注册，请先登陆!');history.back(-1);</script>"
response.End()
end if %>
<html>
<head>
<title>高中学生成绩在线管理系统ASP1.0版---制作：冷剑无情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 12pt
}
A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC6600; TEXT-DECORATION: underline
}
</STYLE></head>
<body bgcolor="#CCCCCC" text="#000000">
<table width="802" border="5" cellspacing="2" cellpadding="4" align="center" bordercolor="#FFFFFF">
<tr>
<td height="787">
<table width="786" border="0" cellspacing="0" cellpadding="0" height="942" align="center">
<tr>
<td height="61">
<div align="center"><b><font size="6" face="楷体_GB2312"><br>
高中学生成绩在线管理系统<br>
</font></b></div>
</td>
</tr>
<tr>
<td height="2">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2">The
Management System Of High School Students Date</font></div>
</td>
</tr>
<tr>
<td height="15"> </td>
</tr>
<tr>
<td height="24">
<table width="802" border="0" cellspacing="0" cellpadding="0" align="center" height="23">
<tr>
<td bgcolor="#EEEEEE">
<div align="center"><font size="2"><img src="images/home.gif" width="14" height="14" align="absmiddle">
<a href="main.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">返回首页</a>
<img src="images/2.gif" width="16" height="16" align="absmiddle">
<a href="search.asp" target="_blank">数据检索</a> <img src="images/01.gif" width="15" height="15" align="absmiddle">
<a href="input.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">数据录入</a>
<img src="images/02.gif" width="17" height="16" align="absmiddle">数据修改
<img src="images/43.gif" width="14" height="15" align="absmiddle">
<a href="delete.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">
数据删除</a> <img src="images/1.gif" width="16" height="16" align="absmiddle">
<a href="huizong.asp?grade=<%=request.querystring("grade")%>" target="_blank">分类汇总</a>
<img src="images/05.gif" width="16" height="16" align="absmiddle">
<a href="helper.asp" target="_blank">系统帮助</a> <img src="images/42.gif" width="17" height="17" align="absmiddle">
<a href="logout.asp">退出系统</a></font></div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="588" valign="top">
<table width="604" border="0" cellspacing="0" cellpadding="0" align="center" height="23">
<tr>
<td height="21"> </td>
</tr>
<tr>
<td height="65">
<div align="center"><font size="4" face="楷体_GB2312"><b><br>
<font size="5">高<%=request.querystring("grade")%>年级<%=request.querystring("class")%>班学生成绩汇总报表</font><br>
<br>
<font color="#FF0000">（</font></b></font><font size="4"><b><font color="#FF0000"><font size="3">您可以在要修改的数据记录前打“V”号)</font></font></b></font></div>
</td>
</tr>
</table>
<br>
<form name="form1" method="post" action="modify2.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">
<table width="800" border="1" cellspacing="0" cellpadding="0" align="center" height="27">
<tr>
<td width="24">
<div align="center">ID</div>
</td>
<td width="81">
<div align="left">学号</div>
</td>
<td width="60">
<div align="center">姓名</div>
</td>
<td width="31">
<div align="center">语文</div>
</td>
<td width="27">
<div align="center">名次</div>
</td>
<td width="30">
<div align="center">数学</div>
</td>
<td width="25">
<div align="center">名次</div>
</td>
<td width="28">
<div align="center">英语</div>
</td>
<td width="24">
<div align="center">名次</div>
</td>
<td width="31">
<div align="center">物理</div>
</td>
<td width="30">
<div align="center">名次</div>
</td>
<td width="32">
<div align="center">化学</div>
</td>
<td width="28">
<div align="center">名次</div>
</td>
<td width="34">
<div align="center">生物</div>
</td>
<td width="29">
<div align="center">名次</div>
</td>
<td width="30">
<div align="center">政治</div>
</td>
<td width="29">
<div align="center">名次</div>
</td>
<td width="29">
<div align="center">历史</div>
</td>
<td width="24">
<div align="center">名次</div>
</td>
<td width="29">
<div align="center">地理</div>
</td>
<td width="29">
<div align="center">名次</div>
</td>
<td width="38">
<div align="center">总分</div>
</td>
<td width="30">
<div align="center">名次</div>
</td>
</tr>
</table>
<%
dim rs
dim sql
set rs=server.createobject("adodb.recordset")
sql="select(select count(*)from scores where language>=a.language) as mingci1,(select count(*)from scores where mathe>=a.mathe) as mingci2,(select count(*)from scores where english>=a.english) as mingci3,(select count(*)from scores where physics>=a.physics) as mingci5,(select count(*)from scores where chemical>=a.chemical) as mingci6,(select count(*)from scores where biological>=a.biological) as mingci7,(select count(*)from scores where politics>=a.politics) as mingci8,(select count(*)from scores where history>=a.history) as mingci9,(select count(*)from scores where geography>=a.geography) as mingci10,(select count(*)from scores where language+mathe+english+physics+chemical+biological+politics+history+geography>=a.language+a.mathe+a.english+a.physics+a.chemical+a.biological+a.politics+a.history+a.geography) as mingci4,* from scores a"
rs.open sql,conn,1,3
do while not rs.eof
%>
<table width="800" border="1" cellspacing="0" cellpadding="0" align="center" height="27" style="border-top-width:0px">
<tr>
<td width="24">
<input type="checkbox" name="checkbox" value="<%=rs("id")%>">
</td>
<td width="82">
<div align="left"><font size="2"><%=rs("testnumber")%></font></div>
</td>
<td width="60">
<div align="center"><font size="2"><%=rs("name")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("language")%></font></div>
</td>
<td width="27">
<div align="center"><font size="2"><%=rs("mingci1")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("mathe")%></font></div>
</td>
<td width="25">
<div align="center"><font size="2"><%=rs("mingci2")%></font></div>
</td>
<td width="28">
<div align="center"><font size="2"><%=rs("english")%></font></div>
</td>
<td width="24">
<div align="center"><font size="2"><%=rs("mingci3")%></font></div>
</td>
<td width="31">
<div align="center"><font size="2"><%=rs("physics")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("mingci5")%></font></div>
</td>
<td width="32">
<div align="center"><font size="2"><%=rs("chemical")%></font></div>
</td>
<td width="28">
<div align="center"><font size="2"><%=rs("mingci6")%></font></div>
</td>
<td width="34">
<div align="center"><font size="2"><%=rs("biological")%></font></div>
</td>
<td width="29">
<div align="center"><font size="2"><%=rs("mingci7")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("politics")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("mingci8")%></font></div>
</td>
<td width="28">
<div align="center"><font size="2"><%=rs("history")%></font></div>
</td>
<td width="24">
<div align="center"><font size="2"><%=rs("mingci9")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("geography")%></font></div>
</td>
<td width="28">
<div align="center"><font size="2"><%=rs("mingci10")%></font></div>
</td>
<td width="38">
<div align="center"><font size="2"><%=rs("language")+rs("mathe")+rs("english")+rs("physics")+rs("chemical")+rs("biological")+rs("politics")+rs("history")+rs("geography")%></font></div>
</td>
<td width="30">
<div align="center"><font size="2"><%=rs("mingci4")%></font></div>
</td>
</tr>
</table>
<%
rs.movenext
loop
rs.close
%>
<input type="hidden" name="grade" value="<%=request.querystring("grade")%>">
<input type="hidden" name="class" value="<%=request.querystring("class")%>">
<div align="center"><br>
<input type="submit" name="Submit" value=" 进入修改所选中的数据 " style="border: 1pt solid #EEEEEE">
<input type="reset" name="Submit2" value=" 重新选择 " style="border: 1pt solid #EEEEEE">
</div>
</form>
</td>
</tr>
<tr>
<td height="18">
<div align="center"><font size="2" color="#000000" face="Arial, Helvetica, sans-serif">Copyright©
问剑网ASP小组 All right Reserved QQ:349643649</font><font size="2" color="#000000">
</font></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -