file:///D:\WebSite\Default.aspx.vb单例模式

最新推荐文章于 2022-01-29 11:31:29 发布

「已注销」

最新推荐文章于 2022-01-29 11:31:29 发布

阅读量246

点赞数

本文链接：https://blog.csdn.net/eds124/article/details/86651046

版权


Partial Class _Default
    Inherits System.Web.UI.Page

    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 String = Me.Login1.RememberMeSet

        Dao.com.CommandText = "select count(*) from t_user where username = ?username and userpass = ?userpass"
        Dao.com.Connection = Dao.con
        Dao.com.Parameters.Clear()
        Dao.com.Parameters.AddWithValue("username", username) '预处理
        Dao.com.Parameters.AddWithValue("userpass", userpass)

        If Dao.con.State = Data.ConnectionState.Closed Then
            Dao.con.Open()
        End If
        Dim o As Object = Dao.com.ExecuteScalar() '查询第一行第一列
        If o = 0 Then
            Return
        End If

        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