?? admin_show_ num_student.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="550" border=0 align=center cellpadding=2 cellspacing=1 bordercolor="#799AE1" class=tableBorder>
<tbody>
<tr>
<th colspan=7 align=center style="height: 23px"> <div align="center"> 查看全部學生</div></th>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" bgcolor="#DEE5FA" class=txlrow> </td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" bgcolor="#DEE5FA" class=txlrow><div align="center">按學號查詢:
<input type="text" name="textfield">
<input type="submit" name="Submit3" value="查詢">
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" bgcolor="#DEE5FA" class=txlrow><div align="center">按姓名查詢:
<input type="text" name="textfield2">
<input type="submit" name="Submit4" value="查詢">
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" bgcolor="#DEE5FA" class=txlrow><div align="center">按班級查詢:
<input type="text" name="textfield3">
<input type="submit" name="Submit5" value="查詢">
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" bgcolor="#DEE5FA" class=txlrow> </td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="68" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">學號</div></td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">密碼</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">姓名</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">性別</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">出生日期</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">政治面貌</td>
<td width="90" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">民族</td>
</tr>
<tr bgcolor="#DEE5FA">
<td width="68" align="center" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" valign="middle" bgcolor="#DEE5FA" class="txlrow"><p>
<label></label>
</p></td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
</tr>
<td width="68" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">籍貫</div></td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">入學年份</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">狀態</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">學籍</td>
<td width="75" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">班別</td>
<td colspan="2" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"> </td>
<tr bgcolor="#DEE5FA">
<td width="68" align="center" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
<td colspan="2" align="center" bgcolor="#DEE5FA" class="txlrow"> </td>
</tr>
<tr bgcolor="#DEE5FA">
<td align="center" class="txlrow"> </td>
<td colspan="6" align="center" bgcolor="#DEE5FA" class="txlrow"><input type="submit" name="Submit" value="確定">
<input type="reset" name="Submit2" value="取消"></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="7" align="left" class="txlrow"><div align="center">
<p> </p>
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan=7 align=center class=txlrow></td>
</tr>
</table>
</FORM>
<%
dim s,s_no,s_paw,s_name,sex,s_birth,s_zzmm,s_mingzu,s_jg,s_years,s_status,s_xueji,banji,zy_name
s_no=request.form("s_no")
s_paw=request.form("s_paw")
s_name=request.form("s_name")
sex=request.form("sex")
s_birth=request.form("s_birth")
s_zzmm=request.form("s_zzmm")
s_mingzu=request.form("s_mingzu")
s_jg=request.form("s_jg")
s_years=request.form("s_years")
s_status=request.form("s_status")
s_xueji=request.form("s_xueji")
banji=request.form("banji")
zy_name=request.form("zy_name")
if request.form("submit")="確定" then
if (s_no="" or s_paw="" or s_name="" or sex="" or s_zzmm="" or s_mingzu="" or s_jg="" or s_years="" or s_status="" or s_xueji="" or banji="" or zy_name="") then
response.write "<script> alert('需要填定的資料沒有完整!');</script>"
else
set rs=server.CreateObject("adodb.recordset")
s="select * from student"
rs.open s,conn,3,3
rs.addnew
rs("s_no")=s_no
rs("s_paw")=s_paw
rs("s_name")=s_name
rs("s_sex")=sex
rs("s_birth")=s_birth
rs("s_zzmm")=s_zzmm
rs("s_mingzu")=s_mingzu
rs("s_jiguan")=s_jg
rs("s_interyears")=s_years
rs("s_zhuantai")=s_status
rs("s_xuezhi")=s_xueji
rs("bj_name")=banji
rs("zy_name")=zy_name
response.write "<script> location.href='success.asp';</script>"
rs.update
end if
end if
%>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -