mybatis输出sql语句

来源：互联网发布：淘宝主图视频pr 编辑：程序博客网时间：2024/05/29 19:05

1、jar包配置，log4j.jar,slf4j-log4j.jar,slf4j.jar，jar包的版本依据项目的具体信息而不同。

2、log4j.properties配置，注意红色字体的几行配置

log4j.rootLogger=INFO, logfile, CONSOLE
#log4j.logger.org.springframework=WARN
#log4j.logger.org.mybatis.spring=WARN

log4j.logger.org.apache.ibatis=info,stdout
log4j.logger.java.sql=debug,stdout
#log4jdbc sql and execute time
log4j.logger.jdbc.sqltiming=INFO
#sql only
log4j.logger.jdbc.sqlonly=DEBUG

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.DatePattern='.'yyyy-MM-dd
log4j.appender.CONSOLE.layout.ConversionPattern=%d [%t] %-5p - %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=${Mis.root}/WEB-INF/logs/mis.log
log4j.appender.logfile.MaxFileSize=10MB
log4j.appender.logfile.MaxBackupIndex=10
log4j.appender.logfile.DatePattern='.'yyyy-MM-dd
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d{dd-MM-yy HH:mm:ss:SSS} - {%p} %c{2} Thread [%t]; %x %m%n

0 0