devbox
很楠不爱3
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

SpringBoot+Vue+Element-UI实现家具商城系统_基于spring boot+mysql的家具销售电商平台系统设计与实现

作者：很楠不爱3 | 2024-06-17 05:27:58

赞

踩

基于spring boot+mysql的家具销售电商平台系统设计与实现

文末获取源码

开发语言：Java

框架：springboot

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7/8.0

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

前言介绍 

社会的发展和科学技术的进步，互联网技术越来越受欢迎。网络计算机的交易方式逐渐受到广大人民群众的喜爱，也逐渐进入了每个用户的使用。互联网具有便利性，速度快，效率高，成本低等优点。 因此，构建符合自己要求的操作系统是非常有意义的。

本文从管理员、用户的功能要求出发，家具商城系统中的功能模块主要是实现管理员；首页、个人中心、用户管理、家具类型管理、家具信息管理、系统管理、订单管理，用户：首页、个人中心。前台首页：首页、家具信息、公告信息、个人中心、后台管理、购物车。

经过认真细致的研究，精心准备和规划，最后测试成功，系统可以正常使用。分析功能调整与家具商城系统实现的实际需求相结合，讨论了Java开发家具商城系统的使用。

系统功能设计

软件的用户界面是最直接接触的对象，包括是否允许用户使用简单方便，请求的响应时间，主图像的整体质量，整体布局的质量。

家具销售电商平台的设计基于现有的网络平台，可以实现用户管理及数据信息管理，方便管理员对后台进行管理有详细的了解及统计分析，随时查看信息状态。 

系统功能设计是在系统开发和设计思想的总体任务的基础上完成的。该系统的主要任务是实现家具销售电商平台管理，使用户可以通过指令完成整个家具销售电商平台的操作。

从上面的描述中可以基本可以实现软件的功能：

1、开发实现家具销售电商平台的整个系统程序； 

2、管理员；首页、个人中心、用户管理、家具类型管理、家具信息管理、系统管理、订单管理等。

3、用户：首页、个人中心。

4、前台首页：首页、家具信息、公告信息、个人中心、后台管理、购物车等相应操作；

5、基础数据管理：实现系统基本信息的添加、修改及删除等操作，并且根据需求进行交流信息的查看及回复相应操作。

系统展示 

首页

家具信息

个人中心

购物车

管理员页面 

用户管理

家具类型管理

家具信息管理

系统管理

部分核心代码

