📄 searchfenxi.asp
字号:
<!--#include file="conn.asp"-->
<%
xueqi=request.form("xueqi")
classno=request.form("classno")
Session.Contents("classno")=classno
if classno="--选择班级--" then
response.write "<script language='javascript'>"
response.write "alert('选择班级');"
response.write "history.back(1);"
response.write "</script>"
response.end
end if
%>
<html>
<title>搜索学生成绩</title>
<body link="#000000" vlink="#000000" alink="#000000" background="imags/bg.jpg">
<p align="left"><b><font color="#660033" size="6">成绩更新</font></b><font size="2" color="#660033">--找出要更新的学生成绩--请点击姓名修改个人成绩</font></p>
<center>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="747" id="AutoNumber1" height="28">
<tr>
<td width="91" height="28" nowrap>
<p align="center">姓名</td>
<%
set rs=server.createobject("adodb.recordset")
sql="Select * from 上课 where classno='"&classno&"' order by id desc "
rs.open sql,conn,1,1
do while not rs.eof
%>
<td width="46" height="28" style="border-left-color: #111111; border-right-color: #111111; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1" nowrap>
<p align="center"><%=rs("lessonname")%>
</td>
<%rs.movenext
loop
%> <td height="28"></td>
<td height="28" width="48"> <span lang="zh-cn">总分</span></td>
<td height="28" width="46"> <span lang="zh-cn">排名</span></td>
</tr>
</table>
</div>
</center>
<table border="0" cellPadding="2" cellSpacing="0" class="table" style="border-collapse: collapse" bordercolor="#111111" height="31" width="747" >
<%dim num
num=1
set rs=server.createobject("adodb.recordset")
sql ="select * from 成绩 where xueqi='"&xueqi&"' and classno='"&classno&"' order by zongfen Desc"
rs.open sql,conn,1,1
do while not rs.eof
%>
<tr>
<td style="border-style: solid; border-width: 1" height="1" width="50" align="center"><a href="scoreupdate.asp?id=<%=rs("id")%>"><%=rs("studentname")%></a></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson1")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson2")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson3")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson4")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson5")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><span style="font-size: 11pt"><%=rs("lesson6")%></span></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson7")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson8")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson9")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson10")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson11")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("lesson12")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=rs("zongfen")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="22" align="center" ><%=num%></td>
</tr>
<% rs.movenext
num = num + 1
i=i+1
loop
%>
</table>
<table border="0" cellpadding="0" cellspacing="0" class="table" width="590" height="65">
<tr>
</tr>
</table>
<p align="center">共找到 <%=INT(RS.recordcount)%> 个学生</p>
</body>
<% rs.close
set rs=nothing
set conn=nothing
%>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -