首先添加依赖
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9.6</version>
</dependency>
然后就可以解析sql了
Statement st = CCJSqlParserUtil.parse(SQL语句);
Select selectStatement = (Select) st;
PlainSelect plain = (PlainSelect) selectStatement.getSelectBody();
在plain之中就包含看了sql的解析结果
plain.getGroupByColumnReferences() sql中的group by
plain.getOrderByElements() order by
plain.getWhere() where 条件信息
plain.getSelectItems() select items