中山精品网站建设策划,网站统计数据,2023知名品牌营销案例100例,湘潭自助建站系统博主介绍#xff1a;✌从事软件开发10年之余#xff0c;专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ #x1f345;文末获取源码联系#x1f345; #x1f447;#x1f3fb; 精… 博主介绍✌从事软件开发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 项目介绍
在数字化时代电子商务的兴起为传统行业带来了新的机遇和挑战。尤其是对于蛋糕销售行业消费者对于个性化、便捷化的购物体验需求日益增长。为了满足市场需求提高销售效率我们设计并开发了一个基于SpringBoot框架的网上蛋糕销售系统。
背景 传统的蛋糕销售模式通常依赖于实体店铺受限于地理位置和营业时间无法满足消费者随时订购的需求。随着互联网技术的发展越来越多的消费者倾向于在线购物享受便捷的服务和个性化的选择。因此开发一个网上蛋糕销售系统对于拓展销售渠道、提升顾客体验具有重要意义。
目的意义
1. 提升购物体验系统提供直观的蛋糕展示、便捷的在线订购流程以及个性化的蛋糕定制服务满足消费者对于便捷和个性化的需求。2. 优化库存管理通过实时更新的库存管理系统可以有效地控制库存量减少过剩或缺货的情况提高库存周转率。3. 增强营销能力系统内置的优惠券和促销活动管理功能有助于吸引新客户提升老客户的复购率增强整体营销能力。4. 提高运营效率系统自动化的订单处理和物流跟踪功能减少了人工操作的错误和时间成本提高了运营效率。5. 数据分析与决策支持系统提供的销售数据分析和客户行为分析为管理者提供了决策支持帮助优化产品结构和营销策略。
综上所述基于SpringBoot框架的网上蛋糕销售系统不仅能够为消费者提供一个便捷、个性化的购物平台还能够为蛋糕销售商提供一个高效、智能化的运营管理工具。通过技术手段优化蛋糕销售流程该系统有望成为推动蛋糕行业电子商务发展的重要力量。
1.2 开发技术
类别技术名称用途/描述开发语言Java一种广泛使用的面向对象编程语言。框架Spring Boot简化Spring应用的初始搭建以及开发过程。ORM工具MyBatis PlusMyBatis的增强工具简化CRUD操作。数据库MySQL流行的关系型数据库管理系统。构建工具Maven项目管理和理解工具。开发工具IDEA集成开发环境用于代码编写和调试。JDK版本JDK 1.8Java开发工具包提供运行Java程序所需的环境。前端框架Vue用于构建用户界面的渐进式JavaScript框架。UI框架Element UI基于Vue的桌面端组件库。前端技术HTML网页内容的标准标记语言。前端技术CSS描述HTML文档的样式。前端技术JS网页脚本语言用于实现网页的动态效果。 2、系统功能设计结构图 功能模块结构图 │ ├── 前端 │ ├── 登录 │ ├── 注册 │ ├── 首页 │ ├── 蛋糕信息 │ ├── 公告资讯 │ ├── 购物车 │ ├── 在线客服 │ └── 个人中心 │ ├── 个人中心 │ ├── 修改密码 │ ├── 我的订单 │ ├── 我的地址 │ ├── 我的收藏 │ └── 我的优惠券 │ └── 后端 ├── 登录 ├── 系统首页 │ └── 统计 ├── 个人中心 ├── 会员管理 ├── 蛋糕分类管理 ├── 蛋糕信息管理 ├── 材料信息管理 ├── 入库信息管理 ├── 出库信息管理 ├── 优惠券管理 ├── 系统管理 │ ├── 公告资讯管理 │ ├── 公告资讯分类管理 │ ├── 在线客服管理 │ ├── 关于我们管理 │ └── 轮播图管理 └── 订单管理 系统MVC框架请求流程展示 3、功能截图 3.1 前台功能 3.2 后台功能 4、数据库表结构设计 --
-- Table structure for table aboutus
--DROP TABLE IF EXISTS aboutus;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE aboutus (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,subtitle varchar(200) DEFAULT NULL COMMENT 副标题,content longtext NOT NULL COMMENT 内容,picture1 longtext COMMENT 图片1,picture2 longtext COMMENT 图片2,picture3 longtext COMMENT 图片3,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT关于我们;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table cart
--DROP TABLE IF EXISTS cart;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE cart (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,tablename varchar(200) DEFAULT dangaoxinxi COMMENT 商品表名,userid bigint(20) NOT NULL COMMENT 用户id,goodid bigint(20) NOT NULL COMMENT 商品id,goodname varchar(200) DEFAULT NULL COMMENT 商品名称,picture longtext COMMENT 图片,buynumber int(11) NOT NULL COMMENT 购买数量,price double DEFAULT NULL COMMENT 单价,goodtype varchar(200) DEFAULT NULL COMMENT 商品类型,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT3 DEFAULT CHARSETutf8 COMMENT购物车表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table chat
--DROP TABLE IF EXISTS chat;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE chat (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,adminid bigint(20) DEFAULT NULL COMMENT 管理员id,ask longtext COMMENT 提问,reply longtext COMMENT 回复,isreply int(11) DEFAULT NULL COMMENT 是否回复,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT81 DEFAULT CHARSETutf8 COMMENT在线客服;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table config
--DROP TABLE IF EXISTS config;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE config (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,name varchar(100) NOT NULL COMMENT 配置参数名称,value varchar(100) DEFAULT NULL COMMENT 配置参数值,url varchar(500) DEFAULT NULL COMMENT url,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT配置文件;
/*!--
-- Table structure for table dangaofenlei
--DROP TABLE IF EXISTS dangaofenlei;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE dangaofenlei (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,dangaofenlei varchar(200) DEFAULT NULL COMMENT 蛋糕分类,image longtext COMMENT image,PRIMARY KEY (id),UNIQUE KEY dangaofenlei (dangaofenlei)
) ENGINEInnoDB AUTO_INCREMENT29 DEFAULT CHARSETutf8 COMMENT蛋糕分类;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table discussdangaoxinxi
--DROP TABLE IF EXISTS discussdangaoxinxi;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussdangaoxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT蛋糕信息评论表;
/*!40101 SET character_set_client saved_cs_client */;DROP TABLE IF EXISTS huiyuan;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE huiyuan (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuming varchar(200) NOT NULL COMMENT 用户名,mima varchar(200) NOT NULL COMMENT 密码,xingming varchar(200) NOT NULL COMMENT 姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,touxiang longtext COMMENT 头像,shouji varchar(200) DEFAULT NULL COMMENT 手机,money double DEFAULT 0 COMMENT 余额,PRIMARY KEY (id),UNIQUE KEY yonghuming (yonghuming)
) ENGINEInnoDB AUTO_INCREMENT1713666145926 DEFAULT CHARSETutf8 COMMENT会员;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table news
--DROP TABLE IF EXISTS news;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE news (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,introduction longtext COMMENT 简介,typename varchar(200) DEFAULT NULL COMMENT 分类名称,name varchar(200) DEFAULT NULL COMMENT 发布人,headportrait longtext COMMENT 头像,clicknum int(11) DEFAULT 0 COMMENT 点击次数,clicktime datetime DEFAULT NULL COMMENT 最近点击时间,thumbsupnum int(11) DEFAULT 0 COMMENT 赞,crazilynum int(11) DEFAULT 0 COMMENT 踩,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,picture longtext NOT NULL COMMENT 图片,content longtext NOT NULL COMMENT 内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT150 DEFAULT CHARSETutf8 COMMENT公告资讯;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table newstype
--DROP TABLE IF EXISTS newstype;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE newstype (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,typename varchar(200) NOT NULL COMMENT 分类名称,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT140 DEFAULT CHARSETutf8 COMMENT公告资讯分类;
/*!40101 SET character_set_client saved_cs_client */;DROP TABLE IF EXISTS storeup;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE storeup (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,refid bigint(20) DEFAULT NULL COMMENT 商品id,tablename varchar(200) DEFAULT NULL COMMENT 表名,name varchar(200) NOT NULL COMMENT 名称,picture longtext COMMENT 图片,type varchar(200) DEFAULT 1 COMMENT 类型,inteltype varchar(200) DEFAULT NULL COMMENT 推荐类型,remark varchar(200) DEFAULT NULL COMMENT 备注,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8 COMMENT收藏表;
/*!40101 SET character_set_client saved_cs_client */;DROP TABLE IF EXISTS token;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE token (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,userid bigint(20) NOT NULL COMMENT 用户id,username varchar(100) NOT NULL COMMENT 用户名,tablename varchar(100) DEFAULT NULL COMMENT 表名,role varchar(100) DEFAULT NULL COMMENT 角色,token varchar(200) NOT NULL COMMENT 密码,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,expiratedtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 过期时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENTtoken表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Table structure for table users
--DROP TABLE IF EXISTS users;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE users (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(100) NOT NULL COMMENT 用户名,password varchar(100) NOT NULL COMMENT 密码,image varchar(200) DEFAULT NULL COMMENT 头像,role varchar(100) DEFAULT 管理员 COMMENT 角色,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;
/*!40101 SET character_set_client saved_cs_client */;5、关键代码 5.1 蛋糕信息Controller模块 package com.controller;import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;
import com.entity.OrdersEntity;
import com.service.OrdersService;
import com.utils.UserBasedCollaborativeFiltering;import com.entity.DangaoxinxiEntity;
import com.entity.view.DangaoxinxiView;import com.service.DangaoxinxiService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MPUtil;
import com.utils.MapUtils;
import com.utils.CommonUtil;
import java.io.IOException;
import com.service.StoreupService;
import com.entity.StoreupEntity;/*** 蛋糕信息* 后端接口* author * email */
RestController
RequestMapping(/dangaoxinxi)
public class DangaoxinxiController {Autowiredprivate DangaoxinxiService dangaoxinxiService;Autowiredprivate StoreupService storeupService;Autowiredprivate OrdersService ordersService;/*** 后台列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,DangaoxinxiEntity dangaoxinxi,RequestParam(required false) Double pricestart,RequestParam(required false) Double priceend,HttpServletRequest request){EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();if(pricestart!null) ew.ge(price, pricestart);if(priceend!null) ew.le(price, priceend);PageUtils page dangaoxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangaoxinxi), params), params));return R.ok().put(data, page);}/*** 前台列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params,DangaoxinxiEntity dangaoxinxi, RequestParam(required false) Double pricestart,RequestParam(required false) Double priceend,HttpServletRequest request){EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();if(pricestart!null) ew.ge(price, pricestart);if(priceend!null) ew.le(price, priceend);PageUtils page dangaoxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangaoxinxi), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/lists)public R list( DangaoxinxiEntity dangaoxinxi){EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();ew.allEq(MPUtil.allEQMapPre( dangaoxinxi, dangaoxinxi)); return R.ok().put(data, dangaoxinxiService.selectListView(ew));}/*** 查询*/RequestMapping(/query)public R query(DangaoxinxiEntity dangaoxinxi){EntityWrapper DangaoxinxiEntity ew new EntityWrapper DangaoxinxiEntity();ew.allEq(MPUtil.allEQMapPre( dangaoxinxi, dangaoxinxi)); DangaoxinxiView dangaoxinxiView dangaoxinxiService.selectView(ew);return R.ok(查询蛋糕信息成功).put(data, dangaoxinxiView);}/*** 后台详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id){DangaoxinxiEntity dangaoxinxi dangaoxinxiService.selectById(id);dangaoxinxi.setClicknum(dangaoxinxi.getClicknum()1);dangaoxinxiService.updateById(dangaoxinxi);dangaoxinxi dangaoxinxiService.selectView(new EntityWrapperDangaoxinxiEntity().eq(id, id));return R.ok().put(data, dangaoxinxi);}/*** 前台详情*/IgnoreAuthRequestMapping(/detail/{id})public R detail(PathVariable(id) Long id){DangaoxinxiEntity dangaoxinxi dangaoxinxiService.selectById(id);dangaoxinxi.setClicknum(dangaoxinxi.getClicknum()1);dangaoxinxiService.updateById(dangaoxinxi);dangaoxinxi dangaoxinxiService.selectView(new EntityWrapperDangaoxinxiEntity().eq(id, id));return R.ok().put(data, dangaoxinxi);}/*** 赞或踩*/RequestMapping(/thumbsup/{id})public R vote(PathVariable(id) String id,String type){DangaoxinxiEntity dangaoxinxi dangaoxinxiService.selectById(id);if(type.equals(1)) {dangaoxinxi.setThumbsupnum(dangaoxinxi.getThumbsupnum()1);} else {dangaoxinxi.setCrazilynum(dangaoxinxi.getCrazilynum()1);}dangaoxinxiService.updateById(dangaoxinxi);return R.ok(投票成功);}/*** 后台保存*/RequestMapping(/save)public R save(RequestBody DangaoxinxiEntity dangaoxinxi, HttpServletRequest request){//ValidatorUtils.validateEntity(dangaoxinxi);dangaoxinxiService.insert(dangaoxinxi);return R.ok();}/*** 前台保存*/RequestMapping(/add)public R add(RequestBody DangaoxinxiEntity dangaoxinxi, HttpServletRequest request){//ValidatorUtils.validateEntity(dangaoxinxi);dangaoxinxiService.insert(dangaoxinxi);return R.ok();}/*** 修改*/RequestMapping(/update)Transactionalpublic R update(RequestBody DangaoxinxiEntity dangaoxinxi, HttpServletRequest request){//ValidatorUtils.validateEntity(dangaoxinxi);dangaoxinxiService.updateById(dangaoxinxi);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){dangaoxinxiService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 前台智能排序*/IgnoreAuthRequestMapping(/autoSort)public R autoSort(RequestParam MapString, Object params,DangaoxinxiEntity dangaoxinxi, HttpServletRequest request,String pre){EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();MapString, Object newMap new HashMapString, Object();MapString, Object param new HashMapString, Object();IteratorMap.EntryString, Object it param.entrySet().iterator();while (it.hasNext()) {Map.EntryString, Object entry it.next();String key entry.getKey();String newKey entry.getKey();if (pre.endsWith(.)) {newMap.put(pre newKey, entry.getValue());} else if (StringUtils.isEmpty(pre)) {newMap.put(newKey, entry.getValue());} else {newMap.put(pre . newKey, entry.getValue());}}params.put(sort, clicknum);params.put(order, desc);PageUtils page dangaoxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangaoxinxi), params), params));return R.ok().put(data, page);}/*** 协同算法基于用户的协同算法*/RequestMapping(/autoSort2)public R autoSort2(RequestParam MapString, Object params,DangaoxinxiEntity dangaoxinxi, HttpServletRequest request){String userId request.getSession().getAttribute(userId).toString();Integer limit params.get(limit)null?10:Integer.parseInt(params.get(limit).toString());ListOrdersEntity orders ordersService.selectList(new EntityWrapperOrdersEntity());MapString, MapString, Double ratings new HashMap();if(orders!null orders.size()0) {for(OrdersEntity o : orders) {MapString, Double userRatings null;if(ratings.containsKey(o.getUserid().toString())) {userRatings ratings.get(o.getUserid().toString());} else {userRatings new HashMap();ratings.put(o.getUserid().toString(), userRatings);}if(userRatings.containsKey(o.getGoodid().toString())) {userRatings.put(o.getGoodid().toString(), userRatings.get(o.getGoodid().toString())1.0);} else {userRatings.put(o.getGoodid().toString(), 1.0);}}}// 创建协同过滤对象UserBasedCollaborativeFiltering filter new UserBasedCollaborativeFiltering(ratings);// 为指定用户推荐物品String targetUser userId;int numRecommendations limit;ListString recommendations filter.recommendItems(targetUser, numRecommendations);// 输出推荐结果System.out.println(Recommendations for targetUser :);for (String item : recommendations) {System.out.println(item);}EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();ew.in(id, recommendations);if(recommendations!null recommendations.size()0) {ew.last(order by FIELD(id, String.join(,, recommendations)));}PageUtils page dangaoxinxiService.queryPage(params, ew);ListDangaoxinxiEntity pageList (ListDangaoxinxiEntity)page.getList();if(pageList.size()limit) {int toAddNum limit-pageList.size();ew new EntityWrapperDangaoxinxiEntity();ew.notIn(id, recommendations);ew.orderBy(id, false);ew.last(limit toAddNum);pageList.addAll(dangaoxinxiService.selectList(ew));} else if(pageList.size()limit) {pageList pageList.subList(0, limit);}page.setList(pageList);return R.ok().put(data, page);}/*** 按值统计*/RequestMapping(/value/{xColumnName}/{yColumnName})public R value(PathVariable(yColumnName) String yColumnName, PathVariable(xColumnName) String xColumnName,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(yColumn, yColumnName);EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();ListMapString, Object result dangaoxinxiService.selectValue(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/*** 按值统计(多)*/RequestMapping(/valueMul/{xColumnName})public R valueMul(PathVariable(xColumnName) String xColumnName,RequestParam String yColumnNameMul, HttpServletRequest request) {String[] yColumnNames yColumnNameMul.split(,);MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);ListListMapString, Object result2 new ArrayListListMapString,Object();SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();for(int i0;iyColumnNames.length;i) {params.put(yColumn, yColumnNames[i]);ListMapString, Object result dangaoxinxiService.selectValue(params, ew);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}result2.add(result);}return R.ok().put(data, result2);}/*** 按值统计时间统计类型*/RequestMapping(/value/{xColumnName}/{yColumnName}/{timeStatType})public R valueDay(PathVariable(yColumnName) String yColumnName, PathVariable(xColumnName) String xColumnName, PathVariable(timeStatType) String timeStatType,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(yColumn, yColumnName);params.put(timeStatType, timeStatType);EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();ListMapString, Object result dangaoxinxiService.selectTimeStatValue(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/*** 按值统计时间统计类型(多)*/RequestMapping(/valueMul/{xColumnName}/{timeStatType})public R valueMulDay(PathVariable(xColumnName) String xColumnName, PathVariable(timeStatType) String timeStatType,RequestParam String yColumnNameMul,HttpServletRequest request) {String[] yColumnNames yColumnNameMul.split(,);MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(timeStatType, timeStatType);ListListMapString, Object result2 new ArrayListListMapString,Object();SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();for(int i0;iyColumnNames.length;i) {params.put(yColumn, yColumnNames[i]);ListMapString, Object result dangaoxinxiService.selectTimeStatValue(params, ew);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}result2.add(result);}return R.ok().put(data, result2);}/*** 分组统计*/RequestMapping(/group/{columnName})public R group(PathVariable(columnName) String columnName,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(column, columnName);EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();ListMapString, Object result dangaoxinxiService.selectGroup(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/*** 总数量*/RequestMapping(/count)public R count(RequestParam MapString, Object params,DangaoxinxiEntity dangaoxinxi, HttpServletRequest request){EntityWrapperDangaoxinxiEntity ew new EntityWrapperDangaoxinxiEntity();int count dangaoxinxiService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dangaoxinxi), params), params));return R.ok().put(data, count);}}5.2 蛋糕信息Service模块 package com.service;import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.DangaoxinxiEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.DangaoxinxiVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.DangaoxinxiView;/*** 蛋糕信息** author * email */
public interface DangaoxinxiService extends IServiceDangaoxinxiEntity {PageUtils queryPage(MapString, Object params);ListDangaoxinxiVO selectListVO(WrapperDangaoxinxiEntity wrapper);DangaoxinxiVO selectVO(Param(ew) WrapperDangaoxinxiEntity wrapper);ListDangaoxinxiView selectListView(WrapperDangaoxinxiEntity wrapper);DangaoxinxiView selectView(Param(ew) WrapperDangaoxinxiEntity wrapper);PageUtils queryPage(MapString, Object params,WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectValue(MapString, Object params,WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectTimeStatValue(MapString, Object params,WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectGroup(MapString, Object params,WrapperDangaoxinxiEntity wrapper);}
5.3 蛋糕信息ServiceImpl模块 package com.service.impl;import org.springframework.stereotype.Service;
import java.util.Map;
import java.util.List;import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.utils.PageUtils;
import com.utils.Query;import com.dao.DangaoxinxiDao;
import com.entity.DangaoxinxiEntity;
import com.service.DangaoxinxiService;
import com.entity.vo.DangaoxinxiVO;
import com.entity.view.DangaoxinxiView;Service(dangaoxinxiService)
public class DangaoxinxiServiceImpl extends ServiceImplDangaoxinxiDao, DangaoxinxiEntity implements DangaoxinxiService {Overridepublic PageUtils queryPage(MapString, Object params) {PageDangaoxinxiEntity page this.selectPage(new QueryDangaoxinxiEntity(params).getPage(),new EntityWrapperDangaoxinxiEntity());return new PageUtils(page);}Overridepublic PageUtils queryPage(MapString, Object params, WrapperDangaoxinxiEntity wrapper) {PageDangaoxinxiView page new QueryDangaoxinxiView(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil new PageUtils(page);return pageUtil;}Overridepublic ListDangaoxinxiVO selectListVO(WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectListVO(wrapper);}Overridepublic DangaoxinxiVO selectVO(WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectVO(wrapper);}Overridepublic ListDangaoxinxiView selectListView(WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectListView(wrapper);}Overridepublic DangaoxinxiView selectView(WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectView(wrapper);}Overridepublic ListMapString, Object selectValue(MapString, Object params, WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectValue(params, wrapper);}Overridepublic ListMapString, Object selectTimeStatValue(MapString, Object params, WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectTimeStatValue(params, wrapper);}Overridepublic ListMapString, Object selectGroup(MapString, Object params, WrapperDangaoxinxiEntity wrapper) {return baseMapper.selectGroup(params, wrapper);}}5.4 蛋糕信息Dao模块 package com.dao;import com.entity.DangaoxinxiEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;
import com.entity.vo.DangaoxinxiVO;
import com.entity.view.DangaoxinxiView;/*** 蛋糕信息* * author * email */
public interface DangaoxinxiDao extends BaseMapperDangaoxinxiEntity {ListDangaoxinxiVO selectListVO(Param(ew) WrapperDangaoxinxiEntity wrapper);DangaoxinxiVO selectVO(Param(ew) WrapperDangaoxinxiEntity wrapper);ListDangaoxinxiView selectListView(Param(ew) WrapperDangaoxinxiEntity wrapper);ListDangaoxinxiView selectListView(Pagination page,Param(ew) WrapperDangaoxinxiEntity wrapper);DangaoxinxiView selectView(Param(ew) WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectValue(Param(params) MapString, Object params,Param(ew) WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectTimeStatValue(Param(params) MapString, Object params,Param(ew) WrapperDangaoxinxiEntity wrapper);ListMapString, Object selectGroup(Param(params) MapString, Object params,Param(ew) WrapperDangaoxinxiEntity wrapper);}6、论文目录结构 摘要... I
Abstract... II
1 绪论... 1 1.1 项目简介... 1 1.2 调查研究... 1 1.2.1 研究背景及意义... 1 1.2.2 国内外研究现状... 2 1.2.3 研究主要内容... 2 1.3 论文的章节安排... 3
2 系统相关技术介绍... 4 2.1 Java语言... 4 2.2 SpringBoot框架... 4 2.3 Vue框架... 4 2.4 MySQL数据库... 4
3 系统需求分析... 6 3.1 可行性分析... 6 3.1.1 技术可行性... 6 3.1.2 经济可行性... 6 3.1.3 操作可行性... 6 3.2 系统功能需求... 6 3.2.1 用户端功能需求... 6 3.2.2 XX端功能需求... 6 3.2.3 管理员端功能需求... 6 3.3 系统性能需求... 6
4 系统总体设计... 7 4.1 系统总体架构设计... 7 4.2 系统的功能设计... 7 4.3 数据库设计... 7 4.3.1 概念设计E-R图... 7 4.3.2 逻辑设计关系模式... 7 4.3.3 数据库物理设计... 7
5 系统详细实现... 14 5.1 系统实现环境... 14 5.2 用户端... 14 5.2.1 登录页面... 14 5.2.2 注册页面... 14 5.2.3 XXXX页面... 14 5.2.4 XXXX页面... 14 5.2.5 XXXX页面... 14 5.3 XXXX端... 15 5.3.1 XXXX页面... 15 5.3.2 XXXX页面... 15 5.3.3 XXXX页面... 15 5.3.4 XXXX页面... 15 5.4 管理端... 15 5.4.1 用户管理页面... 15 5.4.2 XXXX页面... 15 5.4.3 XXXX页面... 16 5.4.4 XXXX页面... 16
6 系统测试... 16 6.1 测试目的... 16 6.2 测试方法... 16 6.3 测试用例... 16 6.3.1 XXXX测试... 16 6.3.2 XXXX测试... 16 6.4 测试结果... 16
结论... 17
参考文献... 18
致谢... 19
更多源码
计算机毕业设计选题1000套等你来 7、源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊!
喜欢文章可以点赞、收藏、关注、评论啦
→下方联系方式获取源码←
