SpringBoot 如何保存日志,控制台打印sql,完整教程展示

港控/mmm° 2022-10-27 13:50 6阅读 0赞

### 本期介绍的是SpringBoot项目如何配置日志完整教程 ###

*   *  1.pom.xml引入日志依赖
     *  2.在resources目录下新建xml文件
     *  3.配置application.yml/properties添加以下代码(二选一)
     *  4.效果展示

## 1.pom.xml引入日志依赖 ##

## 2.在resources目录下新建xml文件 ##

logback-spring.xml(ps:文件名可随意),如图所示  
![在这里插入图片描述][20210204155636563.png]  
粘贴如下配置信息:

<?xml version="1.0" encoding="UTF-8"?>
    <configuration>
        
        
        
        <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
            <encoder>
                <pattern>%d  %p (%file:%line\)- %m%n</pattern>
                
                <charset>UTF-8</charset>
            </encoder>
        </appender>
        
        
        
        <appender name="demolog" class="ch.qos.logback.core.rolling.RollingFileAppender">
            <File>log/demo.log</File>
            
            
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                
                
                <fileNamePattern>log/demo.%d.%i.log</fileNamePattern>
                
                <maxHistory>30</maxHistory>
                <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
                    
                    <maxFileSize>10MB</maxFileSize>
                </timeBasedFileNamingAndTriggeringPolicy>
            </rollingPolicy>
            <encoder>
                
                <pattern>
                    %d %p (%file:%line\)- %m%n
                </pattern>
                
                <charset>UTF-8</charset>
            </encoder>
        </appender>
        
        <root level="info">
            <appender-ref ref="STDOUT" />
        </root>
        
        
        
        <logger name="com.zqy.mybatis.mapper" level="DEBUG">
            <appender-ref ref="demolog" />
        </logger>
    </configuration>

## 3.配置application.yml/properties添加以下代码(二选一) ##

1.application.yml 配置

logging:
      level:
        com.zqy.mybatis.mapper: debug
      config: classpath:logback-spring.xml

2.application.properties配置

logging.level.com.zqy.mybatis.mapper=DEBUG //其中com.zqy.mybatis.mapper为项目mapper接口的路径
    logging.config=classpath:logback-spring.xml

## 4.效果展示 ##

1.部分代码展示  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70]  
2.控制台日志信息如下:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70 1]  
3.日志文件记录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70 2]

[20210204155636563.png]: /images/20221024/4958fb45b7914c19bc778f5c00a7de12.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70]: /images/20221024/677f35c0c6814f57a1c18e5fc645f14a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70 1]: /images/20221024/3c2581b1a7214ea0b8a5ae10f277bb99.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk4MDExNg_size_16_color_FFFFFF_t_70 2]: /images/20221024/79c48c1a088b428d99ea7512cf8bbd6e.png