配置MyBatis log4j.xml 文件后，无法在控制台输出insert,update,delete等sql语句，只显示select语句

log4j.xml配置如下：
[code="java"]
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<!-- Console output -->















/log4j:configuration
[/code]

直接放在src根目录下.
这是我得整个日志文件内容

Rules reminder:

DEBUG < INFO < WARN < ERROR < FATAL

Global logging configuration

log4j.rootLogger=ERROR, stdout,RollingFile

My logging configuration...

log4j.logger.com.baoku=DEBUG
log4j.logger.org.apache.ibatis=ERROR
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%n

#mybatis logger config
log4j.logger.com.ibatis=ERROR
log4j.logger.org.apache.ibatis.jdbc.ScriptRunner=ERROR
log4j.logger.java.sql.Connection=DEBUG
#log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG,stdout

#RollingFile
log4j.appender.RollingFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.RollingFile.File=logs/new-crm.log
log4j.appender.RollingFile.layout=org.apache.log4j.PatternLayout
log4j.appender.RollingFile.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n

所需jar包
--slf4j-api-1.6.4.jar
--slf4j-log4j12-1.6.4.jar
--log4jdbc3-1.2beta2.jar
--commons-logging-1.1.1.jar
--log4j-1.2.16.jar
你试试看能不能行.

[code="java"]01.<?xml version="1.0" encoding="UTF-8" ?>

02.<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

03.

04.

05.

06. <!-- Console output -->

07.

08.

09.

10.

11.

12.

13.

14.

15.

16.

17.

18.

19.

20.

21.

22.

23.

24.

25./log4j:configuration

嘿嘿这样就ok了。
[/code]

我的可以啊.看下面的配置

#mybatis logger config
log4j.logger.com.ibatis=ERROR
log4j.logger.org.apache.ibatis.jdbc.ScriptRunner=ERROR
log4j.logger.java.sql.Connection=DEBUG
#log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG,stdout

控制台输出的日志信息

DEBUG 2011-12-30 12:28:21,154 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Executing: INSERT INTO air_order (air_order_no,companyNo,companyName,bookerName,bookerEmail,bookerMobile,createTime) VALUES (?,?,?,?,?,?,?);
DEBUG 2011-12-30 12:28:21,154 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Executing: INSERT INTO air_order (air_order_no,companyNo,companyName,bookerName,bookerEmail,bookerMobile,createTime) VALUES (?,?,?,?,?,?,?);
DEBUG 2011-12-30 12:28:21,155 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Parameters: WQF201112301228021(String), 10068(String), 测试公司(String), 测试(String), jackyhui@live.cn(String), 18911738137(String), 2011-12-30 12:28:21.038(Timestamp)
DEBUG 2011-12-30 12:28:21,155 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Parameters: WQF201112301228021(String), 10068(String), 测试公司(String), 测试(String), jackyhui@live.cn(String), 18911738137(String), 2011-12-30 12:28:21.038(Timestamp)
DEBUG 2011-12-30 12:28:21,173 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Executing: INSERT INTO air_segment(FROM_CODE,TO_CODE,air_order_no) VALUES(?,?,?)
DEBUG 2011-12-30 12:28:21,173 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Executing: INSERT INTO air_segment(FROM_CODE,TO_CODE,air_order_no) VALUES(?,?,?)
DEBUG 2011-12-30 12:28:21,173 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Parameters: PEK(String), SHA(String), WQF201112301228021(String)
DEBUG 2011-12-30 12:28:21,173 org.apache.ibatis.logging.slf4j.Slf4jImpl: ==> Parameters: PEK(String), SHA(String), WQF201112301228021(String)