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