社区首页 >专栏 >【Log日志】打印mybatis中sql日志并存放到指定文件中

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

石臻臻的杂货铺[同名公众号]

发布于 2021-07-14 02:26:06

2.1K00

代码可运行

文章被收录于专栏：kafka专栏kafka专栏

运行总次数：0

代码可运行

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

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

<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%npattern>
		encoder>
	appender>


	<appender name="common" class="ch.qos.logback.core.rolling.RollingFileAppender">
		<file>${log.path}/common.logfile>
		
		<append>trueappend>
		
		<encoder>
			<pattern>${pattern}pattern>
		encoder>
		
		<filter class="ch.qos.logback.classic.filter.LevelFilter">
			<level>INFOlevel>
			<onMatch>ACCEPTonMatch>
			<onMismatch>DENYonMismatch>
		filter>
		
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${log.path}/common.log.%d{yyyy-MM-dd}fileNamePattern>
			
			<maxHistory>10maxHistory>
		rollingPolicy>
	appender>

	<appender name="exception" class="ch.qos.logback.core.rolling.RollingFileAppender">
		<file>${log.path}/exception.logfile>
		<append>trueappend>
		
		<filter class="ch.qos.logback.classic.filter.LevelFilter">
			<level>ERRORlevel>
			<onMatch>ACCEPTonMatch>
			<onMismatch>DENYonMismatch>
		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>7maxHistory>
		rollingPolicy>
	appender>


	<appender name="mysql_log" class="ch.qos.logback.core.rolling.RollingFileAppender">
		<file>${log.path}/mysql_log.logfile>
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			
			<FileNamePattern>${log.path}/mysql_log.log.%d{yyyy-MM-dd}FileNamePattern>
			
			<MaxHistory>7MaxHistory>
		rollingPolicy>
		<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
			<pattern>${pattern}pattern>
		encoder>
		<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
			<level>DEBUGlevel>
		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>

几个关键点

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

<logger name="com.xxx.mapper" level="DEBUG" additivity="false">
		<appender-ref ref="stdout"/>
		<appender-ref ref="mysql_log" />
	logger>

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