恩威道源商城怎么做呢:一个ASP问题,会的帮忙

来源:百度文库 编辑:高校问答 时间:2024/03/28 23:56:26
大家帮我看看,怎么才能实现验证要注册的用户名是否被用过了。
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>add</title>
</head>
<body>
<%
if request.Form("name")="" then
response.Redirect"zhuce.asp"
end if
dim name,psw,shuoming
name=request.Form("name")
psw=request.Form("psw")
shuoming=request.Form("shuoming")
set conn=Server.CreateObject("ADODB.connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("user.mdb")
Set rs = Server.CreateObject("ADODB.RecordSet")
sqq="select * from user "
rs.open sqq,conn
if rs.eof then
sql="insert into user(name,psw,shuoming) values('"&name&"','"&psw&"','"&shuoming&"')"
conn.execute sql
set conn=nothing
Response.Write"欢迎加入我们班级"
else
Response.Write"该用户名已经被占用换一个吧"
response.end
end if
%>
</body>
</html>
楼下的可以把引号写清点吗?是几个引号啊,是单的还是双的啊

sqq="select * from user "

改为

sqq="select * from user where name = '"&name&"'"