• 计算机毕业设计 基于Vue的米家商城系统的设计与实现 Java实战项目 附源码+文档+视频讲解

    博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌
    🍅文末获取源码联系🍅
    👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
    ————————————————
    计算机毕业设计《1000套》✌

    目录

    1、项目介绍及开发技术

    1.1 项目介绍

    1.2 开发技术

    2、系统功能模块设计

    3、功能截图

    3.1 前台功能

    3.2 后台功能 

    4、数据库表结构设计

    5、关键代码

    5.1 商品信息管理Controller模块 

    5.2 商品信息管理Service模块 

    5.3 商品信息管理ServiceImpl模块

    5.4 商品信息管理Dao模块

    6、论文目录结构

    7、源码获取

    1、项目介绍及开发技术

    1.1 项目介绍

    随着互联网技术的不断发展，电子商务已经成为了人们生活中不可或缺的一部分。而商城系统作为电子商务的重要组成部分，其功能和性能直接影响到用户的购物体验和企业的经营效益。因此，开发一款高效、稳定、易用的商城系统具有重要的现实意义。

    Vue是一种轻量级的前端框架，具有简单易学、高效灵活等特点。基于Vue的米家商城系统可以充分利用Vue的优势，实现快速开发和迭代更新。同时，Vue还具有良好的兼容性和可扩展性，可以适应不同设备和浏览器的需求。

    在计算机专业毕设中，研究基于Vue的米家商城系统不仅可以提高学生的编程能力和实践能力，还可以培养学生的创新思维和团队协作精神。此外，通过对商城系统的研究和开发，可以为相关企业提供技术支持和服务，促进电子商务的发展。

    1.2 开发技术

    Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8+、Vue、HTML、CSS、JS。

    2、系统功能模块设计

    用户：注册登录、首页、商品信息、公告信息、个人中心（我的订单、我的地址、我的收藏）、购物车、客服中心。

    管理员：登录、首页、个人中心（修改密码、个人信息）、用户管理、商品分类管理、商品信息管理、系统管理（公告信息、客服中心、轮播图管理）、订单管理。

    3、功能截图

    3.1 前台功能

    商品信息

    公告信息

    个人中心

    购物车

     

    客服中心

    注册

     登录

    3.2 后台功能 

     首页

     个人中心

     用户管理

    商品分类管理

     

    商品信息管理

     

    系统管理公告信息

     订单管理

    4、数据库表结构设计

    1. -- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
    2. --
    3. -- Host: localhost    Database: springbootho5g5
    4. -- ------------------------------------------------------
    5. -- Server version	5.7.31
    6.  
    7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10. /*!40101 SET NAMES utf8 */;
    11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12. /*!40103 SET TIME_ZONE='+00:00' */;
    13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17.  
    18. --
    19. -- Current Database: `springbootho5g5`
    20. --
    21.  
    22. /*!40000 DROP DATABASE IF EXISTS `springbootho5g5`*/;
    23.  
    24. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootho5g5` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
    25.  
    26. USE `springbootho5g5`;
    27.  
    28. LOCK TABLES `cart` WRITE;
    29. /*!40000 ALTER TABLE `cart` DISABLE KEYS */;
    30. /*!40000 ALTER TABLE `cart` ENABLE KEYS */;
    31. UNLOCK TABLES;
    32.  
    33. --
    34. -- Table structure for table `config`
    35. --
    36.  
    37. DROP TABLE IF EXISTS `config`;
    38. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    39. /*!40101 SET character_set_client = utf8 */;
    40. CREATE TABLE `config` (
    41.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    42.   `name` varchar(100) NOT NULL COMMENT '配置参数名称',
    43.   `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
    44.   PRIMARY KEY (`id`)
    45. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
    46. /*!40101 SET character_set_client = @saved_cs_client */;
    47.  
    48. --
    49. -- Dumping data for table `config`
    50. --
    51.  
    52. LOCK TABLES `config` WRITE;
    53. /*!40000 ALTER TABLE `config` DISABLE KEYS */;
    54. INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
    55. /*!40000 ALTER TABLE `config` ENABLE KEYS */;
    56. UNLOCK TABLES;
    57.  
    58. --
    59. -- Table structure for table `token`
    60. --
    61.  
    62. DROP TABLE IF EXISTS `token`;
    63. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    64. /*!40101 SET character_set_client = utf8 */;
    65. CREATE TABLE `token` (
    66.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    67.   `userid` bigint(20) NOT NULL COMMENT '用户id',
    68.   `username` varchar(100) NOT NULL COMMENT '用户名',
    69.   `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
    70.   `role` varchar(100) DEFAULT NULL COMMENT '角色',
    71.   `token` varchar(200) NOT NULL COMMENT '密码',
    72.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    73.   `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
    74.   PRIMARY KEY (`id`)
    75. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
    76. /*!40101 SET character_set_client = @saved_cs_client */;
    77.  
    78. --
    79. -- Dumping data for table `token`
    80. --
    81.  
    82. LOCK TABLES `token` WRITE;
    83. /*!40000 ALTER TABLE `token` DISABLE KEYS */;
    84. INSERT INTO `token` VALUES (1,21,'工号1','yuangong','员工','outtj0ena1f8344sremckoiw8eq58o8m','2023-05-11 03:59:33','2023-05-11 04:59:34');
    85. /*!40000 ALTER TABLE `token` ENABLE KEYS */;
    86. UNLOCK TABLES;
    87.  
    88. --
    89. -- Table structure for table `users`
    90. --
    91.  
    92. DROP TABLE IF EXISTS `users`;
    93. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    94. /*!40101 SET character_set_client = utf8 */;
    95. CREATE TABLE `users` (
    96.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    97.   `username` varchar(100) NOT NULL COMMENT '用户名',
    98.   `password` varchar(100) NOT NULL COMMENT '密码',
    99.   `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
    100.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
    101.   PRIMARY KEY (`id`)
    102. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
    103. /*!40101 SET character_set_client = @saved_cs_client */;
    104.  
    105. --
    106. -- Dumping data for table `users`
    107. --
    108.  
    109. LOCK TABLES `users` WRITE;
    110. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
    111. INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-05-11 03:58:19');
    112. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
    113. UNLOCK TABLES;
    114.  
    115.  
    116.  
    117. --
    118. -- Table structure for table `yonghu`
    119. --
    120.  
    121. DROP TABLE IF EXISTS `yonghu`;
    122. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    123. /*!40101 SET character_set_client = utf8 */;
    124. CREATE TABLE `yonghu` (
    125.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    126.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    127.   `yonghuming` varchar(200) NOT NULL COMMENT '用户名',
    128.   `xingming` varchar(200) NOT NULL COMMENT '姓名',
    129.   `mima` varchar(200) NOT NULL COMMENT '密码',
    130.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    131.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    132.   PRIMARY KEY (`id`),
    133.   UNIQUE KEY `yonghuming` (`yonghuming`)
    134. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户';
    135. /*!40101 SET character_set_client = @saved_cs_client */;
    136.  
    137. --
    138. -- Dumping data for table `yonghu`
    139. --
    140.  
    141. LOCK TABLES `yonghu` WRITE;
    142. /*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
    143. INSERT INTO `yonghu` VALUES (11,'2023-05-11 03:58:18','用户名1','姓名1','123456','男','13823888881'),(12,'2023-05-11 03:58:18','用户名2','姓名2','123456','男','13823888882'),(13,'2023-05-11 03:58:18','用户名3','姓名3','123456','男','13823888883'),(14,'2023-05-11 03:58:18','用户名4','姓名4','123456','男','13823888884'),(15,'2023-05-11 03:58:18','用户名5','姓名5','123456','男','13823888885'),(16,'2023-05-11 03:58:18','用户名6','姓名6','123456','男','13823888886'),(17,'2023-05-11 03:58:18','用户名7','姓名7','123456','男','13823888887'),(18,'2023-05-11 03:58:18','用户名8','姓名8','123456','男','13823888888');
    144. /*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
    145. UNLOCK TABLES;
    146.  
    147. --
    148. -- Table structure for table `yuangong`
    149. --
    150.  
    151. DROP TABLE IF EXISTS `yuangong`;
    152. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    153. /*!40101 SET character_set_client = utf8 */;
    154. CREATE TABLE `yuangong` (
    155.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    156.   `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    157.   `gonghao` varchar(200) NOT NULL COMMENT '工号',
    158.   `xingming` varchar(200) NOT NULL COMMENT '姓名',
    159.   `mima` varchar(200) NOT NULL COMMENT '密码',
    160.   `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
    161.   `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
    162.   `touxiang` longtext COMMENT '头像',
    163.   PRIMARY KEY (`id`),
    164.   UNIQUE KEY `gonghao` (`gonghao`)
    165. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='员工';
    166. /*!40101 SET character_set_client = @saved_cs_client */;
    167.  
    168. --
    169. -- Dumping data for table `yuangong`
    170. --
    171.  
    172. LOCK TABLES `yuangong` WRITE;
    173. /*!40000 ALTER TABLE `yuangong` DISABLE KEYS */;
    174. INSERT INTO `yuangong` VALUES (21,'2023-05-11 03:58:18','工号1','姓名1','123456','男','13823888881','upload/yuangong_touxiang1.jpg'),(22,'2023-05-11 03:58:18','工号2','姓名2','123456','男','13823888882','upload/yuangong_touxiang2.jpg'),(23,'2023-05-11 03:58:18','工号3','姓名3','123456','男','13823888883','upload/yuangong_touxiang3.jpg'),(24,'2023-05-11 03:58:18','工号4','姓名4','123456','男','13823888884','upload/yuangong_touxiang4.jpg'),(25,'2023-05-11 03:58:18','工号5','姓名5','123456','男','13823888885','upload/yuangong_touxiang5.jpg'),(26,'2023-05-11 03:58:18','工号6','姓名6','123456','男','13823888886','upload/yuangong_touxiang6.jpg'),(27,'2023-05-11 03:58:18','工号7','姓名7','123456','男','13823888887','upload/yuangong_touxiang7.jpg'),(28,'2023-05-11 03:58:18','工号8','姓名8','123456','男','13823888888','upload/yuangong_touxiang8.jpg');
    175. /*!40000 ALTER TABLE `yuangong` ENABLE KEYS */;
    176. UNLOCK TABLES;
    177. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    178.  
    179. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    180. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    181. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    182. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    183. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    184. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    185. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    186.  
    187. -- Dump completed on

    5、关键代码

    5.1 商品信息管理Controller模块 

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

    5.2 商品信息管理Service模块 

    1. package com.service;
    2.  
    3. import com.baomidou.mybatisplus.mapper.Wrapper;
    4. import com.baomidou.mybatisplus.service.IService;
    5. import com.utils.PageUtils;
    6. import com.entity.ShangpinxinxiEntity;
    7. import java.util.List;
    8. import java.util.Map;
    9. import com.entity.vo.ShangpinxinxiVO;
    10. import org.apache.ibatis.annotations.Param;
    11. import com.entity.view.ShangpinxinxiView;
    12.  
    13. /**
    14.  * 商品信息
    15.  *
    16.  * @author 
    17.  * @email 
    18.  * @date 
    19.  */
    20. public interface ShangpinxinxiService extends IService {
    21.  
    22.     PageUtils queryPage(Map params);
    23.     
    24.    	List selectListVO(Wrapper wrapper);
    25.    	
    26.    	ShangpinxinxiVO selectVO(@Param("ew") Wrapper wrapper);
    27.    	
    28.    	List selectListView(Wrapper wrapper);
    29.    	
    30.    	ShangpinxinxiView selectView(@Param("ew") Wrapper wrapper);
    31.    	
    32.    	PageUtils queryPage(Map params,Wrapper wrapper);
    33.    	
    34. }
    35.

    5.3 商品信息管理ServiceImpl模块

    1. package com.service.impl;
    2.  
    3. import org.springframework.stereotype.Service;
    4. import java.util.Map;
    5. import java.util.List;
    6.  
    7. import com.baomidou.mybatisplus.mapper.Wrapper;
    8. import com.baomidou.mybatisplus.mapper.EntityWrapper;
    9. import com.baomidou.mybatisplus.plugins.Page;
    10. import com.baomidou.mybatisplus.service.impl.ServiceImpl;
    11. import com.utils.PageUtils;
    12. import com.utils.Query;
    13.  
    14. import com.dao.ShangpinxinxiDao;
    15. import com.entity.ShangpinxinxiEntity;
    16. import com.service.ShangpinxinxiService;
    17. import com.entity.vo.ShangpinxinxiVO;
    18. import com.entity.view.ShangpinxinxiView;
    19.  
    20. @Service("shangpinxinxiService")
    21. public class ShangpinxinxiServiceImpl extends ServiceImpl implements ShangpinxinxiService {
    22.  
    23.     @Override
    24.     public PageUtils queryPage(Map params) {
    25.         Page page = this.selectPage(
    26.                 new Query(params).getPage(),
    27.                 new EntityWrapper()
    28.         );
    29.         return new PageUtils(page);
    30.     }
    31.     
    32.     @Override
    33. 	public PageUtils queryPage(Map params, Wrapper wrapper) {
    34. 		  Page page =new Query(params).getPage();
    35. 	        page.setRecords(baseMapper.selectListView(page,wrapper));
    36. 	    	PageUtils pageUtil = new PageUtils(page);
    37. 	    	return pageUtil;
    38.  	}
    39.     
    40.     @Override
    41. 	public List selectListVO(Wrapper wrapper) {
    42.  		return baseMapper.selectListVO(wrapper);
    43. 	}
    44. 	
    45. 	@Override
    46. 	public ShangpinxinxiVO selectVO(Wrapper wrapper) {
    47.  		return baseMapper.selectVO(wrapper);
    48. 	}
    49. 	
    50. 	@Override
    51. 	public List selectListView(Wrapper wrapper) {
    52. 		return baseMapper.selectListView(wrapper);
    53. 	}
    54.  
    55. 	@Override
    56. 	public ShangpinxinxiView selectView(Wrapper wrapper) {
    57. 		return baseMapper.selectView(wrapper);
    58. 	}
    59.  
    60. }

    5.4 商品信息管理Dao模块

    1. package com.dao;
    2.  
    3. import com.entity.ShangpinxinxiEntity;
    4. import com.baomidou.mybatisplus.mapper.BaseMapper;
    5. import java.util.List;
    6. import java.util.Map;
    7. import com.baomidou.mybatisplus.mapper.Wrapper;
    8. import com.baomidou.mybatisplus.plugins.pagination.Pagination;
    9.  
    10. import org.apache.ibatis.annotations.Param;
    11. import com.entity.vo.ShangpinxinxiVO;
    12. import com.entity.view.ShangpinxinxiView;
    13.  
    14. /**
    15.  * 商品信息
    16.  * 
    17.  * @author 
    18.  * @email 
    19.  * @date 
    20.  */
    21. public interface ShangpinxinxiDao extends BaseMapper {
    22. 	
    23. 	List selectListVO(@Param("ew") Wrapper wrapper);
    24. 	
    25. 	ShangpinxinxiVO selectVO(@Param("ew") Wrapper wrapper);
    26. 	
    27. 	List selectListView(@Param("ew") Wrapper wrapper);
    28.  
    29. 	List selectListView(Pagination page,@Param("ew") Wrapper wrapper);
    30. 	
    31. 	ShangpinxinxiView selectView(@Param("ew") Wrapper wrapper);
    32.  
    33. }

    6、论文目录结构

    7、源码获取

    感谢大家的阅读，如有不懂的问题可以评论区交流或私聊!

    喜欢文章可以点赞、收藏、关注、评论啦

    →获取源码请私信←

  • 相关阅读:
    七、golang基础之interface与类型断言
    大三第三周学习笔记
    算法分享三个方面学习方法（做题经验，代码编写经验，比赛经验）
    Android面试整理之SQLite数据库——sql语句和常用函数（一）
    知乎回答推广怎么做？知乎回答如何做到置顶？
    ABPvNext 迁移Mysql（macOS）
    【Redis实现秒杀业务②】超卖问题的解决方案
    计网 | 【五 传输层、六 应用层】知识点及例题
    SQL Server Count()函数
    【实战详解】如何快速搭建接口自动化测试框架？Python + Requests
  • 原文地址：https://blog.csdn.net/m0_74181697/article/details/134428200