springmvc 日志打印sql_Mybatis+SpringMVC打印纯SQL日志

web.xml

-------------------------------------------------------------------

log4jConfigLocation

classpath:log4j.properties

log4jRefreshInterval

60000

org.springframework.web.util.Log4jConfigListener

log4j.properties

--------------------------------------------------------------------

# 设置根路径打印级别为debug

log4j.rootLogger=debug, Console

# 定义appender

log4j.appender.Console=org.apache.log4j.ConsoleAppender

log4j.appender.Console.layout=org.apache.log4j.PatternLayout

log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n

# 过滤掉不必要的日志(控制台打印出的多余日志的包路径)

log4j.logger.org.apache=error

log4j.logger.org.springframework=error

log4j.logger.org.mybatis.spring=error

log4j.logger.net.sf=error

log4j.logger.com.alibaba.druid=error

# 打印出sql语句相关日志

log4j.logger.java.sql.ResultSet=error

log4j.logger.java.sql.Connection=error

log4j.logger.java.sql.Statement=debug

log4j.logger.java.sql.PreparedStatement=debug