Difference between revisions of "Statement"

Revision as of 08:19, 4 April 2012

Statement element contains the statement to be evaluated. Those statements might contain placeholders that will be replaced at runtime.

It is used by: DBOperations.

The Statement element has the following parameters:

Attribute

Type

Description

statementType

required

This element represents the type of statement to use.

We recommend using a CallableStatement to process stored procedures. The attribute's admitted values are:

Might contain the sub-elements:

StatementValue contains the value of the statement to be performed.

The StatementValue Element is used by: Statement.

@@ Line 1: / Line 1: @@
-This section contains the statement to be evaluated which can contains one or more [[placeholders]].
+[[Statement]] element contains the statement to be evaluated. Those statements might contain [[placeholders]] that will be replaced at runtime.
+It is used by: [[DBOperations]].
 The Statement element has the following parameters:
-* ''type'': Must be:
+{|class="gvtable"
-** DBOSelect          : select
+! Attribute !! Type !! Description
-** DBOInsert          : insert
+|-
-** DBOUpdate          : update
+| statementType || required || This element represents the type of statement to use.
-** DBOInsertOrUpdate  : insert|update
+We recommend using a CallableStatement to process stored procedures.
-** DBOUpdateOrInsert  : insert|update
+The attribute's admitted values are:
-** DBOCallSP          : callsp
+* CallableStatement
-** Excel Sheet        : select
+* PreparedStatement
+|}
-* ''id'': Pattern: ! [0-9]* ! set a integer value
+Might contain the sub-elements:
+* [[#StatementValue|StatementValue]]
+* [[#ParamResolvers|ParamResolvers]]
+==StatementValue==
+StatementValue contains the value of the statement to be performed.
+The StatementValue Element is used by: [[Statement]].
+==ParamResolvers==