total_top.asp

来自「managerc.zip」· ASP 代码 · 共 77 行

ASP
77
字号
<!--#include file="conn.asp"-->
<%
if session("user")="" then
	response.write "您无此权限"
	response.end
end if

'------------------------------------------------------------------------------------

'------------------------------------------------------------------------------------
%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>总分成绩排行榜</title>
<link rel="stylesheet" href="style.css">
</head>

<body topmargin="0">
<!--#include file="top.asp"-->
<div align="center">
  <center>
  <table border="0" width="400">
    <tr>
      <td width="100%">
        <form method="POST" action="total_top_1.asp">
          <table border="1" width="100%" cellspacing="0" cellpadding="5" bordercolorlight="#000000" bordercolordark="#FFFFFF">
            <tr>
              <td width="50%" align="center">班级</td>
              <td width="50%" align="center">统考场次</td>
            </tr>
            <tr>
              <td width="50%" align="center">
              <%
              set rs=server.createobject("adodb.recordset")
              sql="select * from class"
              rs.open sql,conn,1,1
              %>
              <select size="1" name="user_class">
              <option value="all">全部班级</option>
              <%do while not rs.eof%>
              <option value="<%=rs("stclass")%>"><%=rs("stclass")%></option>
              <%rs.movenext%>
              <%loop%>
              <%rs.close%>
                </select></td>
              <td width="50%" align="center">
              <%
              set rs2=server.createobject("adodb.recordset")
              sql2="select * from testno"
              rs2.open sql2,conn,1,1
              %>
              <select size="1" name="testno"><%do while not rs2.eof%>
              <option value="<%=rs2("testno")%>"><%=rs2("testno")%></option>
              <%rs2.movenext%>
              <%loop%>
              <%rs2.close%>
                </select></td>
            </tr>
          </table>
        </center>
        <p align="right"><input type="submit" value="提交" name="B1"></p>
      </form>
      <center>
      <p> </td>
    </tr>
  </table>
</div>
<!--#include file="down.asp"-->
</body>

</html>

⌨️ 快捷键说明

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