mybatis打印sql语句到控制台

mybatis打印sql语句到控制台

今天因为mybatis的查询效果和预期有所不同，所以要看运行过程中的sql语句
具体配置如下
其中主要是logImpl选择log4j

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="cacheEnabled" value="false" />
        <setting name="lazyLoadingEnabled" value="false" />
        <setting name="useGeneratedKeys" value="true" />
        <setting name="logImpl" value="LOG4J" />
    </settings>
</configuration>
log4j的属性文件如下
```xml
log4j.rootLogger=INFO,console,file
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%-5p] %d %37c %3x - %m%n
log4j.appender.file=org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.Threshold = ERROR
log4j.appender.file.DatePattern='-'yyyy-MM-dd
log4j.appender.file.File=e:/log/MicroMessagempmenu.log
log4j.appender.file.Append=true
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%-5p] %d %37c %3x - %m%n
log4j.logger.com.zbej.ehome.mybatis.dao=TRACE

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.org.mybatis=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.com.zbej.ehome.mybatis.dao=TRACE这一个必须要配置
具体可以看http://www.mybatis.org/mybatis-3/zh/logging.html