📄 search.asp
字号:
<!--#include file="conn.asp"-->
<% if session("user")="" then
response.write"<script>alert('对不起，您还没有登陆，如果您已经注册，请先登陆!');history.back(-1);</script>"
response.End()
end if %>
<html>
<head>
<title>高中学生成绩在线管理系统ASP1.0版---制作：冷剑无情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 12pt
}
A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
COLOR: #CC6600; TEXT-DECORATION: underline
}
</STYLE></head>
<body bgcolor="#CCCCCC" text="#000000">
<table width="721" border="5" cellspacing="2" cellpadding="4" align="center" bordercolor="#FFFFFF" height="420">
<tr>
<td height="371">
<table width="700" border="0" cellspacing="0" cellpadding="0" height="402" align="center">
<tr>
<td height="71">
<div align="center"><b><font size="6" face="楷体_GB2312"><br>
高中学生成绩在线管理系统</font></b></div>
</td>
</tr>
<tr>
<td height="23">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2">The
Management System Of High School Students Date</font></div>
</td>
</tr>
<tr>
<td height="241">
<% if request.querystring("action")="" then %>
<form name="form1" action="search.asp?action=search" method="post">
<table width="392" border="0" cellspacing="0" cellpadding="0" align="center" style="border: 1pt solid #EEEEEE" height="35">
<tr bgcolor="#EEEEEE">
<td height="28" colspan="2">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2">个人成绩数据检索系统</font></div>
</td>
</tr>
<tr>
<td height="29" width="177">
<div align="right"><font size="2">请输入要检索的学生姓名： </font> </div>
</td>
<td height="29" width="215"><font size="2">
<input type="text" name="name" style="border: 1pt solid #EEEEEE;background-color:transparent">
<input type="submit" name="Submit" value="查询" style="border: 1pt solid #EEEEEE;background-color:transparent">
</font></td>
</tr>
</table>
</form>
<br>
<% else %>
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="center"><font size="3" color="#FF0000">您要查询的成绩数据如下：</font><font size="2"></font></div>
</td>
</tr>
</table>
<table width="680" border="1" cellspacing="0" cellpadding="0" height="18" align="center">
<tr>
<td width="150" height="14">
<div align="center"><font size="2"> 学号</font></div>
</td>
<td width="65" height="14">
<div align="center"><font size="2">年级</font></div>
</td>
<td width="65" height="14">
<div align="center"><font size="2">班级</font></div>
</td>
<td width="100" height="14">
<div align="center"><font size="2">姓名</font></div>
</td>
<td width="51" height="14">
<div align="center"><font size="2">语文</font></div>
</td>
<td width="57" height="14">
<div align="center"><font size="2">数学</font></div>
</td>
<td width="46" height="14">
<div align="center"><font size="2">英语</font></div>
</td>
<td width="53" height="14">
<div align="center"><font size="2">物理</font></div>
</td>
<td width="52" height="14">
<div align="center"><font size="2">化学</font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2">生物</font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2">政治</font></div>
</td>
<td width="46" height="14">
<div align="center"><font size="2">历史</font></div>
</td>
<td width="58" height="14">
<div align="center"><font size="2">地理</font></div>
</td>
</tr>
</table>
<% name=request.form("name")
if name="" then response.write"<script>alert('对不起，请输入检索关键字');history.back(-1);</script>" end if
dim rs
dim sql
set rs = server.createobject("adodb.recordset")
sql = "select*from scores where name like '%"&name&"%'"
rs.Open sql,conn,1
if rs.eof then
response.write"对不起，没有相关数据"
else
do while not rs.eof
%>
<br>
<table width="680" border="1" cellspacing="0" cellpadding="0" height="23" align="center" style="border-top-width:0px">
<tr>
<td width="110" height="14">
<div align="center"><font size="2"><%=rs("testnumber")%></font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2"><%=rs("grade")%></font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2"><%=rs("class")%></font></div>
</td>
<td width="75" height="14">
<div align="center"><font size="2"><%=rs("name")%></font></div>
</td>
<td width="41" height="14">
<div align="center"><font size="2"><%=rs("language")%></font></div>
</td>
<td width="44" height="14">
<div align="center"><font size="2"><%=rs("mathe")%></font></div>
</td>
<td width="37" height="14">
<div align="center"><font size="2"><%=rs("english")%></font></div>
</td>
<td width="42" height="14">
<div align="center"><font size="2"><%=rs("physics")%></font></div>
</td>
<td width="40" height="14">
<div align="center"><font size="2"><%=rs("chemical")%></font></div>
</td>
<td width="41" height="14">
<div align="center"><font size="2"><%=rs("biological")%></font></div>
</td>
<td width="40" height="14">
<div align="center"><font size="2"><%=rs("politics")%></font></div>
</td>
<td width="37" height="14">
<div align="center"><font size="2"><%=rs("history")%></font></div>
</td>
<td width="45" height="14">
<div align="center"><font size="2"><%=rs("geography")%></font></div>
</td>
</tr>
</table>
<table width="679" border="0" cellspacing="0" cellpadding="0" align="center" height="15">
<tr>
<td>
<div align="right"><font size="2"><a href="main.asp?grade=<%=rs("grade")%>&class=<%=rs("class")%>">查看所在班级所有成绩数据>>
></a></font></div>
</td>
</tr>
</table>
<font size="2"><a href="main.asp?grade=<%=rs("grade")%>&class=<%=rs("class")%>">
<% rs.movenext
loop %>
</a></font>
<% end if %>
<% end if %>
<br>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<div align="center"><font size="2" color="#000000" face="Arial, Helvetica, sans-serif">Copyright©
问剑网ASP小组 All right Reserved QQ:349643649</font><font size="2" color="#000000">
</font></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -