<%@ Language=VBScript %>
<%
'判断用户是否登录
if isempty(Session("UserName")) then
Response.Redirect "index.asp"
end if
'连接系统数据库
set conn = server.createobject ("adodb.connection")
conn.open "asp"
set RSThisUser=conn.Execute ("select * from usertype where name= '" & Session("UserName") &"' ")
'修改个人信息
if not IsEmpty(Request.Form("Modify")) then
'校验用户的输入
if len(Request.Form("realname"))=0 or len(Request.Form("UserName"))=0 _
or len(Request.Form("Password"))=0 then
TheMessage = "用户登录名,姓名,密码不能为空"
else
conn.execute" update usertype set realname ='" & Request.Form("realname")& "',name='" & Request.Form("UserName")& "',passwd='" & Request.Form("password")& "',sex='" & Request.Form("sex")& "',department='" & Request.Form("position1")& "',position='" & Request.Form("position2")& "',phone='" & Request.Form("phone")& "',mobilephone='" & Request.Form("mobilephone")& "',email='" & Request.Form("Email")& "' Where name='" & Request.Form("UserName") &"'"
//.....试一下在下面加入这句
session("username")=request.form("username")
set RSThisUser=conn.Execute ("select * from usertype where name= '" & Session("UserName") &"' ")
TheMessage = "您的信息已经修改成功,请返回"
end if
else
TheMessage = "请在下面修改您个人信息"
end if
%>
还是不行,要不我把程序拿出来您帮忙看看吧。我估计是程序中出错了。
<%@ Language=VBScript %>
<%
'判断用户是否登录
if isempty(Session("UserName")) then
Response.Redirect "index.asp"
end if
'连接系统数据库
set conn = server.createobject ("adodb.connection")
conn.open "asp"
set RSThisUser=conn.Execute ("select * from usertype where name= '" & Session("UserName") &"' ")
'修改个人信息
if not IsEmpty(Request.Form("Modify")) then
'校验用户的输入
if len(Request.Form("realname"))=0 or len(Request.Form("UserName"))=0 _
or len(Request.Form("Password"))=0 then
TheMessage = "用户登录名,姓名,密码不能为空"
else
conn.execute" update usertype set realname ='" & Request.Form("realname")& "',name='" & Request.Form("UserName")& "',passwd='" & Request.Form("password")& "',sex='" & Request.Form("sex")& "',department='" & Request.Form("position1")& "',position='" & Request.Form("position2")& "',phone='" & Request.Form("phone")& "',mobilephone='" & Request.Form("mobilephone")& "',email='" & Request.Form("Email")& "' Where name='" & Request.Form("UserName") &"'"
set RSThisUser=conn.Execute ("select * from usertype where name= '" & Session("UserName") &"' ")
TheMessage = "您的信息已经修改成功,请返回"
end if
else
TheMessage = "请在下面修改您个人信息"
end if
%>
下边是表单的设置,我只给一个例子:
<tr bgcolor="#6699CC" valign="middle">
<td width="33%" height="43" bgcolor="#6699CC"><font color="#FFFFFF" size="4" face="华文新魏">用户名:</font></td>
<td width="67%"> <p><font color="#FFFFFF" size="4" face="华文新魏">
<input name="UserName" type="text" class="bk" id="UserName" size="25" maxlength="16"value="<% response.write RSThisUser("name") %>">
</font><font color="#FFFFFF" size="2" face="华文新魏">
</td>
</tr>