渲染刷新购物车

最新推荐文章于 2022-10-08 10:52:57 发布

learning coding

最新推荐文章于 2022-10-08 10:52:57 发布

阅读量178

点赞数

本文链接：https://blog.csdn.net/weixin_43434182/article/details/108696087

版权

天天吃货项目学习笔记专栏收录该内容

34 篇文章 6 订阅

订阅专栏

把数组中的数据全部添加到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">
        SELECT
            t_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 priceNormal
        FROM
            items_spec t_items_spec
        LEFT JOIN items t_items ON t_items.id = t_items_spec.item_id
        LEFT JOIN items_img t_items_img ON t_items_img.item_id = t_items.id
        WHERE
            t_items_img.is_main = 1
        AND t_items_spec.id IN
        <foreach collection="paramsList" index="index" item="specId" open="(" separator="," close=")">
            #{specId}
        </foreach>
        <!-- ('1', '3', '5') -->
    </select>