• log4net在控制台显示,记录文件,写入Oracle数据库的配置文件,调用写在总结里面


    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>

    <!-- Register a section handler for the log4net section -->
    <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
    </configSections>
    <log4net>

    <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
    <!--日志路径-->
    <param name= "File" value= ".logs"/>
    <!--是否是向文件中追加日志-->
    <param name= "AppendToFile" value= "true"/>
    <!--log保留天数-->
    <param name= "MaxSizeRollBackups" value= "10"/>
    <!--日志文件名是否是固定不变的-->
    <param name= "StaticLogFileName" value= "false"/>
    <!--日志文件名格式为:2008-08-31.log-->
    <param name= "DatePattern" value= "yyyy-MM-dd&quot;.log&quot;"/>
    <!--日志根据日期滚动-->
    <param name= "RollingStyle" value= "Date"/>
    <layout type="log4net.Layout.PatternLayout">
    <param name="ConversionPattern" value="%d: %-5p %m%n " />
    </layout>
    </appender>

    <!-- 控制台前台显示日志 -->
    <appender name="ColoredConsoleAppender" type="log4net.Appender.ColoredConsoleAppender">
    <mapping>
    <level value="ERROR" />
    <foreColor value="Red, HighIntensity" />
    </mapping>
    <mapping>
    <level value="Info" />
    <foreColor value="Green" />
    </mapping>
    <layout type="log4net.Layout.PatternLayout">
    <conversionPattern value="%n%date{HH:mm:ss,fff} [%-5level] %m" />
    </layout>

    <filter type="log4net.Filter.LevelRangeFilter">
    <param name="LevelMin" value="Info" />
    <param name="LevelMax" value="Fatal" />
    </filter>
    </appender>



    <!-- Oracle Appender -->
    <appender name="ADONetAppender_Oracle" type="log4net.Appender.ADONetAppender">
    <!--bufferSize 为缓冲区大小,只有日志记录超设定值才会一块写入到数据库 -->
    <bufferSize value="0" />
    <!--访问数据库驱动的引用-->
    <connectionType value="Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
    <!--数据库连接字符串-->
    <connectionString value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db_name)));Persist Security Info=True;User ID=uid;Password=password;" />
    <!--数据库执行的Sql语句-->
    <commandText value="INSERT INTO LOG_LOG4NET (LOG_ID, LOG_DATE, LOG_LEVEL, LOG_IDENTITY, LOG_MESSAGE, LOG_EXCEPTION, LOG_LOGGER, LOG_SOURCE) VALUES (LOG_LOG4NET_SEQ.nextval, :log_date, :log_level, :log_identity, :log_message, :log_exception, :logger, :source)" />
    <!-- 日志记录时间,RawTimeStampLayout为默认的时间输出格式 -->
    <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_message" />
    <dbType value="String" />
    <size value="2000" />
    <layout type="log4net.Layout.PatternLayout">
    <conversionPattern value="%m" />
    </layout>
    </parameter>
    <!-- 异常信息 -->
    <parameter>
    <parameterName value=":log_exception" />
    <dbType value="String" />
    <size value="2000" />
    <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>

    <!-- Setup the root category, add the appenders and set the default level -->
    <root>
    <level value="ALL" />
    <appender-ref ref="ADONetAppender_Oracle" />
    <appender-ref ref="RollingLogFileAppender" />
    <appender-ref ref="ColoredConsoleAppender" />
    </root>

    </log4net>
    </configuration>

  • 相关阅读:
    51单片机学习笔记(清翔版)(23)——红外通讯
    51单片机学习笔记(清翔版)(22)——数字温度传感器DS18B20
    信号与系统1.1.4信号的分类-信号的MATLAB的表示与绘图
    信号与系统1.1.3信号的分类-能量与功率信号,因果与反因果
    信号与系统1.1.2信号的分类-周期与非周期
    信号与系统1.1.1信号的分类-确定与随机-离散与连续
    51单片机学习笔记(清翔版)(21)——ADDA数模转换
    51单片机学习笔记(清翔版)(19)——串口通信
    ecplise问题总结
    Android广播机制(转)
  • 原文地址:https://www.cnblogs.com/qiuyunblogs/p/8288753.html
Copyright © 2020-2023  润新知