www.gusucode.com > ASP毕业设计在线考试管理系统源码 > ASP毕业设计在线考试管理系统源码\code\admin\displayscore.asp
<!--#include file="db.asp"-->
<%
sql="select * from score where testid="& request("testid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
%>
<html>
<head>
<title>在线考试系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" src="../js/jm_list.js"></script>
<link href="../Style.css" rel="stylesheet" type="text/css">
</head>
<body id="all" text="#000000">
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
<tr>
<td width="100%">当前位置：在线考试系统 -> 查询所有人成绩
<hr></td>
</tr>
</table>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="100%">
<p align="center" class="style1"><font size="4" face="黑体"><%=rs("subject")%>考试成绩一览表</font></td>
</tr>
<tr>
<td width="100%" height="30">
<p align="center"><b>考试编号：<%=rs("testid")%></b></td>
</tr>
</table>
<table cellSpacing="0" cellPadding="0" border="0" width="100%" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td id="clearStart">
<table width="100%" border="0" cellPadding="5" cellSpacing="1" bgcolor="#5A8BCE" onMouseOver="JM_HLTr('onMouseOnTr')" onMouseOut="JM_HLTrRestore('')" class="listDataTable" id="DataTable" style="border-collapse: collapse">
<tr id="ignore" bgColor="#E6F7FF">
<td class="listTableHead" onClick="JM_PowerList(0)" onyes="head" height="20"> </td>
<td class="listTableHead" onClick="JM_PowerList(0)" onyes="head" height="20">
用户ID</td>
<td class="listTableHead" onClick="JM_PowerList(1)" onyes="head">
姓名</td>
<td class="listTableHead" onClick="JM_PowerList(5)" onyes="head">
成绩</td>
</tr>
<%
i=1
do while not rs.eof
%>
<tr bgcolor="#FFFFFF">
<td height="20">
<p align="center"><%=i%></td>
<td height="20"> <%=rs("userid")%></td>
<td> <%=rs("username")%></td>
<td> <%=rs("score")%></td>
</tr>
<%
i=i+1
rs.movenext
loop
%>
</table>
</td>
</tr>
</table>
</body>
</html>