?? search2.asp
字號(hào):
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="xuanke.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查詢學(xué)生</title>
<style type="text/css">
<!--
@import url("style.css");
body {
background-image: url(image/back.jpg);
}
-->
</style>
</head>
<%
dim cname
cname=request.Form("cname")
%>
<body bgcolor="#FFFFCC">
<div align="center">
<table width="650" border="0" class="table_big">
<tr>
<td width="562" height="505" valign="top"><div align="center">
<!--#include file="include/admin_head.asp" -->
<br>
<form name="form1" method="post" action="">
<table width="729" height="156" border="0" class="table_small">
<tr>
<td height="28" colspan="2" background="image/type_bg.gif">請(qǐng)給出查詢條件</td>
</tr>
<tr>
<td colspan="2" class="table_title"> </td>
</tr>
<tr>
<td colspan="2" class="text"><div align="left">
<div align="center">查看該科的所有學(xué)生
<select name="cname" class="select_filed2" id="cname" >
<%
set rs_course_show=server.CreateObject("adodb.recordset")
'取得預(yù)約總數(shù)-----------------
sql = "select * from course "
rs_course_show.open sql,xuanke_conn,3,2
rs_course_show.movefirst
'循環(huán)顯示課程信息-----------------
while (not rs_course_show.eof or rs_course_show.bof)
%>
<option><%= rs_course_show("cname") %></option>
<%
rs_course_show.movenext
wend
%>
</select>
<input name="search" type="submit" class="button_" id="search" value="查詢">
</div> </tr>
<tr>
<td width="382" height="27" class="text"> </td>
<td width="251" class="text"> </td>
</tr>
</table>
</form>
<%
if cname="" then
response.End()
else
%>
<%
dim rs_course
set rs_course=server.CreateObject("adodb.recordset")
sql = "select * from course where cname ='"&request("cname")&"'"
rs_course.open sql,xuanke_conn,3,2
%>
<%
set rs_search=server.CreateObject("adodb.recordset")
sql = "select * from preengage where p_cno ='"& rs_course("cno")&"'"
rs_search.open sql,xuanke_conn,3,2
if not(rs_search.eof or rs_search.bof) then
%>
<table width="713" border="1" cellspacing="0" class="table_small">
<tr>
<td colspan="7" bordercolor="#0033FF"><form name="form2" method="post" action="search_class2.asp">
<label></label>
按班級(jí)查找
<select name="class" class="select_filed2" id="class">
<%
set rs_class_show=server.CreateObject("adodb.recordset")
'取得預(yù)約總數(shù)-----------------
sql = "select * from class where CourseNo= '" &rs_course("cno")& "'"
rs_class_show.open sql,xuanke_conn,3,2
rs_class_show.movefirst
'循環(huán)顯示課程信息-----------------
while (not rs_class_show.eof or rs_class_show.bof)
%>
<option value="<%=rs_class_show("id")%>"><%= rs_class_show("classdesc") %></option>
<%
rs_class_show.movenext
wend
%>
</select>
<label>
<input type="submit" name="Submit" value="提交">
</label>
</form> </td>
</tr>
<tr><td colspan="7" bordercolor="#0033FF">
<form name="form2" method="post" action="search_zhiyuan.asp">
<label></label>
按志愿查找
<select name="p_zhiyuan" class="select_filed2" id="p_zhiyuan">
<option value="1">第一志愿</option>
<option value="2">第二志愿</option>
<option value="3">第三志愿</option>
</select>
<input type="hidden" name="cno" id="cno" value="<%=rs_course("cno")%>" >
<label>
<input type="submit" name="Submit" value="提交">
</label>
</form>
</td></tr>
<tr>
<td colspan="7" bordercolor="#0033FF" class="text_title"><div align="left">查詢結(jié)果：
<span class="text_blue"><%response.Write("查看所有選擇 "& request.Form("cname")& " 的學(xué)生")%>
</div></td>
</tr>
<tr>
<td colspan="7" bordercolor="#0033FF" class="table_title"> </td>
</tr>
<tr class="text_title">
<td width="126" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">學(xué)生姓名</div></td>
<td width="152" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">學(xué)號(hào)</div></td>
<td width="135" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">身份證</div></td>
<td width="127" bordercolor="#0033FF" background="image/type_bg.gif">志愿</td>
<td width="149" bordercolor="#0033FF" background="image/type_bg.gif">專業(yè)</td>
</tr>
<%
rs_search.movefirst
while (not rs_search.eof or rs_search.bof)
%>
<tr class="text">
<%
set rs_student=server.CreateObject("adodb.recordset")
sql = "select * from student where id_no ='"&rs_search("p_id_no")&"'"
rs_student.open sql,xuanke_conn,3,2
%>
<td bordercolor="#0033FF" bgcolor="#FFFF66"><div align="left"><%= rs_student("name") %></div></td>
<td bordercolor="#0033FF" bgcolor="#FFFF66"><div align="left"><%=rs_student("student_no")%></div></td>
<td bordercolor="#0033FF" bgcolor="#FF6699"><div align="left"><%=rs_student("id_no")%></div></td>
<%if rs_search("p_zhiyuan")=1 then
s="第一志愿"
end if
if rs_search("p_zhiyuan")=2 then
s="第二志愿"
end if
if rs_search("p_zhiyuan")=3 then
s="第三志愿"
end if
%>
<td bordercolor="#0033FF" bgcolor="#FF6699"><%=s%></td>
<td bordercolor="#0033FF" bgcolor="#FF6699"><%= rs_student("classes") %></td>
</tr>
<%
rs_search.movenext
Wend
%>
<td height="31" colspan="7" bordercolor="1">
<%
dim rs_preengage
dim rs_preengage_total
Set rs_preengage = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM preengage where p_cno ='" & rs_course("cno")&"'"
rs_preengage.Open sql,xuanke_conn,3,2
If (rs_preengage.RecordCount = -1) Then
rs_preengage_total=0
rs_preengage.movefirst
While (Not rs_preengage.EOF)
rs_preengage_total = rs_preengage_total + 1
rs_preengage.MoveNext
Wend
else
rs_preengage_total = rs_preengage.RecordCount
End If
%>
<div align="left">當(dāng)前有<span class="text_blue"><%=(rs_preengage_total)%></span>位學(xué)生選擇該課程</div> </td>
</tr>
</table>
<%else%>
<table width="713" border="0" class="table_small">
<tr>
<td colspan="2" class="text_error"><div align="center">●輸入課程不存在或沒(méi)有學(xué)生選擇該課程！</div></td>
<tr>
</table>
<%End If%>
<br>
<!--#include file="include/foot.asp" -->
<br>
</div></td>
</tr>
</table>
</div>
<% End If %>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -