XML Element: select
- Vaishnavi Sridhar (Unlicensed)
This element is used to define a particular select or retrieve query. It supports the following -
Key | Relation Type | Purpose |
|---|---|---|
id | Attribute | A unique Id with which this query is identified within the Logical Data Source! |
parameterMap | Attribute | This is a pointer to the id of the parameterMap defined within the Logical Data Source. |
parameterClass | Attribute | This contains the fully defined class name of the object that provides the parameters to be used for the select DML. Either parameterClass or parameterMap should be used. Not both. |
resultMap | Attribute | This is a pointer to the id of the resultMap defined within the Logical Data Source. |
resultClass | Attribute | This contains the fully defined class name of the object that is the holder for result set for the select DML. Either resultClass or resultMap should be used. Not both. |
include | Child Element | This is used to include a pre defined SQL item into the query at any position. |
The following code segment is a sample definition:
<select id="DEFAULT_SELECT" parameterClass="java.util.HashMap" resultClass="java.util.HashMap"> SELECT 1 FROM DUAL WHERE 1=1 <include refid="FILTER_CLAUSE" /> </select>