配置mybatis解决log4j未正常打印sql的问题

log4j版本：log4j-1.2.16.jar

mybatis版本：mybatis-3.4.4.jar

log4j.properties

#--------------------------------   #  log4j.rootLogger=INFO, stdout  #log4j.logger.test=info  #log4j.logger.org.apache.jasper = DEBUG  #log4j.logger.org.apache.catalina.startup.TldConfig = DEBUG  #log4j.logger.org.apache.catalina.session.ManagerBase = DEBUG    #log4j.logger.com.fiscal = DEBUG  #log4j.logger.com.system = DEBUG    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.logger.java.sql.ResultSet = INFO    log4j.appender.stdout=org.apache.log4j.ConsoleAppender     #log4j.appender.fileout=org.apache.log4j.RollingFileAppender  #log4j.appender.fileout.File=e:/log/ibatis.log   #log4j.appender.fileout.MaxFileSize=10000KB   log4j.appender.stdout.layout=org.apache.log4j.PatternLayout   #log4j.appender.stdout.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss} :%m%n   #log4j.appender.fileout.layout=org.apache.log4j.PatternLayout   #log4j.appender.fileout.layout.ConversionPattern=[%-5p]_%d{yyyy-MM-dd HH:mm:ss} :%m%n    #log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout     # log4j.logger.org=info 

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><properties resource="jdbc.properties"/><typeAliases><package name="itat.zttc.shop.model"/></typeAliases><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="${driver}"/><property name="url" value="${url}"/><property name="username" value="${username}"/><property name="password" value="${password}"/></dataSource></environment></environments><mappers><mapper resource="itat/zttc/shop/model/User.xml"/><mapper resource="itat/zttc/shop/model/Address.xml"/><mapper resource="itat/zttc/shop/model/Category.xml"/><mapper resource="itat/zttc/shop/model/Product.xml"/><mapper resource="itat/zttc/shop/model/CartProduct.xml"/><mapper resource="itat/zttc/shop/model/Orders.xml"/></mappers></configuration>

以上配置，控制台未能正常打印出sql，需要在mybatis-config.xml中增加配置：

<settings> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings>