📄 score_search_student.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
var StuPro;
StuPro=Server.CreateObject("ADODB.Recordset");
StuPro.ActiveConnection=Conn;
StuPro.CursorLocation=3;
StuPro.Source="SELECT * FROM profession";
StuPro.Open();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="link.asp"-->
<title>学生成绩输入修改查询</title>
<script language="javascript">
function TestStuId()
{
if(document.form1.StuId.value=="")
{
alert("请输入学籍号！");
document.form1.StuId.focus();
return false;
}
}
function TestStuName()
{
if(document.form2.StuName.value=="")
{
alert("请输入姓名！");
document.form2.StuName.focus();
return false;
}
}
function TestAbove()
{
if(document.form4.AboveClass.value=="")
{
alert("请将班级填写完整!");
document.form4.AbovePro.focus();
return false;
}
}
</script>
<style type="text/css">
body{text-align:center;}
</style>
</head>
<body>
<!--#include file="top.asp"-->
<table border="1" width="760" cellPadding=0 cellSpacing=0 bgcolor="#FFCCFF" borderColor="#111111"
borderColorDark=#0072b3 borderColorLight=#0072b3 style="BORDER-COLLAPSE: collapse" height="520">
<tr>
<td width="760" height="20" background="images/bar.gif" colspan="7"><div align="center"><font size="3" color="#FF0000"><img src="images/t1.gif"><a href="unlogin.asp">退出登陆</a></font></div></td>
</tr>
<tr>
<td width="20" rowspan="20" height="460"></td>
<td width="100" height="460" rowspan="20"><img border="0" src="images/chengjiguanlileft.gif" width="100" height="460"></td>
<td width="20" rowspan="20" height="460"></td>
<td width="80" height="20"></td>
<td width="20" rowspan="20" height="460"></td>
<td width="500" rowspan="20" height="460">
<form action="score_search_student_id.asp" method="post" name="form1" id="form1">
<table border="1" width="100%" height="80" cellPading=1 cellSpacing=1 bgcolor="#FFFFCC" bordercolor="#000000">
<tr>
<td height="20" colspan="3"><font size="2" color="#FF0000"><b>请选择您要查询的选项：</b></font></td>
</tr>
<tr>
<td width="100%" height="20" colspan="3"><font size="2" color="#FF0000">单个成绩操作</font></td>
</tr>
<tr>
<td width="33%" height="20"><font size="2" color="#FF0000">按学籍号查询：</font></td>
<td width="33%" height="20"><input size=12 name="StuId" id="StuId"></td>
<td width="34%" height="20"><input type="submit" value=确定 name="confirm1" id="confirm1" onClick="return TestStuId()"></td>
</tr>
<tr>
<td width="100%" height="20" colspan="3"></td>
</tr>
</table>
</form>
<form action="score_search_student_name.asp" method="post" name="form2" id="form2">
<table border="1" width="100%" height="40" cellPading=1 cellSpacing=1 bgcolor="#FFFFCC" bordercolor="#000000">
<tr>
<td width="33%" height="20"><font size="2" color="#FF0000">按姓名查询：</font></td>
<td width="33%" height="20"><input size=12 name="StuName" id="StuName"></td>
<td width="34%" height="20"><input type="submit" value=确定 name="confirm2" id="confirm2" onClick="return TestStuName()"></td>
</tr>
<tr>
<td width="100" height="20" colspan="3"></td>
</tr>
</table>
</form>
<form action="score_search_student_all.asp" method="post" name="form3" id="form3">
<table border="1" width="100%" height="100" cellPading=1 cellSpacing=1 bgcolor="#FFFFCC" bordercolor="#000000">
<tr>
<td width="50%" height="20"><font size="2" color="#FF0000">入学年份：</font></td>
<td width="50%" height="20"><input size=12 name="StuInTime" id="StuInTime"></td>
</tr>
<tr>
<td width="50%" height="20"><font size="2" color="#FF0000">所学专业：</font></td>
<td width="50%" height="20">
<select name="StuPro" id="StuPro">
<%
if(!StuPro.EOF)
{
for(i=0;i<=StuPro.RecordCount-1;i++)
{
Response.Write("<option value='"+StuPro.Fields(1).Value+"'>"+StuPro.Fields(1).Value+"</option>");
StuPro.MoveNext;
}
StuPro.MoveFirst;
}
%>
</select>
</td>
</tr>
<tr>
<td width="50%" height="20"><font size="2" color="#FF0000">所在班级：</font></td>
<td width="50%" height="20"><input size=12 name="StuClass" id="StuClass"></td>
</tr>
<tr>
<td width="100%" height="20" colspan="2"><div align=center><input type="submit" value=确定 name="confirm3" id="confirm3" onClick="return TestAll()"></div></td>
</tr>
</table>
</form>
</td>
<td width="20" rowspan="20" height="460"></td>
</tr>
<tr>
<td width="80" background="images/bar1.gif" height="20"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="760" height="20" background="images/bar.gif" colspan="7"></td>
</tr>
<tr>
<td width="760" height="20" colspan="7"></td>
</tr>
</table>
<%
StuPro.Close();
StuPro=null;
Conn.Close();
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -