打印mybatis sql

#将ibatis log4j运行级别调到DEBUG可以在控制台打印出ibatis运行的sql语句
log4j.rootLogger=debug,stdout,logfile
### 把日志信息输出到控制台 ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#log4j.appender.stdout.Target=System.err
log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout
### 把日志信息输出到文件：jbit.log ###
log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=D:/test.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %F %p %m%n

###显示SQL语句部分
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日志文件
#mybatis日志范围??
log4j.logger.com.nes=trace??
#ibatis配置??
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.导入依赖日志包 log4j


??
??
????org.slf4j??
?????slf4j-log4j12??
????1.6.4??
??
????
????log4j????
????log4j????
????1.2.14????
????
????
???????org.slf4j????
??????slf4j-api????
???????1.7.7????