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>
更多推荐
0
0- 0
已为社区贡献2条内容
所有评论(0)