如何实现数据库连接字符串加密问题

 

如何实现数据库连接字符串加密问题

//这我也不记得是从哪个网络见过以下代码，在实现数据库连接字符串加密很实用。记下，以备查！

//SymmetricMethod.cs

using System;
using System.IO;
using System.Security.Cryptography;
using System.Text;
using System.Configuration;

namespace JC
{
 /// <summary>
 /// 对称加密算法类
 /// </summary>
 public class SymmetricMethod
 {
  private SymmetricAlgorithm mobjCryptoService;
  private string Key;
  /// <summary>
  /// 对称加密类的构造函数
  /// </summary>
  public SymmetricMethod()
  {
   mobjCryptoService = new RijndaelManaged();
   Key = "jcsmkjGuz(%&hj7x89H$yuBI0456FtmaT5&fvHUFCy76*h%(HilJ$lhj!y6&(*jkP87jH7";
  }
  /// <summary>
  /// 获得密钥
  /// </summary>
  /// <returns>密钥</returns>
  private byte[] GetLegalKey()
  {
   string sTemp = Key;
   mobjCryptoService.GenerateKey();
   byte[] bytTemp = mobjCryptoService.Key;
   int KeyLength = bytTemp.Length;
   if (sTemp.Length > KeyLength)
    sTemp = sTemp.Substring(0， KeyLength);
   else if (sTemp.Length < KeyLength)
    sTemp = sTemp.PadRight(KeyLength， ’ ’);
   return ASCIIEncoding.ASCII.GetBytes(sTemp);
  }
  /// <summary>
  /// 获得初始向量IV
  /// </summary>
  /// <returns>初试向量IV</returns>
  private byte[] GetLegalIV()
  {
   string sTemp = "jcsmkjE4ghj*Ghg7!rNIfb&95GUY86GfghUb#er57HBh(u%g6HJ($jhWk7&!hg4ui%$hjk";
   mobjCryptoService.GenerateIV();
   byte[] bytTemp = mobjCryptoService.IV;
   int IVLength = bytTemp.Length;
   if (sTemp.Length > IVLength)
    sTemp = sTemp.Substring(0， IVLength);
   else if (sTemp.Length < IVLength)
    sTemp = sTemp.PadRight(IVLength， ’ ’);
   return ASCIIEncoding.ASCII.GetBytes(sTemp);
  }
  /// <summary>
  /// 加密方法
  /// </summary>
  /// <param name="Source">待加密的串</param>
  /// <returns>经过加密的串</returns>
  public string Encrypto(string Source)
  {
   byte[] bytIn = UTF8Encoding.UTF8.GetBytes(Source);
   MemoryStream ms = new MemoryStream();
   mobjCryptoService.Key = GetLegalKey();
   mobjCryptoService.IV = GetLegalIV();
   ICryptoTransform encrypto = mobjCryptoService.CreateEncryptor();
   CryptoStream cs = new CryptoStream(ms， encrypto， CryptoStreamMode.Write);
   cs.Write(bytIn， 0， bytIn.Length);
   cs.FlushFinalBlock();
   ms.Close();
   byte[] bytOut = ms.ToArray();
   return Convert.ToBase64String(bytOut);
  }
  /// <summary>
  /// 解密方法
  /// </summary>
  /// <param name="Source">待解密的串</param>
  /// <returns>经过解密的串</returns>
  public string Decrypto(string Source)
  {
   byte[] bytIn = Convert.FromBase64String(Source);
   MemoryStream ms = new MemoryStream(bytIn， 0， bytIn.Length);
   mobjCryptoService.Key = GetLegalKey();
   mobjCryptoService.IV = GetLegalIV();
   ICryptoTransform encrypto = mobjCryptoService.CreateDecryptor();
   CryptoStream cs = new CryptoStream(ms， encrypto， CryptoStreamMode.Read);
   StreamReader sr = new StreamReader(cs);
   return sr.ReadToEnd();
  }
  public string SqlConnectionstring()
  {
   //Read the configuration Keys and return connectionstring.
   string dataservername=ConfigurationSettings.AppSettings["data source"];
   string databasename=ConfigurationSettings.AppSettings["initial catalog"];
   string userid=ConfigurationSettings.AppSettings["user id"];
   string password=ConfigurationSettings.AppSettings["password"];
   string integratedsecurity=ConfigurationSettings.AppSettings["integrated security"];
   string persistsecurityinfo=ConfigurationSettings.AppSettings["persist security info"];
   string connectionString;
   connectionString =  "data source="+dataservername;
   connectionString += ";initial catalog="+databasename;
   connectionString += ";persist security info="+persistsecurityinfo;
   connectionString += ";user id=" + Decrypto(userid);
   connectionString += ";password=" + Decrypto(password);
   
   return connectionString;
  }

}

}

 

 

//app.config

 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
  <!--   此处显示用户应用程序和配置的属性设置。-->
  <!--   示例：<add key="settingName" value="settingValue"/> -->
  <add key="data source" value="Tony"/>
  <add key="initial catalog" value="jc"/>
  <add key="packet size" value="4096"/>
  <add key="user id" value="UA334GYXDRt1e2cD34FfrUp5aeg=="/>
  <add key="password" value="TPrBKz3211234kZRPhOostXyjR3gg=="/>
  <!--add key="user id" value="UAGYXDRt1e2cDFfrUp5aeg=="/-->
  <!--add key="password" value="TPrBKzkZRPhOostXyjR3gg=="/-->
 </appSettings>
</configuration>