📄 search.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="verifyTeacher.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;
}
}
</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="340">
<tr>
<td width="760" colspan="7" height="20" background="images/bar.gif"></td>
</tr>
<tr>
<td width="20" rowspan="14"></td>
<td width="80"></td>
<td width="20" rowspan="14"></td>
<td width="520" rowspan="14">
<form action="search_result_id.asp" method="post" name="form1" id="form1">
<table border="1" width="100%" height="60" cellPading=1 cellSpacing=1 bgcolor="#FFFFCC" bordercolor="#000000">
<tr>
<td width="100%" height="20" colspan="3"><font size="2" color="#FF0000"><b>请选择您要查询的选项：</b></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="search_result_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="search_result_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">
<%
while(!StuPro.EOF){
Response.Write("<option value='"+StuPro("name")+"'>"+StuPro("name")+"</option>");
StuPro.MoveNext;
}
%>
</select>
</td>
<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="14"></td>
<td width="80"></td>
<td width="20" rowspan="14"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="760" colspan="7" height="20" background="images/bar.gif"></td>
</tr>
<tr>
<td width="760" colspan="7" height="20"></td>
</tr>
</table>
<%
StuPro.Close();
StuPro=null;
Conn.Close();
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -