<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936" %> <% if(Request.ServerVariables("REQUEST_METHOD")=="POST") { //定义变量 var strUserName,strPassword,sql; var dNowDate,dStartTime,dEndTime,strNowDate; var strYear, strMonth, strDate; var strUserID, strUserLevel; //获取当前时间 dNowDate = new Date(); strNowDate = formatNomalDate(dNowDate); dNowDate = formatDate(dNowDate); //获取提交的数据 strUserName = Request.Form("username").item; strPassword = Request.Form("password").item; //判断参数是否有效 if(strUserName=="" || strUserName ==null) { %> <% } if(strPassword=="" || strPassword ==null) { %> <% } conn.Open (ConnStr); sql="SELECT UserID, Password, UserLevel, StartTime, EndTime FROM Login WHERE UserName='"+strUserName+"'"; rs = conn.Execute(sql); if(rs.Eof) { rs.Close(); %> <% }else { if(strPassword==rs("Password")) //密码匹配 { //时间有效性 dStartTime = formatDate(new Date(rs.fields("StartTime").value)); dEndTime = formatDate(new Date(rs.fields("EndTime").value)); strUserID = rs.fields("UserID").value; strUserLevel = rs.fields("UserLevel").value; rs.Close(); if( dNowDate >= dStartTime && dNowDate <= dEndTime ) { Session("UserName") = strUserName; Session("UserID") = strUserID; Session("UserLevel") = strUserLevel; Session("StartTime") = dStartTime; Session("EndTime") = dEndTime; sql="UPDATE Login SET LastLogDate = '"+ strNowDate +"' WHERE UserName = '"+ strUserName +"' "; conn.Execute(sql); }else { Session("UserName") = null; Session("StartTime") = null; Session("EndTime") = null; Session("UserID") = null; Session("UserLevel") = null; %> <% } } else { Session("UserName") = null; Session("StartTime") = null; Session("EndTime") = null; Session("UserID") = null; Session("UserLevel") = null; %> <% } } conn.Close(); } %>

网站首页

<% if ( Session("UserName") == "" || Session("UserName") == null || Session("UserLevel") == null ) { %>

用户名： 密码：

<% }else { %>

您的用户名：<%=Session("UserName")%> 有效期：<%=Session("StartTime")%> 至 <%=Session("EndTime")%> <% //处理不同级别用户显示 var strLevel,strList; strLevel = Session("UserLevel"); switch(strLevel) { case 1: strList = "小学生楷书课堂一 "; strList += "小学生楷书课堂二 "; strList += "小学生楷书课堂三 "; strList += "小学生楷书课堂四 "; strList += "小学生楷书课堂五 "; strList += "小学生楷书课堂六"; break; case 2: strList = "中学生、大学生、成年人行书课堂一 "; strList += "中学生、大学生、成年人行书课堂二 "; strList += "中学生、大学生、成年人行书课堂三 "; strList += "中学生、大学生、成年人行书课堂四 "; strList += "中学生、大学生、成年人行书课堂五 "; strList += "中学生、大学生、成年人行书课堂六"; break; case 0: strList = "小学生楷书课堂一 "; strList += "小学生楷书课堂二 "; strList += "小学生楷书课堂三 "; strList += "小学生楷书课堂四 "; strList += "小学生楷书课堂五 "; strList += "小学生楷书课堂六 "; strList += "中学生、大学生、成年人行书课堂一 "; strList += "中学生、大学生、成年人行书课堂二 "; strList += "中学生、大学生、成年人行书课堂三 "; strList += "中学生、大学生、成年人行书课堂四 "; strList += "中学生、大学生、成年人行书课堂五 "; strList += "中学生、大学生、成年人行书课堂六"; break; default: strList = "小学生楷书课堂 "; strList += "中学生、大学生、成年人行书课堂"; break; } %> <%=strList %>

<% } %>