我的代码如下,填写注册信息不完全时,会提示“请填写完整”并返回注册页,但数据仍然会进入数据库

来源:百度知道 编辑:UC知道 时间:2024/06/15 15:33:27
<!--#include file="conn.asp" -->
<%

uname=request.form("uname")
psd=request.form("psd")
psd2=request.form("psd2")
un=request.form("un")
xb=request.form("xb")
sr=request.form("sr")
tel=request.form("tel")
qq=request.form("qq")
dz=request.form("dz")
email=request.form("email")
zy=request.form("zy")
zzmm=request.form("zzmm")
hjdz=request.form("hjdz")
mz=request.form("mz")
xl=request.form("xl")
xx=request.form("xx")

exec="select * from user where uname='"&uname&"'"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open exec,conn,1,1

if psd2<>psd then
Response.Write(" <script> alert('两次密码不相同!');javascript:history.go(-1);

if psd2<>psd then
Response.Write(" <script> alert('两次密码不相同!');javascript:history.go(-1); </script> ")
Response.end
end if
if uname="" or psd=""or un="" or sr=""or tel=""or zy="" or qq="" or mz="" or email="" or dz="" or hjdz="" then
Response.Write(" <script> alert('请填写完整!'); javascript:history.go(-1); </script> ")
Response.end
else
exec="insert into user(uname,psd,un,xb,sr,tel,qq,dz,email,zy,zzmm,hjdz,mz,xl,xx)values('"+uname+"','"+psd+"','"+un+"','"+xb+"','"+sr+"','"+tel+"','"+qq+"','"+dz+"','"+email+"','"+zy+"','"+zzmm+"','"+hjdz+"','"+mz