Using the Transaction Script pattern - POJOs in Action: Developing Enterprise Applications with Lightweight Frameworks - page 349

<result property="deliveryAddress.zip" column="DELIVERY_ZIP"/>
<result property="restaurant.restaurantId"
column="RESTAURANT_ID"/>
<result property="restaurant.name" column="NAME"/>
<result property="lineItems"
column="PENDING_ORDER_ID"
select="findLineItems"/>
<result property="restaurant.menuItems"
column="RESTAURANT_ID"
select="findMenuItems"/>
</resultMap>

D

E

<select id="findLineItems"
parameterClass="java.lang.String"
resultMap="PendingOrderLineItemResultMap">
select *
from PENDING_ORDER_LINE_ITEM l, MENU_ITEM mi
where
l.pending_order_id = #value:NUMERIC#
AND mi.menu_item_id = l.menu_item_id
</select>

F

<resultMap
id="PendingOrderLineItemResultMap"
class="net.chrisrichardson…PendingOrderLineItemDTO">
<result property="quantity" column="QUANTITY"/>
<result property="index" column="LINE_ITEM_INDEX"/>
<result property="menuItem.menuItemId" column="MENU_ITEM_ID"/>
<result property="menuItem.name" column="NAME"/>
<result property="menuItem.price" column="PRICE"/>
</resultMap>

G

<select id="findMenuItems"
parameterClass="java.lang.String"
resultMap="MenuItemResultMap">
select *
from MENU_ITEM mi
where mi.restaurant_id = #value:NUMERIC#
</select>

H

<resultMap id="MenuItemResultMap"
class="net.chrisrichardson.foodToGo.placeOrderTransactionScripts.
bbbbbbb b ➥ details.MenuItemDTO">
<result property="menuItemId" column="MENU_ITEM_ID"/>
<result property="name" column="NAME"/>
<result property="price" column="PRICE"/>
</resultMap>

</sqlMap>