• 千峰商城-springboot项目搭建-79-保存订单接口实现

    一、流程分析(基础版本)：

     二、数据库实现

    1.数据库操作：

    • 根据收货地址ID，获取收货地址信息(tkMapper)
    • 根据购物车ID，查询购物车详情(需要关联查询商品名称、sku名称、库存、商品图片、商品价格)——>获取生成商品快照的参数
    • 保存订单(tkMapper)
    • 修改库存(tkMapper)
    • 保存商品快照(tkMapper)

    (1)库存

    改造shoopingCart：

    ShoppingCartVO：

        private int skuStock;//库存

    1.   <resultMap id="ShoppingCartVOMap2" type="com.qfedu.fmmall.entity.ShoppingCartVO">
    2.         
    3.         <id column="cart_id" jdbcType="INTEGER" property="cartId" />
    4.         <result column="product_id" jdbcType="VARCHAR" property="productId" />
    5.         <result column="sku_id" jdbcType="VARCHAR" property="skuId" />
    6.         <result column="user_id" jdbcType="VARCHAR" property="userId" />
    7.         <result column="cart_num" jdbcType="VARCHAR" property="cartNum" />
    8.         <result column="cart_time" jdbcType="VARCHAR" property="cartTime" />
    9.         <result column="product_price" jdbcType="DECIMAL" property="productPrice" />
    10.         <result column="sku_props" jdbcType="VARCHAR" property="skuProps" />
    11.         <result column="product_name" jdbcType="VARCHAR" property="productName" />
    12.         <result column="url" jdbcType="VARCHAR" property="productImg" />
    13.         <result column="original_price" jdbcType="VARCHAR" property="originalPrice" />
    14.         <result column="sell_price" jdbcType="VARCHAR" property="sellPrice" />
    15.         <result column="sku_name" jdbcType="VARCHAR" property="skuName" />
    16.         <result column="stock" property="skuStock" />
    17.     resultMap>
    18.  
    19.     <select id="selectShopcartByCids" resultMap="ShoppingCartVOMap2">
    20.         SELECT c.cart_id,
    21.         c.product_id,
    22.         c.sku_id,
    23.         c.user_id,
    24.         c.cart_num,
    25.         c.cart_time,
    26.         c.product_price,
    27.         c.sku_props,
    28.         p.product_name,
    29.         i.url,
    30.         s.original_price,
    31.         s.sell_price,
    32.         s.sku_name,
    33.         s.stock
    34.         FROM shopping_cart c
    35.         INNER JOIN product p
    36.         INNER JOIN product_img i
    37.         INNER JOIN product_sku s
    38.         ON c.product_id=p.product_id
    39.         AND i.item_id=p.product_id
    40.         AND c.sku_id=s.sku_id
    41.         WHERE i.is_main=1 and c.cart_id IN
    42.         <foreach collection="cids" item="cid" separator="," open="(" close=")">
    43.             #{cid}
    44.         foreach>
    45.     select>
      OrderService： 
    1. public interface OrderService {
    2.     public ResultVO addOrder();
    3. }
      OrderServiceImpl： 
    1. @Service
    2. public class OrderServiceImpl implements OrderService {
    3.  
    4.     @Autowired
    5.     private ShoppingCartMapper shoppingCartMapper;
    6.     @Autowired
    7.     private OrdersMapper ordersMapper;
    8.     @Autowired
    9.     private OrderItemMapper orderItemMapper;
    10.  
    11.     public ResultVO addOrder(String cids,Orders order) {
    12.         //1.根据cids查询当前订单中关联的购物车记录详情(包括库存)
    13.         String[] arr = cids.split(",");
    14.         List<Integer> cidsList = new ArrayList<>();
    15.         for (int i=0; ilength;i++){
    16.             cidsList.add(Integer.parseInt(arr[i]));
    17.         }
    18.         List<ShoppingCartVO> list = shoppingCartMapper.selectShopcartByCids(cidsList);
    19.  
    20.         //2.校验库存
    21.         boolean f = true;
    22.         String untitled = "";
    23.         for (ShoppingCartVO sc:list){
    24.             if (Integer.parseInt( sc.getCartNum() )>sc.getSkuStock()){
    25.                 f=false;
    26.                 //break;
    27.             }
    28.             //获取所有商品的名称，以“，”分割拼接成字符串
    29.             untitled = untitled + sc.getProductName() + ",";
    30.         }
    31.         if (f){
    32.             //3.表示用户充足----------保存订单
    33.             order.setUntitled(untitled);
    34.             order.setCreateTime(new Date());
    35.             //生成订单编号
    36.             String orderId = UUID.randomUUID().toString().replace("-", "");
    37.             order.setOrderId(orderId);
    38.  
    39.             //4.保存订单
    40.             int i = ordersMapper.insert(order);
    41.             if (i>0){
    42.                 //生成商品快照
    43.                 List<OrderItem> orderItems = new ArrayList<>();
    44.                 for (ShoppingCartVO sc:list){
    45.                     String itemId = System.currentTimeMillis()+""+ (new Random().nextInt(89999)+10000 );
    46.                     OrderItem orderItem = new OrderItem(itemId, orderId, sc.getProductId(), sc.getProductName(), sc.getProductImg(),
    47.                             sc.getSkuId(), sc.getSkuName(),new BigDecimal(sc.getSellPrice()) , Integer.parseInt(sc.getCartNum()),
    48.                             new BigDecimal(sc.getSellPrice() * Integer.parseInt(sc.getCartNum())) , new Date(), new Date(), 0);
    49.                     orderItems.add(orderItem);
    50.                 }
    51.                 int j = orderItemMapper.insertList(orderItems);
    52.  
    53.                 //扣减库存
    54.  
    55.  
    56.             }
    57.  
    58.  
    59.         }else {
    60.             //表示库存不足
    61.             return new ResultVO(ResStatus.NO,"库存不足，下单失败！",null);
    62.         }
    63.         return null;
    64.     }
    65. }
    (2)保存订单
     OrderServiceImpl： 
    1. @Service
    2. public class OrderServiceImpl implements OrderService {
    3.  
    4.     @Autowired
    5.     private ShoppingCartMapper shoppingCartMapper;
    6.     @Autowired
    7.     private OrdersMapper ordersMapper;
    8.     @Autowired
    9.     private OrderItemMapper orderItemMapper;
    10.     @Autowired
    11.     private ProductSkuMapper productSkuMapper;
    12.  
    13.     public ResultVO addOrder(String cids,Orders order) {
    14.         //1.根据cids查询当前订单中关联的购物车记录详情(包括库存)
    15.         String[] arr = cids.split(",");
    16.         List cidsList = new ArrayList<>();
    17.         for (int i=0; i
    18.             cidsList.add(Integer.parseInt(arr[i]));
    19.         }
    20.         List list = shoppingCartMapper.selectShopcartByCids(cidsList);
    21.  
    22.         //2.校验库存
    23.         boolean f = true;
    24.         String untitled = "";
    25.         for (ShoppingCartVO sc:list){
    26.             if (Integer.parseInt( sc.getCartNum() )>sc.getSkuStock()){
    27.                 f=false;
    28.                 //break;
    29.             }
    30.             //获取所有商品的名称，以“，”分割拼接成字符串
    31.             untitled = untitled + sc.getProductName() + ",";
    32.         }
    33.         if (f){
    34.             //3.表示用户充足----------保存订单
    35.             order.setUntitled(untitled);
    36.             order.setCreateTime(new Date());
    37.             order.setStatus("1");
    38.             //生成订单编号
    39.             String orderId = UUID.randomUUID().toString().replace("-", "");
    40.             order.setOrderId(orderId);
    41.  
    42.             //4.保存订单
    43.             int i = ordersMapper.insert(order);
    44.             //if (i>0){
    45.                 //生成商品快照
    46.                 //List orderItems = new ArrayList<>();
    47.             for (ShoppingCartVO sc:list){
    48.                 int cnum = Integer.parseInt(sc.getCartNum());
    49.                 String itemId = System.currentTimeMillis()+""+ (new Random().nextInt(89999)+10000 );
    50.                 OrderItem orderItem = new OrderItem(itemId, orderId, sc.getProductId(), sc.getProductName(), sc.getProductImg(),
    51.                         sc.getSkuId(), sc.getSkuName(),new BigDecimal(sc.getSellPrice()) , cnum,
    52.                         new BigDecimal(sc.getSellPrice() * cnum) , new Date(), new Date(), 0);
    53.                 //orderItems.add(orderItem);
    54.                 int m = orderItemMapper.insert(orderItem);
    55.             }
    56.             //int j = orderItemMapper.insertList(orderItems);
    57.  
    58.             //5.扣减库存
    59.             for (ShoppingCartVO sc:list){
    60.                 String skuId = sc.getSkuId();
    61.                 int newStock = sc.getSkuStock() - Integer.parseInt(sc.getCartNum());
    62.  
    63. //                    Example example = new Example(ProductSku.class);
    64. //                    Example.Criteria criteria = example.createCriteria();
    65. //                    criteria.andEqualTo("skuId",skuId);
    66.  
    67. //                    ProductSku productSku = productSkuMapper.selectByPrimaryKey(skuId);
    68. //                    //ProductSku productSku = new ProductSku();
    69. //                    productSku.setStock(newStock);
    70. //                    int k = productSkuMapper.updateByPrimaryKey(productSku);
    71.  
    72.                 ProductSku productSku = new ProductSku();
    73.                 productSku.setSkuId(skuId);
    74.                 productSku.setStock(newStock);
    75.                 int k = productSkuMapper.updateByPrimaryKeySelective(productSku);
    76.  
    77.             }
    78.             return new ResultVO(ResStatus.OK,"下单成功！",orderId);
    79.  
    80.         }else {
    81.             //表示库存不足
    82.             return new ResultVO(ResStatus.NO,"库存不足，下单失败！",null);
    83.         }
    84.  
    85.     }
    86. }
      OrderController： 
    1. @RestController
    2. @CrossOrigin
    3. @RequestMapping("/order")
    4. @Api(value = "提供订单相关的操作接口",tags = "订单管理")
    5. public class OrderController {
    6.  
    7.     @Autowired
    8.     private OrderService orderService;
    9.  
    10.     @PostMapping("/add")
    11.     public ResultVO add(String cids,@RequestBody Orders order){
    12.         ResultVO resultVO = orderService.addOrder(cids, order);
    13.         return resultVO;
    14.     }
    15. }
     
     (3)事务管理 
    OrderServiceImpl:

    1.     //保存订单业务
    2.     @Transactional     //事务
    3.     public ResultVO addOrder(String cids,Orders order) {
    4.     ...
    5.  
    6.     }
     (4)删除购物车记录 
    OrderServiceImpl:

    1.             //6.删除购物车:当购物车中的记录购买成功后，购物车对应做删除操作
    2.             for (int cid:cidsList){
    3.                 shoppingCartMapper.deleteByPrimaryKey(cid);
    4.             }
     OrderServiceImpl抛出sq异常： 
    1. @Service
    2. public class OrderServiceImpl implements OrderService {
    3.  
    4.     @Autowired
    5.     private ShoppingCartMapper shoppingCartMapper;
    6.     @Autowired
    7.     private OrdersMapper ordersMapper;
    8.     @Autowired
    9.     private OrderItemMapper orderItemMapper;
    10.     @Autowired
    11.     private ProductSkuMapper productSkuMapper;
    12.  
    13.     //保存订单业务
    14.     @Transactional//事务
    15.     public ResultVO addOrder(String cids,Orders order) throws SQLException{
    16.         //1.根据cids查询当前订单中关联的购物车记录详情(包括库存)
    17.         String[] arr = cids.split(",");
    18.         List cidsList = new ArrayList<>();
    19.         for (int i=0; i
    20.             cidsList.add(Integer.parseInt(arr[i]));
    21.         }
    22.         List list = shoppingCartMapper.selectShopcartByCids(cidsList);
    23.  
    24.         //2.校验库存
    25.         boolean f = true;
    26.         String untitled = "";
    27.         for (ShoppingCartVO sc:list){
    28.             if (Integer.parseInt( sc.getCartNum() )>sc.getSkuStock()){
    29.                 f=false;
    30.                 //break;
    31.             }
    32.             //获取所有商品的名称，以“，”分割拼接成字符串
    33.             untitled = untitled + sc.getProductName() + ",";
    34.         }
    35.         if (f){
    36.             //3.表示用户充足----------保存订单
    37.             order.setUntitled(untitled);
    38.             order.setCreateTime(new Date());
    39.             order.setStatus("1");
    40.             //生成订单编号
    41.             String orderId = UUID.randomUUID().toString().replace("-", "");
    42.             order.setOrderId(orderId);
    43.  
    44.             //4.保存订单
    45.             ordersMapper.insert(order);
    46.             //if (i>0){
    47.                 //生成商品快照
    48.                 //List orderItems = new ArrayList<>();
    49.             for (ShoppingCartVO sc:list){
    50.                 int cnum = Integer.parseInt(sc.getCartNum());
    51.                 String itemId = System.currentTimeMillis()+""+ (new Random().nextInt(89999)+10000 );
    52.                 OrderItem orderItem = new OrderItem(itemId, orderId, sc.getProductId(), sc.getProductName(), sc.getProductImg(),
    53.                         sc.getSkuId(), sc.getSkuName(),new BigDecimal(sc.getSellPrice()) , cnum,
    54.                         new BigDecimal(sc.getSellPrice() * cnum) , new Date(), new Date(), 0);
    55.                 //orderItems.add(orderItem);
    56.                 orderItemMapper.insert(orderItem);
    57.             }
    58.             //int j = orderItemMapper.insertList(orderItems);
    59.  
    60.             //5.扣减库存
    61.             for (ShoppingCartVO sc:list){
    62.                 String skuId = sc.getSkuId();
    63.                 int newStock = sc.getSkuStock() - Integer.parseInt(sc.getCartNum());
    64.  
    65. //                    Example example = new Example(ProductSku.class);
    66. //                    Example.Criteria criteria = example.createCriteria();
    67. //                    criteria.andEqualTo("skuId",skuId);
    68.  
    69. //                    ProductSku productSku = productSkuMapper.selectByPrimaryKey(skuId);
    70. //                    //ProductSku productSku = new ProductSku();
    71. //                    productSku.setStock(newStock);
    72. //                    int k = productSkuMapper.updateByPrimaryKey(productSku);
    73.  
    74.                 ProductSku productSku = new ProductSku();
    75.                 productSku.setSkuId(skuId);
    76.                 productSku.setStock(newStock);
    77.                 productSkuMapper.updateByPrimaryKeySelective(productSku);
    78.  
    79.             }
    80.  
    81.             //6.删除购物车:当购物车中的记录购买成功后，购物车对应做删除操作
    82.             for (int cid:cidsList){
    83.                 shoppingCartMapper.deleteByPrimaryKey(cid);
    84.             }
    85.  
    86.  
    87.             return new ResultVO(ResStatus.OK,"下单成功！",orderId);
    88.  
    89.         }else {
    90.             //表示库存不足
    91.             return new ResultVO(ResStatus.NO,"库存不足，下单失败！",null);
    92.         }
    93.  
    94.     }
    95. }
      OrderController： 
    1. @RestController
    2. @CrossOrigin
    3. @RequestMapping("/order")
    4. @Api(value = "提供订单相关的操作接口",tags = "订单管理")
    5. public class OrderController {
    6.  
    7.     @Autowired
    8.     private OrderService orderService;
    9.  
    10.     @PostMapping("/add")
    11.     public ResultVO add(String cids,@RequestBody Orders order) {
    12.         ResultVO resultVO = null;
    13.         try {
    14.             resultVO = orderService.addOrder(cids, order);
    15.         }catch (SQLException e){
    16.  
    17.             resultVO = new ResultVO(ResStatus.NO,"提交订单失败",null);
    18.         }
    19.  
    20.         return resultVO;
    21.     }
    22. }
  • 相关阅读:
    【CQF Math Class 数学笔记】
    Android Datastore 动态创建与源码解析
    29、CSS进阶——美化表单元素
    EI/知网检索高录用国际学术会议推荐
    如何在Centos8中添加附加的IP
    LeetCode 2512. 奖励最顶尖的 K 名学生：哈希表设计
    如何监控公司电脑上网记录（员工上网行为监控软件有哪些?）
    计算机毕业设计Java校园新闻网站(系统+源码+mysql数据库+lw文档)
    产品经理就业喜报：沉舟侧畔终迎万木春
    酒店公共广播背景音乐-基于互联网+的酒店IP网络广播系统设计
  • 原文地址：https://blog.csdn.net/LYly_B/article/details/126073954