查询数据库之前把密码md5加密
我在登录的时候在判断密码正确之前先把客户端输入的密码md5加密怎么写?
这是我的登录代码 string sql = "select * from bg_user where username='" + user_name + "'and password='" + password + "'";
try
{
cmd = new MySqlCommand(sql, conn);
conn.Open();
MySqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
return true;
}
else
{
return false;
}
}
我在登录的时候在判断密码正确之前先把客户端输入的密码md5加密怎么写?
这是我的登录代码 string sql = "select * from bg_user where username='" + user_name + "'and password='" + password + "'";
try
{
cmd = new MySqlCommand(sql, conn);
conn.Open();
MySqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
return true;
}
else
{
return false;
}
}
/// MD5加密
/// </summary>
/// <param name="encryptText"></param>
/// <returns></returns>
public static string EncryptMD5(string encryptText)
{
MD5 md5 = new MD5CryptoServiceProvider();
byte[] encryptBuf = Encoding.ASCII.GetBytes(encryptText);
encryptBuf = md5.ComputeHash(encryptBuf);
return Convert.ToBase64String(encryptBuf);
}
{
byte[] result = Encoding.Default.GetBytes(str.Trim());
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
return BitConverter.ToString(output).Replace("-", ""); }
string user_name = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox1.Text, "MD5"); //TextBox1.Text为密码框的值
string sql = "select * from bg_user where username='" + user_name + "'and password='" + password + "'";
string sql = "select * from bg_user where username='" + user_name + "'and password='" + MD5(password) + "'";
string password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox1.Text.ToString().Replace(" ", ""), "MD5").ToString();//密码加密