工具/jar包/tips

数据库

查看语句运行时间

set profiling = 1;
show  profiles;
set profiling=0;
-----------------
running sql query will be listed here.
-----------------
show profile for query 1 ；（detail for the first quesy list above）

字符串转多行

SELECT substring_index( substring_index( a.str, ',', b.help_topic_id + 1 ), ',',- 1 )
FROM yourtb a
JOIN mysql.help_topic b 
ON b.help_topic_id < ( length( a.str) - length( REPLACE ( a.str, ',', '' ) ) + 1)

代码质量

jacoco 测试覆盖率检查，配合sonar

sonar 代码质量检测

hibernate-invalidator 后端参数校验

业务

SQL解析 General SQL Parser

下载地址：

http://www.sqlparser.com/dlaction.php?fid=gspjava&ftitle=General%20SQL%20Parser%20Java%20version

办公