/mybatis-log-plugin

Restore mybatis sql log to original whole executable sql.

Primary LanguageJavaOtherNOASSERTION

mybatis-log-plugin mybatis-log-plugin

English

MyBatis Log Plugin

插件功能

  • 还原MyBatis输出的日志为完整的SQL语句。
  • 把SQL日志里面的?替换为真正的参数值。
  • 选中要还原的MyBatis日志，右键点击菜单Restore Sql，还原SQL语句.
  • Java接口方法与Mapper xml文件互相跳转。

按钮作用

  • Text: 从文本内容还原SQL语句
  • Settings: 导航跳转开关，配置不想要输出的SQL语句
  • Format: 输出格式化过的SQL语句
  • Rerun: 重启插件
  • Stop: 停止插件

日志示例

MyBatis Log Test: DEBUG sql1 -  ==>  Preparing: select * from t_table where name = ?
MyBatis Log Test: DEBUG sql1 -  ==> Parameters: hello(String)
MyBatis Log Test: INFO sql2 -  ==>  Preparing: update t_table set name = ? where id = ?
MyBatis Log Test: INFO sql2 -  ==> Parameters: world(String), 123(Integer)
MyBatis Log Test: WARN sql3 -  ==>  Preparing: delete from t_table where id = ?
MyBatis Log Test: WARN sql3 -  ==> Parameters: 123(Integer)
MyBatis Log Test: ERROR sql4 - ==>  Preparing: select * from t_table order by id asc 
MyBatis Log Test: ERROR sql4 - ==>  Parameters:

插件输出的完整的可执行的SQL语句如下：

--  1  MyBatis Log Test: DEBUG sql1 -  ==>
 select *
 FROM t_table
 WHERE name = 'hello';
------------------------------------------------------------
--  2  MyBatis Log Test: INFO sql2 -  ==>
 update t_table set name = 'world'
 WHERE id = 123;
------------------------------------------------------------
--  3  MyBatis Log Test: WARN sql3 -  ==>
 delete
 FROM t_table
 WHERE id = 123;
------------------------------------------------------------
--  4  MyBatis Log Test: ERROR sql4 - ==>
 select *
 FROM t_table order by id asc;

安装下载

mybatis-log-plugin.jar

价格

$5/year

插件文档

https://www.yuque.com/kookob/plugin
文档里面包含插件介绍，使用手册，购买流程，激活失败等说明。

其他插件