mybatis多表关联查询返回类型map

最新推荐文章于 2024-09-22 16:21:14 发布

溜走的螃蟹

最新推荐文章于 2024-09-22 16:21:14 发布

阅读量5.7k

点赞数 1

分类专栏： mybatis 文章标签： mybatis多表关联查询返回类型map

本文链接：https://blog.csdn.net/liutianjie/article/details/86470453

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<!-- 根据异型产品id和制单人筛选出制单人下过的异型产品订单号和库存数量 -->
  <select id="selectOrderNoByPIdAndSP" resultType="java.util.Map" parameterType="Map" >
    SELECT o.order_no orderNo,k.product_count productCount,c.add_date addDate
	FROM (SELECT * FROM order_info_details WHERE single_person = #{singlePerson} 
	AND product_id IN ( 
	<foreach collection="list" item="id" index="index" separator=",">
		#{id}
	</foreach>)) o left join kuwei_pro_table k on o.order_no = k.dingdan_hao 
	left join churuku_table c on o.order_no = c.dingdan_hao
  </select>