www.gusucode.com > ASP+ACCESS学生管理系统(源代码+论文) > ASP+ACCESS学生管理系统(源代码+论文)\zjw\dkcjcx.asp
<!--#include file="data.asp"--> <!--#include file="user.asp"--> <html> <head> <meta http-equiv="Content-Language" content="zh-cn"> <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 width="738" height="35"> <td background="images/top_1.jpg"> <a href="cjgl.asp">统考成绩列表</a> | <a href="search2.asp">添加统考成绩 | <a href="dkcjcx.asp">单科成绩排行榜</a> | <a href="zcjcx.asp">总分成绩排行榜</a> </center> </div> <div align="center"> <center> <table border="1" width="400" cellspacing="0" cellpadding="5" bordercolorlight="#000000" bordercolordark="#FFFFFF"> <tr> <td width="100%">请选择相关类目查询</td> </tr> <tr> <td width="100%"> <form method="POST" action="dkpmb.asp"> <table border="0" width="100%" cellpadding="5" cellspacing="0"> <tr> <td width="33%" align="center" bgcolor="#FFFFEC">班级</td> <td width="33%" align="center" bgcolor="#FFFFEC">统考场次</td> <td width="34%" align="center" bgcolor="#FFFFEC">科目</td> </tr> <tr> <%set rs=createobject("adodb.recordset") sql="select * from class" rs.open sql,conn,1,1 %> <td width="33%" align="center"><select size="1" name="user_class"> <option value="all">统计全部</option> <%do while not rs.eof%> <option value="<%=rs("class")%>"><%=rs("class")%></option> <%rs.movenext%> <%loop%> </select> <%rs.close%></td> <td width="33%" align="center"> <% set rs1=server.createobject("adodb.recordset") sql1="select * from dk" rs1.open sql1,conn,1,1 %> <select size="1" name="testno"> <%do while not rs1.eof%> <option value="<%=rs1("testno")%>"><%=rs1("testno")%></option> <%rs1.movenext%> <%loop%> </select> <%rs1.close%></td> <%set rs2=server.createobject("adodb.recordset") sql2="select * from kc" rs2.open sql2,conn,1,1 %> <td width="34%" align="center"><select size="1" name="subject"><%do while not rs2.eof%> <option value="<%=rs2("kc")%>"><%=rs2("kc")%></option><%rs2.movenext%> <%loop%> <%rs2.close%> </select> </td> </tr> </table> </center> <p align="right"><input type="submit" value="提交" name="B1"></p> </form> <center> </td> </tr> </table> </div> </body> </html>