change_info_save.asp

报名系统

<!--#include file="conn.asp"-->
<%
dim uID
uID=request.cookies("uID")
dim question,answer,rname,sex,mz,year,month,day,blcjzl,oicq,user_province,user_city,jbyydm,sfzh,tel1,addr1,zy,whcd,yzkzh
question=Request.form("question")
answer=Request.form("answer")
rname=Request.form("rname")
sex=Request.form("sex")
mz=Request.form("mz")
year=Request.form("year")
month=Request.form("month")
day=Request.form("day")
blcjzl=Request.form("blcjzl")
user_province=Request.form("user_province")
user_city=Request.form("user_city")
jbyydm=Request.form("jbyydm")
sfzh=Request.form("sfzh")
oicq=Request.form("oicq")
tel1=Request.form("tel1")
addr1=Request.form("addr1")
zy=Request.form("zy")
whcd=Request.form("whcd")
yzkzh=Request.form("yzkzh")

dim rs,sql

set rs=Server.CreateObject("Adodb.Recordset")
sql="select question,answer,rname,sex,mz,year,month,day,blcjzl,oicq,user_province,user_city,jbyydm,sfzh,tel1,addr1,zy,whcd,yzkzh from member where uID='"&uID&"'"
rs.open sql,conn,1,3
rs("question")=question
rs("answer")=answer
rs("rname")=rname
rs("sex")=sex
rs("mz")=mz
rs("year")=year
rs("month")=month
rs("day")=day
rs("blcjzl")=blcjzl
rs("user_province")=user_province
rs("user_city")=user_city
rs("jbyydm")=jbyydm
rs("sfzh")=sfzh
rs("oicq")=oicq
rs("tel1")=tel1
rs("addr1")=addr1
rs("zy")=zy
rs("whcd")=whcd
rs("yzkzh")=yzkzh

rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "<script>alert('恭喜您，资料修改成功！');location.href='change_info.asp';</Script>"
%>