ssm打印sql如何开启_ssm打印sql语句

1、引用log4j-1.2.17.jar

2、在src下放入log4j.properties文件

内容为

log4j.rootLogger=DEBUG,CONSOLE,FILEOUT

log4j.addivity.org.apache=true

# CONSOLE \u6253\u5370\u5230\u63A7\u5236\u53F0

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

log4j.appender.Threshold=DEBUG

log4j.appender.CONSOLE.Target=System.out

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

log4j.appender.CONSOLE.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH\:mm\:ss} \:%m%n

#

# FILEOUT \u6253\u5370\u5230 D\:\\report.log

log4j.appender.FILEOUT=org.apache.log4j.RollingFileAppender

log4j.appender.FILEOUT.File=D\:\\report.log

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

log4j.appender.fileout.MaxFileSize=100000KB

log4j.appender.FILEOUT.Append=true

#log4j.appender.CONSOLE.layout.ConversionPattern=[framework] %d \u2013 %c -%-4r [%t] %-5p %c %x \u2013 %m%n

log4j.appender.FILEOUT.layout.ConversionPattern=[%-5p]_%d{yyyy-MM-dd HH\:mm\:ss} \:%m%n

3、web.xml加入下列语句

log4jConfigLocation

classpath:log4j.properties

log4jRefreshInterval

60000

org.springframework.web.util.Log4jConfigListener