Question

asp用户登录代码

哪位高手帮我看一下这段代码到底哪里出了错，就算我输入的是正确的用户名和密码都提示密码错误。谢谢！

<%
useer = request.Form("name")
psw = request.Form("password")

Set Conn=Server.CreateObject("ADODB.Connection")
strConn="Driver={SQL Server};Server=PC-2154622;Uid=sa;Pwd=;DataBase=student"
Conn.Open strConn

SqlStr = "select * from reger where name='"&useer&"'"
Set Rs = Conn.Execute(SqlStr)

if Rs.eof and Rs.bof then
response.write "<script>alert('不存在的用户名');history.back();</script>"
elseif Rs("password") <> psw then
response.write "<script>alert('密码错误');history.back();</script>"
elseif Rs("password")=psw and Rs("name")=useer then
response.write"<script>alert('登录成功');location.href='index.asp'</script>"
end if

%>

Answer 1

Conn.Open strConn
改成set rs = server.createobject("adodb.recordset")
sql = "select * from G_User where G_UserName='" & username & "'"
rs.open sql,conn,1,1

Answer 2

这个代码要自己申请的，然后每个人有自己的一个

Answer 3

看起来没错。，