当前位置: 代码迷 >> ASP.NET >> 用户登录的验证,对你们来说太初级了!解决方案
  详细解决方案

用户登录的验证,对你们来说太初级了!解决方案

热度:6782   发布时间:2013-02-25 00:00:00.0
用户登录的验证,对你们来说太初级了!
请查找错误。
  protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  {
  string UserName = Request.Form["UserName"];
  string Password = Request.Form["Password"];
  //ACCESS数据库的连接字符串
  string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source="+Server.MapPath(".\\DataBase\\#wulong.mdb");
  //生成一个新的连接
  OleDbConnection myConn = new OleDbConnection(strConn);
  myConn.Open();
  string sql = "select * from users where username=@UserName and Password=@Password";
  OleDbCommand myComm = new OleDbCommand(sql, myConn);
  OleDbDataReader dr = myComm.ExecuteReader();
  if(dr.HasRows){
  Response.Write("成功");
  }else{
  Response.Write("失败");
  }

  }

------解决方案--------------------------------------------------------
string sql = "select * from users where username=@UserName and Password=@Password"; 
存在安全问题
------解决方案--------------------------------------------------------
你抱啥错误?
------解决方案--------------------------------------------------------
string sql = "select * from users where username='"+UserName+"' and Password='"+Password+"'"; 
  相关解决方案