mybatis在控制台打印sql语句

最新推荐文章于 2021-02-06 10:53:17 发布

慕安凉

最新推荐文章于 2021-02-06 10:53:17 发布

阅读量338

点赞数

分类专栏： Mybatis

本文链接：https://blog.csdn.net/lsq_401/article/details/49869423

版权

Mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

<span style="font-size:18px;"><?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration>
	<appender name="<span style="color:#ff0000;">CONSOLE</span>" class="org.apache.log4j.ConsoleAppender">
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%d - %c -%-4r [%t] %-5p %x - %m%n" />
		</layout>
		<!--限制输出级别 -->
		<filter class="org.apache.log4j.varia.LevelRangeFilter">
			<param name="LevelMax" value="DEBUG" />
			<param name="LevelMin" value="DEBUG" />
		</filter>
	</appender>
 
    <logger name="org.apache.ibatis" additivity="true">
        <level value="DEBUG" />
        <appender-ref ref="<span style="color:#ff0000;">CONSOLE</span>" />
 
    </logger>
 
    <logger name="java.sql.Connection" additivity="true">
        <level value="DEBUG"/>
        <appender-ref ref="<span style="color:#ff0000;">CONSOLE</span>" />
 
    </logger>
    <logger name="java.sql.Statement" additivity="true">
        <level value="DEBUG" />
        <appender-ref ref="<span style="color:#ff0000;">CONSOLE</span>" />
 
    </logger>
    <logger name="java.sql.PreparedStatement" additivity="true">
        <level value="DEBUG" />
        <appender-ref ref="<span style="color:#ff0000;">CONSOLE</span>" />
    </logger>
  <logger name="java.sql.ResultSet" additivity="true">
       <level value="DEBUG" />
       <appender-ref ref="<span style="color:#ff0000;">CONSOLE</span>"
    </logger>
    
	<root>
		<priority value="DEBUG" />
		<appender-ref ref="CONSOLE" />
		<appender-ref ref="FILE" />
	</root>
</log4j:configuration>  </span>

PS:注意红色的地方一定要保持一致