Here we can see a SQL SELECT statement that returns address data.
The Java code
used to execute this statement would be:
<select id="getAddress"
parameterClass="int"
resultClass="Address">
SELECT
ADR_ID as id,
ADR_DESCRIPTION as description,
ADR_STREET as street,
ADR_CITY as city,
ADR_PROVINCE as province,
ADR_POSTAL_CODE as postalCode
FROM ADDRESS
WHERE ADR_ID = #id#
</select>
The Java code
used to execute this statement would be:
Address address = (Address) sqlMap.queryForObject("getAddress",
new Integer(5));