?? admin_show_edit_student.asp
字號:
<!--#include file="include/conn.asp"-->
<html>
<head>
<link rel="stylesheet" href="inc/css.css" type="text/css" />
</head>
<body>
<%
dim ID,ww
ID=request.QueryString("id")
ww="select * from student where id="&ID
rs.open ww,conn,1,1
%>
<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=2 align=center style="height: 23px">
<div align="center">
添加管理員</div></th>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="2" align="left" bgcolor="#DEE5FA" class=txlrow> </td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">學號：</div></td>
<td width="287" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">
<div align="left">
<input name="s_no" type="text" id="s_no" value="<%=rs("s_no")%>" size="15">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">登陸密碼：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate">
<div align="left">
<input name="s_paw" type="text" id="s_paw" size="15" value="<%=rs("s_paw")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">姓名：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_name" type="text" id="s_name" size="15" value="<%=rs("s_name")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">性別：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="sex" type="radio" value="男" <%if rs("s_sex")="男" then response.write "checked " end if%>>
男
<input type="radio" name="sex" value="女" <%if rs("s_sex")="女" then response.write "checked " end if%>>
女</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">出生日期：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_birth" type="text" id="s_birth" size="15" value="<%=rs("s_birth")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">政治面貌：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_zzmm" type="text" id="s_zzmm" size="10" value="<%=rs("s_zzmm")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">民族：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_mingzu" type="text" id="s_mingzu" size="15" value="<%=rs("s_mingzu")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">籍貫：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_jiguan" type="text" id="s_jiguan" size="15" value="<%=rs("s_jiguan")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td width="250" align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">入學年份：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_interyears" type="text" id="s_interyears" size="10" value="<%=rs("s_interyears")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">狀態：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_zhuantai" type="text" id="s_zhuantai" size="10" value="<%=rs("s_zhuantai")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">學籍：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="s_xueji" type="text" id="s_xueji" size="8" value="<%=rs("s_xuezhi")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">班級名稱：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="bj_name" type="text" id="bj_name" size="18" value="<%=rs("bj_name")%>">
</div></td>
</tr>
<tr align="center" bgcolor="#799AE1">
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="right">專業名稱：</div></td>
<td align="center" bgcolor="#799AE1" class="txlHeaderBackgroundAlternate"><div align="left">
<input name="zy_name" type="text" id="zy_name" size="20" value="<%=rs("zy_name")%>">
</div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td align="center" class="txlrow"><div align="center"></div></td>
<td align="center" bgcolor="#DEE5FA" class="txlrow">
<div align="left">
<input type="submit" name="Submit" value="修改">
<input type="reset" name="Submit2" value="取消">
<a href="javascript:history.go(-1);">返回</a></div></td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan="2" align="center" class="txlrow"> </td>
</tr>
<tr bgcolor="#DEE5FA">
<td colspan=2 align=center class=txlrow></td>
</tr>
</tbody></table>
<%
rs.close
set rs=nothing
%>
</FORM>
<%
dim s,s_no,s_paw,s_name,s_sex,s_birth,s_zzmm,s_jiguan,s_mingzu,s_interyears,s_zhuantai,s_xuezhi,bj_name,zy_name
s_no=request.form("s_no")
s_paw=request.form("s_paw")
s_name=request.form("s_name")
s_sex=request.form("sex")
s_birth=request.form("s_birth")
s_zzmm=request.form("s_zzmm")
s_mingzu=request.form("s_mingzu")
s_jiguan=request.form("s_jiguan")
s_interyears=request.form("s_interyears")
s_zhuantai=request.form("s_zhuantai")
s_xuezhi=request.form("s_xueji")
bj_name=request.form("bj_name")
zy_name=request.form("zy_name")
if request.form("submit")="修改" then
if (s_no="" or s_paw="" or s_name="" or s_sex="" or s_birth="" or s_zzmm="" or s_mingzu="" or s_jiguan="" or s_interyears="" or s_zhuantai="" or s_xuezhi="" or bj_name=""or zy_name="" ) then
response.write "<script> alert('資料沒有填寫完整!');</script>"
else
set rs=server.CreateObject("adodb.recordset")
s="select * from student where id="&ID
rs.open s,conn,3,3
rs("s_no")=s_no
rs("s_paw")=s_paw
rs("s_name")=s_name
rs("s_sex")=s_sex
rs("s_birth")=s_birth
rs("s_zzmm")=s_zzmm
rs("s_mingzu")=s_mingzu
rs("s_jiguan")=s_jiguan
rs("s_interyears")=s_interyears
rs("s_zhuantai")=s_zhuantai
rs("s_xuezhi")=s_xuezhi
rs("bj_name")=bj_name
rs("zy_name")=zy_name
rs.update
response.write "<script> alert('添加成功!');location.href='admin_show_total_student.asp';</script>"
end if
end if
%>
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -