📄 search_zhiyuan.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="xuanke.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询学生</title>
<style type="text/css">
<!--
@import url("style.css");
body {
background-image: url(image/back.jpg);
}
.STYLE1 {font-size: 12px}
.STYLE2 {color: #0000FF}
-->
</style>
</head>
<%
p_zhiyuan=request.Form("p_zhiyuan")
p_cno=request.Form("cno")
%>
<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>
<%
set rs_student=server.CreateObject("adodb.recordset")
sql = "select student.*,preengage.* from student,preengage where student.id_no=preengage.p_id_no and preengage.p_cno ='"&request.Form("cno")&"'"
sql=sql & "and p_zhiyuan="&p_zhiyuan
rs_student.open sql,xuanke_conn,3,2
if not(rs_student.eof or rs_student.bof) then
%>
<table width="713" border="1" cellspacing="0" class="table_small">
<tr>
<td colspan="7" bordercolor="#0033FF"> </tr>
<tr>
<%
set rs_course=server.CreateObject("adodb.recordset")
sql = "select * from course where course.cno ='"&request.Form("cno")&"'"
rs_course.open sql,xuanke_conn,3,2
%>
<td colspan="7" bordercolor="#0033FF" class="text_title"><div align="left" class="text_blue">查询结果：
<span class="text_blue">
<%response.Write("查看选择 "& rs_course("cname")&" 的学生")%>
</div></td>
</tr>
<tr>
<td colspan="7" bordercolor="#0033FF" class="table_title"> </td>
</tr>
<tr class="text_title">
<td width="133" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">学生姓名</div></td>
<td width="134" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">学号</div></td>
<td width="84" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">身份证</div></td>
<td width="85" bordercolor="#0033FF" background="image/type_bg.gif">志愿</td>
<td width="170" bordercolor="#0033FF" background="image/type_bg.gif"><div align="left">专业</div></td>
</tr>
<%
rs_student.movefirst
while (not rs_student.eof or rs_student.bof)
%>
<tr><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_student("p_zhiyuan")=1 then
s="第一志愿"
end if
if rs_student("p_zhiyuan")=2 then
s="第二志愿"
end if
if rs_student("p_zhiyuan")=3 then
s="第三志愿"
end if
%>
<td bordercolor="#0033FF" bgcolor="#FF6699"><div align="left"><%=s%></div></td>
<td bordercolor="#0033FF" bgcolor="#FF6699"><div align="left"><%= rs_student("classes") %></div></td>
</tr>
<%
rs_student.movenext
Wend
%>
<td height="31" colspan="7" bordercolor="1">
<%
dim rs_class
dim rs_class_total
Set rs_class = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM preengage where p_cno ='"&request.Form("cno")&"'"
rs_class.Open sql,xuanke_conn,3,2
If (rs_class.RecordCount = -1) Then
rs_class_total=0
rs_class.movefirst
While (Not rs_class.EOF)
rs_class_total = rs_class_total + 1
rs_class.MoveNext
Wend
else
rs_class_total = rs_class.RecordCount
End If
%>
<div align="left" class="STYLE1">当前有<span class="STYLE2"><%=(rs_class_total)%></span>位学生选择该课题</div> </td>
</tr>
</table>
<%else%>
<table width="713" border="0" class="table_small">
<tr>
<td colspan="2" class="text_error"><div align="center"></div>
该课题还没有人选</td>
<tr>
</table>
<%end if%>
<br>
<!--#include file="include/foot.asp" -->
</div></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -