秒杀项目学习笔记-秒杀功能实现

目的：商品详情的页面中立即秒杀的功能实现

<td>
    <form id="miaoshaForm" method="post" action="/miaosha/do_miaosha">
        <button class="btn btn-primary btn-block" type="submit" id="buyButton">立即秒杀</button>
        <input type="hidden" name="goodsId" th:value="${goods.id}" />
    </form>
</td>

Controller层

创建MiaoshaController

@Controller
@RequestMapping("/miaosha")
public class MiaoshaController {
    @Autowired
    GoodsService goodsService;
    @Autowired
    OrderService orderService;
    @Autowired
    MiaoshaService miaoshaService;
    
    @RequestMapping("/do_miaosha")
    public String list(Model model, MiaoshaUser user, @RequestParam("goodsId")long goodsId){
        model.addAttribute("user", user);
        //查看登陆状态，未登录返回登陆页面
        if(user == null) {
            return "login";
        }
        //判断库存
        GoodsVo goods = goodsService.getGoodsVoByGoodsId(goodsId);
        int stock = goods.getStockCount();
        if(stock <= 0) {
            model.addAttribute("errmsg", CodeMsg.MIAO_SHA_OVER.getMsg());
            return "miaosha_fail";
        }
        //查询订单，判断是否已经秒杀到了
        MiaoshaOrder order = orderService.getMiaoshaOrderByUserIdGoodsId(user.getId(),goodsId);
        if(order != null){
            model.addAttribute("errmsg", CodeMsg.REPEATE_MIAOSHA.getMsg());
            return "miaosha_fail";
        }
        //减少库存，生成订单
        OrderInfo orderInfo = miaoshaService.miaosha(user, goods);
        model.addAttribute("orderInfo", orderInfo);
        model.addAttribute("goods", goods);
        return "order_detail";//返回订单详情页
    }
}

Service层

创建OrderService

OrderService会生成两个表：OrderInfo、MiaoshaOrder。

@Service
public class OrderService {
    @Autowired
    OrderDao orderDao;
    public MiaoshaOrder getMiaoshaOrderByUserIdGoodsId(long userId, long goodsId) {
        return orderDao.getMiaoshaOrderByUserIdGoodsId(userId, goodsId);
    }
    @Transactional
    public OrderInfo createOrder(MiaoshaUser user, GoodsVo goods) {
        //生成orderInfo对象并赋值，插入到order_info表
        OrderInfo orderInfo = new OrderInfo();
        orderInfo.setCreateDate(new Date());
        orderInfo.setDeliveryAddrId(0L);
        orderInfo.setGoodsCount(1);
        orderInfo.setGoodsId(goods.getId());
        orderInfo.setGoodsName(goods.getGoodsName());
        orderInfo.setGoodsPrice(goods.getMiaoshaPrice());
        orderInfo.setOrderChannel(1);
        orderInfo.setStatus(0);
        orderInfo.setUserId(user.getId());
        long orderId = orderDao.insert(orderInfo);
        //生成miaoshaOrder对象并赋值，插入到miaosha_order表中
        MiaoshaOrder miaoshaOrder = new MiaoshaOrder();
        miaoshaOrder.setGoodsId(goods.getId());
        miaoshaOrder.setOrderId(orderId);
        miaoshaOrder.setUserId(user.getId());
        orderDao.insertMiaoshaOrder(miaoshaOrder);
        return orderInfo;
    }
}

创建MiaoshaService

调用goodsService将商品数量减一，调用orderService生成两个订单表
在MiaoshaService下不建议使用orderDao、goodsDao，可以使用OrderService、GoodsService完成相应功能。因为调用service有可能

@Service
public class MiaoshaService {
    @Autowired
    OrderService orderService;
    @Autowired
    GoodsService goodsService;
    @Transactional
    public OrderInfo miaosha(MiaoshaUser user, GoodsVo goods){
        //减库存 下订单 写入秒杀订单
        //将miaosha_goods里面对应商品的数量减一
        goodsService.reduceStock(goods);
        //生成两张表：order_info maiosha_order 并且返回order_info
        return orderService.createOrder(user, goods);
    }
}

GoodsService添加如下方法

只需要传goods.id,让goodsDao把相应商品的数量减一。

 public void reduceStock(GoodsVo goods){  
        goodsDao.reduceStock(goods.getId());
    }

Dao层

GoodsDao添加如下方法

@Update("update miaosha_goods set stock_count = stock_count - 1 where goods_id = #{id}")
    public  int reduceStock(long id);

创建OrderDao

@Mapper
public interface OrderDao {

    @Select("select * from miaosha_order where user_id = #{userId} and goods_id = #{goodsId}")
    public MiaoshaOrder getMiaoshaOrderByUserIdGoodsId(@Param("userId")long userId,@Param("goodsId")long goodsId);

    @Insert("insert into order_info(user_id, goods_id, goods_name, goods_count, goods_price, order_channel, status, create_date)values("
            + "#{userId}, #{goodsId}, #{goodsName}, #{goodsCount}, #{goodsPrice}, #{orderChannel},#{status},#{createDate} )")
    @SelectKey(keyColumn="id", keyProperty="id", resultType=long.class, before=false, statement="select last_insert_id()")
    public long insert(OrderInfo orderInfo);

    @Insert("insert into miaosha_order (user_id, goods_id, order_id)values(#{userId}, #{goodsId}, #{orderId})")
    public int insertMiaoshaOrder(MiaoshaOrder miaoshaOrder);
}

效果

order_detail.html，只显示秒杀商品的名称


原来秒杀商品数量都是8个，现在iphonex少了一个