Question

iBATIS多表查询的问题

配置文件为：
<select id="getTotalMoney" resultMap="">
<![CDATA[
select sum(odd_price),odr_customer_id
from sal_order join orders_line
on odd_order_id=odr_id
group by odd_order_id
]]>
</select>
sal_orde表对应Order实体类，orders_line表对应OrdersLine实体类
请问resultMap应该怎么写？

Answer 1

resultMap = "java.util.HashMap"

sql这么写：
select sum(odd_price) sumoddprice,odr_customer_id custid
from sal_order join orders_line
on odd_order_id=odr_id
group by odd_order_id

然后用hashMap。get*** 取值

Answer 2

下面写的可对？我也求此问题答案