mybatis怎么配置log4j打印出sql语句

mybatis怎么配置log4j打印出sql语句

ibatis:

log4j.rootLogger=debug, stdout, logfile

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=DEBUG

log4j.logger.org.springframework=ERROR
log4j.logger.org.compass=ERROR

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=empi.log

若mybatis是3.0.4版，试试升级到3.1后的版本也可以！ 在log4j.properties中配置如下信息 log4j.appender.product=org.apache.log4j.dailyrollingfileappender #log4j.appender.product=org.apache.log4j.rollingfileappender log4j.appender.product.append=true log4j.appender.product.datepattern='.'yyyy-mm-dd log4j.appender.product.file=d:/logs/ams.log#为日志输出文件位置 log4j.appender.product.threshold=debug #log4j.appender.product.threshold=info #log4j.appender.product.maxfilesize=20mb log4j.appender.product.layout=org.apache.log4j.patternlayout log4j.appender.product.layout.conversionpattern=%d{yyyy-mm-dd hh\:mm\:ss} [%-5p] %m%n%n log4j.logger.com.ibatis=debug log4j.logger.com.opensymphony.xwork2=info log4j.logger.java.sql=debug log4j.logger.org.apache.struts=info log4j.logger.org.springframework=info log4j.rootlogger=info, console, product