業務需求:
在小程序用戶端購物車頁面能查到當前用戶的所有菜品或者套餐
代碼實現
controller層
@GetMapping("/list")public Result<List<ShoppingCart>> list(){List<ShoppingCart> list = shoppingCartService.shopShoppingCart();return Result.success(list);}
實現類
獲取當前用戶的userId,組裝成一個shoppingcart對象,調用后臺sql進行查詢,將查詢的list返回。
@Overridepublic List<ShoppingCart> shopShoppingCart() {Long userId = BaseContext.getCurrentId();ShoppingCart cart = ShoppingCart.builder().userId(userId).build();List<ShoppingCart> list = shoppingCartMapper.list(cart);return list;}
清空購物車
@DeleteMapping("/clean")public Result clean(){shoppingCartService.deleteShoppingCart();return Result.success();}
?
@Overridepublic void deleteShoppingCart() {Long userId = BaseContext.getCurrentId();shoppingCartMapper.deleteByUserId(userId);}
?
@Delete("delete * from shopping_cart where id=#{userId}")void deleteByUserId(Long userId);