“spring JdbcTemplate”怎么利用Log4j在控制台打印出SQL语句、参数？

#jdbcTemplate sql \x0d\x0alog4j.logger.org.springframework.jdbc.core=DEBUG, file\x0d\x0alog4j.logger.org.springframework.jdbc.core.StatementCreatorUtils=TRACE, file\x0d\x0a用这两个就可以，这个好像是spring 2.5.*支持，再高的版本没试，只能打印出sql和参数，没有其它的说明，看的有些眼花~~

1、log4j配置

[html] view plain copy

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.org.mybatis=DEBUG

log4j.logger.java.sql.Connection=DEBUG

log4j.logger.java.sql.Statement=DEBUG

log4j.logger.java.sql.PreparedStatement=DEBUG

log4j.logger.java.sql.ResultSet=DEBUG

2、导入jar

[html] view plain copy

<dependency>

<groupId>log4j</groupId>

<artifactId>log4j</artifactId>

<version>1.2.14</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>1.7.7</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>1.7.7</version>

</dependency>

3、没了，注意一定要导入slf4j的包，否则sql语句打印不出来

ybatis默认使用log4j，当有self4j这个日志jar包存在时会无法打印sql

#需要debug

log4j.rootCategory=info,stdout,file

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

# log4j.appender.stdout.layout.ConversionPattern= %-d{yyyy-MM-dd HH:mm:ss.SSS}, [%-9t], [%-5p], %C{1}.%M(%L), | %m%n

log4j.appender.stdout.layout.ConversionPattern= %-d{yyyy-MM-dd HH:mm:ss.SSS}, [%-9t], [%-5p], %C{1}.(%-3L), | %m%n

log4j.appender.file=org.apache.log4j.DailyRollingFileAppender

log4j.appender.file.file=${webapp.root}/logs/My.log

log4j.appender.file.DatePattern='.'yyyy-MM-dd

log4j.appender.file.layout=org.apache.log4j.PatternLayout

log4j.appender.file.layout.ConversionPattern= %-d{yyyy-MM-dd HH:mm:ss.SSS}, [%-9t], [%-5p], %C{1}.%M(%L), | %m%n

# OpenSymphony Stuff

log4j.logger.freemarker=info

log4j.logger.com.opensymphony=info

log4j.logger.com.opensymphony.xwork2.ognl=info

log4j.logger.org.apache.struts2=info

# Spring Stuff

log4j.logger.org.springframework=info

#mybatis Console

log4j.logger.java.sql.ResultSet=INFO

log4j.logger.org.apache=INFO

log4j.logger.java.sql.Connection=DEBUG

log4j.logger.java.sql.Statement=DEBUG

log4j.logger.java.sql.PreparedStatement=DEBUG

########## new 20141225

# OpenSymphony Stuff

log4j.logger.freemarker=WARN

log4j.logger.com.opensymphony=WARN

log4j.logger.com.opensymphony.xwork2.ognl=WARN

log4j.logger.org.apache.struts2=WARN

# Spring Stuff

log4j.logger.org.springframework=WARN

#mybatis Console

###显示SQL语句部分

log4j.logger.org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl=DEBUG

log4j.logger.java.sql=DEBUG,stdout

---