📄 pc_classview.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="const.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<%
Dim rs1
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = dbconn
rs1.Source = "SELECT month,month_name FROM set_month where isok=1"
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 1
rs1.Open()
if rs1.eof or rs1.bof then
response.Write("系统错误")
response.End()
end if
Dim rs2
Set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.ActiveConnection = dbconn
rs2.Source = "SELECT class_id,class_name FROM class"
rs2.CursorType = 0
rs2.CursorLocation = 2
rs2.LockType = 1
rs2.Open()
if rs2.eof or rs2.bof then
response.Write("系统错误")
response.End()
end if
dim ismonth
ismonth=month(date)
%>
<p> </p>
<p> </p>
<form name="form" action="pc_classscoreview.asp" method="post" >
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="0" class="atable1">
<tr>
<td colspan="4" bgcolor="#333"><span class="STYLE1"> 班级定位查询</span></td>
</tr>
<tr>
<td height="30" colspan="4" valign="middle" class="tdmenu"><br />
<span class="jushe"> 请选择班级和月份<br />
<br />
</span></td>
</tr>
<tr>
<td width="19%" height="30" class="tdmenu"><div align="center"> 选择班级:</div></td>
<td width="37%" height="30" class="tdmenu">
<select name="m_class" class="tdmenu" id="m_class" onchange="javascript:m_class1.value=this.value;">
<%do while not rs2.eof%>
<option value="<%=rs2(0)%>"><%=rs2(1)%></option>
<%rs2.movenext()
loop%>
</select>
<=> 班级代码：
<input name="m_class1" type="text" value="" class="tdmenu" id="m_class1" size="1" maxlength="1" disabled="disabled" /></td>
<td width="15%" height="30" class="tdmenu"><div align="center"> 选择月份：</div></td>
<td width="29%" height="30" class="tdmenu">
<div align="left">
<select name="t_month" class="tdmenu" id="t_month" onchange="javascript:t_month1.value=t_month.value;tj.value='查看[ '+t_month.value+' ]月份综合分'">
<%do while not rs1.eof%>
<option value="<%=rs1(0)%>" <%if ismonth=rs1(0) then response.Write("selected='selected'") end if%>><%=rs1(1)%></option>
<%rs1.movenext()
loop%>
<option value="fir">第一学期</option>
<option value="sed">第二学期</option>
</select>
<=>
<input name="t_month1" type="text" value="<%=ismonth%>" class="tdmenu" id="t_month1" size="1" maxlength="1" disabled="disabled" />
</div></td></tr>
<tr>
<td width="19%" height="30" class="tdmenu"><div align="center"> 排 序:</div></td>
<td width="37%" height="30" class="tdmenu"><select name="orderby" class="tdmenu" id="orderby" >
<option value="1" selected="selected">学号升序</option>
<option value="2">评分升序</option>
<option value="3">评分降序</option>
</select></td>
<td width="15%" height="30" class="tdmenu"> </td>
<td width="29%" height="30" class="tdmenu"> </td></tr>
<tr>
<td class="tdmenu" colspan="4"><div align="center"> <br />
<input name="提交" type="submit" class="tdmenu" id="tj" value="查询[ <%=ismonth%> ]月份综合分" />
<input name="重填" type="reset" class="tdmenu" id="重填" value="重填" />
<br />
<br />
</div></td>
</tr>
</table>
</form>
<%rs2.close
rs1.close
set rs2=nothing
set rs1=nothing%>
</body>
</html>
<%dbconn.close%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -