login.asp

一路飞扬在线同学录单班级版,主要用于个人系统中的同学录,不过对于学习有帮助!

<!--#include file="inc/DB.INC" -->
<%
Function Sqlstr(data)
 	sqlstr=Replace(data,"'","''")
End Function
	userid=sqlstr(request.form("userid"))
	password=sqlstr(request.form("password"))
sql= "select userid,password from txluser where userid='"&userid&"' and password='"&password&"'"
set rs=conn.execute(sql)
if  rs.eof or  rs.bof then
%>
<script language="javascript">
alert("可能是你的同学ID或密码输入有误！！")
parent.location.href="index.asp"
</script>
<%else
mysql="select truename,logcnt,logtime from [txluser] where userid='"&userid&"'"
set rs=Server.CreateObject ("ADODB.RECORDSET")
rs.open mysql,conn,1,3
rs("logcnt")=rs("logcnt")+1
rs("logtime")=now
truename=rs("truename")
rs.update
set rs=nothing
set conn=nothing
response.cookies("myuserid")=userid
response.cookies("mypwd")=password
session("myuserid")=userid
session("mypwd")=request.form("password")
Application("onuser")=truename
response.redirect "index.asp"
end if
%>