帮帮忙!ASP多用户登陆!

来源:百度知道 编辑:UC知道 时间:2024/05/27 19:48:40
源代码是:
<%session("user")=""
session("pwd")=""
if request("exit")="ok" then
response.redirect "index.asp"
end if%>
<%
user=trim(request.form("user"))
pwd=trim(request.form("pwd"))%>
<%if user<>"" and pwd<>"" then%>
<!--#include file="conn.asp"-->
<%
set rsadm=server.createobject("adodb.recordset")
sqladm="select * from admin"
rsadm.open sqladm,conn,1,1
if not rsadm.eof and then
if rsadm("user")="" then
response.write("<script>alert('用户名不对!');history.go(-1)</script>")
end if
if pwd=rsadm("pwd") then
session("user")=rsadm("user")
session("pwd")=rsadm("pwd")
response.redirect "index.as

缺少寻找.

from admin where UserName='"&user&"'"

没有错。是你数据库结构有问题!

<%session("user")=""
session("pwd")=""
if request("exit")="ok" then
response.redirect "index.asp"
response.end
end if%>
<%
user=trim(request.form("user"))
pwd=trim(request.form("pwd"))%>
<%if user<>"" and pwd<>"" then%>
<!--#include file="conn.asp"-->
<%
set rsadm=server.createobject("adodb.recordset")
sqladm="select * from admin where 用户名字段名='"&user&"'"
rsadm.open sqladm,conn,1,1
if rsadm.eof then
response.write("<script>alert('用户名不对!');history.go(-1)</script>")
response.end
Else
if pwd=rsadm("pwd") then
session("user"