본문 바로가기
정리/MyBatis

MyBatis - 여러개 결과값 처리(Multiple Results)

by 난파선 2017. 1. 13.


resultMap을 사용 ',' 로 구분해서 result maps에 넣는 다.

<resultMap id="PayProductToPrice" type="com.estgames.cabal1.bill.PayProductToPrice">
    		<result column="TotalPrice" property="TotalPrice"/>
    		<result column="tranCount" property="tranCount"/>
    		<result column="totPrice" property="totPrice"/>
    		<result column="ItemName" property="ItemName"/>
</resultMap>
    
<resultMap id="PayProductBillWayCD" type="com.estgames.cabal1.bill.PayProductBillWayCD">
    		<result column="TotalPrice" property="TotalPrice"/>
    		<result column="tranCount" property="tranCount"/>
    		<result column="BillWayCD" property="BillWayCD"/>
    		<result column="BillWayName" property="BillWayName"/>	
</resultMap>


<select id="getTransactionSummary" statementType="CALLABLE" parameterType="java.lang.Object" resultMap="PayProductToPrice, PayProductBillWayCD">
    {
        call CabalCharge.dbo.sp_GetTransactionSummary (#{isCanceled, mode=IN}
        , #{completedPay, mode=IN}
        , #{dateFrom, mode=IN}
        , #{dateTo, mode=IN})
    }
</select>
List<List<Object>> getTransactionSummary(@Param("isCanceled") String isCanceled
            , @Param("completedPay") String completedPay
            , @Param("dateFrom") String dateFrom
            , @Param("dateTo") String dateTo);


댓글