|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DatabaseUpdateAction
Executes SQL statements in a database. For this purpose, the database connection available to the flow context can be used, or alternately, database connection information can be provided to connect to a data source or use a direct JDBC connection.
The Database Update Action returns its result in the flow context variable "RESULT". The following table contains more information on accessing and using the result.Flow Context Variable | Field | Java Type | Description |
---|---|---|---|
RESULT | result | int | The number of rows that were affected by the update. |
Nested Class Summary | |
---|---|
static class |
DatabaseUpdateAction.DatabaseUpdateActionResult
The result after this action runs. |
Method Summary | |
---|---|
void |
addStatement(boolean ignoreError,
java.lang.String statement,
java.lang.Object... parameters)
Adds a prepared statement, with optional parameters, to the list of SQL statements to be executed. |
void |
addStatement(java.lang.String statement,
java.lang.Object... parameters)
Adds a prepared statement, with optional parameters, to the list of SQL statements to be executed. |
java.util.List<java.lang.Integer> |
getIgnoreErrorStatements()
Returns the 0-based index numbers of the statements where any executions errors are ignored. |
java.util.List<java.util.List<java.lang.Object>> |
getParameters()
Returns parameter lists for each SQL statement to be executed. |
java.util.List<java.lang.String> |
getStatements()
Returns a sequence of SQL statements that are used to update a database. |
void |
setIgnoreErrorStatements(java.util.List<java.lang.Integer> ignoreErrorStatements)
Sets the 0-based index numbers of the statements where any executions errors are ignored. |
void |
setParameters(java.util.List<java.util.List<java.lang.Object>> parametersForStatements)
Sets parameter lists for each SQL statement to be executed. |
void |
setStatements(java.util.List<java.lang.String> statements)
Sets a sequence of SQL statements that are used to update a database. |
Methods inherited from interface flux.runtimedatamap.RuntimeDataMap |
---|
getRuntimeDataMap, setRuntimeDataMap |
Method Detail |
---|
void addStatement(boolean ignoreError, java.lang.String statement, java.lang.Object... parameters)
ignoreError
- Indicates whether an error that occurs when this
statement is executed should be ignored.statement
- A prepared statement to be added to the list of SQL
stastements to be executed.parameters
- Optional parameters for the prepared statement.void addStatement(java.lang.String statement, java.lang.Object... parameters)
statement
- A prepared statement to be added to the list of SQL
stastements to be executed.parameters
- Optional parameters for the prepared statement.java.util.List<java.lang.Integer> getIgnoreErrorStatements()
java.util.List<java.util.List<java.lang.Object>> getParameters()
java.util.List<java.lang.String> getStatements()
void setIgnoreErrorStatements(java.util.List<java.lang.Integer> ignoreErrorStatements)
ignoreErrorStatements
- The 0-based index numbers of the statements
where any executions errors are ignored.void setParameters(java.util.List<java.util.List<java.lang.Object>> parametersForStatements)
parametersForStatements
- Parameter lists for each SQL statement to be
executed.void setStatements(java.util.List<java.lang.String> statements)
statements
- A sequence of SQL statements that are used to update a
database.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |