Examples of SQLSelect

com.alibaba.druid.sql.ast.statement.SQLSelect
com.avaje.ebean.annotation.SqlSelect
org.eigenbase.sql.SqlSelect
A SqlSelect is a node of a parse tree which represents a select statement. It warrants its own node type just because we have a lot of methods to put somewhere.
org.ofbiz.sql.SQLSelect

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

        return new SQLCreateTableParser(this.exprParser);
    }


    public SQLSelectStatement parseSelect() {
        SQLSelectParser selectParser = createSQLSelectParser();
        SQLSelect select = selectParser.select();
        return new SQLSelectStatement(select);
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }


        DB2SelectQueryBlock offsetQueryBlock = new DB2SelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));
        offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX"));
        offsetQueryBlock.setWhere(pageCondition);


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

        select.setOrderBy(null);
        countQueryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));


        SQLServerSelectQueryBlock offsetQueryBlock = new SQLServerSelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));
        offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX"));
        offsetQueryBlock.setWhere(pageCondition);


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }


        OracleSelectQueryBlock offsetQueryBlock = new OracleSelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));
        offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX"));
        offsetQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("RN"), //
                                                      SQLBinaryOperator.GreaterThan, //
                                                      new SQLNumberExpr(offset)));


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect


        SQLSubqueryTableSource fromSubquery = new SQLSubqueryTableSource(select);
        fromSubquery.setAlias("ALIAS_COUNT");
        countSelectQuery.setFrom(fromSubquery);


        SQLSelect countSelect = new SQLSelect(countSelectQuery);
        SQLSelectStatement countStmt = new SQLSelectStatement(countSelect);


        return SQLUtils.toSQLString(countStmt, dbType);
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

                lexer.nextToken();
                if (lexer.token() == Token.LPAREN) {
                    SQLAnyExpr anyExpr = new SQLAnyExpr();


                    accept(Token.LPAREN);
                    SQLSelect anySubQuery = createSelectParser().select();
                    anyExpr.setSubQuery(anySubQuery);
                    accept(Token.RPAREN);


                    anySubQuery.setParent(anyExpr);


                    sqlExpr = anyExpr;
                } else {
                    sqlExpr = new SQLIdentifierExpr("ANY");
                }
                break;
            case SOME:
                lexer.nextToken();
                SQLSomeExpr someExpr = new SQLSomeExpr();


                accept(Token.LPAREN);
                SQLSelect someSubQuery = createSelectParser().select();
                someExpr.setSubQuery(someSubQuery);
                accept(Token.RPAREN);


                someSubQuery.setParent(someExpr);


                sqlExpr = someExpr;
                break;
            case ALL:
                lexer.nextToken();
                SQLAllExpr allExpr = new SQLAllExpr();


                accept(Token.LPAREN);
                SQLSelect allSubQuery = createSelectParser().select();
                allExpr.setSubQuery(allSubQuery);
                accept(Token.RPAREN);


                allSubQuery.setParent(allExpr);


                sqlExpr = allExpr;
                break;
            case LITERAL_ALIAS:
                sqlExpr = new SQLIdentifierExpr('"' + lexer.stringVal() + '"');

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

        super(exprParser.getLexer());
        this.exprParser = exprParser;
    }


    public SQLSelect select() {
        SQLSelect select = new SQLSelect();


        withSubquery(select);


        select.setQuery(query());
        select.setOrderBy(parseOrderBy());


        if (select.getOrderBy() == null) {
            select.setOrderBy(parseOrderBy());
        }


        if (lexer.token() == Token.HINT) {
            this.exprParser.parseHints(select.getHints());
        }


        return select;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

    public SQLTableSource parseTableSource() {
        if (lexer.token() == Token.LPAREN) {
            lexer.nextToken();
            SQLTableSource tableSource;
            if (lexer.token() == Token.SELECT || lexer.token() == Token.WITH) {
                SQLSelect select = select();
                accept(Token.RPAREN);
                SQLSelectQuery query = queryRest(select.getQuery());
                if (query instanceof SQLUnionQuery) {
                    tableSource = new SQLUnionQueryTableSource((SQLUnionQuery) query);
                } else {
                    tableSource = new SQLSubqueryTableSource(select);
                }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.statement.SQLSelect

                lexer.nextToken();


                parameter.setName(this.exprParser.name());


                accept(Token.IS);
                SQLSelect select = this.createSQLSelectParser().select();


                SQLDataTypeImpl dataType = new SQLDataTypeImpl();
                dataType.setName("CURSOR");
                parameter.setDataType(dataType);

View Full Code Here

Examples of com.avaje.ebean.annotation.SqlSelect

    Sql sql = cls.getAnnotation(Sql.class);
    if (sql != null) {
      setSql(sql);
    }


    SqlSelect sqlSelect = cls.getAnnotation(SqlSelect.class);
    if (sqlSelect != null) {
      setSqlSelect(sqlSelect);
    }
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.