<select id="queryPharmacyVisitIds" resultMap="queryProductAndPharmacyVisit">
SELECT
tp.product_id,
tp.start_date,
tp.end_date,
tpv.pharmacy_visit_id
FROM
tb_promote_task_pharmacy AS tp
LEFT JOIN tb_promote_task_pharmacy_visit AS tpv ON tpv.promote_task_pharmacy_id = tp.id
WHERE
tp.task_item_id = #{taskItemId}
</select>
<resultMap id="queryProductAndPharmacyVisit" type="com.hooshine.hera.evidence.dto.pharmacy.PromoteTaskPharmacyVisitADTO">
<result column="tp.product_id" property="productId"/>
<result column="tp.start_date" property="startDate"/>
<result column="tp.end_date" property="endDate"/>
<collection property="productVisitIds" ofType="long">
<constructor>
<arg column="tpv.pharmacy_visit_id"/>
</constructor>
</collection>
</resultMap>
MyBatis,resultmap中collection 返回List<;Long>;
最新推荐文章于 2023-04-25 10:14:10 发布