Partial Class Login
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 Boolean = Me.Login1.RememberMeSet '获取记住我
Using con As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(Dao.ConnectionString)
Using com As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand("select count(*) from t_user where username = @username and userpass = @userpass", con)
com.Parameters.AddWithValue("username", username) '预处理
com.Parameters.AddWithValue("userpass", userpass)
con.Open()
Dim o As Object = com.ExecuteScalar() '查询第一行第一列
If o < 1 Then
Return
End If
End Using
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("~/Default.aspx") '登录成功跳转
End Sub
End Class
file:///E:\WebSite\Login.aspx.vb还是别用单例模式了
最新推荐文章于 2023-07-02 15:49:42 发布