Package com.alibaba.druid.sql.parser

Examples of com.alibaba.druid.sql.parser.SQLSelectParser.select()

65
66
67
68
69
70
71
72
73
74
75
        if (lexer.token() == Token.FROM) {
            lexer.nextToken();
            accept(Token.LPAREN);
           
            SQLSelectParser selectParser = createSQLSelectParser();
            SQLSelect select = selectParser.select();

            accept(Token.RPAREN);

            String alias = lexer.stringVal();
            accept(Token.IDENTIFIER);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
                }
            }
            accept(Token.RPAREN);
        }

        SQLSelect query = selectParser.select();
        insert.setQuery(query);

        return insert;
    }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
        if (lexer.token() == Token.FROM) {
            lexer.nextToken();
            accept(Token.LPAREN);
           
            SQLSelectParser selectParser = createSQLSelectParser();
            SQLSelect select = selectParser.select();

            accept(Token.RPAREN);

            String alias = lexer.stringVal();
            accept(Token.IDENTIFIER);
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
                }
            }
            accept(Token.RPAREN);
        }

        SQLSelect query = selectParser.select();
        insert.setQuery(query);

        return insert;
    }
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
public class SQLParserTest extends TestCase {

    public void test_select() throws Exception {
        String sql = "   SELECT COUNT(*) FROM close_plan WHERE 1=1          AND close_type = ?             AND target_type = ?             AND target_id = ?         AND(    mi_name=?   )               AND end_time >= ?         ";
        SQLSelectParser parser = new MySqlSelectParser(sql);
        SQLSelect select = parser.select();

        StringBuilder out = new StringBuilder();
        MySql2OracleOutputVisitor visitor = new MySql2OracleOutputVisitor(out);

        select.accept(visitor);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.