📄 browsetestscore.asp

📁 在线考试系统

💻 ASP

字号:

<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!---#include file="conn.asp"--->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="main.css" rel="stylesheet" type="text/css">
<title>无标题文档</title>

</head>

<body>
<h3 align="center">
<%
TestPaperName=request.QueryString("TestPaperName")
response.Write(TestPaperName)
%>
查看考试分数</h3>
<hr>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr align="center"> 
    <th width="60">序号</th>
    <th width="106">姓名</th>
    <th width="95">客观题得分</th>
    <th width="88">主观题得分</th>
    <th width="52">总得分</th>
  </tr>
  <%
set rst=conn.execute("select * from StudentTestPaper where TestPaperName='"&TestPaperName&"'")
n=1
while not rst.eof
%>
  <tr align="center" bgcolor="#E0F1FC"> 
    <td><%=n%></td>
    <td><%=rst("Name")%></td>
    <td><%=rst("KeGuanScore")%></td>
    <td><%=rst("ZhuGuanScore")%></td>
    <td><font color="red"><%=rst("Score")%></font></td>
  </tr>
  <%
  rst.movenext
  wend
  set rst=conn.execute("select sum(score) as s from StuTestPaper where TestPaperName='"&TestPaperName&"'")
  s=rst("s")
  aver=s/n
  %>
  <tr align="center" bgcolor="#E0F1FC"> 
    <td colspan="3">平均分</td>
    <td colspan="2"><font color="red"><%=aver%></font></td>
  </tr>
</table>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -