商品热销排行
1.商品–创建数据表
1.实现user命令选中store数据库。
use store;
2.在store数据库中创建t_product数据库
/* */ /*!40101 SET NAMES utf8 */; CREATE TABLE t_product ( id int(20) NOT NULL COMMENT '商品id', category_id int(20) DEFAULT NULL COMMENT '分类id', item_type varchar(100) DEFAULT NULL COMMENT '商品系列', title varchar(100) DEFAULT NULL COMMENT '商品标题', sell_point varchar(150) DEFAULT NULL COMMENT '商品卖点', price bigint(20) DEFAULT NULL COMMENT '商品单价', num int(10) DEFAULT NULL COMMENT '库存数量', image varchar(500) DEFAULT NULL COMMENT '图片路径', status int(1) DEFAULT '1' COMMENT '商品状态 1:上架 2:下架 3:删除', priority int(10) DEFAULT NULL COMMENT '显示优先级', created_time datetime DEFAULT NULL COMMENT '创建时间', modified_time datetime DEFAULT NULL COMMENT '最后修改时间', created_user varchar(50) DEFAULT NULL COMMENT '创建人', modified_user varchar(50) DEFAULT NULL COMMENT '最后修改人', PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000001','238',' 牛皮纸记事本 ',' 广博(GuangBo) 10本装40张A5牛皮纸记事本子日记本办公软抄本GBR0731 ',' 经典回顾！超值特惠！','23','99999','/images/portal/00GuangBo1040A5GBR0731/','1','62','2017-10-25 15:08:55','2017-10-25 15:08:55','admin ',' admin '); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000002','238',' 皮面日程本 ',' 广博(GuangBo) 皮面日程本子 计划记事本效率手册米色FB60322 ',' 经典回顾！超值特惠！','46','99999','/images/portal/001GuangBo)FB60322/','1','49','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000003','238','16k记事本','广博(GuangBo)16K115页线圈记事本子日记本文具笔记本图案随机','经典回顾！超值特惠！','13','99999','/images/portal/01GuangBo16K115FB60506/','1','58','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000004','241','计算器','得力（deli）1548A商务办公桌面计算器 太阳能双电源','经典回顾！超值特惠！','58','99999','/images/portal/002calculator1548A/','1','42','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000005','241','圆珠笔','施耐德（Schneider） K15 经典款圆珠笔 (5支混色装)','经典回顾！超值特惠！','29','99999','/images/portal/03SchneiderK15/','1','36','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000006','236','票据网格拉链袋','三木(SUNWOOD) C4523 票据网格拉链袋/文件袋 12个装 颜色随机','经典回顾！超值特惠！','28','99999','/images/portal/04_SUNWOODC452312/','1','53','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000007','163','燃 7000','戴尔Dell 燃700经典版金色','下单赠12000毫安移动电源','32999','99999','/images/portal/11DELLran7000gold/','1','59','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000008','163','燃 7000','戴尔Dell 燃700R1605经典版银色','仅上海，广州，沈阳仓有货！预购从速！','4549','99999','/images/portal/11DELLran7000R1605Ssilvery/','1','32','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000009','163','燃 7000','戴尔Dell 燃700学习版金色','下单赠12000毫安移动电源','39929','99999','/images/portal/11DELLran7000gold/','1','84','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000010','163','燃 7000','戴尔Dell 燃700R1605学习版银色','仅上海，广州，沈阳仓有货！预购从速！','5559','99999','/images/portal/11DELLran7000R1605Ssilvery/','1','21','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000011','163','燃 7000','戴尔Dell 燃700高配版金色','下单赠12000毫安移动电源','3994','99999','/images/portal/11DELLran7000gold/','1','56','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000012','163','燃 7000','戴尔Dell 燃700R1605高配版银色','仅上海，广州，沈阳仓有货！预购从速！','6559','99999','/images/portal/11DELLran7000R1605Ssilvery/','1','16','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000013','238','A5优品商务笔记本','齐心（COMIX）C5902 A5优品商务笔记本子记事本日记本122张','下单即送10400毫安移动电源！再赠手机魔法盒！','41','99999','/images/portal/02COMIXC5902A5122blue/','1','10','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000014','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3标准版金色','仅上海，广州，沈阳仓有货！预购从速！','4600','99999','/images/portal/12(DELL)XPS13gold/','1','1','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000015','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3标准版银色','仅上海，广州，沈阳仓有货！预购从速！','4601','99999','/images/portal/12DELLXPS13-silvery/','1','73','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000016','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3高配版金色','仅上海，广州，沈阳仓有货！预购从速！','4602','99999','/images/portal/12(DELL)XPS13gold/','1','64','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000017','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3高配版银色','仅上海，广州，沈阳仓有货！预购从速！','4604','99992','/images/portal/12DELLXPS13-silvery/','1','100','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000018','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3尊贵版金色','仅上海，广州，沈阳仓有货！预购从速！','4605','99999','/images/portal/12(DELL)XPS13gold/','1','7','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000019','163','XPS13-9360','戴尔(DELL)XPS13-9360-R1609 13.3尊贵版银色','仅上海，广州，沈阳仓有货！预购从速！','4899','99999','/images/portal/12DELLXPS13-silvery/','1','34','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000020','163','IdeaPad310','联想（Lenovo）IdeaPad310低配版黑色','清仓！仅北京，武汉仓有货！','5119','99999','/images/portal/13LenovoIdeaPad310_black/','1','50','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000021','163','IdeaPad310','联想（Lenovo）IdeaPad310低配版银色','清仓！仅北京，武汉仓有货！','5129','99999','/images/portal/13LenovoIdeaPad310_silvery/','1','48','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000022','163','IdeaPad310','联想（Lenovo）IdeaPad310经典版黑色','清仓！仅北京，武汉仓有货！','5119','99999','/images/portal/13LenovoIdeaPad310_black/','1','90','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000023','163','IdeaPad310','联想（Lenovo）IdeaPad310经典版银色','清仓！仅北京，武汉仓有货！','5129','99999','/images/portal/13LenovoIdeaPad310_silvery/','1','6','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000024','163','IdeaPad310','联想（Lenovo）IdeaPad310高配版黑色','清仓！仅北京，武汉仓有货！','5119','99999','/images/portal/13LenovoIdeaPad310_black/','1','60','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000025','163','IdeaPad310','联想（Lenovo）IdeaPad310高配版银色','清仓！仅北京，武汉仓有货！','5129','99999','/images/portal/13LenovoIdeaPad310_silvery/','1','80','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000026','163','YOGA710','联想（Lenovo）YOGA710 14英寸（i7-7500U 8G 256GSSD 2G独显）金色','【0元献礼】好评过万，销量传奇！经典蓝光电视，独有自然光技术专利，过大年带最好的回家！【0元白条试用，1001个拜年计划】','59999','99999','/images/portal/14LenovoYOGA710 _gold/','1','19','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000027','163','YOGA710','联想（Lenovo）YOGA710 14英寸（i7-7500U 8G 256GSSD 2G独显）银色','【0元献礼】好评过万，销量传奇！经典蓝光电视，独有自然光技术专利，过大年带最好的回家！【0元白条试用，1001个拜年计划】','59999','99999','/images/portal/14LenovoYOGA710 _silvery/','1','55','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000028','163','小新310','联想（Lenovo）小新310低配版黑色','清仓！仅北京，武汉仓有货！','4939','99997','/images/portal/15Lenovo_xiaoxin_310_black/','1','19','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000029','163','小新310','联想（Lenovo）小新310低配版银色','清仓！仅北京，武汉仓有货！','4839','99999','/images/portal/15Lenovo_xiaoxin_310_silvery/','1','27','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000030','163','小新310','联想（Lenovo）小新310经典版黑色','清仓！仅北京，武汉仓有货！','4739','99999','/images/portal/15Lenovo_xiaoxin_310_black/','1','78','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000031','163','小新310','联想（Lenovo）小新310经典版银色','清仓！仅北京，武汉仓有货！','4639','99998','/images/portal/15Lenovo_xiaoxin_310_silvery/','1','9','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000032','163','小新310','联想（Lenovo）小新310高配版黑色','清仓！仅北京，武汉仓有货！','4539','99999','/images/portal/15Lenovo_xiaoxin_310_black/','1','9','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000033','163','小新310','联想（Lenovo）小新310高配版银色','清仓！仅北京，武汉仓有货！','4439','99999','/images/portal/15Lenovo_xiaoxin_310_silvery/','1','18','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000034','163','YOGA900','联想（Lenovo）YOGA900绿色','青春的活力 清新漂亮高端大气上档次','5200','99999','/images/portal/16LenovoYOGA900green/','1','63','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000035','163','YOGA900','联想（Lenovo）YOGA900粉色','青春的活力 清新漂亮高端大气上档次','5200','99999','/images/portal/16LenovoYOGA900pink/','1','62','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000036','163','YOGA900','联想（Lenovo）YOGA900红色','青春的活力 清新漂亮高端大气上档次','5200','99999','/images/portal/16LenovoYOGA900red/','1','21','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000037','163','小新13旗舰版','联想(Lenovo)小新Air13 Pro 13.3英寸14.8mm超轻薄笔记本电脑金色','青春的活力 青年专属','6439','99998','/images/portal/17Lenovo)xiaoxinAir13Pro_gold/','1','16','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000038','163','小新13旗舰版','联想(Lenovo)小新Air13 Pro 13.3英寸14.8mm超轻薄笔记本电脑银色','青春的活力 青年专属','6439','99998','/images/portal/17Lenovo)xiaoxinAir13Pro_silvery/','1','17','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000039','163','XPS15','戴尔(DELL) XPS15 银色','限时特价！好评过万条优秀产品！','3333','99999','/images/portal/18(DELL)XPS15_silvery/','1','37','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000040','163','15MF Pro','戴尔(DELL)魔方15MF Pro-R2505TSS灵越标准版','15.6英寸二合一翻转笔记本电脑 (i5-7200U 8GB 1TB IPS Win10)触控银','4443','99999','/images/portal/19DELL15MF Pro/','1','35','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000041','163','XPS15-9550','戴尔(DELL) XPS15标准版','15.6英寸二合一翻转笔记本电脑 (i5-7200U 8GB 1TGB IPS Win10)触控','8443','99999','/images/portal/20DellXPS15-9550/','1','61','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000042','163','ThinkPad New s1','联想ThinkPad New S1（01CD） i5 6代 红色','经典回顾！超值特惠！','4399','99999','/images/portal/21ThinkPad_New_S1/','1','99','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000043','917','书包 bag','乐尚书包 电脑包 bag黑色','给你满载而归的喜悦！','89','99999','/images/portal/22_LEXON_LNE6025B06T/','1','12','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('10000044','917','书包 bag','乐尚书包 电脑包 bag粉色','给你满载而归的喜悦！','89','99999','/images/portal/22_LEXON_LNE6025B06T/','1','62','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000021','238','皮面日程本','广博(GuangBo)皮面日程本子 计划记事本效率手册蓝色FB60321','经典回顾！超值特惠！','22','99999','/images/portal/001GuangBo)FB60322/','1','73','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000391','163','XPS15','戴尔(DELL) XPS15 金色','限时特价！好评过万条优秀产品！','3333','99999','/images/portal/18(DELL)XPS15_silvery/','1','81','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000401','163','15MF Pro','戴尔(DELL)魔方15MF Pro-R2505TSS灵越高配版','15.6英寸二合一翻转笔记本电脑 (i5-7200U 8GB 1TB IPS Win10)触控白','4443','99997','/images/portal/19DELL15MF Pro/','1','86','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000402','163','15MF Pro','戴尔(DELL)魔方15MF Pro-R2505TSS灵越玩家版','15.6英寸二合一翻转笔记本电脑 (i7-7200U 8GB 512GB IPS Win10)触控银','6443','99999','/images/portal/19DELL15MF Pro/','1','84','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000403','163','15MF Pro','戴尔(DELL)魔方15MF Pro-R2505TSS灵越旗舰版','15.6英寸二合一翻转笔记本电脑 (i7-7200U 8GB 512GB IPS Win10)触控白','6443','99999','/images/portal/19DELL15MF Pro/','1','63','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000411','163','XPS15-9550','戴尔(DELL) XPS15升级版 ','15.6英寸二合一翻转笔记本电脑 (i5-7200U 8GB 256GB IPS Win10)触控','8443','99999','/images/portal/20DellXPS15-9550/','1','60','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000412','163','XPS15-9550','戴尔(DELL) XPS15高配版','15.6英寸二合一翻转笔记本电脑 (i7-7200U 8GB 1TB IPS Win10)触控','8443','99999','/images/portal/20DellXPS15-9550/','1','13','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000413','163','XPS15-9550','戴尔(DELL) XPS15专业版','15.6英寸二合一翻转笔记本电脑 (i7-7200U 8GB 256GB IPS Win10)触控','8443','99999','/images/portal/20DellXPS15-9550/','1','83','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000421','163','ThinkPad New s1','联想ThinkPad New S1（01CD） i7 6代 红色','经典回顾！超值特惠！','6399','99999','/images/portal/21ThinkPad_New_S1/','1','74','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000422','163','ThinkPad New s1','联想ThinkPad New S1（01CD） i5 6代 黄色','经典回顾！超值特惠！','4399','99999','/images/portal/21ThinkPad_New_S1/','1','23','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000424','163','ThinkPad New s1','联想ThinkPad New S1（01CD） i5 6代 蓝色','经典回顾！超值特惠！','4399','99999','/images/portal/21ThinkPad_New_S1/','1','87','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin'); insert into `t_product` (`id`, `category_id`, `item_type`, `title`, `sell_point`, `price`, `num`, `image`, `status`, `priority`, `created_time`, `modified_time`, `created_user`, `modified_user`) values('100000425','163','ThinkPad New s1','联想ThinkPad New S1（01CD） i7 6代 蓝色','经典回顾！超值特惠！','6399','99999','/images/portal/21ThinkPad_New_S1/','1','59','2017-10-25 15:08:55','2017-10-25 15:08:55','admin','admin');
t_product.sql
2.商品–创建实体类
创建com.cy.store.entity.Product类，并继承BaseEntity类。在类中声明与数据科中对应的属性。
/** 商品数据的实体类 */ public class Product extends BaseEntity implements Serializable { private Integer id; private Integer categoryId; private String itemType; private String title; private String sellPoint; private Long price; private Integer num; private String image; private Integer status; private Integer priority; //**** }
Product
3.商品热销排行–持久层
3.1 规划查询的SQL语句
查询热销商品列表的SQL语句。
SELECT * FORM t_product WHERE status=1 ORDER BY piority DESC LIMIT 0,4
3.1 规划查询的SQL语句
查询热销商品列表的SQL语句。
SELECT * FORM t_product WHERE status=1 ORDER BY piority DESC LIMIT 0,4
3.2 接口与抽象方法
package com.cy.store.mapper; import com.cy.store.entity.Product; import java.util.List; public interface ProductMapper { /* 查询热销商品的前四名*/ List<Product> findHotList(); }
3.3 配置SQL映射
<?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.cy.store.mapper.ProductMapper"> <resultMap id="ProductEntityMap" type="com.cy.store.entity.Product"> <id column="id" property="id"/> <result column="category_id" property="categoryId"/> <result column="item_type" property="itemType"/> <result column="sell_point" property="sellPoint"/> <result column="created_user" property="createdUser"/> <result column="created_time" property="createdTime"/> <result column="modified_user" property="modifiedUser"/> <result column="modified_time" property="modifiedTime"/> </resultMap> <!-- 查询热销商品的前四名：List<Product> findHostList() --> <select id="findHotList" resultMap="ProductEntityMap"> SELECT * FROM t_product WHERE status=1 ORDER BY priority DESC LIMIT 0,4 </select> </mapper>
ProductMapper–findHotList
4.商品热销排行–业务层
4.1 规划异常
说明：无异常
4.2 实现接口与抽象方法
package com.cy.store.service; import com.cy.store.entity.Product; import java.util.List; /* 处理商品数据的业务层接口 */ public interface IProductService { /*查询热销商品的前四名*/ List<Product> findHotList(); }
4.3 实现抽象方法
创建IProductService接口，并在接口中添加findHotList()方法。
package com.cy.store.service.impl; import com.cy.store.entity.Product; import com.cy.store.mapper.ProductMapper; import com.cy.store.service.IProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; /** 处理商品数据的业务层实现类 */ @Service public class ProductServiceImpl implements IProductService { @Autowired private ProductMapper productMapper; @Override public List<Product> findHotList() { List<Product> list = productMapper.findHotList(); for (Product product : list) { product.setPriority(null); product.setCreatedUser(null); product.setCreatedTime(null); product.setModifiedUser(null); product.setModifiedTime(null); } return list; } }
ProductServiceImpl–findHotList
5.商品热销排行–控制器
5.1 处理异常
说明：无异常
5.2 设计请求
1.设计用户提交的请求，并设计响应的方法
请求路径：/products/hot_list 请求参数：无 请求类型： GET 响应结果：JsonResult<List<Product>> 是否拦截：否，需要将index.html和/products/**请求添加白名单
2.在LoginInterceptorConfigurer中将index.html页面和/products/**请求添加白名单
patterns.add("/web/index.html"); patterns.add("/products/**");
LoginInterceptorConfigurer–/products
5.3 处理请求
1.创建ProductController类继承BaseController类，类添加@RestController和@RequestMapping(“products”)注解，并在类中添加业务层对象。
2.在类中添加处理请求的getHotList()方法。
package com.cy.store.controller; import com.cy.store.entity.Product; import com.cy.store.service.IProductService; import com.cy.store.util.JsonResult; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController @RequestMapping("products") public class ProductController extends BaseController { @Autowired private IProductService productService; @RequestMapping("hot_list") public JsonResult<List<Product>> getHotList() { List<Product> data = productService.findHotList(); return new JsonResult<List<Product>>(OK, data); } }
ProductController–getHotList
3.完成后启动项目，直接访问测试。
6 商品热销排行–前端页面
1.在index.html给“热销排行”列表的div标签设置id属性值。
<div id="hot-list" class="panel-body panel-item">
2.在index.html页面中body标签内部的最后，添加展示热销排行商品的代码。
<!-- showHotList --> <script type="text/javascript"> $(document).ready(function() { showHotList(); }); function showHotList() { $("#hot-list").empty(); $.ajax({ url: "/products/hot_list", type: "GET", dataType: "JSON", success: function(json) { let list = json.data; console.log("count=" + list.length); for (let i = 0; i < list.length; i++) { console.log(list[i].title); let html = '<div class="col-md-12">' + '<div class="col-md-7 text-row-2"><a href="product.html?id=#{id}">#{title}</a></div>' + '<div class="col-md-2">¥#{price}</div>' + '<div class="col-md-3"><img src="..#{image}collect.png" class="img-responsive" /></div>' + '</div>'; html = html.replace(/#{id}/g, list[i].id); html = html.replace(/#{title}/g, list[i].title); html = html.replace(/#{price}/g, list[i].price); html = html.replace(/#{image}/g, list[i].image); $("#hot-list").append(html); } } }); } </script> <!-- showHotList -->
index.html–showHotList
最后测试
说明：图片存储在portal下
README–商品热销排行
