report1.asp

来自「在线学习系统 v1.0 1.本系统采用学号加密码登录」· ASP 代码 · 共 48 行

ASP
48
字号
<!--#include file="conn.asp"-->
<!--#include file="../../teacher/check.asp"-->


<% 
		set rs=Server.CreateObject("ADODB.Recordset")
		sqls="select  * from student order by studyid 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>
  <%do while not rs.eof %>
  <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("studyid")%>><%=rs("studyid")%></td>
      <td width="300" align="center" bgcolor="#CBEFDC"><%=rs("yourname")%></td>
    </tr>
  </table> 
  <%rs.movenext
loop
rs.close
set rs=nothing%>
</body>

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?