log4net是一个优秀的开源日志项目,现将本人使用写成一个demo,如下
0:准备 去http://logging.apache.org/,可下载log4net,最新为1.2版本, 建立一个asp.net web 项目,并将log4net.dll添加到引用
1:建立数据表 CREATE TABLE [dbo].[Log] ( [Id] [int] IDENTITY (1, 1) NOT NULL, [Date] [datetime] NOT NULL, [Thread] [varchar] (255) NOT NULL, [Level] [varchar] (50) NOT NULL, [Logger] [varchar] (255) NOT NULL, [Message] [varchar] (4000) NOT NULL, [Exception] [varchar] (2000) NULL )
2:编写配置文件 <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" /> </configSections>
<system.web> <!-- ...... --> </system.web>
<log4net>
<root> <level value="ALL" /> <appender-ref ref="ADONetAppender" /> </root>
<!-- <logger name="testApp.Logging"> <level value="ALL"/> <appender-ref ref="ADONetAppender" /> </logger> -->
<appender name="ADONetAppender" type="log4net.Appender.ADONetAppender"> <bufferSize value="10" /> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <connectionString value="server=localhost;database=demo;user id=sa;password=123456" /> <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" /> <parameter> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.RawTimeStampLayout" /> </parameter> <parameter> <parameterName value="@thread" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout"> &[1] [2] [3] 下一页 |