📄 score_stu_list.asp
字号:
<!--#include file="../inc/conn_open.asp"-->
<html>
<head>
<title>学生成绩管理系统欢迎您！</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 26px;
color: #990000;
}
.he0 {
height: 20px;
width: 120px;
background-color: #F2F2F2;
}
.he1 {
height: 25px;
width: 60px;
background-color: #F2F2F2;
}
body {
background-color: #F2F2F2;
margin-top: 0px;
}
.STYLE2 {color: #FF0000}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /></head>
<%
if session("sort")<>"学生" then
%>
<Script Language ="JavaScript">
alert("对不起，您没有此项权限，请返回！！！");
history.back();
</Script>
<%
response.end
end if
%>
<body>
<!--#include file="../inc/score_head.asp"-->
<form name="form1" method="post" action="score_list.asp">
<table width="720" border="0" align="center" >
<%
'取出该同学的平时成绩、期末成绩和总成绩
Set rs = Server.CreateObject("adodb.recordset")
sql="select * from zongcj where sid="&session("username")
rs.open sql,conn,3,1
if not rs.eof then
%>
<tr>
<td height="50" >平时成绩：<span class="STYLE2"><%=rs("psscore")%></span>，期末成绩：<span class="STYLE2"><%=rs("qmscore")%></span>，总成绩：<span class="STYLE2"><%=rs("score")%></span>。下面是平时成绩列表。</td>
</tr>
<%end if
rs.close
set rs=nothing%>
</table>
<table width="720" border="2" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#663300" bordercolordark="white">
<tr>
<td height="40" align="center">序号</td>
<td align="center" >学号</td>
<td align="center" >类别</td>
<td align="center" >考核日期</td>
<td align="center" >考核成绩</td>
<td align="center" >备注</td>
</tr>
<%
'取出该同学的平时成绩并列表显示
Set rs = Server.CreateObject("adodb.recordset")
sql="select * from pscj where sid="&session("username")&" order by cdate"
rs.open sql,conn,3,1
sum=1
while not rs.eof
%>
<tr>
<td height="40" align="center"><%=sum%></td>
<td align="center"><%=rs("sid")%></td>
<td align="center"><%=rs("sort")%></td>
<td align="center"><%=rs("cdate")%></td>
<td align="center"><%=rs("score")%></td>
<td align="center"><%=rs("memo")%> </td>
</tr>
<%
sum=sum+1
rs.movenext
wend
rs.close
set rs=nothing
%>
</table>
</form>
</body>
</html>
<!--#include file="../inc/conn_close.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -