第一步:在减少库存的时候进行判断stock_count>0
package com.jack.seckill.dao;
@Mapper
public interface GoodsDao {
@Update("update seckill_goods set stock_count=stock_count-1 where goods_id=#{goodsId} and stock_count>0")
public void reduceStock(SeckillGoods g);
}
第二步:在mysql数据库添加唯一索引
以上2个步骤就能解决秒杀超卖问题