mybatis输出sql语句

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