logback输出mybatis的sql配置

2023-10-20 19:55:52
<?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>
码农公寓

相关文章
