配置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 configuration
PUBLIC "-//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>