/*
 * Copyright 2004-2019 H2 Group. Multiple-Licensed under the MPL 2.0,
 * and the EPL 1.0 (http://h2database.com/html/license.html).
 * Initial Developer: H2 Group
 */
package org.h2.command.dml;

import java.util.ArrayList;

import org.h2.command.CommandInterface;
import org.h2.command.Prepared;
import org.h2.engine.Procedure;
import org.h2.engine.Session;
import org.h2.expression.Expression;
import org.h2.expression.Parameter;
import org.h2.result.ResultInterface;
import org.h2.util.Utils;

This class represents the statement EXECUTE
/** * This class represents the statement * EXECUTE */
public class ExecuteProcedure extends Prepared { private final ArrayList<Expression> expressions = Utils.newSmallArrayList(); private Procedure procedure; public ExecuteProcedure(Session session) { super(session); } public void setProcedure(Procedure procedure) { this.procedure = procedure; }
Set the expression at the given index.
Params:
  • index – the index (0 based)
  • expr – the expression
/** * Set the expression at the given index. * * @param index the index (0 based) * @param expr the expression */
public void setExpression(int index, Expression expr) { expressions.add(index, expr); } private void setParameters() { Prepared prepared = procedure.getPrepared(); ArrayList<Parameter> params = prepared.getParameters(); for (int i = 0; params != null && i < params.size() && i < expressions.size(); i++) { Expression expr = expressions.get(i); Parameter p = params.get(i); p.setValue(expr.getValue(session)); } } @Override public boolean isQuery() { Prepared prepared = procedure.getPrepared(); return prepared.isQuery(); } @Override public int update() { setParameters(); Prepared prepared = procedure.getPrepared(); return prepared.update(); } @Override public ResultInterface query(int limit) { setParameters(); Prepared prepared = procedure.getPrepared(); return prepared.query(limit); } @Override public boolean isTransactional() { return true; } @Override public ResultInterface queryMeta() { Prepared prepared = procedure.getPrepared(); return prepared.queryMeta(); } @Override public int getType() { return CommandInterface.EXECUTE; } }