Mybatis 打印SQL

Log4j.xml

<?xml version="1.0" encoding="UTF-8"?>
<!--
 - Copyright 1999-2011 Alibaba Group.
 -  
 - Licensed under the Apache License, Version 2.0 (the "License");
 - you may not use this file except in compliance with the License.
 - You may obtain a copy of the License at
 -  
 -      http://www.apache.org/licenses/LICENSE-2.0
 -  
 - Unless required by applicable law or agreed to in writing, software
 - distributed under the License is distributed on an "AS IS" BASIS,
 - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 - See the License for the specific language governing permissions and
 - limitations under the License.
-->
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="[%d{dd/MM/yy hh:mm:ss:sss z}] %t %5p %c{2}: %m%n" />
        </layout>
    </appender>
    <appender name="MYBATIS" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d %p [%c] - %m%n" />
        </layout>
    </appender>
    <logger name="log4j.logger.com.ibatis" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.com.ibatis.common.jdbc.SimpleDataSource" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.com.ibatis.common.jdbc.ScriptRunner" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.java.sql.Connection" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.java.sql.Statement" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <logger name="log4j.logger.java.sql.PreparedStatement" additivity="false">
        <level value="DEBUG" />
        <appender-ref ref="MYBATIS" />
    </logger>
    <root>
        <level value="INFO" />
        <appender-ref ref="CONSOLE" />
        <appender-ref ref="MYBATIS"  />
    </root>
</log4j:configuration>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值