首先,将log4j.jar添加到lib下,然后在src目录下添加log4j.properties文件,如下:
# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.<span style="color:#FF0000;">com.chenjun.UserDao</span>=TRACE
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
上面红色部分就是mapper接口的类路径,它表示该类下的所有sql操作都会打印出日志,TRACE代表会打印出sql语句,其实就是带?的预编译语句,传的参数值,查询的结果.,如下:
DEBUG [main] - ==> Preparing: select id,name from userinfo WHERE name like ?
DEBUG [main] - ==> Parameters: 张四(String)
TRACE [main] - <== Columns: ID, NAME
TRACE [main] - <== Row: 43,