springboot+mybatisPlus logback输出sql到文件

核心配置

logging.level.com.xx.xx.xx.mapper=debug
logging.level.org.apache.ibatis.logging=debug  
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.slf4j.Slf4jImpl

之前配置的是org.apache.ibatis.logging.stdout.StdOutImpl就只会在控制台窗口打印，不会记录到日志文件

 logback-spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <!--<include resource="org/springframework/boot/logging/logback/base.xml"/>-->
    <conversionRule conversionWord="clr" converterClass="org.springframework.boot.logging.logback.ColorConverter"/>
    <springProperty scope="context" name="appName" source="xx.application.name" defaultValue="YourProjectName"/>
    <springProperty scope="context" name="logFolder" source="xx.project.log.folder" defaultValue="/usr/logs"/>

    <logger name="org.springframework" level="INFO"/>
    <logger name="org.apache" level="INFO"/>

    <!-- 将所有日志记录到文件中 -->
    <appender name="allFile" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <File>${logFolder}/${appName}.log</File>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <FileNamePattern>${logFolder}/${appName}.%d{yyyy-MM-dd}.log</FileNamePattern>
            <maxHistory>30</maxHistory>
        </rollingPolicy>
        <encoder>
            <Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} %-5level --- [ %thread ] %logger{80}:%method\(%line\) - %msg %n
            </Pattern>
        </encoder>
    </appender>

    <!-- 将所有日志记录到elk中 -->
    <appender name="stash"
              class="net.logstash.logback.appender.LogstashTcpSocketAppender"> <!-- logstash 部署机的 IP 以及监听的端口 -->
        <destination>10.1.135.126:4045</destination>
        <includeCallerData>true</includeCallerData>
        <encoder class="net.logstash.logback.encoder.LogstashEncoder">
            <includeCallerData>true</includeCallerData>
        </encoder>
    </appender>

    <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <Pattern>%clr(%d{yyyy-MM-dd HH:mm:ss.SSS}) %clr(%-5level) --- [ %thread ]
                %clr(%logger{80}:%method\(%line\)) - %msg %n
            </Pattern>
        </encoder>
    </appender>

    <springProfile name="dev">
        <root level="INFO">
            <appender-ref ref="console"/>
            <appender-ref ref="stash"/>
            <appender-ref ref="allFile"/>
        </root>
    </springProfile>

    <springProfile name="!dev">
        <root level="INFO">
            <appender-ref ref="console"/>
            <appender-ref ref="allFile"/>
            <appender-ref ref="stash"/>
        </root>
    </springProfile>
</configuration>