首页 > 代码库 > 登录次数验证,可能还是有些不足的,希望大家指正
登录次数验证,可能还是有些不足的,希望大家指正
protected void BtnLogin_Click(object sender, EventArgs e) { string ConStr = ConfigurationManager.ConnectionStrings["ConStr"].ToString(); string GetNameSql = "SELECT [Title] FROM [dbo].[Info] WHERE [Title]=‘" + this.TxtName.Text+"‘"; string GetPwdSql = "SELECT [Details] FROM [dbo].[Info] WHERE [Details]=‘" + this.Txtpwd.Text + "‘"; string Name = string.Empty; string Pwd = string.Empty; using(SqlConnection conn=new SqlConnection(ConStr)) { conn.Open(); SqlCommand Pwdcomm = new SqlCommand(GetPwdSql, conn); Pwd = Convert.ToString(Pwdcomm.ExecuteScalar()); SqlCommand Namecomm = new SqlCommand(GetNameSql,conn); Name = Convert.ToString(Namecomm.ExecuteScalar()); if (Name == this.TxtName.Text && Pwd == this.Txtpwd.Text) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert(‘登陆成功!‘);</script>"); } else { Response.Write("<script>alert(‘登陆失败!‘);</script>"); //Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert(‘登陆失败!‘);</script>"); } if ((Name == this.TxtName.Text && Pwd != this.Txtpwd.Text) || (Name != this.TxtName.Text && Pwd == this.Txtpwd.Text)) { Session["count"] = Convert.ToInt32(Session["count"]) + 1; } if (Convert.ToInt32(Session["count"]) > 3) { string UpdateTime = "SELECT Datediff(minute, [LoginDate], GetDate()) FROM [Info] WHERE Title=‘" + this.TxtName.Text+"‘"; SqlCommand comm = new SqlCommand(UpdateTime,conn); string countMiuntes=(30-Convert.ToInt32(comm.ExecuteScalar())).ToString(); if (Convert.ToInt32(countMiuntes) > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert(‘登陆超过三次失败!距离解禁还有" + countMiuntes + "分钟‘);</script>"); } if (Convert.ToInt32(countMiuntes) <= 0) { string GetNowTime = "UPDATE [Info] SET [LoginDate]=‘" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "‘ WHERE Title=‘" + this.TxtName.Text + "‘"; SqlCommand commtime = new SqlCommand(GetNowTime, conn); if (commtime.ExecuteNonQuery() > 0) { Session.RemoveAll(); } } } } }
登录次数验证,可能还是有些不足的,希望大家指正
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。