家具信息

  1. @RestController
  2. @RequestMapping("/jiajuxinxi")
  3. public class JiajuxinxiController {
  4.     @Autowired
  5.     private JiajuxinxiService jiajuxinxiService;
  6.  
  7.     @Autowired
  8.     private StoreupService storeupService;
  9.  
  10.     @Autowired
  11.     private OrdersService ordersService;
  12.     
  13.  
  14.  
  15.     /**
  16.      * 后端列表
  17.      */
  18.     @RequestMapping("/page")
  19.     public R page(@RequestParam Map<String, Object> params,JiajuxinxiEntity jiajuxinxi,
  20. 		HttpServletRequest request){
  21.         EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  22. 		PageUtils page = jiajuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiajuxinxi), params), params));
  23.  
  24.         return R.ok().put("data", page);
  25.     }
  26.     
  27.     /**
  28.      * 前端列表
  29.      */
  30. 	@IgnoreAuth
  31.     @RequestMapping("/list")
  32.     public R list(@RequestParam Map<String, Object> params,JiajuxinxiEntity jiajuxinxi, 
  33. 		HttpServletRequest request){
  34.         EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  35. 		PageUtils page = jiajuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiajuxinxi), params), params));
  36.         return R.ok().put("data", page);
  37.     }
  38.  
  39. 	/**
  40.      * 列表
  41.      */
  42.     @RequestMapping("/lists")
  43.     public R list( JiajuxinxiEntity jiajuxinxi){
  44.        	EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  45.       	ew.allEq(MPUtil.allEQMapPre( jiajuxinxi, "jiajuxinxi")); 
  46.         return R.ok().put("data", jiajuxinxiService.selectListView(ew));
  47.     }
  48.  
  49. 	 /**
  50.      * 查询
  51.      */
  52.     @RequestMapping("/query")
  53.     public R query(JiajuxinxiEntity jiajuxinxi){
  54.         EntityWrapper< JiajuxinxiEntity> ew = new EntityWrapper< JiajuxinxiEntity>();
  55.  		ew.allEq(MPUtil.allEQMapPre( jiajuxinxi, "jiajuxinxi")); 
  56. 		JiajuxinxiView jiajuxinxiView =  jiajuxinxiService.selectView(ew);
  57. 		return R.ok("查询家具信息成功").put("data", jiajuxinxiView);
  58.     }
  59. 	
  60.     /**
  61.      * 后端详情
  62.      */
  63.     @RequestMapping("/info/{id}")
  64.     public R info(@PathVariable("id") Long id){
  65.         JiajuxinxiEntity jiajuxinxi = jiajuxinxiService.selectById(id);
  66. 		jiajuxinxi.setClicknum(jiajuxinxi.getClicknum()+1);
  67. 		jiajuxinxi.setClicktime(new Date());
  68. 		jiajuxinxiService.updateById(jiajuxinxi);
  69.         return R.ok().put("data", jiajuxinxi);
  70.     }
  71.  
  72.     /**
  73.      * 前端详情
  74.      */
  75. 	@IgnoreAuth
  76.     @RequestMapping("/detail/{id}")
  77.     public R detail(@PathVariable("id") Long id){
  78.         JiajuxinxiEntity jiajuxinxi = jiajuxinxiService.selectById(id);
  79. 		jiajuxinxi.setClicknum(jiajuxinxi.getClicknum()+1);
  80. 		jiajuxinxi.setClicktime(new Date());
  81. 		jiajuxinxiService.updateById(jiajuxinxi);
  82.         return R.ok().put("data", jiajuxinxi);
  83.     }
  84.     
  85.  
  86.  
  87.  
  88.     /**
  89.      * 后端保存
  90.      */
  91.     @RequestMapping("/save")
  92.     public R save(@RequestBody JiajuxinxiEntity jiajuxinxi, HttpServletRequest request){
  93.     	jiajuxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
  94.     	//ValidatorUtils.validateEntity(jiajuxinxi);
  95.         jiajuxinxiService.insert(jiajuxinxi);
  96.         return R.ok();
  97.     }
  98.     
  99.     /**
  100.      * 前端保存
  101.      */
  102.     @RequestMapping("/add")
  103.     public R add(@RequestBody JiajuxinxiEntity jiajuxinxi, HttpServletRequest request){
  104.     	jiajuxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
  105.     	//ValidatorUtils.validateEntity(jiajuxinxi);
  106.         jiajuxinxiService.insert(jiajuxinxi);
  107.         return R.ok();
  108.     }
  109.  
  110.     /**
  111.      * 修改
  112.      */
  113.     @RequestMapping("/update")
  114.     public R update(@RequestBody JiajuxinxiEntity jiajuxinxi, HttpServletRequest request){
  115.         //ValidatorUtils.validateEntity(jiajuxinxi);
  116.         jiajuxinxiService.updateById(jiajuxinxi);//全部更新
  117.         return R.ok();
  118.     }
  119.     
  120.  
  121.     /**
  122.      * 删除
  123.      */
  124.     @RequestMapping("/delete")
  125.     public R delete(@RequestBody Long[] ids){
  126.         jiajuxinxiService.deleteBatchIds(Arrays.asList(ids));
  127.         return R.ok();
  128.     }
  129.     
  130.     /**
  131.      * 提醒接口
  132.      */
  133. 	@RequestMapping("/remind/{columnName}/{type}")
  134. 	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
  135. 						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
  136. 		map.put("column", columnName);
  137. 		map.put("type", type);
  138. 		
  139. 		if(type.equals("2")) {
  140. 			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  141. 			Calendar c = Calendar.getInstance();
  142. 			Date remindStartDate = null;
  143. 			Date remindEndDate = null;
  144. 			if(map.get("remindstart")!=null) {
  145. 				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
  146. 				c.setTime(new Date()); 
  147. 				c.add(Calendar.DAY_OF_MONTH,remindStart);
  148. 				remindStartDate = c.getTime();
  149. 				map.put("remindstart", sdf.format(remindStartDate));
  150. 			}
  151. 			if(map.get("remindend")!=null) {
  152. 				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
  153. 				c.setTime(new Date());
  154. 				c.add(Calendar.DAY_OF_MONTH,remindEnd);
  155. 				remindEndDate = c.getTime();
  156. 				map.put("remindend", sdf.format(remindEndDate));
  157. 			}
  158. 		}
  159. 		
  160. 		Wrapper<JiajuxinxiEntity> wrapper = new EntityWrapper<JiajuxinxiEntity>();
  161. 		if(map.get("remindstart")!=null) {
  162. 			wrapper.ge(columnName, map.get("remindstart"));
  163. 		}
  164. 		if(map.get("remindend")!=null) {
  165. 			wrapper.le(columnName, map.get("remindend"));
  166. 		}
  167.  
  168.  
  169. 		int count = jiajuxinxiService.selectCount(wrapper);
  170. 		return R.ok().put("count", count);
  171. 	}
  172. 	
  173. 	/**
  174.      * 前端智能排序
  175.      */
  176. 	@IgnoreAuth
  177.     @RequestMapping("/autoSort")
  178.     public R autoSort(@RequestParam Map<String, Object> params,JiajuxinxiEntity jiajuxinxi, HttpServletRequest request,String pre){
  179.         EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  180.         Map<String, Object> newMap = new HashMap<String, Object>();
  181.         Map<String, Object> param = new HashMap<String, Object>();
  182. 		Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();
  183. 		while (it.hasNext()) {
  184. 			Map.Entry<String, Object> entry = it.next();
  185. 			String key = entry.getKey();
  186. 			String newKey = entry.getKey();
  187. 			if (pre.endsWith(".")) {
  188. 				newMap.put(pre + newKey, entry.getValue());
  189. 			} else if (StringUtils.isEmpty(pre)) {
  190. 				newMap.put(newKey, entry.getValue());
  191. 			} else {
  192. 				newMap.put(pre + "." + newKey, entry.getValue());
  193. 			}
  194. 		}
  195. 		params.put("sort", "clicknum");
  196.         params.put("order", "desc");
  197. 		PageUtils page = jiajuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiajuxinxi), params), params));
  198.         return R.ok().put("data", page);
  199.     }
  200.  
  201.  
  202.         /**
  203.      * 协同算法（按用户购买推荐）
  204.      */
  205.     @RequestMapping("/autoSort2")
  206.     public R autoSort2(@RequestParam Map<String, Object> params,JiajuxinxiEntity jiajuxinxi, HttpServletRequest request){
  207.         String userId = request.getSession().getAttribute("userId").toString();
  208.         String goodtypeColumn = "jiajuleixing";
  209.         List<OrdersEntity> orders = ordersService.selectList(new EntityWrapper<OrdersEntity>().eq("userid", userId).eq("tablename", "jiajuxinxi").orderBy("addtime", false));
  210.         List<String> goodtypes = new ArrayList<String>();
  211.         Integer limit = params.get("limit")==null?10:Integer.parseInt(params.get("limit").toString());
  212.         List<JiajuxinxiEntity> jiajuxinxiList = new ArrayList<JiajuxinxiEntity>();
  213. 	//去重
  214.     	List<OrdersEntity> ordersDist = new ArrayList<OrdersEntity>();
  215.     	for(OrdersEntity o1 : orders) {
  216.     		boolean addFlag = true;
  217.     		for(OrdersEntity o2 : ordersDist) {
  218.     			if(o1.getGoodid()==o2.getGoodid() || o1.getGoodtype().equals(o2.getGoodtype())) {
  219.     				addFlag = false;
  220.     				break;
  221.     			}
  222.     		}
  223.     		if(addFlag) ordersDist.add(o1);
  224.     	}
  225.         if(ordersDist!=null && ordersDist.size()>0) {
  226.                 for(OrdersEntity o : ordersDist) {
  227.                         jiajuxinxiList.addAll(jiajuxinxiService.selectList(new EntityWrapper<JiajuxinxiEntity>().eq(goodtypeColumn, o.getGoodtype())));
  228.                 }
  229.         }
  230.         EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  231.         params.put("sort", "id");
  232.         params.put("order", "desc");
  233.         PageUtils page = jiajuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiajuxinxi), params), params));
  234.         List<JiajuxinxiEntity> pageList = (List<JiajuxinxiEntity>)page.getList();
  235.         if(jiajuxinxiList.size()<limit) {
  236.                 int toAddNum = (limit-jiajuxinxiList.size())<=pageList.size()?(limit-jiajuxinxiList.size()):pageList.size();
  237.                 for(JiajuxinxiEntity o1 : pageList) {
  238.                     boolean addFlag = true;
  239.                     for(JiajuxinxiEntity o2 : jiajuxinxiList) {
  240.                         if(o1.getId().intValue()==o2.getId().intValue()) {
  241.                             addFlag = false;
  242.                             break;
  243.                         }
  244.                     }
  245.                     if(addFlag) {
  246.                         jiajuxinxiList.add(o1);
  247.                         if(--toAddNum==0) break;
  248.                     }   
  249.                 }
  250.         }
  251.         page.setList(jiajuxinxiList);
  252.         return R.ok().put("data", page);
  253.     }
  254.  
  255.  
  256.  
  257.  
  258.  
  259. }

协同算法（按用户购买推荐）

  1.  @RequestMapping("/autoSort2")
  2.     public R autoSort2(@RequestParam Map<String, Object> params,JiajuxinxiEntity jiajuxinxi, HttpServletRequest request){
  3.         String userId = request.getSession().getAttribute("userId").toString();
  4.         String goodtypeColumn = "jiajuleixing";
  5.         List<OrdersEntity> orders = ordersService.selectList(new EntityWrapper<OrdersEntity>().eq("userid", userId).eq("tablename", "jiajuxinxi").orderBy("addtime", false));
  6.         List<String> goodtypes = new ArrayList<String>();
  7.         Integer limit = params.get("limit")==null?10:Integer.parseInt(params.get("limit").toString());
  8.         List<JiajuxinxiEntity> jiajuxinxiList = new ArrayList<JiajuxinxiEntity>();
  9. 	//去重
  10.     	List<OrdersEntity> ordersDist = new ArrayList<OrdersEntity>();
  11.     	for(OrdersEntity o1 : orders) {
  12.     		boolean addFlag = true;
  13.     		for(OrdersEntity o2 : ordersDist) {
  14.     			if(o1.getGoodid()==o2.getGoodid() || o1.getGoodtype().equals(o2.getGoodtype())) {
  15.     				addFlag = false;
  16.     				break;
  17.     			}
  18.     		}
  19.     		if(addFlag) ordersDist.add(o1);
  20.     	}
  21.         if(ordersDist!=null && ordersDist.size()>0) {
  22.                 for(OrdersEntity o : ordersDist) {
  23.                         jiajuxinxiList.addAll(jiajuxinxiService.selectList(new EntityWrapper<JiajuxinxiEntity>().eq(goodtypeColumn, o.getGoodtype())));
  24.                 }
  25.         }
  26.         EntityWrapper<JiajuxinxiEntity> ew = new EntityWrapper<JiajuxinxiEntity>();
  27.         params.put("sort", "id");
  28.         params.put("order", "desc");
  29.         PageUtils page = jiajuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiajuxinxi), params), params));
  30.         List<JiajuxinxiEntity> pageList = (List<JiajuxinxiEntity>)page.getList();
  31.         if(jiajuxinxiList.size()<limit) {
  32.                 int toAddNum = (limit-jiajuxinxiList.size())<=pageList.size()?(limit-jiajuxinxiList.size()):pageList.size();
  33.                 for(JiajuxinxiEntity o1 : pageList) {
  34.                     boolean addFlag = true;
  35.                     for(JiajuxinxiEntity o2 : jiajuxinxiList) {
  36.                         if(o1.getId().intValue()==o2.getId().intValue()) {
  37.                             addFlag = false;
  38.                             break;
  39.                         }
  40.                     }
  41.                     if(addFlag) {
  42.                         jiajuxinxiList.add(o1);
  43.                         if(--toAddNum==0) break;
  44.                     }   
  45.                 }
  46.         }
  47.         page.setList(jiajuxinxiList);
  48.         return R.ok().put("data", page);
  49.     }
  50.  
  51.  
  52.  
  53.  
  54.  
  55. }

