mybatis+log4j+springMvc 打印sql语句到控制台

具体log4j.PRoperties.配置 如下:

# Output pattern : date [thread] priority category - message   FATAL 0  ERROR 3  WARN 4  INFO 6  DEBUG 7 log4j.rootLogger=DEBUG, Console, RollingFile#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d %-5p [%c{5}] - %m%n#--------打印sql语句--------------------# #/u9996/u5148/u5C06rootLogger/u7EA7/u522B/u66F4/u6539/u4E3ADEBUG#1 /u5B9A/u4E49/u65E5/u5FD7/u8F93/u51FA/u76EE/u7684/u5730/u4E3A/u63A7/u5236/u53F0#/u63A7/u5236/u53F0/u6253/u5370sql/u8BED/u53E5log4j.appender.Console.Target = System.outlog4j.appender.Console.Threshold=DEBUG# mybatis /u663E/u793ASQL/u8BED/u53E5/u90E8/u5206log4j.logger.org.mybatis=DEBUGlog4j.logger.java.sql=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.ResultSet=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG#--------------------------##RollingFilelog4j.appender.RollingFile=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.RollingFile.File=../logs/eoms/eoms.loglog4j.appender.RollingFile.layout=org.apache.log4j.PatternLayoutlog4j.appender.RollingFile.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n#log4j.logger.java.sql=DEBUG#Springframework level#log4j.logger.org.springframework=ERROR#Hibernate level#log4j.logger.org.hibernate=ERROR#log4j.logger.org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory=ERROR#log4j.logger.org.hibernate.search.impl.ConfigContext=ERROR#log4j.logger.net.sf.ehcache.config.CacheConfiguration=ERROR#Project defalult level#log4j.logger.org.activiti.engine.impl.persistence=DEBUG#log4j.logger.org.apache.shiro=DEBUGlog4j.logger.com.thinkgem.jeesite=DEBUGlog4j.logger.com.thinkgem.jeesite.common.security.shiro=WARNlog4j.logger.JedisUtils=WARNlog4j.logger.LoginController=WARNlog4j.logger.OaNotifyDao.findCount=WARN

注意 要将log4j.rootLogger级别更改为debug