SpringMVC+Mybatis+log4g打印sqlyu

1、首先，在web.xml配置

 <context-param>
        <param-name>log4jConfigLocation</param-name>
        <param-value>classpath:config/log4j.properties</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    </listener>

2、在config建立 log4j.properties 文件

log4j.rootLogger = INFO,console,file

#控制台输出
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern =  %d{ABSOLUTE} %5p %c{1}:%L - %m%n

#日志文件输出
log4j.appender.file = org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.File = /home/plantformManager.log
log4j.appender.file.Append = true
log4j.appender.file.layout = org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss}  [ %t\:%r ] - [ %p ]  %m%n
log4j.appender.file.Threshold = INFO
#log4j.appender.file.Threshold = DEBUG


###显示SQL语句部分
log4j.logger.com.mybatis=DEBUG  
log4j.logger.com.mybatis.common.jdbc.SimpleDataSource=DEBUG  
log4j.logger.com.mybatis.common.jdbc.ScriptRunner=DEBUG  
log4j.logger.com.mybatis.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

#配置要打印的mapper接口(com.excemple.mapper.TestMapper为我的mapper)
log4j.logger.com.excemple.mapper.TestMapper=TRACE

3、配置Mybatis-config.xml

<configuration>
   <properties>  
        <property name="dialect" value="mysql" />  
   </properties>  
   <settings>  
        <setting name="logImpl" value="LOG4J" />    
   </settings>  
</configuration>

其中

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

非常重要