springBoot配置logback，在控制台打印mybatis的sql日志，yml配置

灰太狼 2021-05-05 03:30 1669阅读 0赞

## 1.在application.yml中配置 ##

logging:
      level:
        com.baomidou.mybatisplus.samples: debug
      config: classpath:logback-boot.xml

其中com.baomidou.mybatisplus.samples是你的dao或者是mapper包，debug是级别，

## logback-boot.xml ##

<?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>1KB</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.wyu.itblog.article.mapper" level="DEBUG">
            <appender-ref ref="demolog" />
        </logger>
    </configuration>

## 最后的效果如下： ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70]: /images/20210505/2e1b5fd729a3472eadd74a79589e8a3c.png