ibatis输出sql配置

在MyBatis(iBatis3)出来之前，ibatis自己带了log4j，如果要输出最后生成的数据库sql，只需要在log4j配置一下就可以了：?

[java]?view plaincopy

1. log4j.logger.com.ibatis=DEBUG,?ibatis??????
2. log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG,?ibatis??????
3. log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG,?ibatis??????
4. log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG,ibatis??????
5. log4j.logger.java.sql.Connection=DEBUG,?ibatis??????
6. log4j.logger.java.sql.Statement=DEBUG,?ibatis??????
7. log4j.logger.java.sql.PreparedStatement=DEBUG,?ibatis??????
8. log4j.logger.java.sql.ResultSet=DEBUG,?ibatis???

现在MyBatis已经没有配置log4j了，或者说修改了输出sql的策略，需要使用log4j.xml(话说用资源文件其实也是一样的，不过xml确实方便点，自己写个servlet就找到路径了，轻松愉快)?
[html]?view plaincopy

1. <?xml?version="1.0"?encoding="UTF-8"??>????
2. <!DOCTYPE?log4j:configuration?SYSTEM?"log4j.dtd">????
3. ????
4. <log4j:configuration?xmlns:log4j="http://jakarta.apache.org/log4j/">????
5. ?????????
6. ????<!--?Console?output?-->????
7. ????
8. ????<appender?name="STDOUT"?class="org.apache.log4j.ConsoleAppender">????
9. ????????<layout?class="org.apache.log4j.PatternLayout">????
10. ????????????<param?name="ConversionPattern"?value="%-5p?%d{MM-dd?HH:mm:ss}?%m??(%F:%L)?\n"/>????
11. ????????</layout>????
12. ????</appender>????
13. ?????????
14. ????<category?name="java.sql">????
15. ????????<priority?value="debug"?/>????
16. ????</category>????
17. ????<category?name="com.ibatis">????
18. ????????<priority?value="debug"?/>????
19. ????</category>????
20. ????<root>????
21. ????????<priority?value?="error"?/>????
22. ????????<appender-ref?ref="STDOUT"?/>????
23. ????</root>????
24. ?????????
25. </log4j:configuration>????

内容就不解释了……?
另外，别忘记给你的项目添加commons-logging.jar

转自http://blog.csdn.net/pk490525/article/details/6907338