logback打印原生态sql的配置

maven pom.xml配置

<!-- Logger -->

        <dependency>

            <groupId>ch.qos.logback</groupId>

            <artifactId>logback-classic</artifactId>

            <version>1.0.7</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <version>1.6.4</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-log4j12</artifactId>

            <version>1.6.4</version>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>jcl-over-slf4j</artifactId>

            <version>1.6.4</version>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>log4j</groupId>

            <artifactId>log4j</artifactId>

            <version>1.2.16</version>

            <scope>runtime</scope>

        </dependency>

logback 打印spring jdbcTemplate SQL日志：

<!--JdbcTemplate的日志输出器 -->

    <logger name="org.springframework.jdbc.core.StatementCreatorUtils"

        additivity="false" level="TRACE">

        <appender-ref ref="STDOUT" />

    </logger>

    <logger name="org.springframework.jdbc.core" additivity="true">

        <level value="DEBUG" />

        <appender-ref ref="STDOUT" />

    </logger>

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

        <level value="DEBUG" />

        <appender-ref ref="STDOUT" />

    </logger>

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

        <level value="DEBUG" />

        <appender-ref ref="STDOUT" />

    </logger>

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

        <level value="DEBUG" />

        <appender-ref ref="STDOUT" />

    </logger>

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

        <level value="DEBUG" />

        <appender-ref ref="STDOUT" />

    </logger>

更多最佳实践技术文章