• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号
登陆 注册

用DES加密数据库信息,增强Asp.net的安全性(2)--实现源码

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using System.Text;
using System.Xml;
using System.Security.Cryptography;

namespace writeconfig
{
 /// <summary>
 /// Form1 的摘要说明。
 /// </summary>
 public class frmMain : System.Windows.Forms.Form
 {
  private System.Windows.Forms.Label labserver;
  private System.Windows.Forms.Label labdatabase;
  private System.Windows.Forms.Label labuser;
  private System.Windows.Forms.Label labpassword;
  private System.Windows.Forms.TextBox txtserver;
  private System.Windows.Forms.TextBox txtdatabase;
  private System.Windows.Forms.TextBox txtuser;
  private System.Windows.Forms.TextBox txtpassword;
  private System.Windows.Forms.Button btnRead;
  private System.Windows.Forms.Label label1;
  private System.Windows.Forms.TextBox txtfile;
  private System.Windows.Forms.Button btnWrite;
  private System.Windows.Forms.Button btnLook;
  private System.Windows.Forms.OpenFileDialog ofd;
  private System.Windows.Forms.Label labkey;
  private System.Windows.Forms.TextBox txtkey;
  private FileInfo fi;
  private bool Find;
  private string password="";
  protected string keypassword="";
  private System.Windows.Forms.Button btnDeleteNode;
  
  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;

  public frmMain()
  {
   //
   // Windows 窗体设计器支持所必需的
   //
   InitializeComponent();
   int[] tmp=new int[8]{23,234,195,165,201,240,143,198};
   foreach(int i in tmp)
   {
    keypassword+=((char)i).ToString();
   }
  }

  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }

