⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 waijichaxuntea.asp

📁 学校管理系统中的教师管理模块
💻 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">&nbsp;输入教工的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"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;选择所要查询的性别</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"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;选择员工是否在职</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 选择所要查询的级别</td>
</tr>
<tr>
<td align="right" width="275" background="images/BKG35.JPG">分&nbsp;&nbsp;&nbsp; 校:
</td>
<td width="525" background="images/BKG35.JPG">
<p> <select size="1" name="sFen"><% SchoolDisp %> </select>&nbsp; 请选择所在分校</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=&quot;teaSearch4.asp&quot;" value="查询">
&nbsp;&nbsp;&nbsp;
<input name="Reset1" type="reset" value="重置">&nbsp;&nbsp;&nbsp;&nbsp; 
<input name="Reset" type="reset" onclick="location.href=&quot;main.asp&quot;" value="回到管理主页面">
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -