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

Package com.alibaba.druid.sql.ast.statement

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

com.alibaba.druid.sql.ast.statement.SQLUpdateStatement

    public String explainToUpdateSQL(String sql) {
        return explainToUpdateSQL(sql, new MappingContext());
    }


    public String explainToUpdateSQL(String sql, MappingContext context) {
        SQLUpdateStatement stmt = explainToUpdateSQLObject(sql, context);


        MappingVisitor visitor = this.createMappingVisitor(context);
        stmt.accept(visitor);
        visitor.afterResolve();
        afterResole(visitor);


        return toSQL(stmt);
    }

View Full Code Here

    public int update(Connection conn, String sql, List<Object> parameters) throws SQLException {
        return update(conn, sql, new MappingContext(parameters));
    }


    public int update(Connection conn, String sql, MappingContext context) throws SQLException {
        SQLUpdateStatement sqlObject = this.explainToUpdateSQLObject(sql, context);
        exportParameters(sqlObject, context.getParameters());
        String rawSql = this.toSQL(sqlObject);
        int updateCount = JdbcUtils.executeUpdate(conn, rawSql, context.getParameters());
        return updateCount;
    }

View Full Code Here

        return stmt;
    }


    public SQLUpdateStatement explainToUpdateSQLObject(MappingEngine engine, String sql, MappingContext context) {
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLUpdateStatement stmt = parser.parseUpdateStatement();


        MappingVisitorUtils.setTableSource(engine, stmt, context);


        return stmt;
    }

View Full Code Here

        return stmt;
    }


    public SQLUpdateStatement explainToUpdateSQLObject(MappingEngine engine, String sql, MappingContext context) {
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLUpdateStatement stmt = parser.parseUpdateStatement();


        MappingVisitorUtils.setTableSource(engine, stmt, context);


        return stmt;
    }

View Full Code Here

    public SQLSelectParser createSQLSelectParser() {
        return new SQLSelectParser(this.exprParser);
    }


    public SQLUpdateStatement parseUpdateStatement() throws ParserException {
        SQLUpdateStatement udpateStatement = createUpdateStatement();


        if (lexer.token() == Token.UPDATE) {
            lexer.nextToken();


            SQLTableSource tableSource = this.exprParser.createSelectParser().parseTableSource();
            udpateStatement.setTableSource(tableSource);
        }


        accept(Token.SET);


        for (;;) {
            SQLUpdateSetItem item = new SQLUpdateSetItem();
            item.setColumn(this.exprParser.name());
            accept(Token.EQ);
            item.setValue(this.exprParser.expr());


            udpateStatement.getItems().add(item);


            if (lexer.token() == (Token.COMMA)) {
                lexer.nextToken();
                continue;
            }


            break;
        }


        if (lexer.token() == (Token.WHERE)) {
            lexer.nextToken();
            udpateStatement.setWhere(this.exprParser.expr());
        }


        return udpateStatement;
    }

View Full Code Here


        return udpateStatement;
    }


    protected SQLUpdateStatement createUpdateStatement() {
        return new SQLUpdateStatement();
    }

View Full Code Here

    public SQLSelectParser createSQLSelectParser() {
        return new SQLSelectParser(this.exprParser);
    }


    public SQLUpdateStatement parseUpdateStatement() {
        SQLUpdateStatement udpateStatement = createUpdateStatement();


        if (lexer.token() == Token.UPDATE) {
            lexer.nextToken();


            SQLTableSource tableSource = this.exprParser.createSelectParser().parseTableSource();
            udpateStatement.setTableSource(tableSource);
        }


        parseUpdateSet(udpateStatement);


        if (lexer.token() == (Token.WHERE)) {
            lexer.nextToken();
            udpateStatement.setWhere(this.exprParser.expr());
        }


        return udpateStatement;
    }

View Full Code Here

            lexer.nextToken();
        }
    }


    protected SQLUpdateStatement createUpdateStatement() {
        return new SQLUpdateStatement();
    }

View Full Code Here

        if (parent instanceof SQLDeleteStatement) {
            SQLDeleteStatement deleteStmt = (SQLDeleteStatement) parent;
            deleteStmt.setWhere(condition);
            visitor.setSqlModified(true);
        } else if (parent instanceof SQLUpdateStatement) {
            SQLUpdateStatement updateStmt = (SQLUpdateStatement) parent;
            updateStmt.setWhere(condition);
            visitor.setSqlModified(true);
        } else if (parent instanceof SQLSelectQueryBlock) {
            SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) parent;
            queryBlock.setWhere(condition);
            visitor.setSqlModified(true);

View Full Code Here

                    return false;
                }
            }


            if (parent instanceof SQLUpdateStatement) {
                SQLUpdateStatement update = (SQLUpdateStatement) parent;
                if (update.getWhere() == x) {
                    return true;
                } else {
                    return false;
                }
            }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

Related Classes of com.alibaba.druid.sql.ast.statement.SQLUpdateStatement

com.alibaba.druid.bvt.sql.SQLASTVisitorAdapterTest

com.alibaba.druid.mapping.MappingEngine

com.alibaba.druid.mapping.spi.MSSQLServerMappingProvider

com.alibaba.druid.mapping.spi.MySqlMappingProvider

com.alibaba.druid.mapping.spi.OracleMappingProvider

com.alibaba.druid.sql.parser.SQLStatementParser

com.alibaba.druid.wall.spi.WallVisitorUtils

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.