<!-- 打印sql start -->

    <appender name="IBatis" class="org.apache.log4j.ConsoleAppender">

        <layout class="org.apache.log4j.PatternLayout">

            <param name="ConversionPattern" value="%-4r

        [%t] %-5p %c %x - %m%n" />

        </layout>

        <filter class="org.apache.log4j.varia.LevelRangeFilter">

            <param name="LevelMin" value="DEBUG" />

            <param name="LevelMax" value="DEBUG" />

        </filter>

    </appender>

    <logger name="com.ibatis" additivity="true">

        <level value="DEBUG" />

    </logger>

    <logger name="java.sql.Connection" additivity="true">

        <level value="DEBUG" />

    </logger>

    <logger name="java.sql.Statement" additivity="true">

        <level value="DEBUG" />

    </logger>

    <logger name="java.sql.PreparedStatement" additivity="true">

        <level value="DEBUG" />

        <appender-ref ref="IBatis" />

    </logger>

    <logger name="java.sql.ResultSet" additivity="true">

        <level value="DEBUG" />

        <appender-ref ref="IBatis" />

    </logger>

    <!-- 打印sql end -->