Spring mvc+mybatis+Log4j控制台打印sql语句 末蓝、 2022-05-28 11:16 340阅读 0赞 有时候不知道sql哪里出了问题,想打印出来看看生成的sql是啥样子。 1. 首先引入依赖 <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.7</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.7.7</version> </dependency> 2.src同级或者maven项目中的resource中创建log4j.properties并配置以下信息,rootLogger中设下DEBUG log4j.rootLogger=DEBUG,info, console, log, error ###Console ### log4j.appender.console = org.apache.log4j.ConsoleAppender log4j.appender.console.Target = System.out log4j.appender.console.layout = org.apache.log4j.PatternLayout log4j.appender.console.layout.ConversionPattern = %d %p[%C:%L]- %m%n ### log ### log4j.appender.log = org.apache.log4j.DailyRollingFileAppender log4j.appender.log.File = ${catalina.base}/logs/debug.log log4j.appender.log.Append = true log4j.appender.log.Threshold = DEBUG log4j.appender.log.DatePattern='.'yyyy-MM-dd log4j.appender.log.layout = org.apache.log4j.PatternLayout log4j.appender.log.layout.ConversionPattern = %d %p[%c:%L] - %m%n ### Error ### log4j.appender.error = org.apache.log4j.DailyRollingFileAppender log4j.appender.error.File = ${catalina.base}/logs/error.log log4j.appender.error.Append = true log4j.appender.error.Threshold = ERROR log4j.appender.error.DatePattern='.'yyyy-MM-dd log4j.appender.error.layout = org.apache.log4j.PatternLayout log4j.appender.error.layout.ConversionPattern =%d %p[%c:%L] - %m%n ###\u8F93\u51FASQL log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG log4j.logger.com.pro.mapper = DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG 3.web.xml中配置log4j <listener> <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> </listener> 4.在控制台中可以看到打印出的sql信息![70][] [70]: /images/20220528/3cb59d225e6944f0999946a99e4b3f5c.png
还没有评论,来说两句吧...