SpringBoot mybatis 输出SQL语句到控制台

深藏阁楼爱情的钟 2023-03-01 05:47 120阅读 0赞

配置文件 .yml中如下配置:

logging:
      level:
        com.muyan.mapper: debug #打印sql
      config: classpath:logback.xml

logging标识配置日志

level:

xxx.xx.mapper：debug 对应的package开启日志输出

config 日志的配置使用classpath 下面的logback.xml

logback.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <configuration debug="true" scan="true" scanPeriod="30 seconds">
    	<contextName>commons</contextName>
    	<property resource="logback.properties" />
      
    	<appender name="ROLLING" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		<prudent>false</prudent>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			<fileNamePattern>${file.dir}/${file.name}.%d{yyyy-MM-dd}.${file.ext}
    			</fileNamePattern>
    			<maxHistory>30</maxHistory>
    		</rollingPolicy>
    		<encoder>
    			<pattern>%date %-5level %logger - %message%n 
    			</pattern>
    		</encoder>
    	</appender>
    
    	
    	<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
    		 <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
                
                <pattern>%d{HH:mm:ss.SSS} %-5level %logger{50} - %msg%n</pattern>
            </encoder>
    	</appender>
    
        <logger name="com.apache.ibatis" level="DEBUG"/>
    
    	<root level="INFO">
    		<appender-ref ref="ROLLING" />
    		
    		<appender-ref ref="STDOUT" />
    	</root>
    </configuration>

控制台输出信息如下:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhdG91bmlhbzE_size_16_color_FFFFFF_t_70][]

logback.properties配置如下：

file.dir=/home/tmp  
file.name=commons  
file.ext=log

目录结构：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhdG91bmlhbzE_size_16_color_FFFFFF_t_70 1][]

希望对你有所帮助

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhdG91bmlhbzE_size_16_color_FFFFFF_t_70]: /images/20230209/d155fc8f7e584c20a26a5ac8e0defb7b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhdG91bmlhbzE_size_16_color_FFFFFF_t_70 1]: /images/20230209/b491e32f0bd4485886f9f2559191ca8a.png