首页 > 代码库 > Log4net保存自定义信息到数据库
Log4net保存自定义信息到数据库
概述
Log4net将自身定义信息保存到文本文件和数据库的操作很简单，但是，这些信息有时不符合我们的要求，例如：我想多一些属性值，此时就不不行了。
实现
1、下载log4net，添加log4net引用。
2、创建数据库
<span style="font-size:18px;">create talbe MyLogTable
(
id int primary key identity(1,1),
userid varchar(32),
username varchar(32)
)</span>3、添加实体类，属性为自定义的字段
namespace Log4NetToDatabase
{
public class LogMessage:IRequiresSessionState
{
public LogMessage() { }
public LogMessage(string userID, string UserName)
{
this.userid = userID;
this.username = UserName;
}
private string userid;
public string Userid
{
get { return userid; }
set { userid = value; }
}
private string username;
public string Username
{
get { return username; }
set { username = value; }
}
}
} 4、添加参数转换器类，每个字段一个模式转化类namespace Log4NetToDatabase
{
internal sealed class UserIdPatternConverter : PatternLayoutConverter
{
override protected void Convert(TextWriter writer, LoggingEvent loggingEvent)
{
LogMessage logMessage = loggingEvent.MessageObject as LogMessage;
if (logMessage != null)
{
// 将UserName作为日志信息输出
writer.Write(logMessage.Userid);
}
}
}
internal sealed class UserNamePatternConverter : PatternLayoutConverter
{
override protected void Convert(TextWriter writer, LoggingEvent loggingEvent)
{
LogMessage logMessage = loggingEvent.MessageObject as LogMessage;
if (logMessage != null)
// 将UserName作为日志信息输出
writer.Write(logMessage.Username);
}
}
} 5、自定义layout类namespace Log4NetToDatabase
{
public class CustomLayout : log4net.Layout.LayoutSkeleton
{
public const string DefaultConversionPattern = "%message%newline";
public const string DetailConversionPattern = "%timestamp [%thread] %level %logger %ndc - %message%newline";
private static Hashtable s_globalRulesRegistry;
private string m_pattern;
private PatternConverter m_head;
private Hashtable m_instanceRulesRegistry = new Hashtable();
//这里是重点-------------------------------------------------------
/// <summary>
/// 把自定义的字段放进Hashtable
/// 定义多少个写多少个
/// 注意这里有名称要和配置文件中的名称一致
/// 注意命名空间
/// 在配置文件中要用到命名空间
/// </summary>
static CustomLayout()
{
s_globalRulesRegistry = new Hashtable(2);
s_globalRulesRegistry.Add("username", typeof(UserNamePatternConverter));
s_globalRulesRegistry.Add("userid", typeof(UserIdPatternConverter));
}
//--------------------------------------------------------------------
public CustomLayout()
: this(DefaultConversionPattern)
{ }
public CustomLayout(string pattern)
{
IgnoresException = true;
m_pattern = pattern;
if (m_pattern == null)
{
m_pattern = DefaultConversionPattern;
}
ActivateOptions();
}
public string ConversionPattern
{
get { return m_pattern; }
set { m_pattern = value; }
}
virtual protected PatternParser CreatePatternParser(string pattern)
{
PatternParser patternParser = new PatternParser(pattern);
foreach (DictionaryEntry entry in s_globalRulesRegistry)
{
patternParser.PatternConverters[entry.Key] = entry.Value;
}
foreach (DictionaryEntry entry in m_instanceRulesRegistry)
{
patternParser.PatternConverters[entry.Key] = entry.Value;
}
return patternParser;
}
override public void ActivateOptions()
{
m_head = CreatePatternParser(m_pattern).Parse();
PatternConverter curConverter = m_head;
while (curConverter != null)
{
PatternLayoutConverter layoutConverter = curConverter as PatternLayoutConverter;
if (layoutConverter != null)
{
if (!layoutConverter.IgnoresException)
{
this.IgnoresException = false;
break;
}
}
curConverter = curConverter.Next;
}
}
override public void Format(TextWriter writer, LoggingEvent loggingEvent)
{
if (writer == null)
{
throw new ArgumentNullException("writer");
}
if (loggingEvent == null)
{
throw new ArgumentNullException("loggingEvent");
}
PatternConverter c = m_head;
while (c != null)
{
c.Format(writer, loggingEvent);
c = c.Next;
}
}
public void AddConverter(ConverterInfo converterInfo)
{
AddConverter(converterInfo.Name, converterInfo.Type);
}
public void AddConverter(string name, Type type)
{
if (name == null) throw new ArgumentNullException("name");
if (type == null) throw new ArgumentNullException("type");
if (!typeof(PatternConverter).IsAssignableFrom(type))
{
throw new ArgumentException("The converter type specified [" + type + "] must be a subclass of log4net.Util.PatternConverter", "type");
}
m_instanceRulesRegistry[name] = type;
}
public sealed class ConverterInfo
{
private string m_name;
private Type m_type;
public ConverterInfo()
{ }
public string Name
{
get { return m_name; }
set { m_name = value; }
}
public Type Type
{
get { return m_type; }
set { m_type = value; }
}
}
}
}
6、添加配置信息 <configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>
</configSections>
<log4net>
<logger name="<span style="font-family: Arial, Helvetica, sans-serif;">log4netToSqlServer</span><span style="font-family: Arial, Helvetica, sans-serif;">"></span> <level value=http://www.mamicode.com/"INFO"/>> 7、程序编码 log4net.Config.XmlConfigurator.Configure();
ILog log = log4net.LogManager.GetLogger("log4netToSqlServer");
LogMessage message = new Log4NetToDatabase.LogMessage(userID, UserName);
log.Info(message);
总结
自定义字段信息到数据库和自定义字段信息到文本的操作是一样的，不一样的是配置文件的修改.
Log4net保存自定义信息到数据库
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。