lockback日志记录

桃扇骨 2023-09-29 13:00 8阅读 0赞

### lockback日志记录 ###

*   *  1、lockback-spring.xml
     *  2、日志文件可以结合aop统一日志处理
     *  3、如果在想要将sql记录到日志中需要如下配置

项目当中经常会记录日志，以便于问题排查  
[lockback日志记录源码地址][lockback]

## 1、lockback-spring.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    <configuration debug="false">
        
        <property name="LOG_HOME" value="./logs" />
        
        <property name="appName" value="controller1"/>
        
        <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
            <withJansi>true</withJansi>
            <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
                
                <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %highlight(%-5level) %cyan(%logger{50}:%L) - %msg%n</pattern>
            </encoder>
        </appender>
    
        
        <appender name="INFO_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
            
            <file>${LOG_HOME}/${appName}-info.log</file>
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                
                <FileNamePattern>${LOG_HOME}/${appName}-info.%d{yyyy-MM-dd}.%i.log</FileNamePattern>
                
                <maxHistory>30</maxHistory>
                
                <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
                    <maxFileSize>100MB</maxFileSize>
                </timeBasedFileNamingAndTriggeringPolicy>
            </rollingPolicy>
            <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
                
                <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50}:%L - %msg%n</pattern>
                <charset>UTF-8</charset>
            </encoder>
        </appender>
    
        
        <appender name="ERROR_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
            
            <file>${LOG_HOME}/${appName}-error.log</file>
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                <FileNamePattern>${LOG_HOME}/${appName}-error.%d{yyyy-MM-dd}.log</FileNamePattern>
                <MaxHistory>30</MaxHistory>
            </rollingPolicy>
            <encoder>
                <pattern>%d{yyyy-MM-dd HH:mm:ss} [%thread] %-5level %logger{50}:%L - %msg%n</pattern>
                <charset>UTF-8</charset>
            </encoder>
            <filter class="ch.qos.logback.classic.filter.LevelFilter">
                <level>ERROR</level>
                <onMatch>ACCEPT</onMatch>
                <onMismatch>DENY</onMismatch>
            </filter>
        </appender>
    
    
        
        <logger name="com.apache.ibatis" level="TRACE" />
        <logger name="java.sql.Connection" level="DEBUG" />
        <logger name="java.sql.Statement" level="DEBUG" />
        <logger name="java.sql.PreparedStatement" level="DEBUG" />
    
        
        <root level="INFO">
            <appender-ref ref="STDOUT" />
            <appender-ref ref="INFO_FILE" />
            <appender-ref ref="ERROR_FILE" />
        </root>
    
    </configuration>

## 2、日志文件可以结合aop统一日志处理 ##

[SpringBoot的统一日志记录][SpringBoot]  
log.debug、log.info、log.error会输出到对应的日志文件中。

由于我们自定义了xml的名称，我们需要在properties或者yml中添加加载xml的配置使其生效。  
![在这里插入图片描述][f08a8e602c2c46b280481ecce814d5d2.png]

## 3、如果在想要将sql记录到日志中需要如下配置 ##

*  此配置会将sql输出到日志中，sql并不会在控制台中输出

logging:
     # 加载lockback-spring.xml配置文件
     config: classpath:lockback-spring.xml
     level:
     	com.XXX.mapper: debug

*  此配置会将sql和结果输出到控制台中，sql并不会输出到日志中。

mybatis-plus:
      # 配置MyBatis日志
      configuration:
         log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

控制台sql和结果  
![在这里插入图片描述][7b20a4fb4bf1404991ded168da36c1a6.png]

*  此配置会将sql输出到日志和控制台中（输出的只有sql并没有返回的结果）

logging:
     # 加载lockback-spring.xml配置文件
     config: classpath:lockback-spring.xml
     level:
     	com.XXX.mapper: debug
    mybatis-plus:
      # 配置MyBatis日志
      configuration:
         log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl

![在这里插入图片描述][c3b79ee5a0d6442f9cac46c40ede886c.png]  
![在这里插入图片描述][0148a0fbdd2c4e8586f05193f071c369.png]

[springboot Druid中使用log4j2进行日志输出][springboot Druid_log4j2]  
[SpringBoot环境日志配置，logback配置（支持mybatis、mybatis-plus生成的SQL语句打印）][SpringBoot_logback_mybatis_mybatis-plus_SQL]  
[SpringBoot之Logback日志文件配置 ][SpringBoot_Logback_]

[lockback]: https://gitee.com/wl8888/controller.git
[SpringBoot]: https://blog.csdn.net/weixin_43811057/article/details/115054888?spm=1001.2014.3001.5501
[f08a8e602c2c46b280481ecce814d5d2.png]: https://img-blog.csdnimg.cn/f08a8e602c2c46b280481ecce814d5d2.png
[7b20a4fb4bf1404991ded168da36c1a6.png]: https://img-blog.csdnimg.cn/7b20a4fb4bf1404991ded168da36c1a6.png
[c3b79ee5a0d6442f9cac46c40ede886c.png]: https://img-blog.csdnimg.cn/c3b79ee5a0d6442f9cac46c40ede886c.png
[0148a0fbdd2c4e8586f05193f071c369.png]: https://img-blog.csdnimg.cn/0148a0fbdd2c4e8586f05193f071c369.png
[springboot Druid_log4j2]: https://blog.csdn.net/evalsys/article/details/81031657
[SpringBoot_logback_mybatis_mybatis-plus_SQL]: https://lawsssscat.blog.csdn.net/article/details/105494387?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2~default~CTRLIST~default-1.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~CTRLIST~default-1.pc_relevant_default&utm_relevant_index=2
[SpringBoot_Logback_]: https://www.cnblogs.com/liftsail/p/16652258.html