徐州出租车资格证试题:asp的问题请看一下,这俩个写记录的怎么都不行呢?

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/30 00:37:31
——————————————————————————————
<!--#include file="conn.asp" -->
<%
username=request("username")
psd=request("psd")
sex=request("sex")
age=request("age")
qq=request("qq")
email=request("email")
adr=request("adr")
%>
<%
sql="select * from [user] where username="&username
'sql="select * from user where user='"&user&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof then
rs.addnew
rs("username")=username
rs("psd")=psd
rs("sex")=sex
rs("age")=age
rs("qq")=qq
rs("email")=email
rs("adr")=adr
rs.update
response.Write("<script language=javascript>")
response.Write("alert('注册成功,请登陆!');")
response.Write("window.location('index.asp');")
response.Write("</script>")
else
response.Write("<script language=javascript>")
response.Write("alert('该用户名已经被注册!');")
response.Write("window.history.go(-1);")
response.Write("</script>")
end if
%>
————————————————————————
<!--#include file="conn.asp" -->
<%
username=request("username")
psd=request("psd")
sex=request("sex")
age=request("age")
qq=request("qq")
email=request("email")
adr=request("adr")
%>
<%
sql="select * from [user] where [username]="&username
set rs=conn.execute("sql")
if rs.eof then
slq="insert into [user] (username,psd,sex,age,qq,email,adr) values('"&username&"','"&psd&"','"&sex&"','"&age&"','"&qq&"','"&email&"','"&adr&"')"
set rs=conn.execute(sql)
response.Write("<script language=javascript>")
response.Write("alert('注册成功,请登陆!');")
response.Write("window.location('index.asp');")
response.Write("</script>")
else
response.Write("<script language=javascript>")
response.Write("alert('该用户名已经被注册!');")
response.Write("window.history.go(-1);")
response.Write("</script>")
end if
%>

sql="select * from user where username='"&username&"'"