UC知道谁能帮我看下啊，ASP JAVAscript
来源：百度知道 编辑：UC知道 时间：2024/06/25 04:16:02
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,username,qq,email,address,age,homepage,tel from main"
rs.open sql,conn,1,3
set rs1=server.CreateObject("adodb.recordset")
sql1="select user from main"
rs1.open sql,conn,1,1
if request.Form("user")=rs1("user") then
response.Write "<script language=javascript>"
response.Write "alert('此用户名已被注册!');"
response.Write "javascript:history.go(-1)"
response.Write "</script>"
end if
if request.Form("user")="" or request.Form("password")="" or request.Form("password1")="" or request.Form("username")="" then
response.Write
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,username,qq,email,address,age,homepage,tel from main"
rs.open sql,conn,1,3
set rs1=server.CreateObject("adodb.recordset")
sql1="select user from main"
rs1.open sql,conn,1,1
if request.Form("user")=rs1("user") then
response.Write "<script language=javascript>"
response.Write "alert('此用户名已被注册!');"
response.Write "javascript:history.go(-1)"
response.Write "</script>"
end if
if request.Form("user")="" or request.Form("password")="" or request.Form("password1")="" or request.Form("username")="" then
response.Write
这是你的代码
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,username,qq,email,address,age,homepage,tel from main"
rs.open sql,conn,1,3
set rs1=server.CreateObject("adodb.recordset") ,这里没必要再建一个对象，直接用上面的就行了浪费资源
sql1="select user from main"
rs1.open sql,conn,1,1
if request.Form("user")=rs1("user") then
response.Write "<script language=javascript>"
response.Write "alert('此用户名已被注册!');"
response.Write "javascript:history.go(-1)"
response.Write "</script>"
end if
。。。。。。。。。。。。
下面是我修改的你看一下：
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,username,qq,email,address,age,homepage,tel from main where user='"&request.form("user")&"'"
rs.open sql,conn,1,3 '在这里就直接用条件查询
if rs.recordcount