比如修改密码
set rs=server.createobject("adodb.recordset")
sql="select username,password from user where username='"&username&"'"
rs.open sql,conn,1,3
if not rs.eof then
rs("password")=password
rs.update
response.write "<br>恭喜!密码修改成功!请您记住您的新密码!<br><br><a href=index.asp>点击这里<font color=#ff0000>返回首页</font></a><br>"
else
response.write "<br>密码修改不成功,请与管理员联系!<br>"
end if
rs.close
set rs=nothing
conn.close
set conn=nothing