📄 chengjichaxun.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>
<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>学员成绩信息查询</b></font></td>
</tr>
<tr>
<td align="right" height="21" vAlign="bottom" width="150">学员姓名：
</td>
<td height="21" vAlign="bottom" width="408">
<input name="seaUserName" size="15" maxlength="15">
可输入学生的姓名</td>
</tr>
<tr>
<td align="right" width="150">学员学号：
</td>
<td width="408">
<input name="seaPassWord" size="15" maxlength="15"> 可输入学生的学号</td>
</tr>
<tr>
<td align="right" width="137"> 班 级：
</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=写作１
>写作１</OPTION><option value=写作２
>写作２</OPTION><option value=写作３
>写作３</OPTION><option value=写作４
>写作４</SELECT><font style="TEXT-ALIGN: center" size=2 valign="center">
</font><font style="TEXT-ALIGN: center" valign="center"> 级</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> 请选择所在分校</p></td>
</tr>
<tr>
<td align="right" height="59" width="137">
</td>
<td height="59" width="408">
<input name="submit" type="submit" value="查询">
<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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -