📄 waijichaxuntea.asp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>教工查询</title>
<script language="JavaScript"><!--
function validateLogin(){
var strUserName = document. frmLogin. txtUserName.value;
var strPassword = document. frmLogin. txtPassword.value;
var primeInUserName= document. frmLogin. txtUserName.value.indexOf("'");
var primeInPassword= document. frmLogin. txtPassword.value.indexOf("'");
if (strUserName ==""){
alert("请您输入用户名!");
return false;
}
if (strPassword ==""){
alert("请输入密码!");
return false;
}
if (primeInUserName !=-1){
alert("用户名中不能包含撇号!");
return false;
}
if (primeInPassword !=-1){
alert("密码中不能包含撇号!");
return false;
}
}
-->
</script>
</head>
<%
Sub SchoolDisp()
dim conn, sql,Res
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbf/school.mdb")
sql="select * from school"
set Res=server.createobject("adodb.recordset")
Res.open sql,conn,1,3
while not Res.EOF
response.write "<option value=" & Res("sId") & ">" & Res("sName") & "</option>"
Res.movenext
wend
Res.close
conn.close
End Sub
%>
<body>
<!-- #include virtual="/admin/include/title.html"-->
<p> </p>
<form method="post" name="frmLogin" action="teaSearch4.asp" >
<div align="center">
<table bgColor="#FFFFCC" border="0" cellPadding="0" cellSpacing="0" width="800" background="images/BKG35.JPG">
<tr>
<td colspan="2" align=center height="32" background="images/BKG35.JPG">
<font size="4" color="#0000FF"><b>外籍教工信息查询</b></font></td>
</tr>
<tr>
<td align="right" height="21" vAlign="bottom" width="275" background="images/BKG35.JPG">用 户 名:
</td>
<td height="21" vAlign="bottom" width="525" background="images/BKG35.JPG">
<input name="seaUserName" size="15" maxlength="15"> 输入教工的姓名</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">教 工 ID:
</td>
<td width="525" background="images/BKG35.JPG">
<input name="seaPassWord" size="15" maxlength="15"> 输入教工的ID号</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG" height="21">按性别查询:
</td>
<td width="525" background="images/BKG35.JPG" height="21">
<select style="WIDTH: 67; height:19"
size=1 name=sex> <option
value="" selected
></OPTION><option value=true
>男</OPTION><option value=false
>女</OPTION></SELECT><font style="TEXT-ALIGN: center" size=4 valign="center"> 选择所要查询的性别</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">按员工状况:
</td>
<td width="525" background="images/BKG35.JPG">
<select style="WIDTH: 67; height:19"
size=1 name=sta> <option value=false selected
>是</OPTION><option value=true
>否</OPTION><option
value=""
></OPTION></SELECT><font style="TEXT-ALIGN: center" size=4 valign="center"> 选择员工是否在职</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">教授的级别:
</td>
<td width="525" background="images/BKG35.JPG">
<select style="WIDTH: 67; height:19"
size=1 name=grade> <option
value="" selected
></OPTION><option value=1
>高级</OPTION><option value=0
>低级</SELECT> 选择所要查询的级别</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">分 校:
</td>
<td width="525" background="images/BKG35.JPG">
<p> <select size="1" name="sFen"><% SchoolDisp %> </select> 请选择所在分校</p></td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">按国籍查询:
</td>
<td width="525" background="images/BKG35.JPG">
<select style="WIDTH: 118; height:19"
size=1 name=nation> <option
value="" selected
></OPTION><option value=美国
>美国</OPTION><option value=英国
>英国<option value=加拿大
>加拿大</OPTION><option value=澳洲
>澳洲<option value=其他
>其他</OPTION></SELECT>
<font style="TEXT-ALIGN: center" size=4 valign="center"> 请选择国籍</td>
</tr>
<tr>
<td align="right" height="95" width="275" background="images/BKG35.JPG">
</td>
<td height="95" width="525" background="images/BKG35.JPG">
<input name="submit" type="submit" onclick="location.href="teaSearch4.asp"" value="查询">
<input name="Reset1" type="reset" value="重置">
<input name="Reset" type="reset" onclick="location.href="main.asp"" value="回到管理主页面">
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -