目前的情况是:
[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那么该如何设置?
[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那么该如何设置?
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - <%m>%nlog4j.logger.com.jege.mybatis=TRACE
com.jege.mybatis这个是哪个jar包的?
SQL语句打出来了,参数也打出来了,最后一步不会自己动手?PS:如果楼主找到解决方法请分享。