上传文件

  1. @RestController
  2. @RequestMapping("file")
  3. @SuppressWarnings({"unchecked","rawtypes"})
  4. public class FileController{
  5. 	@Autowired
  6.     private ConfigService configService;
  7. 	/**
  8. 	 * 上传文件
  9. 	 */
  10. 	@RequestMapping("/upload")
  11. 	public R upload(@RequestParam("file") MultipartFile file,String type) throws Exception {
  12. 		if (file.isEmpty()) {
  13. 			throw new EIException("上传文件不能为空");
  14. 		}
  15. 		String fileExt = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")+1);
  16. 		File path = new File(ResourceUtils.getURL("classpath:static").getPath());
  17. 		if(!path.exists()) {
  18. 		    path = new File("");
  19. 		}
  20. 		File upload = new File(path.getAbsolutePath(),"/upload/");
  21. 		if(!upload.exists()) {
  22. 		    upload.mkdirs();
  23. 		}
  24. 		String fileName = new Date().getTime()+"."+fileExt;
  25. 		File dest = new File(upload.getAbsolutePath()+"/"+fileName);
  26. 		file.transferTo(dest);
  27. 		/**
  28.   		 * 如果使用idea或者eclipse重启项目，发现之前上传的图片或者文件丢失，将下面一行代码注释打开
  29.    		 * 请将以下的"D:\\springbootq33sd\\src\\main\\resources\\static\\upload"替换成你本地项目的upload路径，
  30.  		 * 并且项目路径不能存在中文、空格等特殊字符
  31.  		 */
  32. //		FileUtils.copyFile(dest, new File("D:\\springbootq33sd\\src\\main\\resources\\static\\upload"+"/"+fileName)); /**修改了路径以后请将该行最前面的//注释去掉**/
  33. 		if(StringUtils.isNotBlank(type) && type.equals("1")) {
  34. 			ConfigEntity configEntity = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "faceFile"));
  35. 			if(configEntity==null) {
  36. 				configEntity = new ConfigEntity();
  37. 				configEntity.setName("faceFile");
  38. 				configEntity.setValue(fileName);
  39. 			} else {
  40. 				configEntity.setValue(fileName);
  41. 			}
  42. 			configService.insertOrUpdate(configEntity);
  43. 		}
  44. 		return R.ok().put("file", fileName);
  45. 	}
  46. 	
  47. 	/**
  48. 	 * 下载文件
  49. 	 */
  50. 	@IgnoreAuth
  51. 	@RequestMapping("/download")
  52. 	public ResponseEntity<byte[]> download(@RequestParam String fileName) {
  53. 		try {
  54. 			File path = new File(ResourceUtils.getURL("classpath:static").getPath());
  55. 			if(!path.exists()) {
  56. 			    path = new File("");
  57. 			}
  58. 			File upload = new File(path.getAbsolutePath(),"/upload/");
  59. 			if(!upload.exists()) {
  60. 			    upload.mkdirs();
  61. 			}
  62. 			File file = new File(upload.getAbsolutePath()+"/"+fileName);
  63. 			if(file.exists()){
  64. 				/*if(!fileService.canRead(file, SessionManager.getSessionUser())){
  65. 					getResponse().sendError(403);
  66. 				}*/
  67. 				HttpHeaders headers = new HttpHeaders();
  68. 			    headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);    
  69. 			    headers.setContentDispositionFormData("attachment", fileName);    
  70. 			    return new ResponseEntity<byte[]>(FileUtils.readFileToByteArray(file),headers, HttpStatus.CREATED);
  71. 			}
  72. 		} catch (IOException e) {
  73. 			e.printStackTrace();
  74. 		}
  75. 		return new ResponseEntity<byte[]>(HttpStatus.INTERNAL_SERVER_ERROR);
  76. 	}
  77. 	
  78. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/很楠不爱3/article/detail/729807
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号