UC知道操作数据库的问题,急,在线等!!!!
来源：百度知道 编辑：UC知道 时间：2024/07/07 22:03:52
为什么我的输入帐号密码验证时只能用数据库第一个位置的帐号密码阿？高手帮我看一下，我很迷茫
---------------------------------------------------------------
<!--#include file="login_conn.asp" -->
<%
name=trim(request.Form("username"))
pass=trim(request.form("password"))
if name="" or pass="" then
response.write "<script language=javascript>alert('请输入帐号或密码');history.back(-1)</script>"
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from person"
rs.open sql,db,1,3
if name=rs("pp_id") and pass=rs("pp_pw") then
session("power")="yes"
response.redirect "operation.asp"
rs.close
set rs=nothing
else
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from admin"
rs2.open sql2,db,1,3
if name=rs2("zhanghao") and pas
---------------------------------------------------------------
<!--#include file="login_conn.asp" -->
<%
name=trim(request.Form("username"))
pass=trim(request.form("password"))
if name="" or pass="" then
response.write "<script language=javascript>alert('请输入帐号或密码');history.back(-1)</script>"
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from person"
rs.open sql,db,1,3
if name=rs("pp_id") and pass=rs("pp_pw") then
session("power")="yes"
response.redirect "operation.asp"
rs.close
set rs=nothing
else
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from admin"
rs2.open sql2,db,1,3
if name=rs2("zhanghao") and pas
<%
name=trim(request.Form("username"))
pass=trim(request.form("password"))
if name="" or pass="" then
response.write "<script language=javascript>alert('请输入帐号或密码');history.back(-1)</script>"
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from person Where pp_id='"&name&"' and pp_pw='"&pass&"'"
rs.open sql,db,1,3
If not rs.Eof then
session("power")="yes"
response.redirect "operation.asp"
rs.close
set rs=nothing
Else
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from admin Where zhanghao='"&name&"' and mima='"&pass&"'"
rs2.open sql2,db,1,3
if Not Rs2.Eof then
session("qysession")="yes"