最近在开发中,设计的库表结构是双主建,这时候我想通过主键集合对数据进行批量查询,上网找了个方法,经过验证和修改,记录下来。供大家使用
这是接口定义,记得加注解,不然找不到查询对象。
/**
* 根据主键批量查询采购明细信息
* @param detailBatchQueryList 主键集合
* @return 采购明细信息
*/
List<StorePurchaseDetailDTO> queryPurchaseListByPrimKeys(@Param("detailBatchQueryList") List<InfoDetailBatchQueryDTO> detailBatchQueryList);
<select id="queryPurchaseListByPrimKeys"
resultType="com.yinhai.hit.his.core.storage.dto.StorePurchaseDetailDTO">
select
<include refid="Base_Column_List"/>
from DS_STORE_PURCHASE_DETAIL
where (PURCHASE_BILL_ID,PURCHASE_BILL_DSNO) in
<foreach collection="detailBatchQueryList" item="detailQuery" separator=",">
((#{detailQuery.purchaseBillId,jdbcType=VARCHAR},#{detailQuery.purchaseBillDsno,jdbcType=DECIMAL})
)
</foreach>
</select>