当前位置: 代码迷 >> 综合 >> 渲染刷新购物车
  详细解决方案

渲染刷新购物车

热度:74   发布时间:2024-02-20 17:24:42.0

把数组中的数据全部添加到list中

        String ids[]=specIds.split(",");List<String> specIdList=new ArrayList<String>();//把数据中的数据全部添加到list中Collections.addAll(specIdList,ids);

通过mybaits拼接字符串

   <select id="queryItemsBySpecIds" parameterType="list" resultType="com.imooc.pojo.vo.ShopcartVo">SELECTt_items.id AS itemId,t_items.item_name AS itemName,t_items_img.url AS itemImgUrl,t_items_spec.id AS specId,t_items_spec. NAME AS specName,t_items_spec.price_discount AS priceDiscount,t_items_spec.price_normal AS priceNormalFROMitems_spec t_items_specLEFT JOIN items t_items ON t_items.id = t_items_spec.item_idLEFT JOIN items_img t_items_img ON t_items_img.item_id = t_items.idWHEREt_items_img.is_main = 1AND t_items_spec.id IN<foreach collection="paramsList" index="index" item="specId" open="(" separator="," close=")">#{specId}</foreach><!-- ('1', '3', '5') --></select>

 

  相关解决方案