打印mapper.xml中执行的sql语句

1.在mybatis-config.xml中添加（PS:注意元素的顺序）

<settings>

<setting name="logImpl" value="LOG4J"/>

</settings>

2.在log4j.PRoperties中添加一下代码：

log4j.rootLogger=DEBUG,A1,R

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.appender.A1=org.apache.log4j.ConsoleAppender

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

log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%n

log4j.appender.R=org.apache.log4j.DailyRollingFileAppender

log4j.appender.R.File=${catalina.home}/logs/my.log

log4j.appender.R.MaxFileSize=500KB

log4j.appender.R.MaxBackupIndex=10

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

log4j.appender.R.layout.ConversionPattern=%d{yyyy-MM-dd HH/:mm/:ss,SSS} [%t] [%c] [%p] - %m%n

效果如图：