?? chengjichaxun.asp
字號(hào):
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>查詢(xún)</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("請(qǐng)您輸入用戶(hù)名！");
return false;
}
if (strPassword ==""){
alert("請(qǐng)輸入密碼！");
return false;
}
if (primeInUserName !=-1){
alert("用戶(hù)名中不能包含撇號(hào)！");
return false;
}
if (primeInPassword !=-1){
alert("密碼中不能包含撇號(hào)！");
return false;
}
}
-->
</script>
</head>
<body bgColor=GhostWhite>
<!-- #include virtual="/admin/include/title.html"-->
<p> </p>
<%
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
%>
<form method="post" name="frmLogin" action="chengjisearch.asp" >
<table align="center" bgcolor=Azure border="0" cellPadding="0" cellSpacing="0" width="545" background=images/BKG35.JPG>
<tr>
<td colspan="2" align=center height="32">
<font size="4" color="#0000FF"><b>學(xué)員成績(jī)信息查詢(xún)</b></font></td>
</tr>
<tr>
<td align="right" height="21" vAlign="bottom" width="150">學(xué)員姓名：
</td>
<td height="21" vAlign="bottom" width="408">
<input name="seaUserName" size="15" maxlength="15">
可輸入學(xué)生的姓名</td>
</tr>
<tr>
<td align="right" width="150">學(xué)員學(xué)號(hào)：
</td>
<td width="408">
<input name="seaPassWord" size="15" maxlength="15"> 可輸入學(xué)生的學(xué)號(hào)</td>
</tr>
<tr>
<td align="right" width="137"> 班 級(jí)：
</td>
<td width="408">
<select style="WIDTH: 70; height:19"
size=1 name=sClass> <option
value="" selected
></OPTION><option value=P1
>P1</OPTION><option value=P2
>P2</OPTION><option value=P3
>P3</OPTION><option value=K1
>K1</OPTION><option value=K2
>K2</OPTION><option value=K3
>K3</OPTION><option value=K4
>K4</OPTION><option value=K5
>K5</OPTION><option value=K6
>K6</OPTION><option value=K7
>K7</OPTION><option value=K8
>K8</OPTION><option value=K9
>K9</OPTION><option value=K10
>K10</OPTION><option value=K11
>K11</OPTION><option value=K12
>K12</OPTION><option value=RC1
>RC1</OPTION><option value=RC2
>RC2</OPTION><option value=RC3
>RC3</OPTION><option value=RC4
>RC4</OPTION><option value=K1.5
>K1.5</OPTION><option value=K2.5
>K2.5</OPTION><option value=K3.5
>K3.5</OPTION><option value=K4.5
>K4.5</OPTION><option value=K5.5
>K5.5</OPTION><option value=K6.5
>K6.5</OPTION><option value=PRE-K
>PRE-K</OPTION><option value=寫(xiě)作１
>寫(xiě)作１</OPTION><option value=寫(xiě)作２
>寫(xiě)作２</OPTION><option value=寫(xiě)作３
>寫(xiě)作３</OPTION><option value=寫(xiě)作４
>寫(xiě)作４</SELECT><font style="TEXT-ALIGN: center" size=2 valign="center">
</font><font style="TEXT-ALIGN: center" valign="center"> 級(jí)</font><font style="TEXT-ALIGN: center" size=2 valign="center"><select style="WIDTH: 41; height:15"
size=1 name=sban> <option
value="" selected
></OPTION><option value=a
>a</OPTION><option value=b
>b</OPTION><option value=c
>c</OPTION><option value=d
>d</OPTION><option value=e
>e</OPTION><option value=f
>f</OPTION><option value=g
>g</OPTION><option value=h
>h</OPTION><option value=i
>i</OPTION><option value=j
>j</OPTION><option value=k
>k</OPTION><option value=l
>l</OPTION></SELECT> </font>
<font style="TEXT-ALIGN: center" size=4 valign="center"> 班 </td>
</tr>
<tr>
<td align="right" width="137"> 分 校：
</td>
<td width="408">
<p> <select size="1" name="sFenxiao"><% SchoolDisp %> </select> 請(qǐng)選擇所在分校</p></td>
</tr>
<tr>
<td align="right" height="59" width="137">
</td>
<td height="59" width="408">
<input name="submit" type="submit" value="查詢(xún)">
<input name="Reset1" type="reset" value="重置"> <input name="Reset0" type="reset" onclick="location.href="chengji.asp"" value="返回">
</td>
</tr>
</table>
</form>
</table>
</form>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -