casting怎么拍摄:高手帮忙!ASP中用户登陆代码纠错!

来源:百度文库 编辑:神马品牌网 时间:2024/04/27 10:18:19
user.asp:(登陆界面)

<form action="check.asp" method="post" name="form1" class="style1">
<div align="center">
<form name="form1" method="post" action="check.asp">
<div align="center"><img src="images/user.gif" width="36" height="27">登陆:
<input name="name" type="text" id="name">
密码:
<input name="psw" type="password" id="psw">
<input type="submit" name="Submit" value="登陆">
<a href="reg.asp">没有注册?</a></div>
</form>

check.asp:(登陆处理页面)
<!--#include file="conn.asp"-->
<%
dim name,psw,rs,sql,cn
name=request.form("name")
psw=request.form("psw")
if name="" or psw="" then
response.write"<script> window.alert('用户或密码不能为空!'); history.back();</script>"
else
set rs=server.createobject ("adodb.recordset")
sql="select * FROM user Where name='" & Request("name") & "' And psw='" & Request("psw") & "'"
set rs=cn.execute (sql)
If Not rs.Bof And Not rs.Eof Then
response.write "abc"
else
response.write "对不起,用户名或密码有误,请重新登录"
end if
end if
rs.close
set rs =nothing
%>

set rs=cn.execute (sql)
If Not rs.Bof And Not rs.Eof Then
这里执行的是execute方法,所以没有rs.bof and rs.eof的属性,
您可以使用 rs.open sql,conn,1,1方法来执行就正确了!

set rs=cn.execute (sql)
改成
rs.open sql,conn,1,1
可能的错误:
就是直接用request("name")会出问题.
sql="select * FROM user Where name='" & Request("name") & "' And psw='" & Request("psw") & "'"
改成
sql="select * FROM user Where name='" & Request.form("name") & "' And psw='" & Request.form("psw") & "'"