【Log日志】打印mybatis中sql日志并存放到指定文件中

浅浅的花香味﹌ 2022-12-17 02:29 385阅读 0赞

## 打印mybatis中sql日志并存放到指定文件中 ##

**`logback-spring.xml`** (如果是logbackx.xml 动态路径会失效)

<?xml version="1.0" encoding="UTF-8"?>
    <configuration>
    
    	
    	<property name="pattern" value="%d{yyyy-MM-dd HH:mm:ss} %c{1} %L [%p] %m%n %caller{0}"/>
    
    	
    	<springProperty scope="context" name="log.path" source="log.path"/>
    
    	
    	<appender name="stdout" class="ch.qos.logback.core.ConsoleAppender">
    		<encoder charset="UTF-8">
    			
    			<pattern>%d{yyyy-MM-dd HH:mm:ss} %-5level %logger{50} >>> %msg%n</pattern>
    		</encoder>
    	</appender>
    
    
    	<appender name="common" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		<file>${log.path}/common.log</file>
    		
    		<append>true</append>
    		
    		<encoder>
    			<pattern>${pattern}</pattern>
    		</encoder>
    		
    		<filter class="ch.qos.logback.classic.filter.LevelFilter">
    			<level>INFO</level>
    			<onMatch>ACCEPT</onMatch>
    			<onMismatch>DENY</onMismatch>
    		</filter>
    		
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			<fileNamePattern>${log.path}/common.log.%d{yyyy-MM-dd}</fileNamePattern>
    			
    			<maxHistory>10</maxHistory>
    		</rollingPolicy>
    	</appender>
    
    	<appender name="exception" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		<file>${log.path}/exception.log</file>
    		<append>true</append>
    		
    		<filter class="ch.qos.logback.classic.filter.LevelFilter">
    			<level>ERROR</level>
    			<onMatch>ACCEPT</onMatch>
    			<onMismatch>DENY</onMismatch>
    		</filter>
    		<encoder>
    			<pattern>${pattern}</pattern>
    		</encoder>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			<fileNamePattern>${log.path}/exception.log.%d{yyyy-MM-dd}</fileNamePattern>
    			<maxHistory>7</maxHistory>
    		</rollingPolicy>
    	</appender>
    
    
    	<appender name="mysql_log" class="ch.qos.logback.core.rolling.RollingFileAppender">
    		<file>${log.path}/mysql_log.log</file>
    		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
    			
    			<FileNamePattern>${log.path}/mysql_log.log.%d{yyyy-MM-dd}</FileNamePattern>
    			
    			<MaxHistory>7</MaxHistory>
    		</rollingPolicy>
    		<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
    			<pattern>${pattern}</pattern>
    		</encoder>
    		<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
    			<level>DEBUG</level>
    		</filter>
    	</appender>
    
    
    
    	
    	<logger name="com.xxx.mapper" level="DEBUG" additivity="false">
    		<appender-ref ref="stdout"/>
    		<appender-ref ref="mysql_log" />
    	</logger>
    
    
    	
    
    
    	
    	<root level="INFO">
    		<appender-ref ref="stdout"/>
    		<appender-ref ref="common"/>
    		<appender-ref ref="exception"/>
    	</root>
    </configuration>

**几个关键点**

1.  文件名需要为`logback-spring.xml`; 动态日志路径才会生效; 属性文件中配置 `log.path=xxx`;  
    [【Log日志】logback.xml动态配置属性值(包括接入的第三方配置)][Log_logback.xml]
2.  levle 需要是DEBUG等级; 因为sql日志是DEBUG等级的；name= 存放mapper文件的包路径

1.  mybatis的log-impl需要配置正确的实现类 比如 在maybatis-plus中

# 这个配置会将执行的sql打印出来，在开发或测试的时候可以用
    mybatis-plus:
    	configuration:
    	    #log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    	    # 这个配置会将执行的sql打印出来，这个可以存放在文件中 StdOutImpl的是只能打印到控制台
    	    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl

我之前就是一直配置的是 `log-impl: org.apache.ibatis.logging.stdout.StdOutImpl` ;导致文件只能出现在控制台；却没有打印到文件中;

1.  参数值的默认值设置  
    如果配置文件没有设置属性. 可以在使用的地方设置默认值 例如 `${log.path:-默认值}`

--------------------

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

[Log_logback.xml]: https://blog.csdn.net/u010634066/article/details/109185676
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTA2MzQwNjY_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/46edd0c49d2e4bf9ab04569c7e5e7f70.png