千峰商城-springboot项目搭建-75-购物车列表显示价格、数量及总价

1.sql：

#根据用户id查询当前用户的购物车信息
SELECT c.*,p.product_name,i.url,s.original_price,s.sell_price
FROM shopping_cart c 
INNER JOIN product p
INNER JOIN product_img i
INNER JOIN product_sku s
ON c.product_id=p.product_id 
AND i.item_id=p.product_id
AND c.sku_id=s.sku_id
WHERE user_id=14 AND i.is_main=1;

 

2.修改接口

ShoppingCartVO ：

@Data
@AllArgsConstructor
@NoArgsConstructor
public class ShoppingCartVO {

    private Integer cartId;
    private String productId;
    private String skuId;
    private String userId;
    private String cartNum;
    private String cartTime;
    private BigDecimal productPrice;
    private String skuProps;

    private String productName;
    private String productImg;

    private double originalPrice;
    private double sellPrice;
    private String skuName;


}

 

 ShoppingCartMapper.xml:

<?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="BaseResultMap" type="com.qfedu.fmmall.entity.ShoppingCart">
    <!--
      WARNING - @mbg.generated
    -->
    <id 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" />
  </resultMap>

  <resultMap id="ShoppingCartVOMap" type="com.qfedu.fmmall.entity.ShoppingCartVO">
    <!--
      WARNING - @mbg.generated
    -->
    <id 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="selectShopcartByUserId" 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_name
    FROM shopping_cart c
    INNER JOIN product p
    INNER JOIN product_img i
    INNER JOIN product_sku s
    ON c.product_id=p.product_id
    AND i.item_id=p.product_id
    AND c.sku_id=s.sku_id
    WHERE user_id=#{userId} AND i.is_main=1;
  </select>
</mapper>