?? updata.asp
字號:
<%if session("password")<>"" then%>
<!--#include file="inc/conn1.asp"-->
<!-- #include file="inc/top.asp" -->
<%if request.querystring("kind")="admin" then%>
<%
id=trim(Request("id"))
sqlcmd = ("select * from admin where id="&id) '查詢id(ID號)這條記錄
rs.Open sqlcmd,newconn,1,1
session("user")=rs("username")
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form method="POST" action="modify.asp">
<table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="25" align="center"> </td>
<td height="25"> </td>
<td height="25"> </td>
</tr>
<tr>
<td width="57" height="25" align="center">用戶名</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="username" size="25" maxlength="30" class="editbox1" value="<%=rs("username")%>">
</td>
</tr>
<tr>
<td height="25" align="center">密碼</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="password" type="password" size="25" maxlength="30" class="editbox1" value="<%=rs("password")%>"></td>
</tr>
<tr>
<td height="25" colspan="3">
<div align="center">
<input class=bottom name=B12 type=submit value="修改密碼">
<input class=bottom name=B22 type=reset value="重新修改">
<input type="hidden" name="kind" value="0">
<input type="hidden" name="id" value="<%=rs("id")%>">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%end if%>
<%if request.querystring("kind")="user" then%>
<%
id=trim(Request("id"))
sqlcmd = ("select * from user where id="&id) '查詢id(ID號)這條記錄
rs.Open sqlcmd,newconn,1,1
session("xh")=rs("xh")
session("return")="admin_user.asp"
%>
<form method="POST" action="modify.asp">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="57" height="25" align="center">班級</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="bj" size="25" maxlength="30" class="editbox1" value="<%=rs("bj")%>">
</td>
</tr>
<tr>
<td height="25" align="center">學號</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="xh" size="25" maxlength="30" class="editbox1" value="<%=rs("xh")%>"></td>
</tr>
<tr>
<td width="57" height="25" align="center">姓名</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="xm" size="25" maxlength="40" class="editbox1" value="<%=rs("xm")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">密碼</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input type="text" name="mm" size="25" class="editbox1" value="<%=rs("mm")%>">
</td>
</tr>
<tr>
<td height="25" align="center">性別 </td>
<td height="25"> </td>
<td height="25">
<select name="sex">
<option<%if rs("sex")="男" then response.write(" selected")%>>男</option>
<option<%if rs("sex")="女" then response.write(" selected")%>>女</option>
</td>
</tr>
<tr>
<td width="57" height="25" align="center"> </td>
<td width="16" height="25"> </td>
<td width="225" height="25">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">住址</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="addr" size="25" maxlength="100" class="editbox1" value="<%=rs("addr")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">郵編</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="yb" size="25" maxlength="100" class="editbox1" value="<%=rs("yb")%>">
</td>
</tr>
<tr>
<td height="25" colspan="3">
<div align="center">
<input class=bottom name=B12 type=submit value="修改記錄">
<input class=bottom name=B22 type=reset value="重新填寫">
<input type="hidden" name="id" value="<%=rs("id")%>">
<input type="hidden" name="kind" value="1">
</div>
</td>
</tr>
</table>
</form>
<%end if%>
<%if request.querystring("kind")="date" then%>
<%
id=trim(Request("id"))
sqlcmd = ("select * from bbs1 where id="&id) '查詢id(ID號)這條記錄
rs.Open sqlcmd,newconn,1,1
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<form method="POST" action="modify.asp">
<table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="57" height="25" align="center">班級</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="bj" size="25" maxlength="30" class="editbox1" value="<%=rs("bj")%>">
</td>
</tr>
<tr>
<td height="25" align="center">學號</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="xh" size="25" maxlength="30" class="editbox1" value="<%=rs("xh")%>"></td>
</tr>
<tr>
<td width="57" height="25" align="center">姓名</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="user" size="25" maxlength="40" class="editbox1" value="<%=rs("user")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">課程</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input type="text" name="kc" size="25" class="editbox1" value="<%=rs("kc")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">成績</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="cj" size="25" maxlength="100" class="editbox1" value="<%=rs("cj")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">學期</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<select name="xq" class="editbox1">
<option<%if rs("xq")="第一學期" then response.write(" selected")%>>第一學期</option>
<option<%if rs("xq")="第二學期" then response.write(" selected")%>>第二學期</option>
<option<%if rs("xq")="第三學期" then response.write(" selected")%>>第三學期</option>
<option<%if rs("xq")="第四學期" then response.write(" selected")%>>第四學期</option>
<option<%if rs("xq")="第五學期" then response.write(" selected")%>>第五學期</option>
<option<%if rs("xq")="第六學期" then response.write(" selected")%>>第六學期</option>
<option<%if rs("xq")="第七學期" then response.write(" selected")%>>第七學期</option>
<option<%if rs("xq")="第八學期" then response.write(" selected")%>>第八學期</option>
</select>
</td>
</tr>
<tr>
<td width="57" height="25" align="center">類型</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<select name="lx" type="lx">
<option<%if rs("lx")="必修課" then response.write(" selected")%>>必修課</option>
<option<%if rs("lx")="選修課" then response.write(" selected")%>>選修課</option>
<option<%if rs("lx")="限修課" then response.write(" selected")%>>限修課</option>
</select>
</td>
</tr>
<tr>
<td height="25" colspan="3">
<div align="center">
<input class=bottom name=B12 type=submit value="修改記錄">
<input class=bottom name=B22 type=reset value="重新添寫">
<input type="hidden" name="id" value="<%=rs("id")%>">
<input type="hidden" name="kind" value="2">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%end if%>
<%if request.querystring("kind")="bj" then%>
<%
id=trim(Request("id"))
sqlcmd = ("select * from bjb where id="&id) '查詢id(ID號)這條記錄
rs.Open sqlcmd,newconn,1,1
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form method="POST" action="modify.asp">
<table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="25" align="center"> </td>
<td height="25"> </td>
<td height="25"> </td>
</tr>
<tr>
<td width="57" height="25" align="center">班級</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="bj" size="25" maxlength="30" class="editbox1" value="<%=rs("bj")%>">
</td>
</tr>
<tr>
<td height="25" align="center">學號代碼</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="xhf" type="text" size="25" maxlength="30" class="editbox1" value="<%=rs("xhf")%>"></td>
</tr>
<tr>
<td height="25" colspan="3">
<div align="center">
<input class=bottom name=B12 type=submit value="修改記錄">
<input class=bottom name=B22 type=reset value="重新填寫">
<input type="hidden" name="kind" value="3">
<input type="hidden" name="id" value="<%=rs("id")%>">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%end if%>
<%if request.querystring("kind")="kc" then%>
<%
id=trim(Request("id"))
sqlcmd = ("select * from kcb where id="&id) '查詢id(ID號)這條記錄
rs.Open sqlcmd,newconn,1,1
%>
<table width=100% border="0" align=center cellpadding="0" cellspacing="0">
<td align="center" width="50%"><br>
<form name="form1" method="post" action="modify.asp">
<table width="50%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
<tr align="center">
<td height="32" colspan="2">修改與班級相對應的課程及類型</td>
</tr>
<tr>
<td width="26%" align="center">班級</td>
<td width="74%"><input type="text" name="bj" size="30" value="<%=rs("bj")%>">
</td>
</tr>
<tr>
<td align="center">課程</td>
<td><input name="kc" type="text" size="30" value="<%=rs("kc")%>"></td>
</tr>
<tr>
<td align="center">學期</td>
<td><select name="xq">
<option<%if rs("xq")="第一學期" then response.write(" selected")%>>第一學期</option>
<option<%if rs("xq")="第二學期" then response.write(" selected")%>>第二學期</option>
<option<%if rs("xq")="第三學期" then response.write(" selected")%>>第三學期</option>
<option<%if rs("xq")="第四學期" then response.write(" selected")%>>第四學期</option>
<option<%if rs("xq")="第五學期" then response.write(" selected")%>>第五學期</option>
<option<%if rs("xq")="第六學期" then response.write(" selected")%>>第六學期</option>
<option<%if rs("xq")="第七學期" then response.write(" selected")%>>第七學期</option>
<option<%if rs("xq")="第八學期" then response.write(" selected")%>>第八學期</option>
</select></td>
</tr>
<tr>
<td align="center">類型</td>
<td><select name="lx">
<option>必修課</option>
<option>選修課</option>
<option>限修課</option>
</select></td>
</tr>
<tr align="center">
<td colspan="2">
<input name="kind" type="hidden" value="4">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
<input type="hidden" name="id" value="<%=rs("id")%>"></td>
</tr>
<tr>
<td colspan=2><table width=100% cellspacing="0" cellpadding="0">
<tr><td width=15% align=center>
注意</td><td>1.填寫完后請到課程管理一欄進行確認。
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br><br>
<%end if%>
<!--#include file="inc/copyright.asp"-->
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -