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.ConsoleAppenderlog4j.appender.console.Target = System.outlog4j.appender.console.layout = org.apache.log4j.PatternLayoutlog4j.appender.console.layout.ConversionPattern =  %d{ABSOLUTE} %5p %c{1}:%L - %m%n#日志文件输出log4j.appender.file = org.apache.log4j.DailyRollingFileAppenderlog4j.appender.file.File = /home/plantformManager.loglog4j.appender.file.Append = truelog4j.appender.file.layout = org.apache.log4j.PatternLayoutlog4j.appender.file.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss}  [ %t\:%r ] - [ %p ]  %m%nlog4j.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=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUGlog4j.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" /> 

非常重要