概述
Log4net保存自定義欄位到資料庫，此處以oracle資料庫為例
實作
1、下載log4net，添加log4net參考，
2、創建資料庫
CREATE TABLE TASKDB.WORKFLOWLOGS
(
LOG_ID NUMBER NOT NULL,
LOG_USERID VARCHAR2(100 BYTE),
LOG_OPERATERTYPE VARCHAR2(100 BYTE),
LOG_MESSAGE VARCHAR2(4000 BYTE),
LOG_DATE DATE,
LOG_LEVEL VARCHAR2(255 BYTE),
LOG_IDENTITY VARCHAR2(255 BYTE),
LOG_EXCEPTION VARCHAR2(4000 BYTE),
LOG_LOGGER VARCHAR2(255 BYTE),
LOG_SOURCE VARCHAR2(1000 BYTE)
)
3、添加自定義欄位的物體類
namespace Log4NetToDatabase { /// <summary> /// 包含了所有的自定欄位屬性 /// </summary> public class LogContent : IRequiresSessionState { public LogContent(string _UserId, string _OperaterType, string _Message) { UserId = _UserId; OperaterType = _OperaterType; Message = _Message; } public string UserId { get; set; } public string OperaterType { get; set; } public string Message { get; set; } } }
4、添加引數轉換器類，每個欄位一個轉化類
namespace Log4NetToDatabase { public class Log4NetConvert { internal sealed class UserIdPatternConverter : PatternLayoutConverter { override protected void Convert(TextWriter writer, LoggingEvent loggingEvent) { LogContent content = loggingEvent.MessageObject as LogContent; if (content != null) { writer.Write(content.UserId); } } } internal sealed class OperaterTypePatternConverter : PatternLayoutConverter { override protected void Convert(TextWriter writer, LoggingEvent loggingEvent) { LogContent content = loggingEvent.MessageObject as LogContent; if (content != null) { writer.Write(content.OperaterType); } } } internal sealed class MessagePatternConverter : PatternLayoutConverter { override protected void Convert(TextWriter writer, LoggingEvent loggingEvent) { LogContent content = loggingEvent.MessageObject as LogContent; if (content != null) { writer.Write(content.Message); } } } } }
5、添加自定義layout類
namespace Log4NetToDatabase { public class CustomLayout : PatternLayout { public CustomLayout() { //this.AddConverter("property", typeof(Log4NetConvert)); this.AddConverter("UserId", typeof(Log4NetConvert.UserIdPatternConverter)); this.AddConverter("OperaterType", typeof(Log4NetConvert.OperaterTypePatternConverter)); this.AddConverter("Message", typeof(Log4NetConvert.MessagePatternConverter)); } } }
6 、添加配置資訊
<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/> </configSections> <log4net> <!--日志記錄器--> <logger name="OperationLog" additivity="false"> <level value="ALL"/> <!--設定使用的資料庫記錄器--> <appender-ref ref="AdoNetAppender_Operation"/> </logger> <!--資料庫記錄器--> <appender name="AdoNetAppender_Operation" type="log4net.Appender.AdoNetAppender"> <!--sqlserver日志資料庫連接串--> <!--<connectionType value="https://www.cnblogs.com/shurun/p/System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> <connectionString value="https://www.cnblogs.com/shurun/p/Data Source=./sqlexpress;initial catalog=kuiyu.net;User ID=sa;Password=1" providerName="System.Data.SqlClient"/>--> <!--oracle日志資料庫連接串--> <connectionType value="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/> <connectionString value="Data Source=//localhost:1521/orcl;User ID=xxxxdb;Password=xxxxdb;"/> <!--日志資料庫腳本--> <commandText value="INSERT INTO WORKFLOWLOGS (LOG_ID,LOG_USERID,LOG_OPERATERTYPE, LOG_MESSAGE, LOG_DATE, LOG_LEVEL, LOG_IDENTITY, LOG_EXCEPTION, LOG_LOGGER, LOG_SOURCE) VALUES (WORKFLOWLOGS_SEQ.nextval, :UserId,:OperaterType, :Message,:log_date, :log_level, :log_identity,:log_exception, :logger, :source )" /> <bufferSize value="1"/> <!--自定義成員 --> <parameter> <parameterName value=":UserId" /> <dbType value="String" /> <size value="1000" /> <layout type="Log4NetToDatabase.CustomLayout"> <conversionPattern value="%UserId" /> </layout> </parameter> <parameter> <parameterName value=":OperaterType" /> <dbType value="String" /> <size value="1000" /> <layout type="Log4NetToDatabase.CustomLayout"> <conversionPattern value="%OperaterType" /> </layout> </parameter> <parameter> <parameterName value=":Message" /> <dbType value="String" /> <size value="4000" /> <layout type="Log4NetToDatabase.CustomLayout"> <conversionPattern value="%Message" /> </layout> </parameter> <parameter> <parameterName value=":log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.RawTimeStampLayout"> </layout> </parameter> <parameter> <parameterName value=":log_level" /> <dbType value="String" /> <size value="10" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%level" /> </layout> </parameter> <parameter> <parameterName value=":log_identity" /> <dbType value="String" /> <size value="100" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%identity" /> </layout> </parameter> <parameter> <parameterName value=":log_exception" /> <dbType value="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%exception" /> </layout> </parameter> <parameter> <parameterName value=":logger" /> <dbType value="String" /> <size value="255" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%logger" /> </layout> </parameter> <parameter> <parameterName value=":source" /> <dbType value="String" /> <size value="1000" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%file:%line" /> </layout> </parameter> </appender> </log4net> </configuration>
7、呼叫寫入日志
ILog log = log4net.LogManager.GetLogger("OperationLog"); log.Info(new LogContent(dt_user.Rows[0]["userid"].ToString(), "登錄", "登陸系統"));
總結
添加自定義欄位的物體類
添加引數轉換器類
添加自定義layout類
添加配置資訊
呼叫寫入日志
若對您有用，請贊助個棒棒糖~
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/285332.html
標籤：ASP.NET