21、【购物车模块】——全选、全反选、单选、单反选、查询购物车商品数量功能开发

谁借莪１个温暖的怀抱￠ 2022-05-06 01:28 191阅读 0赞

\#\#\#\#1、接口开发：  
\#\#\#\#\#\#1、全选接口开发：  
`*Controller`:

//全选
        @RequestMapping("select_all.do")
        @ResponseBody
        public ServerResponse<CartVo> selectAll(HttpSession session){ 
            User user =(User) session.getAttribute(Const.CURRENT_USER);
    
            if(user == null){ 
                return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
            }
            return iCartService.selectOrUnselectAll(user.getId(),Const.Cart.CHECKED,null);
        }

`*Service`:

//购物车选或不选
        ServerResponse<CartVo> selectOrUnselectAll(Integer userId,Integer checked,Integer productId);

`*ServiceImpl`:

//购物车全选或全不选
        public ServerResponse<CartVo> selectOrUnselectAll(Integer userId,Integer checked,Integer productId){
            cartMapper.checkedOrUncheckedProduct(userId,checked,productId);
            return this.list(userId);
        }

`checkedOrUncheckedProduct`方法：  
`*Mapper`:

//全选购物车中的商品或者不全选购物车中的商品
        int checkedOrUncheckedProduct(@Param("userId") Integer userId,@Param("checked") Integer checked,@Param("productId") Integer productId);

`*Mappler.xml`:

<update id="checkedOrUncheckedProduct" parameterType="map">
        update mmall_cart
        set checked = #{checked},
        update_time=now()
        where user_id=#{userId}
        <if test="productId != null">
        and product_id=#{productId}
        </if>
      </update>

上面`Impl`方法中的`list`方法在上一篇文章中：[20、【购物车模块】——更新、删除、查询购物车功能开发][20]获取购物车信息列表的时候又讲~

\#\#\#\#\#2、全反选接口开发：  
`*Controller`:

//全反选
        @RequestMapping("un_select_all.do")
        @ResponseBody
        public ServerResponse<CartVo> unSelectAll(HttpSession session,Integer productId){ 
            User user =(User) session.getAttribute(Const.CURRENT_USER);
    
            if(user == null){ 
                return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
            }
            return iCartService.selectOrUnselectAll(user.getId(),Const.Cart.UN_CHECKED,null);
        }

`*Service`:

//购物车选或不选
        ServerResponse<CartVo> selectOrUnselectAll(Integer userId,Integer checked,Integer productId);

`*ServiceImpl`:

//购物车全选或全不选
        public ServerResponse<CartVo> selectOrUnselectAll(Integer userId,Integer checked,Integer productId){ 
            cartMapper.checkedOrUncheckedProduct(userId,checked,productId);
            return this.list(userId);
        }

`checkedOrUncheckedProduct`方法：  
`*Mapper`:

`*Mappler.xml`:

其实全选不全反选接口是差不多的，只是在现在的是否选中的状态进行了判断~  
\#\#\#\#\#3、单选接口开发：  
`*Controller`:

//单独选
        @RequestMapping("select.do")
        @ResponseBody
        public ServerResponse<CartVo> Select(HttpSession session,Integer productId){ 
            User user =(User) session.getAttribute(Const.CURRENT_USER);
    
            if(user == null){ 
                return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
            }
            return iCartService.selectOrUnselectAll(user.getId(),Const.Cart.CHECKED,productId);
        }

\#\#\#\#\#4、单反选接口开发：

//单独反选
        @RequestMapping("un_select.do")
        @ResponseBody
        public ServerResponse<CartVo> unSelect(HttpSession session,Integer productId){ 
            User user =(User) session.getAttribute(Const.CURRENT_USER);
            if(user == null){ 
                return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
            }
            return iCartService.selectOrUnselectAll(user.getId(),Const.Cart.UN_CHECKED,productId);
        }

\#\#\#其中单选，单反选同意也是用了上面`selectOrUnselectAll`方法，只是传递的参数不同~

\#\#\#\#\#5、查询购物车数量接口开发：  
`*Controller`:

//查询当前用户购物车的数量，如果一个产品数量有十个，我们显示是1个
        @RequestMapping("get_cart_product_count.do")
        @ResponseBody
        public ServerResponse<Integer> getCartProductCount(HttpSession session){ 
            User user =(User) session.getAttribute(Const.CURRENT_USER);
    
            if(user == null){ 
                return ServerResponse.createBySuccess(0);
            }
            return iCartService.getCartProductCount(user.getId());
        }

`*Service`:

//获取用户购物车中商品数量
        ServerResponse<Integer> getCartProductCount(Integer userId);

`*ServiceImpl`:

//获取用户购物车中商品数量
        public  ServerResponse<Integer> getCartProductCount(Integer userId){ 
            if(userId == null){ 
                return ServerResponse.createBySuccess(0);
            }
            return ServerResponse.createBySuccess(cartMapper.selectProductCountByUserId(userId));
        }

`*Mapper`:

//根据用户Id查询购物车中商品的数量
        int selectProductCountByUserId(Integer userId);

`*Mappler.xml`:

<select id="selectProductCountByUserId" resultType="int" parameterType="int" >
            select IFNULL(sum(quantity),0) as count from mmall_cart where user_id = #{userId}
    
        </select>

\#\#\#\#2、接口测试：  
\#\#\#\#\#1、全选接口测试：  
![image.png][]

\#\#\#\#\#2、全反选接口测试：  
![image.png][image.png 1]  
\#\#\#\#\#3、单选接口测试：  
![image.png][image.png 2]  
\#\#\#\#\#4、单反选接口测试：  
![image.png][image.png 3]  
\#\#\#\#\#5、获取购物车数量接口测试：  
![image.png][image.png 4]

[20]: https://www.jianshu.com/p/1e13c7b7970a
[image.png]: /images/20220506/0656d6cfbfc64d51a1d3918eef158414.png
[image.png 1]: /images/20220506/09f83cc4ff9746cb879b349ead3e2376.png
[image.png 2]: /images/20220506/0079d87bc33e4e3ea64ce7ec1d1a4950.png
[image.png 3]: /images/20220506/ce1b2fb849644575a93b412d13f6325d.png
[image.png 4]: /images/20220506/5b8969fc383f4b18bcefad07c51aebcc.png