spring mvc mybatis如何利用log4j打印包含参数(而不是问号)的完整sql
目前的情况是:
[java.sql.PreparedStatement] - ==> Executing: select * from t_admin limit ?,?
[java.sql.PreparedStatement] - ==> Parameters: 5(Integer), 500(Integer)
sql和参数分两行打印
log4j.properties文件配置:
log4j.rootLogger=error, stdout, catalina,info
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.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=INFO
如果想要的效果如下:
[java.sql.PreparedStatement] - ==> Executing: select * from t_admin limit 5,500
那么该如何设置?