asp登录提示FROM子句语法错误
来源:百度知道 编辑:UC知道 时间:2024/06/03 04:39:57
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("data/xinx.mdb")
uname = Request("uname")
mima = Request("mima")
if uname = "" then
Response.redirect("Error.asp?Err=用户名为空,请输入!")
Response.End
else
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM user WHERE username='"&uname&"'"
response.write sql
rs.open "SELECT * FROM user WHERE username='"&uname&"'",conn,1,1
if not rs.eof then
if mima=rs("password") then
session("uname")=uname
response.redirect("list.asp")
else
Response.redirect("Error.asp?Err=密码输入错误,请确认!")
end if
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("data/xinx.mdb")
uname = Request("uname")
mima = Request("mima")
if uname = "" then
Response.redirect("Error.asp?Err=用户名为空,请输入!")
Response.End
else
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM user WHERE username='"&uname&"'"
response.write sql
rs.open "SELECT * FROM user WHERE username='"&uname&"'",conn,1,1
if not rs.eof then
if mima=rs("password") then
session("uname")=uname
response.redirect("list.asp")
else
Response.redirect("Error.asp?Err=密码输入错误,请确认!")
end if
把SELECT * FROM user WHERE username='zhbllzh018'
改成SELECT * FROM user WHERE username='"&zhbllzh018&"' 再试试
因为user 在数据库中有特特殊的意思因此要这样写:
sql="SELECT * FROM [user] WHERE username='"&uname&"'"
rs.open sql,conn,1,1
删除下面两行:
sql="SELECT * FROM user WHERE username='"&uname&"'"
response.write sql
下面这层结构要修改:
if not rs.eof then
...
else
response.write "找不到用户"
end if
多了个单引号 本来应该是username=zhbllzh018,现在是username='zhbllzh018' ,改这句
sql="SELECT * FROM user WHERE username="&uname&""
你的代码写得好像很啰嗦!
不会写就直接找个别人写好的