秒杀

淡淡的烟草味﹌ 2022-04-01 14:46 376阅读 0赞

、

编辑页面列表，动态展示，我这里展示每页8个  
![2][]  
秒杀页  
![4][]  
详情页  
![2][2 1]

<li class="seckill-item">
    					<div class="pic">
    						<img src="img/_/list.jpg" alt=''>
    					</div>
    					<div class="intro"><span>Apple苹果iPhone 6s 32G金色 移动联通电信4G手机</span></div>
    					<div class='price'><b class='sec-price'>￥6088</b><b class='ever-price'>￥6988</b></div>
    					<div class='num'>
    						<div>已售87%</div>
    						<div class='progress'>
    							<div class='sui-progress progress-danger'><span style='width: 70%;' class='bar'></span></div>
    						</div>
    						<div>剩余<b class='owned'>29</b>件</div>
    					</div>
    					<a class='sui-btn btn-block btn-buy' href='seckill-item.html' target='_blank'>立即抢购</a>
    				</li>

包含字段  
![3][]

CREATE TABLE `tb_mkill` (
      `id` int(11) NOT NULL,
      `sku_id` bigint(20) DEFAULT NULL COMMENT '商品id 参考sku表',
      `began_time` datetime NOT NULL COMMENT '开始时间',
      `end_time` datetime DEFAULT NULL COMMENT '结束时间',
      `image` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `title` varchar(255) DEFAULT NULL,
      `mkill_price` bigint(15) NOT NULL COMMENT '秒杀价格参考sku表',
      `mkill_status` int(1) DEFAULT NULL COMMENT '秒杀状态 1可以秒杀 2不可以秒杀 ',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

> 依赖，使用了generator 生成pojo  
> 生成tb\_stock 以及tb\_mkill 这两张表单的entity  
> 参考 [https://blog.csdn.net/weixin\_42323802/article/details/83050762][https_blog.csdn.net_weixin_42323802_article_details_83050762]

![3][3 1]

完整依赖

业务字段seckill\_stock ‘可秒杀库存’, \`seckill\_total ‘秒杀总数量’,  
![2][2 2]

public @Data class TbMkill implements Serializable { 
        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private Integer id;
        private Long skuId;
        private Date beganTime;
        private Date endTime;
        private String image;
        private String title;
        private Double mkillPrice;
        private Integer mkillStatus;
        private static final long serialVersionUID = 1L;
        // 业务字段
        @Transient
        private Integer seckillStock;
        @Transient
        private Integer seckillTotal;
    }

public @Data class TbStock implements Serializable { 
        private Long skuId;
        private Integer seckillStock;
        private Integer seckillTotal;
        private Integer stock;
        private static final long serialVersionUID = 1L;
    
    }

当用户点击发送秒杀请求时候，封装sku作为参数传递、  
post 请求 [api.leyou.com/api/mkill/addMkill][api.leyou.com_api_mkill_addMkill]

/** * @auther SyntacticSugar * @data 2018/12/31 0031下午 2:42 * POST api.leyou.com/api/mkill/addMkill */
    public class MkillParams { 
        private Long skuId;
        private Date beganTime;
        private Date endTime;
        //参与秒杀的数目
        private Integer count;
        //折扣
        private Double discount;
    }

修改网关、重启网关  
![2][2 3]

通用mapper

public interface MkillMapper extends Mapper<TbMkill> { 
    }

public interface TbStockMapper extends Mapper<TbStock> { 
    }

controller

###### 1.1、添加秒杀商品到秒杀库存，修改库存、 ######

/** * @auther SyntacticSugar * @data 2018/12/31 0031下午 3:01 */
    @RestController
    public class MkillController { 
    
        @Autowired
        private MkillService mkillService;
        @PostMapping("addMkill")
        public ResponseEntity<Void> addMkill(@RequestBody MkillParams mkillParams){ 
            if (mkillParams!=null) { 
                this.mkillService.addMkillGoods(mkillParams);
            }else { 
                return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR);
            }
            return ResponseEntity.ok().build();
        }
    }

service

在这里插入代码片

###### 1.2、查询秒杀商品、 ######

[2]: /images/20220401/9a5de89907f549c2a5fb9ef86b8c7f23.png
[4]: /images/20220401/ff0c87672d0741aa97d1b6d5cdb4c52c.png
[2 1]: /images/20220401/7dfe7a0feb784c67b3f579ff8fa7535d.png
[3]: /images/20220401/eda51e4d62524905a4942414038b6bf0.png
[https_blog.csdn.net_weixin_42323802_article_details_83050762]: https://blog.csdn.net/weixin_42323802/article/details/83050762
[3 1]: /images/20220401/291704980fbd466bbcbc682467a457db.png
[2 2]: /images/20220401/85bf369a464c4faf8f404c47e16869a4.png
[api.leyou.com_api_mkill_addMkill]: http://api.leyou.com/api/mkill/addMkill
[2 3]: /images/20220401/398d271f5c02412b9c2b3c46605408f4.png