如何在控制台打印出mybatis sql语句日志

来源：http://blog.youkuaiyun.com/wdq892157341/article/details/50836190

1.首先配置 log4j日志文件 

[html]  view plain  copy

1. #mybatis日志范围  
2. log4j.logger.com.nes=TRACE  
3. #ibatis配置  
4. log4j.logger.com.ibatis=DEBUG    
5. log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG    
6. log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG    
7. log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG    
8. log4j.logger.org.mybatis=DEBUG    
9. log4j.logger.java.sql.Connection=DEBUG    
10. log4j.logger.java.sql.Statement=DEBUG    
11. log4j.logger.java.sql.PreparedStatement=DEBUG    
12. log4j.logger.java.sql.ResultSet=DEBUG    

2.导入依赖日志包 log4j

[html]  view plain  copy

 

1. <!-- SLFJ 可依赖到log4j-->  
2. <dependency>  
3.     <groupId>org.slf4j</groupId>  
4.      <artifactId>slf4j-log4j12</artifactId>  
5.     <version>1.6.4</version>  
6. </dependency>  
7. <dependency>    
8.     <groupId>log4j</groupId>    
9.     <artifactId>log4j</artifactId>    
10.     <version>1.2.14</version>    
11. </dependency>    
12. <dependency>    
13.        <groupId>org.slf4j</groupId>    
14.       <artifactId>slf4j-api</artifactId>    
15.        <version>1.7.7</version>    
16. </dependency>