网站建设项目背景,建一个营销网站的步骤,网站 个人 公司 区别是什么,程序员给女盆友做的网站目录前言一、登录方式调整二、生成秒杀订单2.1 绑定秒杀商品2.2 查看秒杀商品2.3 订单秒杀2.3.1 移除seata相关#xff08;方便测压#xff09;2.3.2 生成秒杀订单2.3.3 前端页面秒杀测试注意前言 博主博客用到的资源都会同步分享到资源包中 一、登录方式调整
第1步#xf…
目录前言一、登录方式调整二、生成秒杀订单2.1 绑定秒杀商品2.2 查看秒杀商品2.3 订单秒杀2.3.1 移除seata相关方便测压2.3.2 生成秒杀订单2.3.3 前端页面秒杀测试注意前言 博主博客用到的资源都会同步分享到资源包中 一、登录方式调整
第1步从zmall-common的pom.xml中移除spring-session-data-redis依赖 注意 1本项目中不采用spring-session方式改用redis直接存储用户登录信息主要是为了方便之后的jmeter压测 2这里只注释调用spring-session的依赖保留redis的依赖 第2步在zmall-common公共模块中定义RedisConfig配置类
Configuration
public class RedisConfig {Beanpublic RedisTemplateString,Object restTemplate(RedisConnectionFactory redisConnectionFactory){RedisTemplateString,Object redisTemplatenew RedisTemplate();//String类型Key序列化redisTemplate.setKeySerializer(new StringRedisSerializer());//String类型Value序列化redisTemplate.setValueSerializer(new GenericJackson2JsonRedisSerializer());//Hash类型Key序列化redisTemplate.setHashKeySerializer(new StringRedisSerializer());//Hash类型Value序列化redisTemplate.setHashValueSerializer(new GenericJackson2JsonRedisSerializer());redisTemplate.setConnectionFactory(redisConnectionFactory);return redisTemplate;}
}这里一定要注意最后在将RedisConnectionFactory设置到RedisTemplate中不要在最前做该步操作不然会导致String和Hash类型的序列化无效将采用默认的JdkSerializationRedisSerializer进行序列化从而导致保存的key前缀出现乱码问题。细心细心细心o(╥﹏╥)o 参考链接 第3步在zmall-common公共模块中配置redis相关服务 IRedisServcie
public interface IRedisService {/*** 将登陆用户对象保存到Redis中并以token来命名* param token* param user*/void setUserToRedis(String token, User user);/*** 根据token令牌从Redis中获取User对象* param token* return*/User getUserByToken(String token);
}RedisServcieImple
Service
public class RedisServiceImpl implements IRedisService {Autowiredprivate RedisTemplateString,Object redisTemplate;Overridepublic void setUserToRedis(String token, User user) {String keyuser:token;redisTemplate.boundValueOps(key).set(user,7200,TimeUnit.SECONDS);}Overridepublic User getUserByToken(String token) {return (User) redisTemplate.opsForValue().get(user:token);}
}用户登录成功后将用户对象保存到Redis中并设置超时时间7200秒。 第4步在zmall-common公共模块中配置配置自定义参数解析UserArgumentResolver、WebConfig
/*** 自定义用户参数类*/
Component
public class UserArgumentResolver implements HandlerMethodArgumentResolver {Autowiredprivate IRedisService redisService;/*** 只有supportsParameter方法执行返回true才能执行下面的resolveArgument方法* param methodParameter* return*/Overridepublic boolean supportsParameter(MethodParameter methodParameter) {Class? type methodParameter.getParameterType();return type User.class;}Overridepublic Object resolveArgument(MethodParameter methodParameter,ModelAndViewContainer modelAndViewContainer,NativeWebRequest nativeWebRequest,WebDataBinderFactory webDataBinderFactory) throws Exception {HttpServletRequest req (HttpServletRequest) nativeWebRequest.getNativeRequest();//从cookie获取token令牌String token CookieUtils.getCookieValue(req, token);//判断cookie中的token令牌是否为空if(StringUtils.isEmpty(token))throw new BusinessException(JsonResponseStatus.TOKEN_ERROR);//根据token令牌获取redis中存储的user对象方便jmeter测试User user redisService.getUserByToken(token);if(nulluser)throw new BusinessException(JsonResponseStatus.TOKEN_ERROR);return user;}
}WebConfig
Component
public class WebConfig implements WebMvcConfigurer {Autowiredprivate UserArgumentResolver userArgumentResolver;Overridepublic void addArgumentResolvers(ListHandlerMethodArgumentResolver resolvers) {resolvers.add(userArgumentResolver);}Overridepublic void addResourceHandlers(ResourceHandlerRegistry registry) {//添加静态资源访问映射//registry.addResourceHandler(/static/**)// .addResourceLocations(classpath:/static/);}
}第5步用户登录业务调整将spring-session方式更改为redis方式存储登录用户信息。
//5.通过UUID生成token令牌并保存到cookie中
String token UUID.randomUUID().toString().replace(-,);
//将随机生成的Token令牌保存到Cookie中并设置1800秒超时时间
CookieUtils.setCookie(req,resp,token,token,7200);
//6.将token令牌与spring session进行绑定并存入redis中
//HttpSession session req.getSession();
//session.setAttribute(token,us);
//将token令牌与user绑定后存储到redis中方便jmeter测试
redisService.setUserToRedis(token,us);这里采用Redis方式直接存储登录用户信息只为后续使用Jmeter压测时提供便利。正常运行使用项目还是可以使用spring-session方式。 第6步修改商品服务zmall-product模块中的index方法将之前从HttpSession中获取登录用户信息改换成User对象参数方式
RequestMapping(/index.html)
public String index(Model model, User user){System.out.println(user);
}在调用index方法之前先由自定义的参数解析器进行参数解析并返回解析结果User所以在这里可直接在方法参数中获取的User对象。 第7步重启zmall-user和zmall-product模块完成用户登录后直接在浏览器地址栏输入http://zmall.com/product-serv/index.html查看zmall-product模块中的控制台是否已经获取到登录用户对象信息。 二、生成秒杀订单
2.1 绑定秒杀商品
首先页面加入到项目中
sellDetails.html
!DOCTYPE html
html xmlnshttp://www.w3.org/1999/xhtml
head
#include common/head.html
meta http-equivContent-Type contenttext/html; charsetutf-8 /link typetext/css relstylesheet hrefcss/style.css /!--[if IE 6]script srcjs/iepng.js typetext/javascript/scriptscript typetext/javascriptEvPNG.fix(div, ul, img, li, input, a); /script![endif]-- script typetext/javascript srcjs/jquery-1.11.1.min_044d0927.js/scriptscript typetext/javascript srcjs/jquery-1.8.2.min.js/scriptscript typetext/javascript srcjs/menu.js/script script typetext/javascript srcjs/lrscroll_1.js/scriptscript typetext/javascript srcjs/n_nav.js/script title尤洪/title
/head
body
!--Begin Header Begin--
div classsoubgdiv classsou!--Begin 所在收货地区 Begin--span classs_city_bspan classfl送货至/spanspan classs_cityspan四川/spandiv classs_city_bgdiv classs_city_t/divdiv classs_city_ch2请选择所在的收货地区/h2table border0 classc_tab stylewidth:235px; margin-top:10px; cellspacing0 cellpadding0trthA/thtd classc_hspan安徽/spanspan澳门/span/td/trtrthB/thtd classc_hspan北京/span/td/trtrthC/thtd classc_hspan重庆/span/td/trtrthF/thtd classc_hspan福建/span/td/trtrthG/thtd classc_hspan广东/spanspan广西/spanspan贵州/spanspan甘肃/span/td/trtrthH/thtd classc_hspan河北/spanspan河南/spanspan黑龙江/spanspan海南/spanspan湖北/spanspan湖南/span/td/trtrthJ/thtd classc_hspan江苏/spanspan吉林/spanspan江西/span/td/trtrthL/thtd classc_hspan辽宁/span/td/trtrthN/thtd classc_hspan内蒙古/spanspan宁夏/span/td/trtrthQ/thtd classc_hspan青海/span/td/trtrthS/thtd classc_hspan上海/spanspan山东/spanspan山西/spanspan classc_check四川/spanspan陕西/span/td/trtrthT/thtd classc_hspan台湾/spanspan天津/span/td/trtrthX/thtd classc_hspan西藏/spanspan香港/spanspan新疆/span/td/trtrthY/thtd classc_hspan云南/span/td/trtrthZ/thtd classc_hspan浙江/span/td/tr/table/div/div/span/span!--End 所在收货地区 End--span classfrspan classfl你好请a hrefLogin.html登录/anbsp; a hrefRegist.html stylecolor:#ff4e00;免费注册/anbsp;|nbsp;a href#我的订单/anbsp;|/spanspan classssdiv classss_lista href#收藏夹/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#我的收藏夹/a/lilia href#我的收藏夹/a/li/ul/div/div /divdiv classss_lista href#客户服务/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#客户服务/a/lilia href#客户服务/a/lilia href#客户服务/a/li/ul/div/div /divdiv classss_lista href#网站导航/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#网站导航/a/lilia href#网站导航/a/li/ul/div/div /div/spanspan classfl|nbsp;关注我们/spanspan classs_sha href# classsh1新浪/aa href# classsh2微信/a/spanspan classfr|nbsp;a href#手机版nbsp;img srcimages/s_tel.png alignabsmiddle //a/span/span/div
/div
div classtopdiv classlogoa hrefIndex.htmlimg srcimages/logo.png //a/divdiv classsearchforminput typetext value classs_ipt /input typesubmit value搜索 classs_btn //form span classfla href#咖啡/aa href#iphone 6S/aa href#新鲜美食/aa href#蛋糕/aa href#日用品/aa href#连衣裙/a/span/divdiv classi_cardiv classcar_t购物车 [ span3/span ]/divdiv classcar_bg!--Begin 购物车未登录 Begin--div classun_login还未登录a hrefLogin.html stylecolor:#ff4e00;马上登录/a 查看购物车/div!--End 购物车未登录 End--!--Begin 购物车已登录 Begin--ul classcarslidiv classimga href#img srcimages/car1.jpg width58 height58 //a/divdiv classnamea href#法颂浪漫梦境50ML 香水女士持久清新淡香 送2ML小样3只/a/divdiv classpricefont color#ff4e00399/font X1/div/lilidiv classimga href#img srcimages/car2.jpg width58 height58 //a/divdiv classnamea href#香奈儿Chanel邂逅活力淡香水50ml/a/divdiv classpricefont color#ff4e00399/font X1/div/lilidiv classimga href#img srcimages/car2.jpg width58 height58 //a/divdiv classnamea href#香奈儿Chanel邂逅活力淡香水50ml/a/divdiv classpricefont color#ff4e00399/font X1/div/li/uldiv classprice_sum共计nbsp; font color#ff4e00/fontspan1058/span/divdiv classprice_aa href#去购物车结算/a/div!--End 购物车已登录 End--/div/div
/div
!--End Header End--
!--Begin Menu Begin--
div classmenu_bgdiv classmenu!--Begin 商品分类详情 Begin-- div classnavdiv classnav_t全部商品分类/divdiv classleftNav noneul lidiv classfjspan classn_imgspan/spanimg srcimages/nav1.png //spanspan classfl进口食品、生鲜/span/divdiv classzjdiv classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav2.png //spanspan classfl食品、饮料、酒/span/divdiv classzj styletop:-40px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力2/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav3.png //spanspan classfl母婴、玩具、童装/span/divdiv classzj styletop:-80px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力3/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav4.png //spanspan classfl家居、家庭清洁、纸品/span/divdiv classzj styletop:-120px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力4/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav5.png //spanspan classfl美妆、个人护理、洗护/span/divdiv classzj styletop:-160px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力5/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav6.png //spanspan classfl女装、内衣、中老年/span/divdiv classzj styletop:-200px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力6/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav7.png //spanspan classfl鞋靴、箱包、腕表配饰/span/divdiv classzj styletop:-240px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力7/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav8.png //spanspan classfl男装、运动/span/divdiv classzj styletop:-280px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力8/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav9.png //spanspan classfl手机、小家电、电脑/span/divdiv classzj styletop:-320px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力9/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/li lidiv classfjspan classn_imgspan/spanimg srcimages/nav10.png //spanspan classfl礼品、充值/span/divdiv classzj styletop:-360px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力10/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/li /ul /div/div !--End 商品分类详情 End-- ul classmenu_r lia hrefIndex.html首页/a/lilia hrefFood.html美食/a/lilia hrefFresh.html生鲜/a/lilia hrefHomeDecoration.html家居/a/lilia hrefSuitDress.html女装/a/lilia hrefMakeUp.html美妆/a/lilia hrefDigital.html数码/a/lilia hrefGroupBuying.html团购/a/li/uldiv classm_ad中秋送好礼/div/div
/div
!--End Menu End--
div classi_bg div classpostionspan classfl全部 美妆个护 香水 迪奥 迪奥真我香水/span/div div classcontent mar_10!--Begin 特卖 Begin--div classs_leftdiv classlim_timediv classlim_sh_bgspan classlim_sh分享/spana href#img srcimages/sh_1.gif //aa href#img srcimages/sh_2.gif //aa href#img srcimages/sh_3.gif //aa href#img srcimages/sh_4.gif //aa href#img srcimages/sh_5.gif //a/divtable border0 stylewidth:100%; margin-bottom:50px; cellspacing0 cellpadding0tr valigntoptd width315div classlim_nameDior/迪奥 真我香水/divdiv classlim_pricespan classch_txt5288/spana href# classch_a抢购/a/divdiv classlim_ctable border0 stylewidth:100%; color:#888888; cellspacing0 cellpadding0trtd width35%市场价 /tdtd width65%折扣/td/trtr stylefont-family:Microsoft YaHei;td styletext-decoration:line-through;5388/td td8.0/td/tr/table/divdiv classlim_cdiv classdes_choicespan classfl型号/spanulli classchecked30mldiv classch_img/div/lili50mldiv classch_img/div/lili100mldiv classch_img/div/li/ul/divdiv classdes_choicespan classfl颜色/spanulli红色div classch_img/div/lili classchecked白色div classch_img/div/lili黑色div classch_img/div/li/ul/div/divdiv classlim_cspan classfl数量/spaninput typetext value2 classlim_ipt //divdiv classlim_clock距离团购结束还有br /span1200 时 30 分 28 秒/span/div/tdtd width525 aligncenter styleborder-left:1px solid #eaeaea;img srcimages/tm_big.jpg width460 height460 //td/tr/table/divdiv classdes_borderdiv classdes_titulli classcurrenta href#p_attribute商品属性/a/lilia href#p_details商品详情/a/lilia href#p_comment商品评论/a/li/ul/divdiv classdes_con idp_attributetable border0 aligncenter stylewidth:100%; font-family:宋体; margin:10px auto; cellspacing0 cellpadding0trtd商品名称迪奥香水/tdtd商品编号1546211/tdtd品牌 迪奥Dior/tdtd上架时间2015-09-06 09:19:09 /td/trtrtd商品毛重160.00g/tdtd商品产地法国/tdtd香调果香调香型淡香水/香露EDT/tdtdnbsp;/td/trtrtd容量1ml-15ml /tdtd类型女士香水Q版香水组合套装/tdtdnbsp;/tdtdnbsp;/td/tr/table /div/div div classdes_border idp_detailsdiv classdes_t商品详情/divdiv classdes_contable border0 aligncenter stylewidth:745px; font-size:14px; font-family:宋体; cellspacing0 cellpadding0trtd width265img srcimages/de1.jpg width206 height412 //tdtdb迪奥真我香水(Q版)/bbr /【商品规格】5mlbr /【商品质地】液体br /【商品日期】与专柜同步更新br /【商品产地】法国br /【商品包装】无外盒 无塑封br /【商品香调】花束花香调br /【适用人群】适合女性都市白领性感有女人味的成熟女性br //td/tr/tablep aligncenterimg srcimages/de2.jpg width746 height425 /br /br /img srcimages/de3.jpg width750 height417 /br /br /img srcimages/de4.jpg width750 height409 /br /br /img srcimages/de5.jpg width750 height409 //p/div/div div classdes_border idp_commentdiv classdes_t商品评论/divtable border0 classjud_tab cellspacing0 cellpadding0trtd width175 classjud_perp80.0%/p好评度/tdtd width310table border0 stylewidth:100%; cellspacing0 cellpadding0trtd width90好评font color#99999980%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/trtrtd中评font color#99999920%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/trtrtd差评font color#9999990%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/tr/table/tdtd width290 classjud_bg您可对已购买商品进行评价br /a href#img srcimages/btn_jud.gif //a/td/tr/tabletable border0 classjud_list stylewidth:100%; margin-top:30px; cellspacing0 cellpadding0tr valigntoptd width160img srcimages/peo1.jpg width20 height20 alignabsmiddle /nbsp;向死而生/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd产品很好香味很喜欢必须给赞。 br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo2.jpg width20 height20 alignabsmiddle /nbsp;就是这么想的/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd送朋友她很喜欢大爱。 br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo3.jpg width20 height20 alignabsmiddle /nbsp;墨镜墨镜/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd大家都说不错br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo4.jpg width20 height20 alignabsmiddle /nbsp;那*****洋 br /font color#999999匿名用户/font/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd下次还会来买推荐。br /font color#9999992015-09-24/font/td/tr/tablediv classpagesa href# classp_pre上一页/aa href# classcur1/aa href#2/aa href#3/a...a href#20/aa href# classp_pre下一页/a/div/div/div !--End 特卖 End--div classs_rightdiv classr_historydiv classr_his_t用户还喜欢/divullidiv classimga href#img srcimages/his_1.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan368.00/span/font nbsp; 18R/div/lilidiv classimga href#img srcimages/his_2.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan768.00/span/font nbsp; 18R/div/lilidiv classimga href#img srcimages/his_3.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan680.00/span/font nbsp; 18R/div/li/ul/divdiv classsell_hotdiv classs_hot_tspan classfl热销品牌/spanspan classh_more fra href#更多/a/span/divullia href#img srcimages/hb_1.jpg width160 height59 //a/lilia href#img srcimages/hb_2.jpg width160 height59 //a/lilia href#img srcimages/hb_3.jpg width160 height59 //a/lilia href#img srcimages/hb_4.jpg width160 height59 //a/lilia href#img srcimages/hb_5.jpg width160 height59 //a/lilia href#img srcimages/hb_6.jpg width160 height59 //a/lilia href#img srcimages/hb_7.jpg width160 height59 //a/lilia href#img srcimages/hb_8.jpg width160 height59 //a/lilia href#img srcimages/hb_9.jpg width160 height59 //a/lilia href#img srcimages/hb_10.jpg width160 height59 //a/lilia href#img srcimages/hb_11.jpg width160 height59 //a/lilia href#img srcimages/hb_12.jpg width160 height59 //a/li/ul/div/div/div !--Begin Footer Begin --div classb_btm_bg bg_colordiv classb_btmtable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b1.png width62 height62 //tdtdh2正品保障/h2正品行货 放心购买/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b2.png width62 height62 //tdtdh2满38包邮/h2满38包邮 免运费/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b3.png width62 height62 //tdtdh2天天低价/h2天天低价 畅选无忧/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b4.png width62 height62 //tdtdh2准时送达/h2收货时间由你做主/td/tr/table/div/divdiv classb_navdl dta href#新手上路/a/dtdda href#售后流程/a/dddda href#购物流程/a/dddda href#订购方式/a/dddda href#隐私声明/a/dddda href#推荐分享说明/a/dd/dldldta href#配送与支付/a/dtdda href#货到付款区域/a/dddda href#配送支付查询/a/dddda href#支付方式说明/a/dd/dldldta href#会员中心/a/dtdda href#资金管理/a/dddda href#我的收藏/a/dddda href#我的订单/a/dd/dldldta href#服务保证/a/dtdda href#退换货原则/a/dddda href#售后服务保证/a/dddda href#产品质量保证/a/dd/dldldta href#联系我们/a/dtdda href#网站故障报告/a/dddda href#购物咨询/a/dddda href#投诉与建议/a/dd/dldiv classb_tel_bga href# classb_sh1新浪微博/a a href# classb_sh2腾讯微博/ap服务热线br /span400-123-4567/span/p/divdiv classb_erdiv classb_er_cimg srcimages/er.gif width118 height118 //divimg srcimages/ss.png //div/div div classbtmbgdiv classbtm备案/许可证编号蜀ICP备12009302号-1-www.dingguagua.com Copyright © 2015-2018 尤洪商城网 All Rights Reserved. 复制必究 , Technical Support: Dgg Group br /img srcimages/b_1.gif width98 height33 /img srcimages/b_2.gif width98 height33 /img srcimages/b_3.gif width98 height33 /img srcimages/b_4.gif width98 height33 /img srcimages/b_5.gif width98 height33 /img srcimages/b_6.gif width98 height33 //div /div!--End Footer End --
/div/body!--[if IE 6]
script src//letskillie6.googlecode.com/svn/trunk/2/zh_CN.js/script
![endif]--
/html
然后需要把用到的方法写入到mapper方法中把mapper放入到公共模块中
ProductMapper.xml
select idqueryKillProdNews resultTypejava.util.Mapselectk.id,k.item_id,p.name,p.price,p.fileNamefromzmall_kill k,zmall_product pwhere k.item_idp.id andk.is_active1 and(now() between start_time and end_time)order by k.create_time desclimit 4/selectselect idqueryKillProdById resultTypejava.util.Mapselectk.id,k.item_id,k.total,p.name,p.price,p.fileNamefromzmall_kill k,zmall_product pwhere k.item_idp.id and k.is_active1 and item_id#{value}/select对应的mapper类加入方法
ProductMapper
Repository
public interface ProductMapper extends BaseMapperProduct {ListMapString,Object queryKillProdNews();MapString,Object queryKillProdById(Integer pid);}
service层
IProductService
public interface IProductService extends IServiceProduct {void updateStock(Integer pid,Integer num);/*** 首页显示秒杀商品查询* return*/ListMapString,Object queryKillProdNews();/*** 根据商品ID查询秒杀商品信息* param pid 秒杀商品ID* return*/MapString,Object queryKillProdById(Integer pid);
}ProductController
RequestMapping(/index.html)public ModelAndView index(Model model, User user){ModelAndView mvnew ModelAndView();//按照商品的销量降序排序获取销量排名Top5的商品ListProduct products productService.list(new QueryWrapperProduct().orderByDesc(hot).last(limit 5));model.addAttribute(hots,products);//Object username session.getAttribute(username);//System.out.println(**********username);System.out.println(user);//获取显示秒杀商品ListMapString, Object maps productService.queryKillProdNews();mv.addObject(kills,maps);mv.setViewName(index);return mv;}测试 sellDetails.html
!DOCTYPE html
html xmlnshttp://www.w3.org/1999/xhtml
head
#include common/head.html
meta http-equivContent-Type contenttext/html; charsetutf-8 /link typetext/css relstylesheet hrefcss/style.css /!--[if IE 6]script srcjs/iepng.js typetext/javascript/scriptscript typetext/javascriptEvPNG.fix(div, ul, img, li, input, a); /script![endif]-- script typetext/javascript srcjs/jquery-1.11.1.min_044d0927.js/scriptscript typetext/javascript srcjs/jquery-1.8.2.min.js/scriptscript typetext/javascript srcjs/menu.js/script script typetext/javascript srcjs/lrscroll_1.js/scriptscript typetext/javascript srcjs/n_nav.js/script title尤洪/title
/head
body
!--Begin Header Begin--
div classsoubgdiv classsou!--Begin 所在收货地区 Begin--span classs_city_bspan classfl送货至/spanspan classs_cityspan四川/spandiv classs_city_bgdiv classs_city_t/divdiv classs_city_ch2请选择所在的收货地区/h2table border0 classc_tab stylewidth:235px; margin-top:10px; cellspacing0 cellpadding0trthA/thtd classc_hspan安徽/spanspan澳门/span/td/trtrthB/thtd classc_hspan北京/span/td/trtrthC/thtd classc_hspan重庆/span/td/trtrthF/thtd classc_hspan福建/span/td/trtrthG/thtd classc_hspan广东/spanspan广西/spanspan贵州/spanspan甘肃/span/td/trtrthH/thtd classc_hspan河北/spanspan河南/spanspan黑龙江/spanspan海南/spanspan湖北/spanspan湖南/span/td/trtrthJ/thtd classc_hspan江苏/spanspan吉林/spanspan江西/span/td/trtrthL/thtd classc_hspan辽宁/span/td/trtrthN/thtd classc_hspan内蒙古/spanspan宁夏/span/td/trtrthQ/thtd classc_hspan青海/span/td/trtrthS/thtd classc_hspan上海/spanspan山东/spanspan山西/spanspan classc_check四川/spanspan陕西/span/td/trtrthT/thtd classc_hspan台湾/spanspan天津/span/td/trtrthX/thtd classc_hspan西藏/spanspan香港/spanspan新疆/span/td/trtrthY/thtd classc_hspan云南/span/td/trtrthZ/thtd classc_hspan浙江/span/td/tr/table/div/div/span/span!--End 所在收货地区 End--span classfrspan classfl你好请a hrefLogin.html登录/anbsp; a hrefRegist.html stylecolor:#ff4e00;免费注册/anbsp;|nbsp;a href#我的订单/anbsp;|/spanspan classssdiv classss_lista href#收藏夹/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#我的收藏夹/a/lilia href#我的收藏夹/a/li/ul/div/div /divdiv classss_lista href#客户服务/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#客户服务/a/lilia href#客户服务/a/lilia href#客户服务/a/li/ul/div/div /divdiv classss_lista href#网站导航/adiv classss_list_bgdiv classs_city_t/divdiv classss_list_cullia href#网站导航/a/lilia href#网站导航/a/li/ul/div/div /div/spanspan classfl|nbsp;关注我们/spanspan classs_sha href# classsh1新浪/aa href# classsh2微信/a/spanspan classfr|nbsp;a href#手机版nbsp;img srcimages/s_tel.png alignabsmiddle //a/span/span/div
/div
div classtopdiv classlogoa hrefIndex.htmlimg srcimages/logo.png //a/divdiv classsearchforminput typetext value classs_ipt /input typesubmit value搜索 classs_btn //form span classfla href#咖啡/aa href#iphone 6S/aa href#新鲜美食/aa href#蛋糕/aa href#日用品/aa href#连衣裙/a/span/divdiv classi_cardiv classcar_t购物车 [ span3/span ]/divdiv classcar_bg!--Begin 购物车未登录 Begin--div classun_login还未登录a hrefLogin.html stylecolor:#ff4e00;马上登录/a 查看购物车/div!--End 购物车未登录 End--!--Begin 购物车已登录 Begin--ul classcarslidiv classimga href#img srcimages/car1.jpg width58 height58 //a/divdiv classnamea href#法颂浪漫梦境50ML 香水女士持久清新淡香 送2ML小样3只/a/divdiv classpricefont color#ff4e00399/font X1/div/lilidiv classimga href#img srcimages/car2.jpg width58 height58 //a/divdiv classnamea href#香奈儿Chanel邂逅活力淡香水50ml/a/divdiv classpricefont color#ff4e00399/font X1/div/lilidiv classimga href#img srcimages/car2.jpg width58 height58 //a/divdiv classnamea href#香奈儿Chanel邂逅活力淡香水50ml/a/divdiv classpricefont color#ff4e00399/font X1/div/li/uldiv classprice_sum共计nbsp; font color#ff4e00/fontspan1058/span/divdiv classprice_aa href#去购物车结算/a/div!--End 购物车已登录 End--/div/div
/div
!--End Header End--
!--Begin Menu Begin--
div classmenu_bgdiv classmenu!--Begin 商品分类详情 Begin-- div classnavdiv classnav_t全部商品分类/divdiv classleftNav noneul lidiv classfjspan classn_imgspan/spanimg srcimages/nav1.png //spanspan classfl进口食品、生鲜/span/divdiv classzjdiv classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav2.png //spanspan classfl食品、饮料、酒/span/divdiv classzj styletop:-40px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力2/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/divdiv classzj_l_ch2零食 / 糖果 / 巧克力/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav3.png //spanspan classfl母婴、玩具、童装/span/divdiv classzj styletop:-80px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力3/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav4.png //spanspan classfl家居、家庭清洁、纸品/span/divdiv classzj styletop:-120px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力4/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav5.png //spanspan classfl美妆、个人护理、洗护/span/divdiv classzj styletop:-160px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力5/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav6.png //spanspan classfl女装、内衣、中老年/span/divdiv classzj styletop:-200px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力6/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav7.png //spanspan classfl鞋靴、箱包、腕表配饰/span/divdiv classzj styletop:-240px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力7/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav8.png //spanspan classfl男装、运动/span/divdiv classzj styletop:-280px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力8/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/lilidiv classfjspan classn_imgspan/spanimg srcimages/nav9.png //spanspan classfl手机、小家电、电脑/span/divdiv classzj styletop:-320px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力9/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/li lidiv classfjspan classn_imgspan/spanimg srcimages/nav10.png //spanspan classfl礼品、充值/span/divdiv classzj styletop:-360px;div classzj_ldiv classzj_l_ch2零食 / 糖果 / 巧克力10/h2a href#坚果/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#巧克力/a|a href#口香糖/a|a href#海苔/a|a href#鱼干/a|a href#蜜饯/a|a href#红枣/a|a href#蜜饯/a|a href#红枣/a|a href#牛肉干/a|a href#蜜饯/a|/div/divdiv classzj_ra href#img srcimages/n_img1.jpg width236 height200 //aa href#img srcimages/n_img2.jpg width236 height200 //a/div/div/li /ul /div/div !--End 商品分类详情 End-- ul classmenu_r lia hrefIndex.html首页/a/lilia hrefFood.html美食/a/lilia hrefFresh.html生鲜/a/lilia hrefHomeDecoration.html家居/a/lilia hrefSuitDress.html女装/a/lilia hrefMakeUp.html美妆/a/lilia hrefDigital.html数码/a/lilia hrefGroupBuying.html团购/a/li/uldiv classm_ad中秋送好礼/div/div
/div
!--End Menu End--
div classi_bg div classpostionspan classfl全部 美妆个护 香水 迪奥 迪奥真我香水/span/div div classcontent mar_10!--Begin 特卖 Begin--div classs_leftdiv classlim_timediv classlim_sh_bgspan classlim_sh分享/spana href#img srcimages/sh_1.gif //aa href#img srcimages/sh_2.gif //aa href#img srcimages/sh_3.gif //aa href#img srcimages/sh_4.gif //aa href#img srcimages/sh_5.gif //a/divtable border0 stylewidth:100%; margin-bottom:50px; cellspacing0 cellpadding0tr valigntoptd width315div classlim_name${(prod.name)!}/divdiv classlim_pricespan classch_txt${(prod.price)!}/spana hrefjavascript:void(0); classch_a pid${(prod.item_id)!} price${(prod.price)!}抢购/a/divdiv classlim_ctable border0 stylewidth:100%; color:#888888; cellspacing0 cellpadding0trtd width35%市场价 /tdtd width65%折扣/td/trtr stylefont-family:Microsoft YaHei;td styletext-decoration:line-through;${(prod.price)!}/tdtd8.0/td/tr/table/divdiv classlim_cdiv classdes_choicespan classfl型号/spanulli classchecked30mldiv classch_img/div/lili50mldiv classch_img/div/lili100mldiv classch_img/div/li/ul/divdiv classdes_choicespan classfl颜色/spanulli红色div classch_img/div/lili classchecked白色div classch_img/div/lili黑色div classch_img/div/li/ul/div/divdiv classlim_cspan classfl数量/spaninput typetext value${(prod.total)!} classlim_ipt //divdiv classlim_clock距离团购结束还有br /span1200 时 30 分 28 秒/span/div/tdtd width525 aligncenter styleborder-left:1px solid #eaeaea;img src${(prod.fileName)!} width460 height460 //td/tr/table/divdiv classdes_borderdiv classdes_titulli classcurrenta href#p_attribute商品属性/a/lilia href#p_details商品详情/a/lilia href#p_comment商品评论/a/li/ul/divdiv classdes_con idp_attributetable border0 aligncenter stylewidth:100%; font-family:宋体; margin:10px auto; cellspacing0 cellpadding0trtd商品名称迪奥香水/tdtd商品编号1546211/tdtd品牌 迪奥Dior/tdtd上架时间2015-09-06 09:19:09 /td/trtrtd商品毛重160.00g/tdtd商品产地法国/tdtd香调果香调香型淡香水/香露EDT/tdtdnbsp;/td/trtrtd容量1ml-15ml /tdtd类型女士香水Q版香水组合套装/tdtdnbsp;/tdtdnbsp;/td/tr/table /div/div div classdes_border idp_detailsdiv classdes_t商品详情/divdiv classdes_contable border0 aligncenter stylewidth:745px; font-size:14px; font-family:宋体; cellspacing0 cellpadding0trtd width265img srcimages/de1.jpg width206 height412 //tdtdb迪奥真我香水(Q版)/bbr /【商品规格】5mlbr /【商品质地】液体br /【商品日期】与专柜同步更新br /【商品产地】法国br /【商品包装】无外盒 无塑封br /【商品香调】花束花香调br /【适用人群】适合女性都市白领性感有女人味的成熟女性br //td/tr/tablep aligncenterimg srcimages/de2.jpg width746 height425 /br /br /img srcimages/de3.jpg width750 height417 /br /br /img srcimages/de4.jpg width750 height409 /br /br /img srcimages/de5.jpg width750 height409 //p/div/div div classdes_border idp_commentdiv classdes_t商品评论/divtable border0 classjud_tab cellspacing0 cellpadding0trtd width175 classjud_perp80.0%/p好评度/tdtd width310table border0 stylewidth:100%; cellspacing0 cellpadding0trtd width90好评font color#99999980%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/trtrtd中评font color#99999920%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/trtrtd差评font color#9999990%/font/tdtdimg srcimages/pl.gif alignabsmiddle //td/tr/table/tdtd width290 classjud_bg您可对已购买商品进行评价br /a href#img srcimages/btn_jud.gif //a/td/tr/tabletable border0 classjud_list stylewidth:100%; margin-top:30px; cellspacing0 cellpadding0tr valigntoptd width160img srcimages/peo1.jpg width20 height20 alignabsmiddle /nbsp;向死而生/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd产品很好香味很喜欢必须给赞。 br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo2.jpg width20 height20 alignabsmiddle /nbsp;就是这么想的/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd送朋友她很喜欢大爱。 br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo3.jpg width20 height20 alignabsmiddle /nbsp;墨镜墨镜/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd大家都说不错br /font color#9999992015-09-24/font/td/trtr valigntoptd width160img srcimages/peo4.jpg width20 height20 alignabsmiddle /nbsp;那*****洋 br /font color#999999匿名用户/font/tdtd width180颜色分类font color#999999粉色/font br /型号font color#99999950ml/font/tdtd下次还会来买推荐。br /font color#9999992015-09-24/font/td/tr/tablediv classpagesa href# classp_pre上一页/aa href# classcur1/aa href#2/aa href#3/a...a href#20/aa href# classp_pre下一页/a/div/div/div !--End 特卖 End--div classs_rightdiv classr_historydiv classr_his_t用户还喜欢/divullidiv classimga href#img srcimages/his_1.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan368.00/span/font nbsp; 18R/div/lilidiv classimga href#img srcimages/his_2.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan768.00/span/font nbsp; 18R/div/lilidiv classimga href#img srcimages/his_3.jpg width185 height162 //a/divdiv classnamea href#Dior/迪奥香水2件套装/a/divdiv classpricefontspan680.00/span/font nbsp; 18R/div/li/ul/divdiv classsell_hotdiv classs_hot_tspan classfl热销品牌/spanspan classh_more fra href#更多/a/span/divullia href#img srcimages/hb_1.jpg width160 height59 //a/lilia href#img srcimages/hb_2.jpg width160 height59 //a/lilia href#img srcimages/hb_3.jpg width160 height59 //a/lilia href#img srcimages/hb_4.jpg width160 height59 //a/lilia href#img srcimages/hb_5.jpg width160 height59 //a/lilia href#img srcimages/hb_6.jpg width160 height59 //a/lilia href#img srcimages/hb_7.jpg width160 height59 //a/lilia href#img srcimages/hb_8.jpg width160 height59 //a/lilia href#img srcimages/hb_9.jpg width160 height59 //a/lilia href#img srcimages/hb_10.jpg width160 height59 //a/lilia href#img srcimages/hb_11.jpg width160 height59 //a/lilia href#img srcimages/hb_12.jpg width160 height59 //a/li/ul/div/div/div !--Begin Footer Begin --div classb_btm_bg bg_colordiv classb_btmtable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b1.png width62 height62 //tdtdh2正品保障/h2正品行货 放心购买/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b2.png width62 height62 //tdtdh2满38包邮/h2满38包邮 免运费/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b3.png width62 height62 //tdtdh2天天低价/h2天天低价 畅选无忧/td/tr/tabletable border0 stylewidth:210px; height:62px; float:left; margin-left:75px; margin-top:30px; cellspacing0 cellpadding0trtd width72img srcimages/b4.png width62 height62 //tdtdh2准时送达/h2收货时间由你做主/td/tr/table/div/divdiv classb_navdl dta href#新手上路/a/dtdda href#售后流程/a/dddda href#购物流程/a/dddda href#订购方式/a/dddda href#隐私声明/a/dddda href#推荐分享说明/a/dd/dldldta href#配送与支付/a/dtdda href#货到付款区域/a/dddda href#配送支付查询/a/dddda href#支付方式说明/a/dd/dldldta href#会员中心/a/dtdda href#资金管理/a/dddda href#我的收藏/a/dddda href#我的订单/a/dd/dldldta href#服务保证/a/dtdda href#退换货原则/a/dddda href#售后服务保证/a/dddda href#产品质量保证/a/dd/dldldta href#联系我们/a/dtdda href#网站故障报告/a/dddda href#购物咨询/a/dddda href#投诉与建议/a/dd/dldiv classb_tel_bga href# classb_sh1新浪微博/a a href# classb_sh2腾讯微博/ap服务热线br /span400-123-4567/span/p/divdiv classb_erdiv classb_er_cimg srcimages/er.gif width118 height118 //divimg srcimages/ss.png //div/div div classbtmbgdiv classbtm备案/许可证编号蜀ICP备12009302号-1-www.dingguagua.com Copyright © 2015-2018 尤洪商城网 All Rights Reserved. 复制必究 , Technical Support: Dgg Group br /img srcimages/b_1.gif width98 height33 /img srcimages/b_2.gif width98 height33 /img srcimages/b_3.gif width98 height33 /img srcimages/b_4.gif width98 height33 /img srcimages/b_5.gif width98 height33 /img srcimages/b_6.gif width98 height33 //div /div!--End Footer End --
/div/body!--[if IE 6]
script src//letskillie6.googlecode.com/svn/trunk/2/zh_CN.js/script
![endif]--
/html
2.2 查看秒杀商品
点击限时秒杀中的秒杀商品根据秒杀商品ID查询秒杀商品详情信息并跳转到sellDetail.html页面展示秒杀商品信息。
RequestMapping(/sellDetail.html)public String sellDetail(RequestParam Integer pid, Model model){//根据商品ID查询秒杀商品信息MapString, Object prod productService.queryKillProdById(pid);model.addAttribute(prod,prod);return sellDetails;}2.3 订单秒杀
2.3.1 移除seata相关方便测压
第1步先注释掉zmall-order和zmall-product模块中的seata依赖 第2步分别删掉zmall-order和zmall-product模块中resources目录下的bootstrap.xml和register.conf文件 seata分布式事务进行jmeter压测秒杀订单接口效率太低1000个并发请求吞吐量为4.5/so(╥﹏╥)o 2.3.2 生成秒杀订单
将SnowFlake雪花ID生成工具类导入到zmall-common模块中utils然后再生成秒杀订单时使用雪花ID来充当秒杀订单编号在zmall-order模块中完成秒杀订单生成工作。
IOrderService
public interface IOrderService extends IServiceOrder {Order createOrder(Integer pid,Integer num);/*** 生成秒杀订单* param user 登陆用户对象* param pid 秒杀商品ID* param price 秒杀商品价格* return*/JsonResponseBody? createKillOrder(User user, Integer pid, Float price);
}OrderServiceImpl
Autowired
private KillServiceImpl killService;
Autowired
private OrderDetailServiceImpl orderDetailService;TransactionalOverridepublic JsonResponseBody? createKillOrder(User user, Integer pid, Float price) {//1.根据秒杀商品编号获取秒杀商品库存是否为空Kill kill killService.getOne(new QueryWrapperKill().eq(item_id,pid));if(kill.getTotal()1)throw new BusinessException(JsonResponseStatus.STOCK_EMPTY);//2.秒杀商品库存减一killService.update(new UpdateWrapperKill().eq(item_id,pid).setSql(totaltotal-1));//3.生成秒杀订单及订单项SnowFlake snowFlakenew SnowFlake(2,3);Long orderIdsnowFlake.nextId();int orderIdInt new Long(orderId).intValue();//创建订单Order ordernew Order();order.setUserId(user.getId());order.setLoginName(user.getLoginName());order.setCost(price);order.setSerialNumber(orderIdInt);this.save(order);//创建订单项OrderDetail orderDetailnew OrderDetail();orderDetail.setOrderId(orderIdInt);orderDetail.setProductId(pid);orderDetail.setQuantity(1);orderDetail.setCost(price);orderDetailService.save(orderDetail);return new JsonResponseBody();}OrderController
RequestMapping(/createKillOrder/{pid}/{price})ResponseBodypublic JsonResponseBody? createKillOrder(User user,PathVariable(pid) Integer pid,PathVariable(price) Float price){return orderService.createKillOrder(user,pid,price);}2.3.3 前端页面秒杀测试
在sellDetail.html页面中添加订单秒杀JS方法。
script$(function(){$(.ch_a).click(function(){let pid$(this).attr(pid);console.log(pid);$.post(http://zmall.com/order-serv/createKillOrder,{pid:pid},function(rs){console.log(rs);if(rs.code200)alert(秒杀成功);elsealert(rs.msg);},json);});});
/script这里虽然已经能正常展示秒杀效果但是还是存在很多问题比如重复抢购问题等等问题。
注意 $.post(http://user.zmall.com/userLogin,{loginName:loginName,password:password},function(rs){console.log(rs);if(rs.code200){location.hrefhttp://product.zmall.com/index.html;}else{alert(rs.msg);}},json);post方式不能跨二级域名发送请求location.href可以跨二级域名发送请求
$(function(){$(.ch_a).click(function(){let pid$(this).attr(pid);let price$(this).attr(price);console.log(pid%s,price%s,pid,price);$.post(http://zmall.com/order-serv/createKillOrder/pid/price,{},function(rs){console.log(rs);if(rs.code200)alert(秒杀成功);elsealert(rs.msg);},json);});});$.post(‘http://zmall.com/order-serv/createKillOrder/’pid‘/’price,{},function(rs){});能够正常访问
$.post(‘http://order.zmall.com/createKillOrder/’pid‘/’price,{},function(rs){});则会出现跨域问题
