antlr4 mysql_Antlr4解析MySQL语法使用方法

image.png

按照Oracle文件夹里的说明https://github.com/mysql/mysql-workbench/tree/8.0/library/parsers/grammars

, 根据生成命令生成的C++代码,如果把-Dlanguage改成Java,生成的代码中少了一些抽象类.

按照Positive Technologies文件夹https://github.com/antlr/grammars-v4/tree/master/sql/mysql/Positive-Technologies

里的MySqlLexer.g4和MySqlParser.g4根据命令生成Java代码,命令如下:

java -jar ./antlr-4.8-complete.jar -Dlanguage=Java -listener -visitor -o ./mysql-parser -package com.mysql.parser MySqlLexer.g4 MySqlParser.g4

测试:

String sql = "select a.id from t_order a straight_join t_product b on a.productId = b.id".toUpperCase();

final MySqlLexer mySqlLexer = new MySqlLexer(CharStreams.fromString(sql));

final CommonTokenStream commonTokenStream = new CommonTokenStream(mySqlLexer);

final MySqlParser mySqlParser