Partial Class _Default
Inherits System.Web.UI.Page
Private Function login(ByVal username As String, ByVal userpass As String) As Boolean '登陆检查
Dim b As Boolean = False
Dao.sds.SelectCommand = "select count(*) from t_user where username = ? and userpass = ?"
Dao.sds.SelectParameters.Clear()
Dao.sds.SelectParameters.Add(1, username)
Dao.sds.SelectParameters.Add(2, userpass)
If Dao.sds.Select(DataSourceSelectArguments.Empty)(0)(0) Then '如果count(*)查询出来是非0的数字就
b = True
End If
Return b
End Function
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Request.Cookies("username") IsNot Nothing And Request.Cookies("userpass") IsNot Nothing Then '如果cookie不为空就...
Dim username As String = Request.Cookies("username").Value '就取出cookie里面的数据,然后...
Dim userpass As String = Request.Cookies("userpass").Value
If Me.login(username, userpass) Then '然后就到login里面去验证一下,如果是真就...
Response.Redirect("~/Index.aspx") '就直接跳转到Index页面
End If
End If
End Sub
Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
Dim username As String = Me.Login1.UserName
Dim userpass As String = Me.Login1.Password
If Me.login(username, userpass) Then
Response.Cookies("username").Value = username '登录成功写入cookie
Response.Cookies("userpass").Value = userpass
If Me.Login1.RememberMeSet Then
Response.Cookies("username").Expires = DateTime.Now.AddDays(7) '设置cookie超时时间为7天
Response.Cookies("userpass").Expires = DateTime.Now.AddDays(7)
End If
Response.Redirect("~/Index.aspx") '登录成功跳转
End If
End Sub
End Class