  #region Windows 窗体设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmMain));
   this.labserver = new System.Windows.Forms.Label();
   this.labdatabase = new System.Windows.Forms.Label();
   this.labuser = new System.Windows.Forms.Label();
   this.labpassword = new System.Windows.Forms.Label();
   this.txtserver = new System.Windows.Forms.TextBox();
   this.txtdatabase = new System.Windows.Forms.TextBox();
   this.txtuser = new System.Windows.Forms.TextBox();
   this.txtpassword = new System.Windows.Forms.TextBox();
   this.btnRead = new System.Windows.Forms.Button();
   this.btnWrite = new System.Windows.Forms.Button();
   this.txtfile = new System.Windows.Forms.TextBox();
   this.label1 = new System.Windows.Forms.Label();
   this.btnLook = new System.Windows.Forms.Button();
   this.ofd = new System.Windows.Forms.OpenFileDialog();
   this.labkey = new System.Windows.Forms.Label();
   this.txtkey = new System.Windows.Forms.TextBox();
   this.btnDeleteNode = new System.Windows.Forms.Button();
   this.SuspendLayout();
   //
   // labserver
   //
   this.labserver.Location = new System.Drawing.Point(21, 57);
   this.labserver.Name = "labserver";
   this.labserver.Size = new System.Drawing.Size(87, 14);
   this.labserver.TabIndex = 0;
   this.labserver.Text = "服务器：";
   //
   // labdatabase
   //
   this.labdatabase.Location = new System.Drawing.Point(21, 93);
   this.labdatabase.Name = "labdatabase";
   this.labdatabase.Size = new System.Drawing.Size(87, 14);
   this.labdatabase.TabIndex = 1;
   this.labdatabase.Text = "数据源：";
   //
   // labuser
   //
   this.labuser.Location = new System.Drawing.Point(21, 129);
   this.labuser.Name = "labuser";
   this.labuser.Size = new System.Drawing.Size(87, 14);
   this.labuser.TabIndex = 2;
   this.labuser.Text = "用户名：";
   //
   // labpassword
   //
   this.labpassword.Location = new System.Drawing.Point(21, 165);
   this.labpassword.Name = "labpassword";
   this.labpassword.Size = new System.Drawing.Size(87, 14);
   this.labpassword.TabIndex = 3;
   this.labpassword.Text = "密  码：";
   //
   // txtserver
   //
   this.txtserver.Location = new System.Drawing.Point(117, 50);
   this.txtserver.Name = "txtserver";
   this.txtserver.Size = new System.Drawing.Size(187, 25);
   this.txtserver.TabIndex = 4;
   this.txtserver.Text = "";
   //
   // txtdatabase
   //
   this.txtdatabase.Location = new System.Drawing.Point(117, 86);
   this.txtdatabase.Name = "txtdatabase";
   this.txtdatabase.Size = new System.Drawing.Size(187, 25);
   this.txtdatabase.TabIndex = 4;
   this.txtdatabase.Text = "";
   //
   // txtuser
   //
   this.txtuser.Location = new System.Drawing.Point(117, 122);
   this.txtuser.Name = "txtuser";
   this.txtuser.Size = new System.Drawing.Size(187, 25);
   this.txtuser.TabIndex = 4;
   this.txtuser.Text = "";
   //
   // txtpassword
   //
   this.txtpassword.Location = new System.Drawing.Point(117, 158);
   this.txtpassword.Name = "txtpassword";
   this.txtpassword.PasswordChar = '*';
   this.txtpassword.Size = new System.Drawing.Size(187, 25);
   this.txtpassword.TabIndex = 4;
   this.txtpassword.Text = "";
   this.txtpassword.TextChanged += new System.EventHandler(this.txtpassword_TextChanged);
   //
   // btnRead
   //
   this.btnRead.Location = new System.Drawing.Point(320, 154);
   this.btnRead.Name = "btnRead";
   this.btnRead.Size = new System.Drawing.Size(100, 29);
   this.btnRead.TabIndex = 5;
   this.btnRead.Text = "读配置";
   this.btnRead.Click += new System.EventHandler(this.btnRead_Click);
   //
   // btnWrite
   //
   this.btnWrite.Location = new System.Drawing.Point(320, 191);
   this.btnWrite.Name = "btnWrite";
   this.btnWrite.Size = new System.Drawing.Size(100, 28);
   this.btnWrite.TabIndex = 5;
   this.btnWrite.Text = "写配置";
   this.btnWrite.Click += new System.EventHandler(this.btnWrite_Click);
   //
   // txtfile
   //
   this.txtfile.Location = new System.Drawing.Point(117, 14);
   this.txtfile.Name = "txtfile";
   this.txtfile.Size = new System.Drawing.Size(187, 25);
   this.txtfile.TabIndex = 6;
   this.txtfile.Text = "请选择目录下Web.config文件";
   //
   // label1
   //
   this.label1.Location = new System.Drawing.Point(21, 21);
   this.label1.Name = "label1";
   this.label1.Size = new System.Drawing.Size(96, 14);
   this.label1.TabIndex = 3;
   this.label1.Text = "配置文件：";
   //
   // btnLook
   //
   this.btnLook.Location = new System.Drawing.Point(320, 13);
   this.btnLook.Name = "btnLook";
   this.btnLook.Size = new System.Drawing.Size(100, 28);
   this.btnLook.TabIndex = 7;
   this.btnLook.Text = "浏览...";
   this.btnLook.Click += new System.EventHandler(this.btnLook_Click);
   //
   // ofd
   //
   this.ofd.Filter = "Web配置文件|web.config";
   //
   // labkey
   //
   this.labkey.Location = new System.Drawing.Point(21, 201);
   this.labkey.Name = "labkey";
   this.labkey.Size = new System.Drawing.Size(96, 14);
   this.labkey.TabIndex = 3;
   this.labkey.Text = "读写节值：";
   //
   // txtkey
   //
   this.txtkey.Location = new System.Drawing.Point(117, 194);
   this.txtkey.Name = "txtkey";
   this.txtkey.Size = new System.Drawing.Size(187, 25);
   this.txtkey.TabIndex = 4;
   this.txtkey.Text = "ConnStr";
   //
   // btnDeleteNode
   //
   this.btnDeleteNode.Location = new System.Drawing.Point(320, 119);
   this.btnDeleteNode.Name = "btnDeleteNode";
   this.btnDeleteNode.Size = new System.Drawing.Size(100, 28);
   this.btnDeleteNode.TabIndex = 5;
   this.btnDeleteNode.Text = "删除节";
   this.btnDeleteNode.Visible = false;
   this.btnDeleteNode.Click += new System.EventHandler(this.btnDeleteNode_Click);
   //
   // frmMain
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);
   this.ClientSize = new System.Drawing.Size(437, 239);
   this.Controls.Add(this.btnLook);
   this.Controls.Add(this.txtfile);
   this.Controls.Add(this.btnRead);
   this.Controls.Add(this.txtserver);
   this.Controls.Add(this.labpassword);
   this.Controls.Add(this.labuser);
   this.Controls.Add(this.labdatabase);
   this.Controls.Add(this.labserver);
   this.Controls.Add(this.txtdatabase);
   this.Controls.Add(this.txtuser);
   this.Controls.Add(this.txtpassword);
   this.Controls.Add(this.btnWrite);
   this.Controls.Add(this.label1);
   this.Controls.Add(this.labkey);
   this.Controls.Add(this.txtkey);
   this.Controls.Add(this.btnDeleteNode);
   this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
   this.MaximizeBox = false;
   this.MinimizeBox = false;
   this.Name = "frmMain";
   this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
   this.Text = "数据库连接配置";
   this.Load += new System.EventHandler(this.Form1_Load);
   this.ResumeLayout(false);

  }
  #endregion

  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new frmMain());
  }

  private void Form1_Load(object sender, System.EventArgs e)
  {
  
  }

  private void btnLook_Click(object sender, System.EventArgs e)
  {
   ofd.ShowDialog();
   txtfile.Text=ofd.FileName;
  }

  private bool inittxtfile()
  {
   txtfile.Text=txtfile.Text.Trim();
   if(txtfile.Text=="")
   {
    txtfile.Text=System.Environment.CurrentDirectory+@"\web.config";
   }
   fi=new FileInfo(txtfile.Text);
   if(!fi.Exists)
   {
    MessageBox.Show("没有找到配置文件!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return false;
   }
   else
   {
    return true;
   }

  }
  private void btnWrite_Click(object sender, System.EventArgs e)
  {
   if(!inittxtfile())
   {
    return;
   }
   if((txtserver.Text.Trim()=="")||(txtdatabase.Text.Trim()=="")||(txtuser.Text.Trim()==""))
   {
    MessageBox.Show("写配置失败,配置信息不完整!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return;
   }
   Find=false;
   XmlDocument xd=new XmlDocument();
   xd.Load(fi.FullName);
   XmlNodeList nodeList=null;
   try
   {
    nodeList=xd.SelectSingleNode("/configuration/appSettings").ChildNodes; //获取appSettings节点的所有子节点
   }
   catch
   {
    MessageBox.Show("写配置失败,未找到配置节!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return;
   }
   //连接字符串
   string orgstr="server="+txtserver.Text.Trim()+";u;
   string str= Encrypt(orgstr,keypassword);

   foreach(XmlNode Node in nodeList)
   {
    XmlElement xe=(XmlElement)Node; //将子节点类型转换为XmlElement类型
    if(xe.GetAttribute("key")==txtkey.Text.Trim())
    {
     xe.Attributes["value"].Value = str;
     Find=true;
     break;
    }
   }
   if(Find)
   {
    xd.Save(txtfile.Text);
    MessageBox.Show("写配置成功!","配置成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
   }
   else
   {
    //未找到节点,建立节点
    XmlNode xn=xd.SelectSingleNode("/configuration/appSettings");
    XmlElement elem = xd.CreateElement("and");
    elem.SetAttribute("key",txtkey.Text.Trim());
    elem.SetAttribute("value",str);
    try
    {
     xn.AppendChild(elem);
     xd.Save(fi.FullName);
     MessageBox.Show("写配置成功!","配置成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
    }
    catch
    {
     MessageBox.Show("写配置失败,可能文件权限不够!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    }
   }
  }

  private void btnRead_Click(object sender, System.EventArgs e)
  {
   if(!inittxtfile())
   {
    return;
   }
   Find=false;
   XmlDocument xd=new XmlDocument();
   xd.Load(fi.FullName);
   XmlNodeList nodeList=null;
   try
   {
    nodeList=xd.SelectSingleNode("/configuration/appSettings").ChildNodes; //获取appSettings节点的所有子节点
   }
   catch
   {
    MessageBox.Show("读配置失败,未找到配置节!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return;
   }
   string readstr="";
   foreach(XmlNode Node in nodeList)
   {
    XmlElement xe=(XmlElement)Node; //将子节点类型转换为XmlElement类型
    if(xe.GetAttribute("key")==txtkey.Text.Trim())
    {
     readstr=xe.Attributes["value"].Value;
     Find=true;
     break;
    }
   }
   if(!Find)
   {
    MessageBox.Show("读配置失败,未找到配置节!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return;
   }
   #region 读配置并解析
   string connstr=Decrypt(readstr,keypassword);
   string [] tmp2=connstr.Split(new char[]{';','='});
   for(int i=0;i<tmp2.Length;i+=2)
   {
    if((tmp2[i].ToLower()=="server")||(tmp2[i].ToLower()=="data source"))
    {
     txtserver.Text=tmp2[i+1];
    }
    else if((tmp2[i].ToLower()=="uid")||(tmp2[i].ToLower()=="userid"))
    {
     txtuser.Text=tmp2[i+1];
    }
    else if((tmp2[i].ToLower()=="database")||(tmp2[i].ToLower()=="initial catalog"))
    {
     txtdatabase.Text=tmp2[i+1];
    }
    else if((tmp2[i].ToLower()=="pwd")||(tmp2[i].ToLower()=="password"))
    {
     txtpassword.Text="*******************";
     password=tmp2[i+1];
    }
    continue;

   }
   #endregion
  }
  #region 加密方法
  public string Encrypt(string pToEncrypt, string sKey)
  {
   DESCryptoServiceProvider des = new DESCryptoServiceProvider();
   byte[] inputByteArray = Encoding.Default.GetBytes(pToEncrypt);

   //建立加密对象的密钥和偏移量
   //原文使用ASCIIEncoding.ASCII方法的GetBytes方法
   //使得输入密码必须输入英文文本
   des.Key = ASCIIEncoding.ASCII.GetBytes(sKey);
   des.IV = ASCIIEncoding.ASCII.GetBytes(sKey);
   MemoryStream ms = new MemoryStream();
   CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(),CryptoStreamMode.Write);
   cs.Write(inputByteArray, 0, inputByteArray.Length);
   cs.FlushFinalBlock();
   StringBuilder ret = new StringBuilder();
   foreach(byte b in ms.ToArray())
   {
    ret.AppendFormat("{0:X2}", b);
   }
   ret.ToString();
   return ret.ToString();
  }
  #endregion
  #region 解密方法
  public string Decrypt(string pToDecrypt, string sKey)
  {
   DESCryptoServiceProvider des = new DESCryptoServiceProvider();

   byte[] inputByteArray = new byte[pToDecrypt.Length / 2];
   for(int x = 0; x < pToDecrypt.Length / 2; x++)
   {
    int i = (Convert.ToInt32(pToDecrypt.Substring(x * 2, 2), 16));
    inputByteArray[x] = (byte)i;
   }

   //建立加密对象的密钥和偏移量，此值重要，不能修改
   des.Key = ASCIIEncoding.ASCII.GetBytes(sKey);
   des.IV = ASCIIEncoding.ASCII.GetBytes(sKey);
   MemoryStream ms = new MemoryStream();
   CryptoStream cs = new CryptoStream(ms, des.CreateDecryptor(),CryptoStreamMode.Write);

   cs.Write(inputByteArray, 0, inputByteArray.Length);
   cs.FlushFinalBlock();


   //建立StringBuild对象，CreateDecrypt使用的是流对象，必须把解密后的文本变成流对象
   StringBuilder ret = new StringBuilder();

   return System.Text.Encoding.Default.GetString(ms.ToArray());
  }
  #endregion
  private void txtpassword_TextChanged(object sender, System.EventArgs e)
  {
   password=txtpassword.Text.Trim();
  }

  private void btnDeleteNode_Click(object sender, System.EventArgs e)
  {
   if(!inittxtfile())
   {
    return;
   }
   XmlDocument xd=new XmlDocument();
   xd.Load(fi.FullName);

   XmlNodeList nodeList=null;
   try
   {
    nodeList=xd.SelectSingleNode("/configuration/appSettings").ChildNodes; //获取appSettings节点的所有子节点
   }
   catch
   {
    MessageBox.Show("删除配置节失败,未找到配置节!","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
    return;
   }
   int ClearNodes=0;
   foreach(XmlNode Node in nodeList)
   {
    XmlElement xe=(XmlElement)Node; //将子节点类型转换为XmlElement类型
    if(xe.GetAttribute("key")==txtkey.Text.Trim())
    {
     Node.RemoveAll();
     ClearNodes++;
    }
   }
   if(ClearNodes>0)
   {
    xd.Save(txtfile.Text);
    MessageBox.Show("删除配置节成功!","删除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
   }
  }
 }
}

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
asp.net C# web service Object moved to here.发布时间：2022-07-10
下一篇：
ASP.NET MVC 3升级至MVC 5.1的遭遇：“已添加了具有相同键的项”发布时间：2022-07-10
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap