MyBatis日志解析工具

MyBatis日志解析工具支持MyBatis3.0以上版本，能够将Mybatis打印的SQL日志转换成SQL语句。
例如将下面打印的SQL日志：

==>  Preparing: select * from(select t.*,rownum rn from(select DISTINCT BS_PT_ID, BS_PT_CODE, BS_PT_NAME, BS_PT_STATUS, BS_PT_NATURE, REMARK, IS_DEL, CREATED_BY, CREATED_TIME, UPDATED_TIME, UPDATED_BY, VERSION, IS_INACTIVE, ISOLATION_CODE,ADDRESS,PROVINCE_ID from MI_COD_BS_pt where IS_INACTIVE=0 and is_del=0 and upper(BS_PT_CODE) LIKE CONCAT(CONCAT('%',?), '%') order by CREATED_TIME DESC)t where rownum <= ? ) where rn >= ? 
==> Parameters: 001(String), 10(Integer), 1(Integer)

复制后粘贴到工具中执行

得到SQL如下：

select * from(select t.*,rownum rn from(select DISTINCT BS_PT_ID, 
BS_PT_CODE, 
BS_PT_NAME, 
BS_PT_STATUS, 
BS_PT_NATURE, 
REMARK, 
IS_DEL, 
CREATED_BY, 
CREATED_TIME, 
UPDATED_TIME, 
UPDATED_BY, 
VERSION, 
IS_INACTIVE, 
ISOLATION_CODE,ADDRESS,PROVINCE_ID from MI_COD_BS_pt where IS_INACTIVE=0 and is_del=0 and upper(BS_PT_CODE) LIKE CONCAT(CONCAT('%','001'), 
'%') order by CREATED_TIME DESC)t where rownum <= 10 ) where rn >= 1 

注意事项：

复制的日志中必须包含Preparing和Parameters这两行的内容

下载地址：https://download.youkuaiyun.com/download/warehouse666/11172774