mybatis打印sql log4j的两种配置方式

最新推荐文章于 2024-07-26 21:37:59 发布

cash199110

最新推荐文章于 2024-07-26 21:37:59 发布

阅读量2.5k

点赞数

本文链接：https://blog.csdn.net/cash199110/article/details/78890753

版权

1.properties文件

log4j.rootLogger=debug

log4j.logger.java.sql.Connection=debug    
log4j.logger.java.sql.Statement = debug    
log4j.logger.java.sql.PreparedStatement = debug    
log4j.logger.java.sql.ResultSet =debug

2.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

	<!-- Appenders -->
	<appender name="console" class="org.apache.log4j.ConsoleAppender">
		<param name="Target" value="System.out" />
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%5p [%t] %d [%c] (line %L) - %m%n" />
		</layout>
	</appender>

	<!-- system default log file -->
	<appender name="default" class="org.apache.log4j.RollingFileAppender">
		<param name="File" value="" />
		<param name="Append" value="true" />
        <param name="MaxFileSize" value="20MB" />
        <param name="MaxBackupIndex" value="50" />
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%5p [%t] %d{yy-MM-dd HH:mm:ss} %c{1} (line %L) - %m%n" />
		</layout>
	</appender>

	<!-- Application Loggers -->
	<logger name="org.springframework">
		<level value="debug" />
	</logger>
	<logger name="java.sql">  
        <level value="debug" />  
    </logger> 

	<!-- Root Logger -->
	<root>
		<priority value="debug" />
		<appender-ref ref="console" />
		<appender-ref ref="default" />
	</root>

</log4j:configuration>