zccheck.asp

这是一个网上购物物网站,数据库的连接在CONN.ASP中,既有前台网站,也有后台管理

<!--#include file="conn.asp"-->
<%

    set rs=server.createobject("adodb.recordset")
	rs.open "select * from guser where username="&request("username"),conn,1,1
	if rs.eof then
	set rs1=server.createobject("adodb.recordset")
	rs1.open"select * from guser where usrname",conn,3,2
	
	
	rs1.addnew	
    rs1("username")=request.Form("username")
    rs1("password")=request.Form("password")
	rs1("password2")=request.Form("password2")
	rs1("truename")=request.Form("truename")
	rs1("sex")=request.Form("sex")
    rs1("sfz")=request.Form("sfz")
	rs1("email")=request.Form("email")
	rs1("telphone")=request.Form("telphone")
	rs1("question")=request.Form("question")
	rs1("reply")=request.Form("reply")
	rs1("address")=request.form("address")
	rs1("addtime")=now()
	rs1s.update
	Response.Write("<script>alert('添加成功！');window.location='goods_add.asp';</script>")
response.write"<SCRIPT language=JavaScript>alert('恭喜你注册成功！,请登录！');"
response.write"</SCRIPT>" 
response.Redirect("login.asp")
response.end 
else
response.write"<SCRIPT language=JavaScript>alert('对不起用户名已经存在！,请返回！');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end 
 end if %>