如何返回用户的注册信息
sysdy 2001-12-28 09:46:03 我正在做一个用户注册的页面,想实现注册完后返回注册信息,不知代码该怎样写。
我的注册代码如下:
<%
name=Request.Form("name")
pwd=Request.Form("pwd")
sex=request.form("sex")
age=Request.Form("age")
email=Request.Form("email")
QQ=Request.Form("QQ")
Set DataCon=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
DataCon.ConnectionTimeout=20
DataCon.Open "DSN=guestbook_server;uid=sysdy;pwd=185898"
sqlquery="select * from reg_info where name='"&name&"'"
set rs=datacon.execute(sqlquery)
if not rs.eof then
Response.Write "<html><body><center><font size=5>您的名字已经有人在使用。</font></center></body></html>"
else
sqlstr="insert into reg_info(name,pwd,sex,age,email,QQ)"
sqlstr=sqlstr & "values('"&name&"','"&pwd&"','"&sex&"','"&age&"','"&email&"','"&QQ&"')"
DataCon.Execute(sqlstr)
end if
response.write request.cookies("name")
response.write request.cookies("sex")
response.write request.cookies("age")
response.write request.cookies("email")
response.write request.cookies("QQ")
dataCon.close
%>