mybatis中的resultMap一对多映射是通过标签进行映射的
SELECT h.id,v.vessel_no,v.voyage_no,h.offhire_start_time,h.offhire_end_time,pc.port_name ,pc.port_charge
FROM dh_voybeb_hwsr h
right join dh_voybeb_voyagev on v.vessel_no = h.vessel_no and v.voyage_no = h.voyage_no
left join dh_voybeb_port_charge pc on pc.vessel_no = v.vessel_no and pc.voyage_no =v.voyage_no
如上图,dh_voybeb_hwsr 和dh_voybeb_port_charge 的关系是一对多,如果用resultMap映射通过“一”中的重复属性(如下图)用标签来确定一对多关系。