chkadmin.asp

ASP+ACCESS 产品报价系统 开发环境简单 主要是周杰伦FANs的交互活动

<!--#include file="conn1.asp"-->
<!--#include file="md5.asp"-->
<%dim admin,password,verifycode
admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
verifycode=replace(trim(request("verifycode")),"'","")
if admin="" or password="" then
response.Write "<script LANGUAGE='javascript'>alert('您的管理ID或密码有误！');history.go(-1);</script>"
response.end
end if
if cstr(session("getcode"))<>cstr(trim(request("verifycode"))) then
response.Write "<script LANGUAGE='javascript'>alert('请输入正确的验证码！');history.go(-1);</script>"
response.end
end if

set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [user] where username='"&admin&"' and userpassword='"&password&"' " ,conn,1,3
if not(rs.bof and rs.eof) then
if password=rs("userpassword") then
session("admin")=trim(rs("username"))
session("name")=trim(rs("userzhenshiname"))
Session("userid")=rs("userid")
session("flag")=int(rs("flag"))
session("reglx")=int(rs("reglx"))
session("userdept")=trim(rs("userdept"))
session.Timeout=20
rs("lastlogin")=now()
rs("logins")=rs("logins")+1
rs.Update
rs.Close
set rs=nothing
response.Redirect "Admin_lyb.asp"
else
response.write "<script LANGUAGE='javascript'>alert('对不起，登陆失败！你的帐号或者密码有误');history.go(-1);</script>"
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起，登陆失败！你的帐号或者密码有误');history.go(-1);</script>"
end if
%>