winform程序的sql需要加密码？应如何加密！~

[liuwei19860906]

问题如上，敬请指点！~

[liuwei19860906]

我在网上找了 还有点DES 他们点过程相似，但应该有所不同，不同在哪里？

  #region DES加密解密
   /// <summary>
   /// DES加密
   /// </summary>
   /// <param name="Data">被加密的明文</param>
   /// <param name="Key">密钥</param>
   /// <param name="Vector">向量</param>
   /// <returns>密文</returns>
   public static Byte[] DESEncrypt(Byte[] Data, String Key, String Vector)
   {
    Byte[] bKey = new Byte[8];
    Array.Copy(Encoding.UTF8.GetBytes(Key.PadRight(bKey.Length)), bKey, bKey.Length);
    Byte[] bVector = new Byte[8];
    Array.Copy(Encoding.UTF8.GetBytes(Vector.PadRight(bVector.Length)), bVector, bVector.Length);

    Byte[] Cryptograph = null; // 加密后的密文

    DESCryptoServiceProvider EncryptProvider = new DESCryptoServiceProvider();
    EncryptProvider.Mode = CipherMode.CBC;
    EncryptProvider.Padding = PaddingMode.Zeros;

    try
    {
     // 开辟一块内存流
     using (MemoryStream Memory = new MemoryStream())
     {
      // 把内存流对象包装成加密流对象
      using (CryptoStream Encryptor = new CryptoStream(Memory,
      EncryptProvider.CreateEncryptor(bKey, bVector),
      CryptoStreamMode.Write))
      {
       // 明文数据写入加密流
       Encryptor.Write(Data, 0, Data.Length);
       Encryptor.FlushFinalBlock();

       Cryptograph = Memory.ToArray();
      }
     }
    }
    catch
    {
     Cryptograph = null;
    }

    return Cryptograph;
   }

   /// <summary>
   /// DES解密
   /// </summary>
   /// <param name="Data">被解密的密文</param>
   /// <param name="Key">密钥</param>
   /// <param name="Vector">向量</param>
   /// <returns>明文</returns>
   public static Byte[] DESDecrypt(Byte[] Data, String Key, String Vector)
   {
    Byte[] bKey = new Byte[8];
    Array.Copy(Encoding.UTF8.GetBytes(Key.PadRight(bKey.Length)), bKey, bKey.Length);
    Byte[] bVector = new Byte[8];
    Array.Copy(Encoding.UTF8.GetBytes(Vector.PadRight(bVector.Length)), bVector, bVector.Length);

    Byte[] Original = null;

    DESCryptoServiceProvider CryptoProvider = new DESCryptoServiceProvider();
    CryptoProvider.Mode = CipherMode.CBC;
    CryptoProvider.Padding = PaddingMode.Zeros;

    try
    {
     // 开辟一块内存流，存储密文
     using (MemoryStream Memory = new MemoryStream(Data))
     {
      // 把内存流对象包装成加密流对象
      using (CryptoStream Decryptor = new CryptoStream(Memory,
      CryptoProvider.CreateDecryptor(bKey, bVector),
      CryptoStreamMode.Read))
      {
       // 明文存储区
       using (MemoryStream OriginalMemory = new MemoryStream())
       {
        Byte[] Buffer = new Byte[1024];
        Int32 readBytes = 0;
        while ((readBytes = Decryptor.Read(Buffer, 0, Buffer.Length)) > 0)
        {
         OriginalMemory.Write(Buffer, 0, readBytes);
        }

        Original = OriginalMemory.ToArray();
       }
      }
     }
    }
    catch
    {
     Original = null;
    }

    return Original;
   }
   #endregion

   #region AES加密解密
   /// <summary>
   /// AES加密
   /// </summary>
   /// <param name="Data">被加密的明文</param>
   /// <param name="Key">密钥</param>
   /// <param name="Vector">向量</param>
   /// <returns>密文</returns>
   public static Byte[] AESEncrypt(Byte[] Data, String Key, String Vector)
   {
    Byte[] bKey = new Byte[32];
    Array.Copy(Encoding.UTF8.GetBytes(Key.PadRight(bKey.Length)), bKey, bKey.Length);
    Byte[] bVector = new Byte[16];
    Array.Copy(Encoding.UTF8.GetBytes(Vector.PadRight(bVector.Length)), bVector, bVector.Length);

    Byte[] Cryptograph = null; // 加密后的密文

    Rijndael Aes = Rijndael.Create();
    try
    {
     // 开辟一块内存流
     using (MemoryStream Memory = new MemoryStream())
     {
      // 把内存流对象包装成加密流对象
      using (CryptoStream Encryptor = new CryptoStream(Memory,
       Aes.CreateEncryptor(bKey, bVector),
       CryptoStreamMode.Write))
      {
       // 明文数据写入加密流
       Encryptor.Write(Data, 0, Data.Length);
       Encryptor.FlushFinalBlock();

       Cryptograph = Memory.ToArray();
      }
     }
    }
    catch
    {
     Cryptograph = null;
    }

    return Cryptograph;
   }

[liuwei19860906]

我以前没搞过加密。这个问题是不是很弱啊。。

[uvvvw]

用aes加密吧。网上现成代码。

[永生天地]

http://topic.csdn.net/u/20091221/22/DDA565B1-118E-453D-A1EF-D94F28ACAFA3.html

[jianuMan]

SQL 不是放在代码里面的吗？
干嘛需要加密？

我觉得sql 那个帐号 要弄得复杂点 否则会被攻破