📄 mod.asp
字号:
<!--#include file="conn.asp"-->
<%
if request.Form("tishi")="设置问题" then response.Redirect "my_psw_set.asp"
%>
<%
if request("edit")="ok" then call edit()
%>
<HEAD><TITLE>学生信息修改</TITLE>
<META http-equiv=Content-Language content=zh-cn>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="images/style.css" type=text/css rel=stylesheet>
</HEAD>
<BODY bgColor=#2f66bf >
<DIV align=center>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=0
cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width="100%"><!--#include file="head.asp"--></TD></TR></TBODY></TABLE>
<TABLE dir=ltr cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV align=center>
<TABLE height=830 cellSpacing=0 cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width=763 background=images/head_13.jpg height=15></TD></TR>
<TR>
<TD vAlign=top align=middle width=763
background=images/head_14.jpg height=49>
<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 cellSpacing=0 cellPadding=0 width=763
border=0><TBODY>
<TR>
<TD width=11 rowSpan=4> </TD>
<TD width=741></TD>
<TD width=11 rowSpan=4> </TD></TR>
<TR>
<TD width=741></TD></TR>
<TR>
<TD width=741> </TD></TR>
<TR>
<TD width=741></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width=763 background=images/head_16.jpg height=11></TD></TR>
<TR>
<TD width=763 background=images/head_11.jpg height=726>
<DIV align=center>
<TABLE id=table8 height="101%" cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=187>
<!-- #include file="left.asp" -->
</TD>
<TD vAlign=top>
<TABLE id=table9 height=30 cellSpacing=0 cellPadding=0
width=571 border=0>
<TBODY>
<TR>
<TD width=12 background=images/sousuo_1.jpg> </TD>
<TD width=115 background=images/sousuo_2.jpg>
<TABLE id=table12 height=18 cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top><FONT color=#ffffff><SPAN
style="FONT-SIZE: 12px"> 学 生 搜
索</SPAN></FONT></TD></TR></TBODY></TABLE></TD>
<TD background=images/sousuo_2.jpg> </TD>
<TD vAlign=top width=133
background=images/sousuo_2.jpg>
<FORM style="MARGIN: 0px" name="form1" action="search.asp" method="post">
<TABLE cellSpacing=0 cellPadding=0 width=390 border=0>
<TBODY>
<TR>
<TD width=56></TD>
<TD vAlign=top width=144><SPAN lang=zh-cn>
<SELECT class=smallSel size=1 name="searchid">
<OPTION value="Userid" selected name="typeid">=按登陆学号=</OPTION>
<OPTION value="UserName" name="typeid">=按学生姓名=</OPTION>
<OPTION value="Sex" name="typeid">=按学生性别=</OPTION>
<OPTION value="Birthday" name="typeid">=按出生年月=</OPTION>
<OPTION value="Banji" name="typeid">=按学生班级=</OPTION>
</SELECT></SPAN>
</TD>
<TD vAlign=top width=113>
<input name="searchkey" type="text" onfocus="this.value=''" size="10" maxlength="10" value=关键字>
</TD>
<TD width=77><DIV align=center>
<INPUT type=image src="images/sousuo_4.jpg" border=0 name=Submit value="开始查找" onclick="return checkk();"></DIV></TD></TR></TBODY></TABLE></FORM></TD></TD>
<TD width=15
background=images/sousuo_5.jpg> </TD></TR></TBODY></TABLE>
<TABLE id=table15 height=131 cellSpacing=0 cellPadding=0
width=568 border=0>
<TBODY>
<TR>
<TD width=146 background=images/bjbg_1.jpg height=35>
<TABLE id=table16 height=20 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle><FONT style="FONT-SIZE: 12px"
color=#ff0000>学生信息修改</FONT></TD></TR></TBODY>
</TABLE></TD>
<TD width=422 height=35><IMG height=35 src="images/bjbg_2.jpg" width=422 border=0></TD></TR>
<TR>
<TD align=middle width=568 background=images/bjbg_3.jpg colSpan=2>
<% if request.cookies("userid")<>"" then %>
<%=request.Cookies("&userid&")%>
<%
set rs=conn.execute("select * from [user] where UserId='"&request.cookies("userid")&"'")
%>
<table id=table28 height=162 align="center" cellSpacing=0 cellPadding=0 width=557 height=135 border=0>
<tr><td>
<%if rs("Memo2")<>"" then%>
<table width="80%" border="0" cellpadding="4" cellspacing="0" bordercolor="#C0C0C0" align=center bordercolordark="#FFFFFF">
<tr><td><marquee scrolldelay="200" id=zimu1 onMouseOver=zimu1.stop() onMouseOut=zimu1.start()><b>管理员：</b><%=rs("Memo2")%></marquee></td></tr>
</table>
<%end if%>
<form name="myinfo" action="mod.asp" method="post">
<table width="80%" border="1" cellpadding="4" cellspacing="0" bordercolor="#C0C0C0" align=center bordercolordark="#FFFFFF">
<tr><td colspan=2><b>以下为基本资料：</b></td></tr>
<tr>
<td width="30%" align="right">登陆学号： </td>
<td width="70%"><%=rs("UserID")%></td>
</tr>
<tr>
<td align="right">真实姓名： </td>
<td><input type="text" name="Username" value="<%=rs("UserName")%>" maxlength="16" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
</tr>
<tr>
<td align="right">电子邮箱： </td>
<td><input type="text" name="UserMail" value="<%=rs("UserMail")%>" maxlength="100" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ;"></td>
</tr>
<tr>
<td align="right">所在班级： </td>
<td><input type="text" name="Banji" value="<%=rs("Banji")%>" maxlength="50" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
</tr>
<tr>
<td align="right">所学专业： </td>
<td><input type="text" name="Zhuanye" value="<%=rs("Zhuanye")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
</tr>
<tr>
<td align="right">联系电话： </td>
<td><input type="text" name="HomePhone" value="<%=rs("HomePhone")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
</tr>
<tr>
<td align="right">性 别： </td>
<td>
<input name="Sex" type="radio" value="1" <%if rs("Sex")="1" then response.write "checked"%>><img border=0 src=images/login/boy.gif>帅哥 <input type="radio" name="Sex" value="0" <%if rs("Sex")="0" then response.write "checked"%>><img border=0 src=images/login/girl.gif>靓妹
</td></tr>
<tr>
<td align="right">出生年月： </td>
<td><input type="text" name="Birthday" value="<%=rs("Birthday")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr><td colspan=2><b>以下为选填资料：</b></td></tr>
<tr>
<td width="30%" align="right">移动电话： </td>
<td width="70%"><input type="text" name="CompPhone" value="<%=rs("CompPhone")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">腾讯QQ号： </td>
<td><input type="text" name="UserQQ" value="<%=rs("UserQQ")%>" maxlength="11" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">家庭住址： </td>
<td><input type="text" name="Address" value="<%=rs("Address")%>" maxlength="50" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">邮政编码： </td>
<td><input type="text" name="Zipcode" value="<%=rs("Zipcode")%>" maxlength="6" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
</tr>
<tr>
<td align="right">国 家： </td>
<td><input type="text" name="Country" value="<%=rs("Country")%>" maxlength="30" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">省 份： </td>
<td><input type="text" name="Province" value="<%=rs("Province")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">城 市： </td>
<td><input type="text" name="City" value="<%=rs("City")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
</tr>
<tr>
<td align="right">个人说明： </td>
<td><TEXTAREA type="text" name="Memo" ROWS="4" COLS="38" style="BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"><%=rs("Memo")%></TEXTAREA></td>
</tr>
<tr><td colspan=2 align=center>
<input type="submit" name="Submit" value="确认修改">
<input name="Submit2" type="reset" value="重新填写"><input type=hidden name=edit value="ok">
<input type="submit" name="tishi" title="忘记密码，可通过提示问题修改登陆密码" value="设置问题">
</td></tr></table>
</form>
<%
rs.close
set rs=nothing
else response.Write"你想干什么呢？小子没有登陆也来改资料"
end if%>
<TR> <TD width=568 colSpan=2 height=16><IMG height=16 src="images/bjbg_6.jpg" width=568 border=0></TD>
</TR>
</TABLE>
</TABLE></TABLE>
<DIV align=center>
<CENTER>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 height=76
cellSpacing=0 cellPadding=0 width=763 border=0>
<TBODY>
<TR>
<TD width=763 background=images/xiabg_3.jpg height=76>
<DIV align=center>
<TABLE id=table34 cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<TR>
<TD align=middle><FONT color=#051547><SPAN
style="FONT-SIZE: 12px">CopyRingt 2006
清水河源工作室</SPAN></FONT></TD>
</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></CENTER></DIV>
<DIV></DIV></BODY>
<%
'修改资料
sub edit()
Username=trim(request("Username"))
UserQQ=trim(request("UserQQ"))
Zipcode=trim(request("Zipcode"))
Address=trim(request("Address"))
Sex=trim(request("Sex"))
Birthday=trim(request("Birthday"))
HomePhone=trim(request("HomePhone"))
CompPhone=trim(request("CompPhone"))
UserMail=trim(request("UserMail"))
Country=trim(request("Country"))
Province=trim(request("Province"))
City=trim(request("City"))
Banji=trim(request("Banji"))
Zhuanye=trim(request("Zhuanye"))
Memo=trim(request("Memo"))
sql = "select * from [user] where UserId='"&request.cookies("userid")&"'"
set rs=Server.Createobject("ADODB.RecordSet")
rs.Open sql,conn,1,3
rs("Username")=Username
rs("Sex")=Sex
rs("UserQQ")=UserQQ
rs("Address")=Address
rs("Zipcode")=Zipcode
rs("Birthday")=Birthday
rs("HomePhone")=HomePhone
rs("CompPhone")=CompPhone
rs("UserMail")=UserMail
rs("Country")=Country
rs("Province")=Province
rs("City")=City
rs("Banji")=Banji
rs("Zhuanye")=Zhuanye
rs("Memo")=Memo
rs.update
set rs = nothing
response.write "<script language='javascript'>"
response.write "alert('操作成功，您修改的个人资料已保存！');"
response.write "location.href='mod.asp';"
response.write "</script>"
response.end
end sub
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -