UC知道帮我看下这段代码啊!ASP JAVAscript
来源：百度知道 编辑：UC知道 时间：2024/07/03 02:53:04
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,user_name,xb,age,qq,email,homepage,address from user where user='"&request.form("user")&"'"
rs.open sql,conn,1,3
if rs.recordcount > 0 then
response.Write "<script language=javascript>"
response.Write "alert('此用户名已被没册');"
response.write "javascript:history.go(-1)"
response.write "</script>"
else
if request.form("user")="" or request.form("passowre") or request.form("password1")="" or request.form("user_name")="" then
response.Write "<script language=javascript>"
response.Write "alert('请认真填定完整');"
response.write "javascript:history.go(-1)"
response.write "<
<%
set rs=server.CreateObject("adodb.recordset")
sql="select user,password,user_name,xb,age,qq,email,homepage,address from user where user='"&request.form("user")&"'"
rs.open sql,conn,1,3
if rs.recordcount > 0 then
response.Write "<script language=javascript>"
response.Write "alert('此用户名已被没册');"
response.write "javascript:history.go(-1)"
response.write "</script>"
else
if request.form("user")="" or request.form("passowre") or request.form("password1")="" or request.form("user_name")="" then
response.Write "<script language=javascript>"
response.Write "alert('请认真填定完整');"
response.write "javascript:history.go(-1)"
response.write "<
if rs.recordcount > 0 then
改成
if not(rs.eof and rs.bof) then
试试。
if (request.form("user")<>"" then
sql="select user_name from user where user_name ='"&request.form("user")&"'"
.................
end if
数据库不用取出全部的列。user是你的表明而不是列名吧？
另外这似乎是VB脚本而不是java脚本
SQL语句2处错误
1. 你用user做表名而且又是直接用,这样不行的,因为user是SQL保留字,非要用你得加上 [] 号,如: [user]
2.where user='"&request.form("user")&"'" ,我想这里的 user 应该是user_name吧?
还有一个问题是,你只判断数据库用户名是否存在,何必把其它字段都取出来呢?
SQL语句改成如下:
sql="select user_name from [user] where user_name='"&request.form("user")&"'"