Spring mvc+mybatis+Log4j控制台打印sql语句

末蓝、 2022-05-28 11:16 334阅读 0赞

有时候不知道sql哪里出了问题，想打印出来看看生成的sql是啥样子。

1. 首先引入依赖

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