anltr 解析MYSQL

String sql = "select a as c,b as s,‘zhange‘ F, 1/5 as e from t_order";

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

        final CommonTokenStream commonTokenStream = new CommonTokenStream(mySqlLexer);

        final MysqlQueryParser mySqlParser = new MysqlQueryParser(commonTokenStream);

        mySqlParser.addParseListener(new MysqlQueryBaseListener());

        final MysqlQueryParser.SelectStatementContext selectStatementContext = mySqlParser.selectStatement();
        for (ParseTree child : selectStatementContext.children) {
            if (child instanceof MysqlQueryParser.SelectElementsContext) {
                List<ParseTree>  columnElementContextList = ((MysqlQueryParser.SelectElementsContext) child).children;
                for (int i = 0; i < columnElementContextList.size(); i++) {
                    ParseTree tree = columnElementContextList.get(i);
                    if (tree instanceof MysqlQueryParser.SelectColumnElementContext) {
                        MysqlQueryParser.SelectColumnElementContext columnElementContext = (MysqlQueryParser.SelectColumnElementContext) tree;
                        System.out.println(columnElementContext.fullColumnName());
                        System.out.println(columnElementContext.start.getText() + "----------" + columnElementContext.start.getType());
                        System.out.println(columnElementContext.stop.getText());
                    }
                }
            }
            System.out.println(child.getText() + "------"  );

        }

anltr 解析MYSQL

上一篇:[SQL]master..sysprocesses


下一篇:Mysql/Oracle 通过cmd命令开启服务和关闭服务