chkuser.asp

电子商务网络购物系统

<!--#include file="conn.asp"-->
<!--#include file="func.asp"-->
<%dim username,password,comeurl
username=replace(trim(request("username")),"'","")
password=md5(replace(trim(request("password")),"'",""))
if trim(request("comeurl"))="" then
comeurl="index.asp"
else
comeurl=trim(request("comeurl"))
end if
if username="" or password="" then
response.Write "<center><a href=login.asp><font color=red size=2>对不起，登录失败，请检查您的登录名和密码</font></a></center>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [user] where username='"&username&"' and password='"&password&"' " ,conn,1,3
if not(rs.bof and rs.eof) then
if password=rs("password") then
response.Cookies("timesshop")("username")=trim(request("username"))
rs("lastvst")=now()
rs("loginnum")=rs("loginnum")+1
rs.Update
rs.Close
set rs=nothing
call loginok()
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
sub loginok()
response.Write "<font size=2>欢迎您 <font color=red size=2>"&request.Cookies("timesshop")("username")&"</font>，两秒种后将自动跳转到相应页！</font>"
response.redirect "profile.asp?action=profile"
end sub
%>