判断登陆的帐号与密码是否在数据库中有记录
<DIV class=lh3 id=veryContent style="OVERFLOW: hidden; WIDTH: 100%"><TABLE class=contentTable id=blogContentTable cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD style="FONT-SIZE: 12px; WORD-WRAP: break-word" vAlign=top>
<DIV id=blogContainer><IMG id=paperPicArea0 style="DISPLAY: none" src="http://imgcache.qq.com/ac/qzone_v4/b.gif">
<DIV id=paperTitleArea style="DISPLAY: none" align=center><SPAN id=paperTitle style="DISPLAY: block; FONT-WEIGHT: bolder; WORD-BREAK: break-all"><FONT face="" color=#000e04>[顶]判断登陆的帐号与密码是否在数据库中有记录</FONT></SPAN></DIV><IMG id=paperPicArea style="DISPLAY: none" src="http://imgcache.qq.com/ac/qzone_v4/b.gif"><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR> <BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000></FONT><WBR><BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000><B><WBR><% <BR> 'Pass是密码 admname帐号 注意上页的文本框一定要取这两个名字要不然总提示密码错误或帐号错误 <BR> AdmName=Request.Form("Name") '获取上页文本框的帐号直 <BR> Pass=Request.Form("Pass") '获取上页文本框的密码直 <BR> Set Rs=Server.GreateObject("ADODB,RecordSet") <BR> SqlStr="Select*from Admin where name='"&AdmName&"' and pass='"&AdmPass&"'" <BR> Rs.Open SqlStr,conn,1,3 '建立数据库对象 然后查询 帐号 与密码 在数据库中是否有 <BR> if RS.EOF AND RS.BOF then '如果没有 那么 跳转到 登陆那页 <BR> Response.Redirect("login.asp") <BR> response.end <BR> else '否则 <BR> session("admin")=rs("admin") '登陆进来的帐号付给 session 缓存 <BR> Response.Redirect("admin.asp") '进入真正的管理员后台 <BR> response.end '结束</B><WBR></FONT><WBR> <BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000><B><WBR> end if '结束</B><WBR></FONT><WBR> <BR><FONT style="FONT-SIZE: small; LINE-HEIGHT: 1.3em" color=#ff0000><B><WBR><BR>%></B></FONT></DIV></TD></TR></TBODY></TABLE></DIV>
页:
[1]