SQL中根据传入的idList循环查询
<select id="getCollectByShop" parameterType="java.util.List" resultMap="shopCollectBuyMap"> SELECT GI.GOODS_DBID, GI.CS_DBID, GI.GOODS_NAME, GI.GOODS_MAT_CODE, GI.GOODS_CONTRACT_PRICE, GI.GOODS_CAN_BUY, GI.GOODS_MIN_CAN_BUY, GI.GOODS_MEASUER_UNIT FROM GOODS_INFO AS GI WHERE GI.GOODS_DBID IN <foreach collection="goodsDbidList" item="item" index="" separator="," open="(" close=")"> #{item} </foreach>
</select>
dao层:
List<GoodsInfoVO> getCollectByShop(@Param("goodsDbidList") List<String> goodsDbidList);
[ 版权声明 ]:
本文所有权归作者本人,文中参考的部分已经做了标记!
商业用途转载请联系作者授权!
非商业用途转载,请标明本文链接及出处!