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

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()+";uid="+txtuser.Text.Trim()+";database="+txtdatabase.Text.Trim()+";pwd="+password+"";

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);

}

}

}

}

• ·返回服务器登陆的时间，并判断星期(限SQLSe
• ·MOODLE-WIKI-BLOG 安装
• ·java.util.Enumeration翻译
• ·PHP ADODB1.99版手册 (修正版)
• ·SQL Server 2000 （SP4）笔记
• ·对Malloc的疑惑!
• ·用DES加密数据库信息,增强Asp.net的安
• ·使用Jxl读写excel文件
• ·javax.servlet.GenericSe
• ·吃饭之前闻香蕉和苹果可抑制你的食欲 减肥_美丽