Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Request.Cookies("username") Is Nothing Or Request.Cookies("userpass") Is Nothing Then '没有就不执行
Return
End If
Dim username As String = Request.Cookies("username").Value '有就获取
Dim userpass As String = Request.Cookies("userpass").Value
Using sds As SqlDataSource = New SqlDataSource("System.Data.Odbc", "Dsn=mydata", "select count(*) from t_user where username = ? and userpass = ?") '然后判断是否可以登陆
sds.SelectParameters.Add(1, username)
sds.SelectParameters.Add(2, userpass)
Dim dv As System.Data.DataView = sds.Select(DataSourceSelectArguments.Empty)
If dv(0)(0) = 0 Then
Return
End If
End Using
Response.Redirect("~/Index.aspx")
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
Dim b As Boolean = Me.Login1.RememberMeSet
Using sds As SqlDataSource = New SqlDataSource("System.Data.Odbc", "Dsn=mydata", "select count(*) from t_user where username = ? and userpass = ?")
sds.SelectParameters.Add(1, username)
sds.SelectParameters.Add(2, userpass)
Dim dv As System.Data.DataView = sds.Select(DataSourceSelectArguments.Empty)
If dv(0)(0) = 0 Then
Return
End If
End Using
Response.Cookies("username").Value = username '登录成功写入cookie
Response.Cookies("userpass").Value = userpass
If b 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 Sub
End Class
http://localhost:49330/WebSite/Default.aspx.vb带可以验证cookie的自动登陆
最新推荐文章于 2024-02-11 11:00:40 发布