Log4Net获取异常信息并写入Mysql数据库

xiaoxiao2021-02-28  172

本文介绍使用Log4net实现获取程序的错误信息,并将错误信息写入Mysql的数据库。

第一步:

引用相关的dll插件:log4net.dll和Mysql.Data.dll

第二步:添加log4net.config文件。

<?xml version="1.0" encoding="utf-8"?> <configuration> <system.web> <compilation debug="true" targetFramework="4.5" /> <httpRuntime targetFramework="4.5" /> </system.web> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/> </configSections> <log4net> <appender name="AdoNetAppender_MySql" type="log4net.Appender.AdoNetAppender"> <bufferSize value="1"/> <param name="ConnectionType" value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data"/> <param name="ConnectionString" value="server=localhost;database=lognet;Uid=root;Pwd=12345;"/> <commandText value="INSERT INTO logdetails (LogDate,LogThread,LogLevel,LogLogger,LogActionClick,LogMessage,UserName,UserIP) VALUES (@log_date, @thread, @log_level, @logger, @ActionsClick, @message,@UserName,@UserIP)"/> <parameter> <parameterName value="@log_date"/> <dbType value="DateTime"/> <layout type="log4net.Layout.RawTimeStampLayout"/> <layout type="log4net.Layout.PatternLayout" value="
转载请注明原文地址: https://www.6miu.com/read-18158.html

最新回复(0)