?? report.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="../../teacher/check.asp"-->
<%
kaoid=request("id")
set rs=Server.CreateObject("ADODB.Recordset")
sqls="select * from report where 試卷id="&kaoid &" order by 學生id desc "
set rs=conn.execute(sqls)%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>網上考試系統</title>
<link rel="stylesheet" type="text/css" href="../css.css">
</head>
<body topmargin="0" leftmargin="0">
<p>
<p align="center"><font class=test1>成績統計管理點擊學號進入管理</font></p>
<div align="center">
<center>
<table width="500" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse">
<tr>
<td width="200" align="center" bgcolor="#CBEFDC">學號</td>
<td width="300" align="center" bgcolor="#CBEFDC">姓名</td>
</tr></table><%if rs.eof then %>暫時沒有學生參加過考試<%else%>
<%do while not rs.eof %>
<%studyid=rs("學生id")%>
<table width="500" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse">
<tr>
<td width="200" align="center" bgcolor="#CBEFDC"><a href=../report.asp?id=<%=rs("學生id")%>><%=rs("學生id")%></td>
<td width="300" align="center" bgcolor="#CBEFDC"><%set js=Server.CreateObject("ADODB.Recordset")
sqlstr="select * from student where studyid='"&studyid&"'"
js.open sqlstr,conn,1,1%><%=js("yourname")%><%js.close
set js=nothing%></td>
</tr>
</table>
<%rs.movenext
loop
rs.close
set rs=nothing%>
<%end if%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -