?? 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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -