📄 main.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>
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</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="800" 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">
返回首页 <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"><a href="modify.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">数据修改</a>
<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="795" border="0" cellspacing="0" cellpadding="0" align="center" height="23">
<tr>
<td height="29" width="641">
<form name="form1" action="class.asp?grade=<%=request.form("grade")%>" method="post">
<div align="right">
<table width="401" border="0" cellspacing="0" cellpadding="0" align="right">
<tr>
<td height="29">
<div align="right">成绩数据快速通道：
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option selected>请选择您要查看的年级</option>
<option value="class.asp?grade=1">高一年级</option>
<option value="class.asp?grade=2">高二年级</option>
<option value="class.asp?grade=3">高三年级</option>
</select>
<font size="2"> </font></div>
</td>
</tr>
</table>
</div>
</form>
</td>
<td height="29" width="184">
<form name="form1" method="get" action="main.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">
<div align="right">
<table width="183" border="0" cellspacing="0" cellpadding="0" align="right">
<tr>
<td height="5">
<div align="right">
<select name="select" onChange="MM_jumpMenu('parent',this,0)">
<option selected>请选择您要查看的班级</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=1">一班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=2">二班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=3">三班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=4">四班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=5">五班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=6">六班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=7">七班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=8">八班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=9">九班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=10">十班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=11">十一班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=12">十二班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=13">十三班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=14">十四班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=15">十五班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=16">十六班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=17">十七班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=18">十八班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=19">十九班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=20">二十班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=21">二十一班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=22">二十二班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=23">二十三班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=24">二十四班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=25">二十五班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=26">二十六班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=27">二十七班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=28">二十八班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=29">二十九班</option>
<option value="main.asp?grade=<%=request.querystring("grade")%>&class=30">三十</option>
</select>
<input type="hidden" name="grade" value="<%=request.form("grade")%>">
<font size="2"> </font></div>
</td>
</tr>
</table>
</div>
</form>
</td>
</tr>
<tr>
<td height="65" colspan="2">
<div align="center"><font size="4" face="楷体_GB2312"><b><br>
<font size="5">高<%=request.querystring("grade")%>年级<%=request.querystring("class")%>班学生成绩汇总报表</font></b></font></div>
</td>
</tr>
</table>
<br>
<table width="800" border="1" cellspacing="0" cellpadding="0" align="center" height="27">
<tr>
<td width="84">
<div align="left">学号</div>
</td>
<td width="62">
<div align="center">姓名</div>
</td>
<td width="38">
<div align="center">语文</div>
</td>
<td width="29">
<div align="center">名次</div>
</td>
<td width="39">
<div align="center">数学</div>
</td>
<td width="28">
<div align="center">名次</div>
</td>
<td width="35">
<div align="center">英语</div>
</td>
<td width="26">
<div align="center">名次</div>
</td>
<td width="29">
<div align="center">物理</div>
</td>
<td width="26">
<div align="center">名次</div>
</td>
<td width="32">
<div align="center">化学</div>
</td>
<td width="26">
<div align="center">名次</div>
</td>
<td width="27">
<div align="center">生物</div>
</td>
<td width="26">
<div align="center">名次</div>
</td>
<td width="29">
<div align="center">政治</div>
</td>
<td width="28">
<div align="center">名次</div>
</td>
<td width="28">
<div align="center">历史</div>
</td>
<td width="28">
<div align="center">名次</div>
</td>
<td width="30">
<div align="center">地理</div>
</td>
<td width="26">
<div align="center">名次</div>
</td>
<td width="46">
<div align="center">总分</div>
</td>
<td width="32">
<div align="center">名次</div>
</td>
</tr>
</table>
<% grade=request.querystring("grade")
banji=request.querystring("class")
dim rs
dim sql
set rs=server.createobject("adodb.recordset")
sql="select(select count(*)from scores where language>=a.language and grade="&grade&" and class="&banji&") as mingci1,(select count(*)from scores where mathe>=a.mathe and grade="&grade&" and class="&banji&") as mingci2,(select count(*)from scores where english>=a.english and grade="&grade&" and class="&banji&") as mingci3,(select count(*)from scores where physics>=a.physics and grade="&grade&" and class="&banji&") as mingci5,(select count(*)from scores where chemical>=a.chemical and grade="&grade&" and class="&banji&") as mingci6,(select count(*)from scores where biological>=a.biological and grade="&grade&" and class="&banji&") as mingci7,(select count(*)from scores where politics>=a.politics and grade="&grade&" and class="&banji&") as mingci8,(select count(*)from scores where history>=a.history and grade="&grade&" and class="&banji&") as mingci9,(select count(*)from scores where geography>=a.geography and grade="&grade&" and class="&banji&") 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 and grade="&grade&" and class="&banji&") as mingci4,* from scores a where grade="&grade&" and class="&banji&""
rs.open sql,conn,1,3
if rs.eof then
response.write"<font color=red>对不起，暂时没有相关成绩</font>"
end if
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="84">
<div align="left"><font size="2"><%=rs("testnumber")%></font></div>
</td>
<td width="62">
<div align="center"><font size="2"><%=rs("name")%></font></div>
</td>
<td width="38">
<div align="center"><font size="2"><%=rs("language")%></font></div>
</td>
<td width="29">
<div align="center"><font size="2"><%=rs("mingci1")%></font></div>
</td>
<td width="39">
<div align="center"><font size="2"><%=rs("mathe")%></font></div>
</td>
<td width="28">
<div align="center"><font size="2"><%=rs("mingci2")%></font></div>
</td>
<td width="35">
<div align="center"><font size="2"><%=rs("english")%></font></div>
</td>
<td width="26">
<div align="center"><font size="2"><%=rs("mingci3")%></font></div>
</td>
<td width="29">
<div align="center"><font size="2"><%=rs("physics")%></font></div>
</td>
<td width="26">
<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="26">
<div align="center"><font size="2"><%=rs("mingci6")%></font></div>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -