流产后发汗的最佳时间:asp会员登陆判断的问题

来源:百度文库 编辑:高考问答 时间:2024/04/29 13:40:21
我的数据表里一共有三个会员,我希望每个会员登陆时,返回不同的页面,详情如下:
ID 用户名(name) 密码(psw)
1 lx 123
2 nu 123
3 bd 123

我的目标是,用lx成功登陆后,返回百度网站,用nu登陆成功后,返回新浪网,我的源代码是只要是这个表里的用户,密码验证正确后,都返回同一个页面了。请那位高手帮忙指点修改一下。
我的源代码内容如下:

<%
name=request.form("name")
psw=request.form("psw")
if name="" or psw="" then
response.Write("<script language=javascript>alert('请填写完整!');history.go(-1)</script>")
end if
sql="SELECT * FROM company WHERE name='" & Replace(name,"'","''") & "' and psw='" & Replace(psw,"'","''") & "'"
set rs=conn.execute(sql)
if rs.eof or rs.bof then
response.write "<script language=javascript>"
response.write "alert('用户或密码不对!');"
response.write "javascript:history.go(-1);"
response.write "</script>"
else
session("name")=name
response.write"<SCRIPT language=JavaScript>alert('登陆成功');"
response.write"this.location.href='http://www.baidu.com';</SCRIPT>"
end if
%>

if session("name")=lx then
response.write"<SCRIPT language=JavaScript>alert('登陆成功');"
response.write"this.location.href='http://www.baidu.com';</SCRIPT>"
end if
if session("name")=nu then
response.write"<SCRIPT language=JavaScript>alert('登陆成功');"
response.write"this.location.href='http://www.cnvb.cn;</SCRIPT>"
end if
if session("name")=db then
response.write"<SCRIPT language=JavaScript>alert('登陆成功');"
response.write"this.location.href='http://www.sina.com';</SCRIPT>"
end if