?? displayscore.asp
字號:
<!--#include file="conn.inc"-->
<%
sql="select * from exam_score where testid="& request("testid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<title>原創作品 -- 數據重排1.0</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta content="Microsoft FrontPage 5.0" name="GENERATOR">
<meta name="ProgId" content="FrontPage.Editor.Document">
<style type="text/css">
.listDataTable {
FONT-SIZE: 15px
}
.listTableHead {
FONT-WEIGHT: bold; CURSOR: hand
}
.onMouseOnTr {
CURSOR: default; COLOR: #ff0000; BACKGROUND-COLOR: #efefef
}
.listTableHeadO {
FONT-WEIGHT: bold; CURSOR: s-resize; COLOR: #ffffff;BACKGROUND-COLOR: #006699
}
.listHeadClicked {
FONT-WEIGHT: bold; CURSOR: n-resize; COLOR: #ffffff; BACKGROUND-COLOR: #990033
}
.listHeadClicked0 {
FONT-WEIGHT: bold; CURSOR: s-resize; COLOR: #ffffff; BACKGROUND-COLOR: #990033
}
</style>
<script language="JavaScript" src="../js/jm_list.js"></script>
<link rel="stylesheet" type="text/css" href="css.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%">當前位置:<a href="news.asp">系統管理</a> >
<a href="searchscore.asp">查詢成績</a> > 未審批考試計劃查詢</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"><b><font color="#FF0000" size="4" face="黑體">保定市公安消防支隊《<%=rs("subject")%>》考試成績一覽表</font></b></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 class="listDataTable" id="DataTable" onmouseover="JM_HLTr('onMouseOnTr')" onmouseout="JM_HLTrRestore('')" cellSpacing="1" cellPadding="0" width="100%" border="1" style="border-collapse: collapse" bordercolor="#C0C0C0">
<tr id="ignore" bgColor="#eeeeee">
<td class="listTableHead" onclick="JM_PowerList(0)" onyes="head" height="20" bgcolor="#E1E1E1"> </td>
<td class="listTableHead" onclick="JM_PowerList(0)" onyes="head" height="20" bgcolor="#E1E1E1">
警官證號</td>
<td class="listTableHead" onclick="JM_PowerList(1)" onyes="head" bgcolor="#E1E1E1">
姓名</td>
<td class="listTableHead" onclick="JM_PowerList(2)" onyes="head" bgcolor="#E1E1E1">
所在部門</td>
<td class="listTableHead" onclick="JM_PowerList(3)" onyes="head" bgcolor="#E1E1E1">
所在單位</td>
<td class="listTableHead" onclick="JM_PowerList(4)" onyes="head" bgcolor="#E1E1E1">
崗位</td>
<td class="listTableHead" onclick="JM_PowerList(5)" onyes="head" bgcolor="#E1E1E1">
成績</td>
</tr>
<%
i=1
do while not rs.eof
%>
<tr>
<td height="20" bgcolor="#E1E1E1">
<p align="center"><%=i%></td>
<td height="20"> <%=rs("userid")%></td>
<td> <%=rs("username")%></td>
<td> <%=rs("department")%></td>
<td> <%=rs("office")%></td>
<td> <%=rs("duties")%></td>
<td> <%=rs("score")%></td>
</tr>
<%
i=i+1
rs.movenext
loop
%>
<tr id="ignore">
<td align="right" colSpan="7"></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -