📄 search.asp
字号:
<!--#include file="conn.asp"-->
<%
studentname=request.form("studentname")
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
if studentname="" 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="760" id="AutoNumber1" height="28">
<tr><td width="70" height="28">
<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="52" 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">
<p align="center"><font size="2"><%=rs("lessonname")%></td>
<%rs.movenext
i=i+1
loop
%>
</td>
<td height="28">
<p align="center"><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="760" >
<%
set rs=server.createobject("adodb.recordset")
sql ="select * from 成绩 where studentname='"&studentname&"' and xueqi='"&xueqi&"' and classno='"&classno&"'"
rs.open sql,conn,1,1
do while not rs.eof
%>
<tr>
<td style="border-style: solid; border-width: 1" height="1" width="56" align="center" >
<a href="scoreupdate.asp?id=<%=rs("id")%>"><%=rs("studentname")%></a></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson1")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson2")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson3")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson4")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson5")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><span style="font-size: 11pt"><%=rs("lesson6")%></span></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson7")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson8")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson9")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson10")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson11")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("lesson12")%></td>
<td style="border-style: solid; border-width: 1" height="1" width="40" align="center" ><%=rs("zongfen")%></td>
</tr>
<% rs.movenext
i=i+1
loop
%>
</table>
<table border="0" cellpadding="0" cellspacing="0" class="table" width="590" height="65">
<tr>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" class="table">
<tr>
<td width="100%" >
</td>
</tr>
</table>
<p align="center">共找到<%=INT(RS.recordcount)%>个名为<font color="#800000"> <%=studentname%> </font>的学生</p>
</body>
<% rs.close
set rs=nothing
set conn=nothing
%>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -