Question

mybatis怎么配置log4j打印出sql语句

Answer 1

1. log4j的基础配置你那边应该有了，下面是sql的输出配置

2. ##格式化输出sql执行过程
   log4j.logger.java.sql.ResultSet=INFO  
   log4j.logger.org.apache=INFO  
   log4j.logger.java.sql.Connection=DEBUG  
   log4j.logger.java.sql.Statement=DEBUG  
   log4j.logger.java.sql.PreparedStatement=DEBUG

Answer 2

ibatis:

log4j.rootLogger=debug, stdout, logfile

log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG

log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG

log4j.logger.org.springframework=ERROR
log4j.logger.org.compass=ERROR

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=empi.log

Answer 3

把配置文件里面的针对package定义日志级别定义为debug模式，简单的说就是将你看到的warn修改为debug