在购物车列表中选择对应的商品之后，点击提交生成订单的过程

流程图：

 

接口实现：

收货地址列表接口：

此操作的数据库实现可以通过tkMapper通过方法完成

service接口：

package com.qfedu.fmmall.service;import com.qfedu.fmmall.vo.R;/*** @Description:* @Author : Jerry* @create : 2022-06-30 14:59*/
public interface UserAddrService {public R listAddrByUid(int userId);}

service实现类：

package com.qfedu.fmmall.service.impl;import com.qfedu.fmmall.dao.UserAddrMapper;
import com.qfedu.fmmall.entity.UserAddr;
import com.qfedu.fmmall.service.UserAddrService;
import com.qfedu.fmmall.vo.R;
import com.qfedu.fmmall.vo.ResStatus;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import tk.mybatis.mapper.entity.Example;import java.util.List;/*** @Description:* @Author : Jerry* @create : 2022-06-30 15:01*/
public class UserAddrServiceImpl implements UserAddrService {@Autowiredprivate UserAddrMapper userAddrMapper;@Transactional(propagation = Propagation.SUPPORTS)public R listAddrByUid(int userId) {Example example = new Example(UserAddrMapper.class);Example.Criteria criteria = example.createCriteria();criteria.andEqualTo("userId",userId);criteria.andEqualTo("status",1);List<UserAddr> userAddrs = userAddrMapper.selectByExample(example);R r = new R(ResStatus.OK, "success", userAddrs);return r;}
}

controller：

package com.qfedu.controller;import com.qfedu.fmmall.service.UserAddrService;
import com.qfedu.fmmall.vo.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;/*** @Description:* @Author : Jerry* @create : 2022-06-30 15:11*/
@RestController
@CrossOrigin
@RequestMapping("/userAddr")
public class UserAddrController {@Autowiredprivate UserAddrService userAddrService;@GetMapping("/login")public R listAddr(Integer userId, @RequestHeader("token") String token){R r = userAddrService.listAddrByUid(userId);return r;}}

购物车记录列表接口：

根据一个id的集合，查询购物车记录：

Mapper接口定义查询方法：

 映射配置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.qfedu.fmmall.dao.ShoppingCartMapper">
<resultMap id="ShoppingCartVOMap" type="com.qfedu.fmmall.entity.ShoppingCartVO"><result column="cart_id" jdbcType="INTEGER" property="cartId" /><result column="product_id" jdbcType="VARCHAR" property="productId" /><result column="sku_id" jdbcType="VARCHAR" property="skuId" /><result column="user_id" jdbcType="VARCHAR" property="userId" /><result column="cart_num" jdbcType="VARCHAR" property="cartNum" /><result column="cart_time" jdbcType="VARCHAR" property="cartTime" /><result column="product_price" jdbcType="DECIMAL" property="productPrice" /><result column="sku_props" jdbcType="VARCHAR" property="skuProps" /><result column="product_name" jdbcType="VARCHAR" property="productName" /><result column="url" jdbcType="VARCHAR" property="productImg" /><result column="original_price" jdbcType="VARCHAR" property="originalPrice" /><result column="sell_price" jdbcType="VARCHAR" property="sellPrice" /><result column="sku_name" jdbcType="VARCHAR" property="skuName" />
</resultMap>
<select id="selectShopCartByCids" resultMap="ShoppingCartVOMap">select c.cart_id,c.product_id,c.sku_id,c.user_id,c.cart_num,c.cart_time,c.product_price,c.sku_props,p.product_name, i.url,s.original_price,s.sell_price,s.sku_namefrom shopping_cart cINNER JOIN product pINNER JOIN product_img iINNER JOIN product_sku sON c.product_id = p.product_idand i.item_id = p.product_idand c.sku_id = s.sku_idwhere i.is_main = 1 and c.cart_id in<foreach collection="list" item="cid" separator="," open="(" close=")">#{cid}</foreach>
</select>
</mapper>

service接口：

 

service实现类：

使String变成集合

 

@Override
public R listShoppingCartsByCids(String cids) {String[] arr = cids.split(",");List<Integer> cardIds = new ArrayList<>();for(int i=0;i< arr.length;i++){cardIds.add(Integer.parseInt(arr[i]));}List<ShoppingCartVO> list = shoppingCartMapper.selectShopCartByCids(cardIds);R r = new R(ResStatus.OK, "success", list);return r;
}

controller：

@GetMapping("/listByCids")
public R listByCids(String cids, @RequestHeader("token")String token){R r = shoppingCartService.listShoppingCartsByCids(cids);//需用逗号隔开return r;
}

下一章订单提交及支付.............