秒杀的步骤和使用redis+rabbitmq优化后的步骤

秒杀步骤：

1、判断用户是否登陆

2、在秒杀商品表里判断库存是否足够

@Select("select g.*,sg.stock_count,sg.start_date,sg.end_date,sg.seckill_price from seckill_goods sg left join goods g  on sg.goods_id=g.id where g.id=#{goodsId}")

3、在秒杀订单表里判断是否秒杀到

@Select("select * from seckill_order where user_id=#{userId} and goods_Id=#{goodsId}")

4、在秒杀商品表里减少库存

@Update("update seckill_goods set stock_count=stock_count-1 where goods_id=#{goodsId} and stock_count>0")

5、在订单表里和秒杀订单表里生成订单

@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} )")

@Insert("insert into seckill_order (user_id, goods_id, order_id)values(#{userId}, #{goodsId}, #{orderId})")