SSM框架让MyBatis的sql语句显示在控制器中

最新推荐文章于 2024-08-19 21:18:25 发布

一条鱼itr

最新推荐文章于 2024-08-19 21:18:25 发布

阅读量5.1k

点赞数

首先要配置log4j.properties

在里面添加此代码：

### set log levels ###
log4j.rootLogger=debug, stdout

### 把日志信息输出到控制台 ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender 
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %p [%c] %m%n

### show 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

//  控制器中的sql和他的参数

2017-12-18 11:05:20 DEBUG [yizhi.xiaoyuan.mapper.TActivityMapper.selectActivity] ==>  Preparing: select id,name,sponsor,address,pro_code,city_code,area_code,start_time,apply_start_time,apply_count,school_id,seq,status,type from t_activity where (start_time between ? and (SELECT DATE_ADD(?,INTERVAL +1 MONTH) AS A)) and (apply_start_time between ? and (SELECT DATE_ADD(?,INTERVAL +1 MONTH) AS B)) and ? and name like ? or intro like ? or address like ? ORDER BY seq asc LIMIT ?,? 
2017-12-18 11:05:20 DEBUG [yizhi.xiaoyuan.mapper.TActivityMapper.selectActivity] ==> Parameters: 2017-12-01 10:48:06(String), 2017-12-01 10:48:06(String), 2017-12-01 10:48:06(String), 2017-12-01 10:48:06(String), 1+1=2(String), %a%(String), %null%(String), %null%(String), 0(Integer), 3(Integer)

http://blog.csdn.net/javahighness/article/details/52623452