MyBatis Log Plugin

English Introduction

This is a plugin for IntelliJ IDEA that restore the mybatis generate sql to original whole sql.
It will generate sql statements with replace ? to the really param value.
Through the "Tools -> MyBatis Log Plugin" menu you can tail the sql log.
You can selected the "Filter" button on the left to filter the contents don't wanna display.
You can selected the "Format Sql" button on the left to format the generate sql statements.
Parse Config: The output SQL log must contain a identifiable prefix for normal parsing, such as: "Preparing:" and "Parameters:"

The left buttons function:

Sql Text: Restore sql from text
Filter: Filter setting
Rerun: Rerun this plugin
Stop: Stop output the sql log
Format Sql: Format the subsequent sql statements
Close: Close this plugin window

Support Format

Support the mybatis's output format below:

2016-11-11 16:46:29.316 DEBUG selectSql1 - ==> Preparing: select * from t_table where name = ?
2016-11-11 16:46:29.343 DEBUG selectSql1 - ==> Parameters: hello(String)

Use "Preparing:" and "Parameters:" characters to split the log sql.
And it will output the whole sql:
select * from t_table where name = 'hello';

Download Plugin

mybatis-log-plugin.jar

Donations are welcomed

PayPal

中文介绍

这是一个Intellij的插件，主要作用是把mybatis生成的PreparedStatement语句恢复成原始完整的sql语句。
它将用真实的参数值替换PreparedStatement语句的问号占位符。
通过 "Tools -> MyBatis Log Plugin" 这个菜单可以实时输出sql日志。
点击窗口左边的 "Filter" 按钮，可以过滤不想要输出的sql语句。
点击窗口左边的 "Format Sql" 按钮，可以格式化输出的sql语句。
解析配置：输出的sql日志必须包含可识别的前缀才能正常解析，如："Preparing:"和"Parameters:"

左边几个按钮的作用：

Sql Text: 从文本还原语句
Filter: 过滤语句配置
Rerun: 重新启动
Stop: 停止输出
Format Sql: 格式化后续输出的Sql语句
Close: 关闭该窗口

支持格式

支持mybatis的输出格式如下：

2016-11-11 16:46:29.316 DEBUG selectSql1 - ==> Preparing: select * from t_table where name = ?
2016-11-11 16:46:29.343 DEBUG selectSql1 - ==> Parameters: hello(String)

以 "Preparing:" 和 "Parameters:" 作为分割符进行解析。
接着输出的完成sql语句如下：
select * from t_table where name = 'hello';

插件下载

mybatis-log-plugin.jar

项目地址

https://github.com/kookob/mybatis-log-plugin

参考列表

Reference and copy some code from below list:
https://github.com/JetBrains/intellij-community
https://github.com/krasa/GrepConsole
https://github.com/hibernate/hibernate-orm

欢迎捐赠

如果您觉得我的插件不错，对您有所帮助，可以捐赠请作者吃个冰淇淋~，在此表示感谢^_^。

zhangyi0412/mybatis-log-plugin