📄 admin_show_total_student.asp
字号:
<!--#include file="include/conn.asp"-->
<html>
<head>
<link rel="stylesheet" href="inc/css.css" type="text/css" />
</head>
<body>
<%
dim sql
sql="select * from student"
rs.open sql,conn,1,1
rs.pagesize=2
zhongye=rs.pagecount
page=int(request("page"))
if page<=0 then page=1
if request("page")="" then page=1
rs.absolutepage=page
%>
<form name="form1" method="post" action="">
<table width="760" border=0 align=center cellpadding=2 cellspacing=1 bordercolor="#799AE1" class=tableBorder>
<tbody>
<tr>
<th colspan="13" align=center style="height: 23px"> <div align="center"> 查看全部学生</div></th>
</tr>
<tr align="center" bgcolor="#799AE1">
<td colspan="13" align="left" bgcolor="#DEE5FA" class=txlrow> </td>
</tr>
<%
if rs.eof and rs.bof then
response.Write("暂时没有数据！")
else
for i=1 to rs.pagesize %>
<tr bgcolor="#DEE5FA">
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">学号</td>
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">密码</td>
<td width="40" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">姓名</td>
<td width="30" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">性别</td>
<td width="70" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">出生日期</td>
<td width="63" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">政治面貌</td>
<td width="39" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">民族</td>
<td width="65" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">籍贯</td>
<td width="59" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">入学年份</td>
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">状态</td>
<td width="40" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">学籍</td>
<td width="49" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">班级</td>
<td width="110" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">专业名称</td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#DEE5FA" class=txlrow><a href="admin_show_no_student.asp?id=<%=rs("ID")%>"><%=rs("s_no")%></a></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_paw")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_name")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_sex")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_birth")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_zzmm")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_mingzu")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_jiguan")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_interyears")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_zhuantai")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_xuezhi")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("bj_name")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("zy_name")%></td>
</tr>
<%
rs.movenext
next
end if
%>
<tr><td colspan="13"></td>
<tr><td colspan="13"></tr>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow"><div align="center">
<p>
<% for i=1 to zhongye%>
<a href="admin_show_total_student.asp?page=<%=i%>"> <%=i%></a>
<%Next%>
<%
rs.close
set rs=nothing
%>
</p>
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="55%"><div align="right">查看：
<select name="select">
<option value="1">按学号查询</option>
<option value="2">按姓名查询</option>
<option value="3">按班级查询</option>
</select>
<input name="input" type="text" id="input" size="15">
<input type="submit" name="Submit" value="查询">
</div></td>
<td width="45%"> <a href="javascript:history.go(-1);">返回></a></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow"> </td>
</tr>
<tr bgcolor="#DEE5FA">
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">学号</td>
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">密码</td>
<td width="40" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">姓名</td>
<td width="30" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">性别</td>
<td width="70" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">出生日期</td>
<td width="63" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">政治面貌</td>
<td width="39" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">民族</td>
<td width="65" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">籍贯</td>
<td width="59" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">入学年份</td>
<td width="50" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">状态</td>
<td width="40" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">学籍</td>
<td width="49" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">班级</td>
<td width="110" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">专业名称</td>
</tr>
<%
dim sele,input
if request.form("submit")="查询" then
sele=request.form("select")
set rs=server.CreateObject("adodb.recordset")
if sele="1" then
v="select * from student where s_no='"&request.Form("input")&"'"
rs.open v,conn,1,1
else if sele="2" then
v="select * from student where s_name='"&request.Form("input")&"'"
rs.open v,conn,1,1
else if sele="3" then
v="select * from student where bj_name='"&request.Form("input")&"'"
rs.open v,conn,1,1
end if
end if
end if
%>
<% do while not rs.eof %>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#DEE5FA" class=txlrow><a href="admin_show_no_student.asp?id=<%=rs("ID")%>"><%=rs("s_no")%></a></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_paw")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_name")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_sex")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_birth")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_zzmm")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_mingzu")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_jiguan")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_interyears")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_zhuantai")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("s_xuezhi")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("bj_name")%></td>
<td align="center" bgcolor="#DEE5FA" class=txlrow><%=rs("zy_name")%></td>
</tr>
<% rs.movenext
loop
%>
<%
rs.close
set rs=nothing
end if
%>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow"> </td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow"> </td>
</tr>
</table>
</FORM>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -