?? admin_show_total_student1.asp
字號:
<!--#include file="include/conn.asp"-->
<html>
<head>
<link rel="stylesheet" href="inc/css.css" type="text/css" />
</head>
<body>
<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>
<tr><td colspan="13"></td>
<tr><td colspan="13"></tr>
<tr bgcolor="#DEE5FA">
<td colspan="13" align="left" class="txlrow"><div align="center">
<p>
</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="s_name" type="text" id="s_name" 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
if sele="按學號查詢" and input="" then
response.write"不能為空"
else
sele=request.form("select")
input=request.form("s_name")
sql="select * from student where s_no='"&request.Form("s_name")&"'"
rs.open sql,conn,1,1
%>
<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>
<%
end if
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>
else if sele="按姓名查詢" then
tt="select * from student where s_name="&input
rs.open sql,conn,1,1
else
tt="select * from student where bj_name="&input
rs.open sql,conn,1,1
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -