日志管理完成版----.net练习篇

好在系统没有最终使用这个版本，这下可以放心的在网上发文了。其实就是简单的数据库连接啊，添加啊，删除啊什么的。

首先在数据库中写一个表Log (logdatetime,loguser,logtype,logmodule,logdescribe)后来发现这个表名跟关键字重了，不过也懒得改了。单独写了一个类用来添加数据到数据库中。代码如下：

using System;

using System.Data;

using System.Data.SqlClient;

namespace LogModule

{

/// <summary>

/// LogModule 的摘要说明。

/// </summary>

public class LogModule

{

public LogModule()

{

//

// TODO: 在此处添加构造函数逻辑

//

}

/// <summary>

/// 日志添加

/// </summary>

public static void log(string lu,string lt,string lm, string ld)

{

if (lu!=null && lt!=null && ld!=null)

{

try

{

SqlConnection logConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=xxxx");

logConn.Open();

string logInsert ="insert into Log(logdatetime,loguser,logtype,logmodule,logdescribe) values(getdate(), '" +

lu+"', '"+lt+"','"+lm+"','"+ld+"')";

SqlCommand logCmd = new SqlCommand(logInsert,logConn);

logCmd.ExecuteNonQuery();

//释放资源

logCmd.Dispose();

logConn.Close();

}

catch (System.Exception e)

{

Console.WriteLine(e.Message);

}

}

}

}

}

这样其他类就能够引用这个方法了，而且不用new一个对象，用起来还算方便。而对于日志的管理，修改是没有必要的，删除和查询则是在于用户交互的过程中完成的，所以做了个form来实现，如上例，我还是粘出全文：

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

namespace LogModule

{

/// <summary>

/// Form1 的摘要说明。

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.Windows.Forms.Button button3;

private System.Windows.Forms.Button button4;

private System.Windows.Forms.Button button5;

private System.Windows.Forms.ListView listView1;

private System.Windows.Forms.ColumnHeader columnHeader1;

private System.Windows.Forms.ColumnHeader columnHeader2;

private System.Windows.Forms.ColumnHeader columnHeader3;

private System.Windows.Forms.ColumnHeader columnHeader4;

private System.Windows.Forms.ColumnHeader columnHeader5;

private System.Windows.Forms.ColumnHeader columnHeader6;

private System.Windows.Forms.ComboBox comboBox1;

private System.Windows.Forms.ComboBox comboBox2;

private System.Windows.Forms.ComboBox comboBox3;

private System.Windows.Forms.ComboBox comboBox4;

private System.Windows.Forms.ComboBox comboBox5;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Label label2;

private System.Windows.Forms.Label label3;

private System.Windows.Forms.Label label4;

private System.Windows.Forms.Label label5;

private System.Windows.Forms.TextBox textBox1;

static SqlConnection conn = new SqlConnection ("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=xxxx");

/// <summary>

/// 必需的设计器变量。

/// </summary>

private System.ComponentModel.Container components = null;

public Form1()

{

//

// Windows 窗体设计器支持所必需的

//

InitializeComponent();

//

// TODO: 在 InitializeComponent 调用后添加任何构造函数代码

//

}

/// <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()

{

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();

this.button3 = new System.Windows.Forms.Button();

this.button4 = new System.Windows.Forms.Button();

this.button5 = new System.Windows.Forms.Button();

this.listView1 = new System.Windows.Forms.ListView();

this.columnHeader5 = new System.Windows.Forms.ColumnHeader();

this.columnHeader1 = new System.Windows.Forms.ColumnHeader();

this.columnHeader2 = new System.Windows.Forms.ColumnHeader();

this.columnHeader3 = new System.Windows.Forms.ColumnHeader();

this.columnHeader6 = new System.Windows.Forms.ColumnHeader();

this.columnHeader4 = new System.Windows.Forms.ColumnHeader();

this.comboBox1 = new System.Windows.Forms.ComboBox();

this.comboBox2 = new System.Windows.Forms.ComboBox();

this.comboBox3 = new System.Windows.Forms.ComboBox();

this.comboBox4 = new System.Windows.Forms.ComboBox();

this.label1 = new System.Windows.Forms.Label();

this.label2 = new System.Windows.Forms.Label();

this.label3 = new System.Windows.Forms.Label();

this.label4 = new System.Windows.Forms.Label();

this.label5 = new System.Windows.Forms.Label();

this.comboBox5 = new System.Windows.Forms.ComboBox();

this.textBox1 = new System.Windows.Forms.TextBox();

this.SuspendLayout();

//

// button1

//

this.button1.Location = new System.Drawing.Point(552, 16);

this.button1.Name = "button1";

this.button1.Size = new System.Drawing.Size(104, 48);

this.button1.TabIndex = 20;

this.button1.Text = "查找日志";

this.button1.Click += new System.EventHandler(this.button1_Click);

//

// button2

//

this.button2.Location = new System.Drawing.Point(576, 336);

this.button2.Name = "button2";

this.button2.Size = new System.Drawing.Size(80, 40);

this.button2.TabIndex = 22;

this.button2.Text = "添加日志";

this.button2.Click += new System.EventHandler(this.button2_Click);

//

// button3

//

this.button3.Location = new System.Drawing.Point(552, 72);

this.button3.Name = "button3";

this.button3.Size = new System.Drawing.Size(104, 48);

this.button3.TabIndex = 21;

this.button3.Text = "整理日志";

this.button3.Click += new System.EventHandler(this.button3_Click);

//

// button4

//

this.button4.Location = new System.Drawing.Point(576, 424);

this.button4.Name = "button4";

this.button4.Size = new System.Drawing.Size(80, 48);

this.button4.TabIndex = 40;

this.button4.Text = "退出系统";

this.button4.Click += new System.EventHandler(this.button4_Click);

//

// button5

//

this.button5.Location = new System.Drawing.Point(576, 376);

this.button5.Name = "button5";

this.button5.Size = new System.Drawing.Size(80, 40);

this.button5.TabIndex = 23;

this.button5.Text = "测试页面";

this.button5.Click += new System.EventHandler(this.button5_Click);

//

// listView1

//

this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {

this.columnHeader5,

this.columnHeader1,

this.columnHeader2,

this.columnHeader3,

this.columnHeader6,

this.columnHeader4});

this.listView1.FullRowSelect = true;

this.listView1.GridLines = true;

this.listView1.Location = new System.Drawing.Point(16, 136);

this.listView1.MultiSelect = false;

this.listView1.Name = "listView1";

this.listView1.Size = new System.Drawing.Size(640, 184);

this.listView1.TabIndex = 30;

this.listView1.View = System.Windows.Forms.View.Details;

this.listView1.SelectedIndexChanged += new System.EventHandler(this.listView1_SelectedIndexChanged);

//

// columnHeader5

//

this.columnHeader5.Text = "Log_ID";

//

// columnHeader1

//

this.columnHeader1.Text = " 日期 时间";

this.columnHeader1.Width = 130;

//

// columnHeader2

//

this.columnHeader2.Text = "用户";

this.columnHeader2.Width = 80;

//

// columnHeader3

//

this.columnHeader3.Text = "类型";

//

// columnHeader6

//

this.columnHeader6.Text = "模块";

this.columnHeader6.Width = 70;

//

// columnHeader4

//

this.columnHeader4.Text = "描述";

this.columnHeader4.Width = 210;

//

// comboBox1

//

this.comboBox1.Location = new System.Drawing.Point(16, 40);

this.comboBox1.Name = "comboBox1";

this.comboBox1.Size = new System.Drawing.Size(104, 20);

this.comboBox1.TabIndex = 10;

//

// comboBox2

//

this.comboBox2.Location = new System.Drawing.Point(16, 96);

this.comboBox2.Name = "comboBox2";

this.comboBox2.Size = new System.Drawing.Size(104, 20);

this.comboBox2.TabIndex = 11;

//

// comboBox3

//

this.comboBox3.Location = new System.Drawing.Point(152, 40);

this.comboBox3.Name = "comboBox3";

this.comboBox3.Size = new System.Drawing.Size(104, 20);

this.comboBox3.TabIndex = 12;

//

// comboBox4

//

this.comboBox4.Location = new System.Drawing.Point(152, 96);

this.comboBox4.Name = "comboBox4";

this.comboBox4.Size = new System.Drawing.Size(104, 20);

this.comboBox4.TabIndex = 13;

//

// label1

//

this.label1.Location = new System.Drawing.Point(16, 16);

this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(64, 16);

this.label1.TabIndex = 12;

this.label1.Text = "起始时间";

//

// label2

//

this.label2.Location = new System.Drawing.Point(16, 72);

this.label2.Name = "label2";

this.label2.Size = new System.Drawing.Size(72, 16);

this.label2.TabIndex = 13;

this.label2.Text = "最终时间";

//

// label3

//

this.label3.Location = new System.Drawing.Point(152, 16);

this.label3.Name = "label3";

this.label3.Size = new System.Drawing.Size(72, 16);

this.label3.TabIndex = 14;

this.label3.Text = "操作用户";

//

// label4

//

this.label4.Location = new System.Drawing.Point(152, 72);

this.label4.Name = "label4";

this.label4.Size = new System.Drawing.Size(64, 16);

this.label4.TabIndex = 15;

this.label4.Text = "处理类型";

//

// label5

//

this.label5.Location = new System.Drawing.Point(296, 16);

this.label5.Name = "label5";

this.label5.Size = new System.Drawing.Size(64, 16);

this.label5.TabIndex = 16;

this.label5.Text = "模块";

//

// comboBox5

//

this.comboBox5.Location = new System.Drawing.Point(296, 40);

this.comboBox5.Name = "comboBox5";

this.comboBox5.Size = new System.Drawing.Size(104, 20);

this.comboBox5.TabIndex = 14;

//

// textBox1

//

this.textBox1.Location = new System.Drawing.Point(16, 336);

this.textBox1.Multiline = true;

this.textBox1.Name = "textBox1";

this.textBox1.ReadOnly = true;

this.textBox1.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;

this.textBox1.Size = new System.Drawing.Size(544, 136);

this.textBox1.TabIndex = 20;

this.textBox1.TabStop = false;

this.textBox1.Text = "";

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);

this.ClientSize = new System.Drawing.Size(672, 485);

this.Controls.Add(this.textBox1);

this.Controls.Add(this.comboBox5);

this.Controls.Add(this.label5);

this.Controls.Add(this.label4);

this.Controls.Add(this.label3);

this.Controls.Add(this.label2);

this.Controls.Add(this.label1);

this.Controls.Add(this.comboBox4);

this.Controls.Add(this.comboBox3);

this.Controls.Add(this.comboBox2);

this.Controls.Add(this.comboBox1);

this.Controls.Add(this.listView1);

this.Controls.Add(this.button5);

this.Controls.Add(this.button4);

this.Controls.Add(this.button3);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Name = "Form1";

this.Text = "日志管理";

this.Load += new System.EventHandler(this.Form1_Load);

this.ResumeLayout(false);

}

#endregion

/// <summary>

/// 应用程序的主入口点。

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

/// <summary>

/// 执行查找的指令

/// </summary>

/// <param name="sender">无参</param>

/// <param name="e">无参</param>

private void button1_Click(object sender, System.EventArgs e)

{

this.find(comboBox1.Text, comboBox2.Text, comboBox3.Text, comboBox4.Text, comboBox5.Text);

}

/// <summary>

/// 添加一条测试的日志

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

private void button2_Click(object sender, System.EventArgs e)

{

//LogModule.log("服务控制台","操作","商品管理","测试事务添加一个新的log测试事务添加一个新的log测试事务添加一个新的log测试事务添加一个新的log测试事务添加一个新的log");

}

/// <summary>

/// 整理日志，删除两个月以前的日志

/// </summary>

/// <param name="sender">无参</param>

/// <param name="e">无参</param>

private void button3_Click(object sender, System.EventArgs e)

{

System.Windows.Forms.DialogResult chose=MessageBox.Show("是否删除日志（保留近两个月的日志）","整理日志",MessageBoxButtons.OKCancel);

if((chose.ToString()).Equals("OK"))

{

//------------------------------------------------------------------------------

//注意此处where后面的用法

string logDel ="delete from LogManage where logdatetime<dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())-1, 0))";

SqlCommand logCmd = new SqlCommand(logDel,conn);

try

{

logCmd.ExecuteNonQuery();

}

catch (System.Exception e1)

{

Console.WriteLine(e1.Message);

}

//释放资源

logCmd.Dispose();

}

}

/// <summary>

/// 日志查找

/// C端最核心的代码了...写的有点长

/// </summary>

public void find(string logdfirst, string logdlast, string loguser, string logtype, string logmodule)

{

//创建数据连接

//string select="select logid,logdatetime,loguser,logtype,logmoduleone,logdescribeone,logmoduletwo,logdescribetwo from LogManage";

string select="select * from Log";

//清空listview的现实内容

listView1.Items.Clear();

if(logdfirst == null) logdfirst="";

if(logdlast == null) logdlast="";

if(loguser == null) loguser="";

if(logtype == null) logtype="";

if(logmodule == null) logmodule="";

//---------------------------------------------------------------------------------

//应该优化这里的代码，提高效率和减少判断的次数，现在感觉有bug了，太长了

if(logdfirst.Equals("") && logdlast.Equals("") && loguser.Equals("") && logtype.Equals("") && logmodule.Equals(""))

{

//初始状态

}

else

{

select+=" where 1>0";

if(!logdfirst.Equals(""))

{

select+=" and logdatetime>CONVERT(datetime,'"+logdfirst+" 00:00:00.000')";

}

if(!logdlast.Equals(""))

{

select+=" and logdatetime<=CONVERT(datetime,'"+logdlast+" 23:59:59.999')";

}

if(!loguser.Equals(""))

{

select+=" and loguser='"+loguser+"'";

}

if(!logtype.Equals(""))

{

select+=" and logtype='"+logtype+"'";

}

if(!logmodule.Equals(""))

{

select+=" and logmodule='"+logmodule+"'";

}

}

//select+=" order by logdatetime";

//得到最终的select查询代码

//---------------------------------------------------------------------------------

SqlCommand selectCMD = new SqlCommand (select,conn);

//创建并初始化SqlCommand对象

SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = selectCMD;

SqlDataReader myReader = selectCMD.ExecuteReader();

while(myReader.Read())

{

ListViewItem item = new ListViewItem(myReader.GetInt64(0).ToString());

item.SubItems.Add(myReader.GetDateTime(1).ToShortDateString() +

" " + myReader.GetDateTime(1).ToLongTimeString() + "." +

myReader.GetDateTime(1).Millisecond);

item.SubItems.Add(myReader.GetString(2));

item.SubItems.Add(myReader.GetString(3));

item.SubItems.Add(myReader.GetString(4));

item.SubItems.Add(myReader.GetString(5));

listView1.Items.Add(item);

}

//释放资源

myReader.Close();

selectCMD.Dispose();

sqlDataAdapter1.Dispose();

}

/*

/// <summary>

/// 日志的删除 需引入时间做为参量

/// 原先可以完成对单条记录的删除

/// </summary>

public void logKill(string dt, string hd, string tp, string dr)

{

string logDel ="delete from LogDesc where datetime = CONVERT(datetime,'"+dt+

"') and handle='"+hd+"'"+

" and type='"+tp+"' and descr='"+dr+"'";

SqlCommand logCmd = new SqlCommand(logDel,conn);

try

{

logCmd.ExecuteNonQuery();

}

catch (System.Exception e)

{

Console.WriteLine(e.Message);

}

//释放资源

logCmd.Dispose();

}

*/

/// <summary>

/// 退出系统

/// </summary>

/// <param name="sender">无参</param>

/// <param name="e">无参</param>

private void button4_Click(object sender, System.EventArgs e)

{

conn.Close();

Application.Exit();

}

/// <summary>

/// 初始化参量

/// </summary>

/// <param name="sender">无参</param>

/// <param name="e">无参</param>

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

{

//*********************************************************************************

conn.Open();

//*********************************************************************************

this.find("","","","","");

//---------------------------------------------------------------------------------

//初始化时间的combobox内容

string logComb1="select distinct CONVERT(char(10),logdatetime,102) from Log";

SqlCommand selectCMD = new SqlCommand (logComb1,conn);

//创建并初始化SqlCommand对象

SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = selectCMD;

SqlDataReader myReader = selectCMD.ExecuteReader();

while(myReader.Read())

{

comboBox1.Items.Add(myReader.GetString(0));

comboBox2.Items.Add(myReader.GetString(0));

}

//释放资源

myReader.Close();

selectCMD.Dispose();

sqlDataAdapter1.Dispose();

//---------------------------------------------------------------------------------

//初始化操作员的combobox内容

string logComb3="select distinct loguser from Log";

selectCMD = new SqlCommand (logComb3,conn);

//创建并初始化SqlCommand对象

sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = selectCMD;

myReader = selectCMD.ExecuteReader();

while(myReader.Read())

{

comboBox3.Items.Add(myReader.GetString(0));

}

//释放资源

myReader.Close();

selectCMD.Dispose();

sqlDataAdapter1.Dispose();

//---------------------------------------------------------------------------------

//初始化类型的combobox内容

string logComb4="select distinct logtype from Log";

selectCMD = new SqlCommand (logComb4,conn);

//创建并初始化SqlCommand对象

sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = selectCMD;

myReader = selectCMD.ExecuteReader();

while(myReader.Read())

{

comboBox4.Items.Add(myReader.GetString(0));

}

//释放资源

myReader.Close();

selectCMD.Dispose();

sqlDataAdapter1.Dispose();

//---------------------------------------------------------------------------------

//初始化模块的combobox内容

string logComb5="select distinct logmodule from Log where logmodule!=''";

selectCMD = new SqlCommand (logComb5,conn);

//创建并初始化SqlCommand对象

sqlDataAdapter1 = new SqlDataAdapter();

sqlDataAdapter1.SelectCommand = selectCMD;

myReader = selectCMD.ExecuteReader();

while(myReader.Read())

{

comboBox5.Items.Add(myReader.GetString(0));

}

//释放资源

myReader.Close();

selectCMD.Dispose();

sqlDataAdapter1.Dispose();

}

/// <summary>

/// 单击listview在下方的textbox中显示出该条记录的详细信息

/// </summary>

/// <param name="sender">无参</param>

/// <param name="e">无参</param>

private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)

{

int selectCount = listView1.SelectedItems.Count;

if (selectCount !=0)

{

string id="",dt="",us="",tp="",md="",ds="";

foreach(ListViewItem lvi in listView1.SelectedItems)

{

id=lvi.SubItems[0].Text;

dt=lvi.SubItems[1].Text;

us=lvi.SubItems[2].Text;

tp=lvi.SubItems[3].Text;

md=lvi.SubItems[4].Text;

ds=lvi.SubItems[5].Text;

textBox1.Text="LOG_ID:"+id+"\r\n时间:"+dt+"\r\n操作员:"+us+"\r\n类型:"+

tp+"\r\n模块:"+md+"\r\n描述:"+ds;

}

}

}

}

}

如果一句解释都没有呢，确实看着不太方便。但是文中确实没有什么难点，只是个个功能的简单累加，

以后使用的时候一旦忘了，拿出来看看，确实会方便些。

尽以本文献给那些，入门的，入门很就忽然忘了的，随便看看的，热爱编程的战友们。

• ·尹恩惠私服搭配PK活动着装 打扮_美丽顾问
• ·使用links方式安装Eclipse插件真是好
• ·处理checkbox 小技巧！
• ·胖女孩如何穿出显瘦潮流感 打扮_美丽顾问
• ·J2EE学习经验和流程
• ·POJO应用框架：Spring Vs. EJB
• ·女文艺青年的减龄quot;森女quot;搭配
• ·纤细PK寒流 减5KG潮搭有方 打扮_美丽顾问
• ·使用新的代码和标记模型创建真实的应用程序(Wi
• ·泛型算法：Tips (4) --- 再论初始化