sql resultType="java.util.HashMap"

最新推荐文章于 2021-12-14 17:35:13 发布

weixin_34391854

最新推荐文章于 2021-12-14 17:35:13 发布

阅读量1.3k

点赞数

文章标签： java python 数据库

原文链接：https://my.oschina.net/u/2611159/blog/809625

版权

2019独角兽企业重金招聘Python工程师标准>>>

结果集为hashMap时的sql

mapper List<HashMap> sel*();

<select id="selGoodsCateTotaNum" resultType="java.util.HashMap" parameterType="com.nxmall.nxds.goods.dao.model.Goods">
  SELECT SUM(b.curr_stock) as tNum , a.category_id
   FROM nxds_goods  a LEFT JOIN `nxds_goods_spec`  b ON a.id = b.goods_id
  WHERE  a.is_enabled = '1'  AND a.system_id='1'  GROUP BY a.category_id
</select>

转载于:https://my.oschina.net/u/2611159/blog/809625