SQL mapping in ibatis

Here we can see a SQL SELECT statement that returns address data.

<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));