logback输出mybatis的sql配置

浏览数：716 / 时间：2015年06月12日

<?xml version="1.0" 
encoding="UTF-8"?>
<configuration>
    <appender name="console" 
class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
 
    <appender name="rollingFile" 
class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>${catalina.base}/logs/carmall-manager.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>${catalina.base}/logs/carmall-manager.%d{yyyy-MM-dd}.log</fileNamePattern>
        </rollingPolicy>
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
 
    <!-- project default 
level -->
    <logger name="cn.iautos.manager" 
level="debug" 
/>
 
    <!--log4jdbc -->
    <logger name="jdbc.sqltiming" 
level="debug"/>
    <logger name="com.ibatis" 
level="debug" 
/>
    <logger name="com.ibatis.common.jdbc.SimpleDataSource" 
level="debug" 
/>
    <logger name="com.ibatis.common.jdbc.ScriptRunner" 
level="debug" 
/>
    <logger name="com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate"
        level="debug" 
/>
    <logger name="java.sql.Connection" 
level="debug" 
/>
    <logger name="java.sql.Statement" 
level="debug" 
/>
    <logger name="java.sql.PreparedStatement" 
level="debug" 
/>
    <logger name="java.sql.ResultSet" 
level="debug" 
/>
    <root level="info">
        <appender-ref ref="console" 
/>
        <appender-ref ref="cn.iautos.manager" 
/>
        <appender-ref ref="com.ibatis" 
/>
        <appender-ref ref="rollingFile" 
/>
    </root>
</configuration>