You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Rajanikanth Gaddam <gr...@gmail.com> on 2006/03/03 17:22:28 UTC
Re: implementing HashMap of HashMaps in resultMap...
How do I implement map of maps using Ibatis? I have included the sql config
file.
>
> I am expecting a following result:
> HashMap --> key --> manager
> value --> java.util.Map --> key -->
> orderId
> value
> --> List of beans of type test.Trade
>
> I appreciate all the help.
>
> <sqlMap namespace="report">
> <resultMap id="getDataMap" class="test.ResultHolder" groupBy="manager">
> <result property="manager" column="mgr" />
> <result property="orderIdMap" resultMap="orderIdMap" />
> </resultMap>
>
> <resultMap id="orderIdMap" class="java.util.HashMap" groupBy="orderId">
> <result property="orderId" column="order_id" />
> <result property="beanList" resultMap="beanList" javaType="
> java.util.ArrayList"/>
> </resultMap>
>
> <resultMap id="beanList" class="test.Trade">
> <result property="txnId" column="txn_id" />
> <result property="tradeDisplayType" column="trd_display_id" />
> <result property="tradeType" column="trd_type" />
> <result property="numberOfShares" column="shr_face" javaType="double" />
> <result property="sharePrice" column="u_price" javaType="double" />
> <result property="tradeDate" column="txn_date" javaType="java.util.Date"
> />
> <result property="settleDate" column="set_date" javaType="java.util.Date"
> />
> </resultMap>
>
> <select id="getData" resultMap="getDataMap">
> select
> mgr,
> order_id,
> oms_order_id ,
> gloss_txn_id ,
> trd_display_id,
> trd_type,
> shr_face,
> u_price,
> txn_date
> from
> Tab_A
> </select>
> </sqlMap>
>
> Thanks and Regards
> Raj
>