幸福网咖订座点餐小程序的设计与实现

文章目录

    • 前言
    • 详细视频演示
    • 具体实现截图
      • 后端框架SpringBoot
      • 微信小程序
      • 持久层框架MyBaits
    • 成功系统案例:
    • 参考代码
    • 数据库
    • 源码获取

前言

博主介绍:CSDN特邀作者、985高校计算机专业毕业、现任某互联网大厂高级全栈开发工程师、Gitee/掘金/华为云/阿里云/GitHub等平台持续输出高质量技术内容、深耕Java、小程序、前端、python等技术领域和毕业项目实战,以及程序定制化开发、全栈讲解。

💯文末获取源码+数据库💯
感兴趣的可以先收藏起来,还有大家在毕设选题,项目以及论文编写等相关问题都可以找我咨询,希望帮助更多的人。

详细视频演示

视频演示

具体实现截图

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

后端框架SpringBoot

Spring Boot允许开发者快速构建出既可以独立运行又满足生产级别标准的Spring基础应用程序。此框架通过提供一系列便捷的工具和服务,极大地促进了基于Spring的应用开发工作的效率和质量。通过提供一系列大型项目中常用的默认配置,Spring Boot最大化减少配置文件的使用,开发者能够迅速启动和运行Spring应用程序。

Spring Boot通过约定优于配置的原则,避免了许多传统Spring应用开发时繁琐的配置,该框架支持对内嵌服务器的自动配置,如Tomcat、Jetty或Undertow,从而简化了Web应用的部署过程。

微信小程序

小程序开发框架的目标是通过尽可能简单、高效的方式让开发者可以在微信中开发具有原生 APP 体验的服务。
整个小程序框架系统分为两部分:逻辑层(App Service)和 视图层(View)。小程序提供了自己的视图层描述语言 WXML 和 WXSS,以及基于 JavaScript 的逻辑层框架,并在视图层与逻辑层间提供了数据传输和事件系统,让开发者能够专注于数据与逻辑。

持久层框架MyBaits

MyBatis是一个开源的持久层框架,它可以帮助开发者简化数据库操作的编写和管理。MyBatis的核心思想是将SQL语句和Java代码分离,通过XML或注解的方式来描述数据库操作,从而实现了数据访问层的解耦和灵活性。

MyBatis的优势主要包括以下几点:

简化数据库操作:MyBatis通过提供强大的SQL映射功能,可以将Java对象与数据库表进行映射,开发者无需手动编写繁琐的SQL语句,大大简化了数据库操作的编写和维护。

灵活的SQL控制:MyBatis支持动态SQL,可以根据不同的条件和逻辑来动态生成SQL语句,使得查询、更新等操作更加灵活和可控。

缓存支持:MyBatis提供了一级缓存和二级缓存的支持,可以有效减少数据库的访问次数,提高系统性能。

可扩展性强:MyBatis采用插件机制,可以方便地扩展和定制自己的功能,满足各种不同的业务需求。

所有项目均为博主亲自收集、开发并严格测试,确保源码完整、可运行,无缺失依赖或兼容性问题!同学们拿到后就能使用!博主具备多年高级开发经验,能深入讲解代码架构、核心逻辑及技术难点,助你高效掌握项目精髓。

成功系统案例:

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

参考代码

package com.ch.ebusiness.controller.admin;import com.ch.ebusiness.common.Constants;
import com.ch.ebusiness.common.CategoryLevelEnum;
import com.ch.ebusiness.common.ServiceResultEnum;
import com.ch.ebusiness.entity.GoodsCategory;
import com.ch.ebusiness.entity.Goods;
import com.ch.ebusiness.service.CategoryService;
import com.ch.ebusiness.service.GoodsService;
import com.ch.ebusiness.util.PageQueryUtil;
import com.ch.ebusiness.util.Result;
import com.ch.ebusiness.util.ResultGenerator;
import org.springframework.stereotype.Controller;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import java.util.Objects;@Controller
@RequestMapping("/admin")
public class GoodsController {@Resourceprivate GoodsService goodsService;@Resourceprivate CategoryService categoryService;@GetMapping("/goods")public String goodsPage(HttpServletRequest request) {request.setAttribute("path", "newbee_mall_goods");return "admin/newbee_mall_goods";}@GetMapping("/goods/edit")public String edit(HttpServletRequest request) {request.setAttribute("path", "edit");//查询所有的一级分类List<GoodsCategory> firstLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(0L), CategoryLevelEnum.LEVEL_ONE.getLevel());if (!CollectionUtils.isEmpty(firstLevelCategories)) {//查询一级分类列表中第一个实体的所有二级分类List<GoodsCategory> secondLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(firstLevelCategories.get(0).getCategoryId()), CategoryLevelEnum.LEVEL_TWO.getLevel());if (!CollectionUtils.isEmpty(secondLevelCategories)) {//查询二级分类列表中第一个实体的所有三级分类List<GoodsCategory> thirdLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(secondLevelCategories.get(0).getCategoryId()), CategoryLevelEnum.LEVEL_THREE.getLevel());request.setAttribute("firstLevelCategories", firstLevelCategories);request.setAttribute("secondLevelCategories", secondLevelCategories);request.setAttribute("thirdLevelCategories", thirdLevelCategories);request.setAttribute("path", "goods-edit");return "admin/newbee_mall_goods_edit";}}return "error/error_5xx";}@GetMapping("/goods/edit/{goodsId}")public String edit(HttpServletRequest request, @PathVariable("goodsId") Long goodsId) {request.setAttribute("path", "edit");Goods newBeeMallGoods = goodsService.getNewBeeMallGoodsById(goodsId);if (newBeeMallGoods == null) {return "error/error_400";}if (newBeeMallGoods.getGoodsCategoryId() > 0) {if (newBeeMallGoods.getGoodsCategoryId() != null || newBeeMallGoods.getGoodsCategoryId() > 0) {//有分类字段则查询相关分类数据返回给前端以供分类的三级联动显示GoodsCategory currentGoodsCategory = categoryService.getGoodsCategoryById(newBeeMallGoods.getGoodsCategoryId());//商品表中存储的分类id字段为三级分类的id,不为三级分类则是错误数据if (currentGoodsCategory != null && currentGoodsCategory.getCategoryLevel() == CategoryLevelEnum.LEVEL_THREE.getLevel()) {//查询所有的一级分类List<GoodsCategory> firstLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(0L), CategoryLevelEnum.LEVEL_ONE.getLevel());//根据parentId查询当前parentId下所有的三级分类List<GoodsCategory> thirdLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(currentGoodsCategory.getParentId()), CategoryLevelEnum.LEVEL_THREE.getLevel());//查询当前三级分类的父级二级分类GoodsCategory secondCategory = categoryService.getGoodsCategoryById(currentGoodsCategory.getParentId());if (secondCategory != null) {//根据parentId查询当前parentId下所有的二级分类List<GoodsCategory> secondLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(secondCategory.getParentId()), CategoryLevelEnum.LEVEL_TWO.getLevel());//查询当前二级分类的父级一级分类GoodsCategory firestCategory = categoryService.getGoodsCategoryById(secondCategory.getParentId());if (firestCategory != null) {//所有分类数据都得到之后放到request对象中供前端读取request.setAttribute("firstLevelCategories", firstLevelCategories);request.setAttribute("secondLevelCategories", secondLevelCategories);request.setAttribute("thirdLevelCategories", thirdLevelCategories);request.setAttribute("firstLevelCategoryId", firestCategory.getCategoryId());request.setAttribute("secondLevelCategoryId", secondCategory.getCategoryId());request.setAttribute("thirdLevelCategoryId", currentGoodsCategory.getCategoryId());}}}}}if (newBeeMallGoods.getGoodsCategoryId() == 0) {//查询所有的一级分类List<GoodsCategory> firstLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(0L), CategoryLevelEnum.LEVEL_ONE.getLevel());if (!CollectionUtils.isEmpty(firstLevelCategories)) {//查询一级分类列表中第一个实体的所有二级分类List<GoodsCategory> secondLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(firstLevelCategories.get(0).getCategoryId()), CategoryLevelEnum.LEVEL_TWO.getLevel());if (!CollectionUtils.isEmpty(secondLevelCategories)) {//查询二级分类列表中第一个实体的所有三级分类List<GoodsCategory> thirdLevelCategories = categoryService.selectByLevelAndParentIdsAndNumber(Collections.singletonList(secondLevelCategories.get(0).getCategoryId()), CategoryLevelEnum.LEVEL_THREE.getLevel());request.setAttribute("firstLevelCategories", firstLevelCategories);request.setAttribute("secondLevelCategories", secondLevelCategories);request.setAttribute("thirdLevelCategories", thirdLevelCategories);}}}request.setAttribute("goods", newBeeMallGoods);request.setAttribute("path", "goods-edit");return "admin/newbee_mall_goods_edit";}/*** 列表*/@RequestMapping(value = "/goods/list", method = RequestMethod.GET)@ResponseBodypublic Result list(@RequestParam Map<String, Object> params) {if (StringUtils.isEmpty(params.get("page")) || StringUtils.isEmpty(params.get("limit"))) {return ResultGenerator.genFailResult("参数异常!");}PageQueryUtil pageUtil = new PageQueryUtil(params);return ResultGenerator.genSuccessResult(goodsService.getNewBeeMallGoodsPage(pageUtil));}/*** 添加*/@RequestMapping(value = "/goods/save", method = RequestMethod.POST)@ResponseBodypublic Result save(@RequestBody Goods newBeeMallGoods) {if (StringUtils.isEmpty(newBeeMallGoods.getGoodsName())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsIntro())|| StringUtils.isEmpty(newBeeMallGoods.getTag())|| Objects.isNull(newBeeMallGoods.getOriginalPrice())|| Objects.isNull(newBeeMallGoods.getGoodsCategoryId())|| Objects.isNull(newBeeMallGoods.getSellingPrice())|| Objects.isNull(newBeeMallGoods.getStockNum())|| Objects.isNull(newBeeMallGoods.getGoodsSellStatus())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsCoverImg())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsDetailContent())) {return ResultGenerator.genFailResult("参数异常!");}String result = goodsService.saveNewBeeMallGoods(newBeeMallGoods);if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {return ResultGenerator.genSuccessResult();} else {return ResultGenerator.genFailResult(result);}}/*** 修改*/@RequestMapping(value = "/goods/update", method = RequestMethod.POST)@ResponseBodypublic Result update(@RequestBody Goods newBeeMallGoods) {if (Objects.isNull(newBeeMallGoods.getGoodsId())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsName())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsIntro())|| StringUtils.isEmpty(newBeeMallGoods.getTag())|| Objects.isNull(newBeeMallGoods.getOriginalPrice())|| Objects.isNull(newBeeMallGoods.getSellingPrice())|| Objects.isNull(newBeeMallGoods.getGoodsCategoryId())|| Objects.isNull(newBeeMallGoods.getStockNum())|| Objects.isNull(newBeeMallGoods.getGoodsSellStatus())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsCoverImg())|| StringUtils.isEmpty(newBeeMallGoods.getGoodsDetailContent())) {return ResultGenerator.genFailResult("参数异常!");}String result = goodsService.updateNewBeeMallGoods(newBeeMallGoods);if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {return ResultGenerator.genSuccessResult();} else {return ResultGenerator.genFailResult(result);}}/*** 详情*/@GetMapping("/goods/info/{id}")@ResponseBodypublic Result info(@PathVariable("id") Long id) {Goods goods = goodsService.getNewBeeMallGoodsById(id);if (goods == null) {return ResultGenerator.genFailResult(ServiceResultEnum.DATA_NOT_EXIST.getResult());}return ResultGenerator.genSuccessResult(goods);}/*** 批量修改销售状态*/@RequestMapping(value = "/goods/status/{sellStatus}", method = RequestMethod.PUT)@ResponseBodypublic Result delete(@RequestBody Long[] ids, @PathVariable("sellStatus") int sellStatus) {if (ids.length < 1) {return ResultGenerator.genFailResult("参数异常!");}if (sellStatus != Constants.SELL_STATUS_UP && sellStatus != Constants.SELL_STATUS_DOWN) {return ResultGenerator.genFailResult("状态异常!");}if (goodsService.batchUpdateSellStatus(ids, sellStatus)) {return ResultGenerator.genSuccessResult();} else {return ResultGenerator.genFailResult("修改失败");}}}

数据库

/*Navicat Premium Data TransferSource Server         : localhost_3306Source Server Type    : MySQLSource Server Version : 80012Source Host           : localhost:3306Source Schema         : 20250215_internet_cafeTarget Server Type    : MySQLTarget Server Version : 80012File Encoding         : 65001Date: 22/02/2025 18:40:53
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user`  (`admin_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',`login_user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员登陆名称',`login_password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员登陆密码',`nick_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员显示昵称',`locked` tinyint(4) NULL DEFAULT 0 COMMENT '是否锁定 0未锁定 1已锁定无法登陆',PRIMARY KEY (`admin_user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员', 0);
INSERT INTO `admin_user` VALUES (2, 'newbee-admin1', 'e10adc3949ba59abbe56e057f20f883e', '新蜂01', 0);
INSERT INTO `admin_user` VALUES (3, 'newbee-admin2', 'e10adc3949ba59abbe56e057f20f883e', '新蜂02', 0);-- ----------------------------
-- Table structure for carousel
-- ----------------------------
DROP TABLE IF EXISTS `carousel`;
CREATE TABLE `carousel`  (`carousel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '首页轮播图主键id',`carousel_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轮播图',`redirect_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '\'##\'' COMMENT '点击后的跳转地址(默认不跳转)',`carousel_rank` int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`create_user` int(11) NOT NULL DEFAULT 0 COMMENT '创建者id',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',`update_user` int(11) NOT NULL DEFAULT 0 COMMENT '修改者id',PRIMARY KEY (`carousel_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of carousel
-- ----------------------------
INSERT INTO `carousel` VALUES (13, 'http://localhost:8080/upload/20250220_23171599.jpeg', '##', 0, 0, '2024-03-30 21:31:35', 0, '2025-02-20 23:17:17', 0);
INSERT INTO `carousel` VALUES (14, 'http://localhost:8080/upload/20250220_23172887.jpeg', '##', 0, 0, '2025-01-08 22:23:19', 0, '2025-02-20 23:17:30', 0);
INSERT INTO `carousel` VALUES (15, 'http://localhost:8080/admin/dist/img/img-upload.png', '##', 0, 1, '2025-01-21 15:10:38', 0, '2025-01-21 15:10:45', 0);
INSERT INTO `carousel` VALUES (16, 'http://localhost:8080/upload/20250220_23174176.jpeg', '##', 0, 0, '2025-01-21 15:12:03', 0, '2025-02-20 23:17:43', 0);
INSERT INTO `carousel` VALUES (17, 'http://localhost:8080/upload/20250121_1512088.jpeg', '##', 0, 1, '2025-01-21 15:12:11', 0, '2025-02-20 23:16:56', 0);-- ----------------------------
-- Table structure for charge
-- ----------------------------
DROP TABLE IF EXISTS `charge`;
CREATE TABLE `charge`  (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`amount` int(11) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of charge
-- ----------------------------
INSERT INTO `charge` VALUES (2, 10);-- ----------------------------
-- Table structure for equipment
-- ----------------------------
DROP TABLE IF EXISTS `equipment`;
CREATE TABLE `equipment`  (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`equipment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备名称',`equipment_state` int(11) NULL DEFAULT 1 COMMENT '设备状态',`create_time` datetime(0) NULL DEFAULT NULL COMMENT '时间',`price` int(11) NOT NULL DEFAULT 0 COMMENT '价格',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of equipment
-- ----------------------------
INSERT INTO `equipment` VALUES (1, '包厢区', 1, '2025-02-16 14:45:05', 0);
INSERT INTO `equipment` VALUES (2, '大厅区', 1, '2025-02-16 14:46:59', 5);
INSERT INTO `equipment` VALUES (4, '电竞区', 1, '2025-02-20 17:20:30', 0);-- ----------------------------
-- Table structure for goods_category
-- ----------------------------
DROP TABLE IF EXISTS `goods_category`;
CREATE TABLE `goods_category`  (`category_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类id',`category_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '分类级别(1-一级分类 2-二级分类 3-三级分类)',`parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父分类id',`category_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',`category_rank` int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`create_user` int(11) NOT NULL DEFAULT 0 COMMENT '创建者id',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',`update_user` int(11) NULL DEFAULT 0 COMMENT '修改者id',PRIMARY KEY (`category_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 175 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of goods_category
-- ----------------------------
INSERT INTO `goods_category` VALUES (149, 1, 0, '现做奶茶', 0, 0, '2024-03-30 21:38:49', 0, '2025-02-20 22:28:04', 0);
INSERT INTO `goods_category` VALUES (150, 1, 0, '现泡茶饮', 0, 0, '2024-03-30 21:38:55', 0, '2025-02-20 22:27:34', 0);
INSERT INTO `goods_category` VALUES (151, 1, 0, '冰箱饮料', 0, 0, '2024-03-30 21:39:06', 0, '2025-02-20 22:29:26', 0);
INSERT INTO `goods_category` VALUES (152, 1, 0, '主食', 0, 0, '2024-03-30 21:39:15', 0, '2025-02-20 23:10:46', 0);
INSERT INTO `goods_category` VALUES (153, 2, 149, '分类', 0, 0, '2024-03-30 21:42:54', 0, '2025-02-20 23:37:07', 0);
INSERT INTO `goods_category` VALUES (154, 2, 149, '现做奶茶', 0, 0, '2024-03-30 21:43:26', 0, '2025-02-20 23:43:18', 0);
INSERT INTO `goods_category` VALUES (155, 3, 154, '现做奶茶', 0, 0, '2024-03-30 21:44:48', 0, '2025-02-20 23:36:57', 0);
INSERT INTO `goods_category` VALUES (156, 2, 150, '现泡茶饮', 0, 0, '2024-03-30 21:49:52', 0, '2025-02-20 22:28:58', 0);
INSERT INTO `goods_category` VALUES (157, 3, 156, '现泡茶饮', 0, 0, '2024-03-30 21:50:14', 0, '2025-02-20 22:27:09', 0);
INSERT INTO `goods_category` VALUES (158, 2, 151, '冰箱饮料', 0, 0, '2024-03-30 21:50:33', 0, '2025-02-20 22:29:40', 0);
INSERT INTO `goods_category` VALUES (159, 3, 158, '冰箱饮料', 0, 0, '2024-03-30 21:50:46', 0, '2025-02-20 22:29:51', 0);
INSERT INTO `goods_category` VALUES (160, 1, 0, '小零食', 0, 0, '2025-01-21 15:01:00', 0, '2025-02-20 22:32:16', 0);
INSERT INTO `goods_category` VALUES (161, 2, 160, '小零食', 0, 0, '2025-01-21 15:01:12', 0, '2025-02-20 23:09:52', 0);
INSERT INTO `goods_category` VALUES (162, 2, 160, '零食', 0, 0, '2025-01-21 15:01:21', 0, '2025-01-21 15:01:21', 0);
INSERT INTO `goods_category` VALUES (163, 1, 0, '香烟', 0, 0, '2025-01-21 15:01:40', 0, '2025-02-20 22:32:48', 0);
INSERT INTO `goods_category` VALUES (164, 2, 163, '香烟', 0, 0, '2025-01-21 15:01:54', 0, '2025-02-20 23:47:09', 0);
INSERT INTO `goods_category` VALUES (165, 3, 161, '小零食', 0, 0, '2025-01-21 15:02:58', 0, '2025-02-20 22:31:35', 0);
INSERT INTO `goods_category` VALUES (166, 3, 161, '泡面火腿', 0, 0, '2025-01-21 15:03:05', 0, '2025-02-20 22:32:02', 0);
INSERT INTO `goods_category` VALUES (167, 3, 162, '辣条', 0, 0, '2025-01-21 15:03:23', 0, '2025-02-20 23:10:06', 0);
INSERT INTO `goods_category` VALUES (168, 3, 162, '坚果', 0, 0, '2025-01-21 15:03:29', 0, '2025-02-20 23:10:22', 0);
INSERT INTO `goods_category` VALUES (169, 3, 164, '香烟', 0, 0, '2025-01-21 15:03:53', 0, '2025-02-20 22:32:36', 0);
INSERT INTO `goods_category` VALUES (170, 2, 163, '打火机', 0, 0, '2025-02-20 17:49:51', 0, '2025-02-20 23:47:21', 0);
INSERT INTO `goods_category` VALUES (171, 3, 170, '打火机', 0, 0, '2025-02-20 17:50:09', 0, '2025-02-20 23:47:33', 0);
INSERT INTO `goods_category` VALUES (172, 1, 0, '纸巾', 0, 0, '2025-02-20 17:51:29', 0, '2025-02-20 22:33:11', 0);
INSERT INTO `goods_category` VALUES (173, 2, 172, '纸巾', 0, 0, '2025-02-20 17:51:52', 0, '2025-02-20 23:06:32', 0);
INSERT INTO `goods_category` VALUES (174, 3, 173, '纸巾', 0, 0, '2025-02-20 17:52:03', 0, '2025-02-20 22:33:02', 0);-- ----------------------------
-- Table structure for goods_info
-- ----------------------------
DROP TABLE IF EXISTS `goods_info`;
CREATE TABLE `goods_info`  (`goods_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品表主键id',`goods_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名',`goods_intro` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品简介',`goods_category_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '关联分类id',`goods_cover_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/admin/dist/img/no-img.png' COMMENT '商品主图',`goods_carousel` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/admin/dist/img/no-img.png' COMMENT '商品轮播图',`goods_detail_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品详情',`original_price` int(11) NOT NULL DEFAULT 1 COMMENT '商品价格',`selling_price` int(11) NOT NULL DEFAULT 1 COMMENT '商品实际售价',`stock_num` int(11) NOT NULL DEFAULT 0 COMMENT '商品库存数量',`tag` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品标签',`goods_sell_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '商品上架状态 0-下架 1-上架',`create_user` int(11) NOT NULL DEFAULT 0 COMMENT '添加者主键id',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '商品添加时间',`update_user` int(11) NOT NULL DEFAULT 0 COMMENT '修改者主键id',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '商品修改时间',PRIMARY KEY (`goods_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10926 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of goods_info
-- ----------------------------
INSERT INTO `goods_info` VALUES (10904, '小零食', '小零食', 165, 'http://localhost:8080/upload/20250220_2359319.jpeg', 'http://localhost:8080/upload/20250220_2359319.jpeg', '小零食', 10, 6, 999, '小零食', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:59:32');
INSERT INTO `goods_info` VALUES (10913, '小零食', '小零食', 165, 'http://localhost:8080/upload/20250220_23585923.jpeg', 'http://localhost:8080/upload/20250220_23585923.jpeg', '小零食', 10, 6, 999, '小零食', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:59:00');
INSERT INTO `goods_info` VALUES (10914, '现做奶茶', '现做奶茶', 155, 'http://localhost:8080/upload/20250220_23582021.jpeg', 'http://localhost:8080/upload/20250220_23582021.jpeg', '现做奶茶', 20, 16, 998, '现做奶茶', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:58:22');
INSERT INTO `goods_info` VALUES (10915, '现做奶茶', '现做奶茶', 155, 'http://localhost:8080/upload/20250220_23575460.jpeg', 'http://localhost:8080/upload/20250220_23575460.jpeg', '现做奶茶', 20, 16, 999, '现做奶茶', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:57:55');
INSERT INTO `goods_info` VALUES (10916, '打火机', '打火机', 171, 'http://localhost:8080/upload/20250220_2357141.jpeg', 'http://localhost:8080/upload/20250220_2357141.jpeg', '打火机', 6, 2, 999, '打火机', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:57:15');
INSERT INTO `goods_info` VALUES (10917, '小零食', '1210万有效像素,3倍光学变焦,2.7英寸液晶屏,纤薄设计,笑脸快门*1 人脸检测', 165, 'http://localhost:8080/upload/20250220_23535535.jpeg', 'http://localhost:8080/upload/20250220_23535535.jpeg', '小零食', 10, 6, 998, '小零食', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:53:57');
INSERT INTO `goods_info` VALUES (10918, '坚果', '坚果', 168, 'http://localhost:8080/upload/20250220_23531616.jpeg', 'http://localhost:8080/upload/20250220_23531616.jpeg', '1210万有效像素,3倍光学变焦,2.7英寸液晶屏,纤薄设计,笑脸快门*1 人脸检测', 16, 10, 999, '坚果', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:53:18');
INSERT INTO `goods_info` VALUES (10919, '泡面', '泡面', 166, 'http://localhost:8080/upload/20250220_23523557.jpeg', 'http://localhost:8080/upload/20250220_23523557.jpeg', '泡面', 10, 8, 998, '泡面', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:52:36');
INSERT INTO `goods_info` VALUES (10920, '现泡茶饮', '现泡茶饮', 157, 'http://localhost:8080/upload/20250220_2351480.jpeg', 'http://localhost:8080/upload/20250220_2351480.jpeg', '现泡茶饮', 20, 12, 998, '现泡茶饮', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:51:50');
INSERT INTO `goods_info` VALUES (10921, '纸巾', '纸巾', 174, 'http://localhost:8080/upload/20250220_2351061.jpeg', 'http://localhost:8080/upload/20250220_2351061.jpeg', '纸巾', 2, 1, 999, '纸巾', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:51:07');
INSERT INTO `goods_info` VALUES (10922, '辣条', '辣条', 167, 'http://localhost:8080/upload/20250220_2350244.jpeg', 'http://localhost:8080/upload/20250220_2350244.jpeg', '<p>\n	辣条\n</p>\n<p>\n	<br />\n</p>', 8, 6, 999, '辣条', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:50:26');
INSERT INTO `goods_info` VALUES (10923, '冰箱饮料', '冰箱饮料', 159, 'http://localhost:8080/upload/20250220_23490160.jpeg', 'http://localhost:8080/upload/20250220_23490160.jpeg', '冰箱饮料', 8, 8, 999, '6', 0, 0, '2024-03-30 21:47:55', 0, '2025-02-20 23:49:03');
INSERT INTO `goods_info` VALUES (10924, '香烟', '香烟', 169, 'http://localhost:8080/upload/20250220_23481452.jpeg', 'http://localhost:8080/upload/20250220_23481452.jpeg', '香烟', 100, 30, 999, '香烟', 0, 0, '2025-01-21 15:06:05', 0, '2025-02-21 00:00:03');
INSERT INTO `goods_info` VALUES (10925, '现做奶茶', '现做奶茶', 155, 'http://localhost:8080/upload/20250220_23380197.jpeg', 'http://localhost:8080/upload/20250220_23380197.jpeg', '现做奶茶<br />', 20, 16, 996, '现做奶茶', 0, 0, '2025-01-21 15:13:00', 0, '2025-02-20 23:59:51');-- ----------------------------
-- Table structure for index_config
-- ----------------------------
DROP TABLE IF EXISTS `index_config`;
CREATE TABLE `index_config`  (`config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '首页配置项主键id',`config_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '显示字符(配置搜索时不可为空,其他可为空)',`config_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1-搜索框热搜 2-搜索下拉框热搜 3-(首页)热销商品 4-(首页)新品上线 5-(首页)为你推荐',`goods_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '商品id 默认为0',`redirect_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '##' COMMENT '点击后的跳转地址(默认不跳转)',`config_rank` int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`create_user` int(11) NOT NULL DEFAULT 0 COMMENT '创建者id',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',`update_user` int(11) NULL DEFAULT 0 COMMENT '修改者id',PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of index_config
-- ----------------------------
INSERT INTO `index_config` VALUES (29, '10897', 3, 0, '##', 0, 1, '2024-02-06 11:07:45', 0, '2024-02-06 11:08:42', 0);
INSERT INTO `index_config` VALUES (30, '10897', 3, 0, '##', 2, 1, '2024-02-06 11:08:10', 0, '2024-02-06 11:08:42', 0);
INSERT INTO `index_config` VALUES (31, '10897', 3, 0, '##', 3, 1, '2024-02-06 11:08:14', 0, '2024-02-06 11:08:42', 0);
INSERT INTO `index_config` VALUES (32, '10897', 3, 0, '##', 1, 1, '2024-02-06 11:08:20', 0, '2024-02-06 11:08:42', 0);
INSERT INTO `index_config` VALUES (33, '西班牙原装进口爱旺斯', 3, 10897, '##', 0, 1, '2024-02-06 11:09:22', 0, '2024-03-30 21:32:04', 0);
INSERT INTO `index_config` VALUES (34, '比瑞吉', 3, 10898, '##', 1, 1, '2024-02-06 11:18:22', 0, '2024-03-30 21:32:04', 0);
INSERT INTO `index_config` VALUES (35, '狗粮', 3, 10903, '##', 2, 1, '2024-02-06 13:41:52', 0, '2024-03-30 21:32:04', 0);
INSERT INTO `index_config` VALUES (36, '卡比CANIDAE', 3, 10902, '##', 3, 1, '2024-02-06 13:42:22', 0, '2024-03-30 21:32:04', 0);
INSERT INTO `index_config` VALUES (37, '卡比CANIDAE', 4, 10902, '##', 0, 1, '2024-02-06 14:22:18', 0, '2024-03-30 21:32:09', 0);
INSERT INTO `index_config` VALUES (38, '卡比CANIDAE', 5, 10902, '##', 0, 1, '2024-02-06 14:23:03', 0, '2024-02-06 14:23:25', 0);
INSERT INTO `index_config` VALUES (39, '卡比CANIDAE', 5, 10902, '##', 0, 1, '2024-02-06 14:23:55', 0, '2024-03-30 21:32:14', 0);
INSERT INTO `index_config` VALUES (40, '牛肉配方成犬粮', 4, 10903, '##', 1, 1, '2024-02-06 14:27:25', 0, '2024-03-30 21:32:09', 0);
INSERT INTO `index_config` VALUES (41, '三文鱼配方', 4, 10897, '##', 2, 1, '2024-02-18 14:45:48', 0, '2024-03-30 21:32:09', 0);
INSERT INTO `index_config` VALUES (42, '进口狗粮', 4, 10901, '##', 3, 1, '2024-02-18 14:46:50', 0, '2024-03-30 21:32:09', 0);
INSERT INTO `index_config` VALUES (43, '玩具', 5, 10899, '##', 1, 1, '2024-02-18 14:47:40', 0, '2024-03-30 21:32:14', 0);
INSERT INTO `index_config` VALUES (44, '大块头', 5, 10900, '##', 2, 1, '2024-02-18 14:49:39', 0, '2024-03-30 21:32:14', 0);
INSERT INTO `index_config` VALUES (45, '狗粮', 5, 10903, '##', 3, 1, '2024-02-18 14:51:18', 0, '2024-03-30 21:32:14', 0);
INSERT INTO `index_config` VALUES (46, '热销商品', 3, 10904, '##', 0, 0, '2024-03-30 21:48:52', 0, '2024-03-30 21:48:52', 0);
INSERT INTO `index_config` VALUES (47, '新品上线', 4, 10904, '##', 0, 0, '2024-03-30 21:49:04', 0, '2024-03-30 21:49:04', 0);
INSERT INTO `index_config` VALUES (48, '推荐商品', 5, 10904, '##', 0, 0, '2024-03-30 21:49:18', 0, '2024-03-30 21:49:18', 0);-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (`id` int(11) NOT NULL AUTO_INCREMENT,`note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (4, '本网咖24小时营业中.');-- ----------------------------
-- Table structure for order_item
-- ----------------------------
DROP TABLE IF EXISTS `order_item`;
CREATE TABLE `order_item`  (`order_item_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单关联购物项主键id',`order_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '订单主键id',`goods_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '关联商品id',`goods_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '下单时商品的名称(订单快照)',`goods_cover_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '下单时商品的主图(订单快照)',`selling_price` int(11) NOT NULL DEFAULT 1 COMMENT '下单时商品的价格(订单快照)',`goods_count` int(11) NOT NULL DEFAULT 1 COMMENT '数量(订单快照)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',PRIMARY KEY (`order_item_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 65 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of order_item
-- ----------------------------
INSERT INTO `order_item` VALUES (49, 27, 10904, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 1, '2025-01-11 14:07:46');
INSERT INTO `order_item` VALUES (50, 28, 10904, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 1, '2025-01-11 15:54:22');
INSERT INTO `order_item` VALUES (51, 29, 10923, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 3, '2025-01-18 15:40:31');
INSERT INTO `order_item` VALUES (52, 29, 10913, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 1, '2025-01-18 15:40:31');
INSERT INTO `order_item` VALUES (53, 30, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 3, '2025-01-19 20:14:22');
INSERT INTO `order_item` VALUES (54, 31, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 4, '2025-01-19 20:33:15');
INSERT INTO `order_item` VALUES (55, 32, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 2, '2025-01-20 18:02:53');
INSERT INTO `order_item` VALUES (56, 33, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 2, '2025-01-20 18:04:52');
INSERT INTO `order_item` VALUES (57, 34, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 3, '2025-01-20 19:10:31');
INSERT INTO `order_item` VALUES (58, 34, 10919, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 2, '2025-01-20 19:10:31');
INSERT INTO `order_item` VALUES (59, 35, 10919, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 1, '2025-01-20 20:07:16');
INSERT INTO `order_item` VALUES (60, 36, 10924, '黄金级别鱼食', 'http://localhost:8080/upload/20250121_15060360.jpeg', 100, 2, '2025-01-21 15:06:41');
INSERT INTO `order_item` VALUES (61, 37, 10925, '狗狗牌狗粮', 'http://localhost:8080/upload/20250121_15125872.jpg', 1000, 3, '2025-01-21 15:15:24');
INSERT INTO `order_item` VALUES (62, 38, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 2, '2025-02-20 17:15:26');
INSERT INTO `order_item` VALUES (63, 39, 10919, '索尼DSC-W190', 'http://localhost:8080/upload/20250108_22354486.jpg', 19999, 3, '2025-02-20 17:22:40');
INSERT INTO `order_item` VALUES (64, 40, 10922, '索尼DSC-W190', 'http://localhost:8080/upload/20250111_09335030.jpeg', 19999, 1, '2025-02-20 23:45:34');
INSERT INTO `order_item` VALUES (65, 41, 10925, '现做奶茶', 'http://localhost:8080/upload/20250220_23380197.jpeg', 16, 3, '2025-02-21 21:51:30');
INSERT INTO `order_item` VALUES (66, 41, 10914, '现做奶茶', 'http://localhost:8080/upload/20250220_23582021.jpeg', 16, 1, '2025-02-21 21:51:30');
INSERT INTO `order_item` VALUES (67, 41, 10917, '小零食', 'http://localhost:8080/upload/20250220_23535535.jpeg', 6, 1, '2025-02-21 21:51:30');
INSERT INTO `order_item` VALUES (68, 41, 10919, '泡面', 'http://localhost:8080/upload/20250220_23523557.jpeg', 8, 1, '2025-02-21 21:51:30');
INSERT INTO `order_item` VALUES (69, 42, 10920, '现泡茶饮', 'http://localhost:8080/upload/20250220_2351480.jpeg', 12, 1, '2025-02-21 21:52:01');-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (`order_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单表主键id',`order_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单号',`user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户主键id',`total_price` int(11) NOT NULL DEFAULT 1 COMMENT '订单总价',`pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付状态:0.未支付,1.支付成功,-1:支付失败',`pay_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0.无 1.支付宝支付 2.微信支付',`pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付时间',`order_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '订单状态:0.待支付 1.已支付 2.配货完成 3:出库成功 4.交易成功 -1.手动关闭 -2.超时关闭 -3.商家关闭',`extra_info` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单body',`user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人姓名',`user_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人手机号',`user_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人收货地址',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (22, '17071982018202735', 1, 759, 1, 1, '2024-02-06 13:43:32', 4, '', '', '', '杭州市西湖区xx小区x幢419 十三 137xxxx2703', 0, '2024-02-06 13:43:21', '2024-02-06 13:43:57');
INSERT INTO `orders` VALUES (23, '17082402323421051', 1, 1817, 0, 0, NULL, 0, '', '', '', '杭州市西湖区xx小区x幢419 十三 137xxxx2703', 0, '2024-02-18 15:10:32', '2024-02-18 15:10:32');
INSERT INTO `orders` VALUES (24, '17082406617938081', 1, 1817, 0, 0, NULL, 0, '', '', '', '杭州市西湖区xx小区x幢419 十三 137xxxx2703', 0, '2024-02-18 15:17:41', '2024-02-18 15:17:41');
INSERT INTO `orders` VALUES (25, '17082406938293119', 1, 499, 0, 0, NULL, -3, '', '', '', '杭州市西湖区xx小区x幢419 十三 137xxxx2703', 0, '2024-02-18 15:18:13', '2025-01-20 18:56:48');
INSERT INTO `orders` VALUES (26, '17082409296081166', 1, 2058, 1, 2, '2024-02-18 15:22:17', 3, '', '', '', '杭州市西湖区xx小区x幢419 十三 137xxxx2703', 0, '2024-02-18 15:22:09', '2024-02-18 15:23:10');
INSERT INTO `orders` VALUES (27, '17365756667682310', 8, 19999, 0, 0, NULL, 0, '', '', '', '万达影城(维港城店)', 0, '2025-01-11 14:07:46', '2025-01-11 14:07:46');
INSERT INTO `orders` VALUES (28, '17365820626711195', 8, 19999, 0, 0, NULL, 0, '', '', '', '万达影城(维港城店)', 0, '2025-01-11 15:54:22', '2025-01-11 15:54:22');
INSERT INTO `orders` VALUES (29, '17371860313377093', 8, 79996, 0, 0, NULL, 0, '', '', '', '万达影城(维港城店)', 0, '2025-01-18 15:40:31', '2025-01-18 15:40:31');
INSERT INTO `orders` VALUES (30, '17372888635276617', 12, 59997, 1, 1, '2025-01-20 18:55:30', 1, '', '', '', '和实施', 0, '2025-01-19 20:14:22', '2025-01-20 18:55:30');
INSERT INTO `orders` VALUES (31, '17372899967935488', 12, 79996, 1, 2, '2025-01-19 20:33:17', 4, '', '', '', '和实施', 0, '2025-01-19 20:33:15', '2025-01-20 19:01:43');
INSERT INTO `orders` VALUES (32, '17373673745044862', 12, 39998, 1, 1, '2025-01-20 18:54:01', 4, '', '', '', '和实施', 0, '2025-01-20 18:02:53', '2025-01-20 19:01:34');
INSERT INTO `orders` VALUES (33, '17373674928216522', 12, 39998, 1, 2, '2025-01-20 18:04:59', 1, '', '', '', '和实施', 0, '2025-01-20 18:04:52', '2025-01-20 18:04:59');
INSERT INTO `orders` VALUES (34, '17373714320167247', 12, 99995, 1, 1, '2025-01-20 19:10:34', 4, '', '', '', '和实施', 0, '2025-01-20 19:10:31', '2025-01-20 19:24:09');
INSERT INTO `orders` VALUES (35, '17373748373858885', 12, 19999, 0, 0, NULL, 0, '', '', '', '和实施', 0, '2025-01-20 20:07:16', '2025-01-20 20:07:16');
INSERT INTO `orders` VALUES (36, '17374432007001527', 12, 200, 1, 1, '2025-01-21 15:06:43', 4, '', '', '', '萨达大大大', 0, '2025-01-21 15:06:41', '2025-01-21 15:07:19');
INSERT INTO `orders` VALUES (37, '17374437233284916', 12, 3000, 1, 2, '2025-01-21 15:15:26', 4, '', '', '', '湖南省', 0, '2025-01-21 15:15:24', '2025-01-21 15:15:57');
INSERT INTO `orders` VALUES (38, '17400429279542583', 12, 39998, 1, 2, '2025-02-20 17:15:30', 1, '', '', '', '222', 0, '2025-02-20 17:15:26', '2025-02-20 17:15:30');
INSERT INTO `orders` VALUES (39, '17400433626096911', 12, 59997, 1, 1, '2025-02-20 17:22:45', 1, '', '', '', 'A区2号包厢33号高级电脑', 0, '2025-02-20 17:22:40', '2025-02-20 17:22:45');
INSERT INTO `orders` VALUES (40, '17400663348674622', 8, 19999, 1, 2, '2025-02-20 23:45:38', 1, '', '', '', '万达影城(维港城店)', 0, '2025-02-20 23:45:34', '2025-02-20 23:45:38');
INSERT INTO `orders` VALUES (41, '17401458902216954', 8, 78, 1, 2, '2025-02-21 21:51:36', 1, '', '', '', '万达影城(维港城店)', 0, '2025-02-21 21:51:30', '2025-02-21 21:51:36');
INSERT INTO `orders` VALUES (42, '17401459215653182', 8, 12, 1, 2, '2025-02-21 21:52:05', 1, '', '', '', '万达影城(维港城店)', 0, '2025-02-21 21:52:01', '2025-02-21 21:52:05');-- ----------------------------
-- Table structure for seat
-- ----------------------------
DROP TABLE IF EXISTS `seat`;
CREATE TABLE `seat`  (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`equipment_id` int(11) NULL DEFAULT NULL COMMENT '设备ID',`user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID',`start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',`is_history` int(11) NOT NULL DEFAULT 0 COMMENT '是否历史',`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',`amount` int(11) NULL DEFAULT 0 COMMENT '费用',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of seat
-- ----------------------------
INSERT INTO `seat` VALUES (2, 1, 12, '2025-02-19 22:48:08', '2025-02-20 22:48:00', 1, '2025-02-19 22:48:19', 23);
INSERT INTO `seat` VALUES (3, 1, 12, '2025-02-20 15:26:41', '2025-02-20 21:26:00', 1, '2025-02-20 15:26:55', 75);
INSERT INTO `seat` VALUES (4, 2, 12, '2025-02-20 16:34:00', '2025-02-21 23:34:00', 1, '2025-02-20 15:34:46', 465);
INSERT INTO `seat` VALUES (5, 4, 12, '2025-02-20 17:23:52', '2025-02-20 21:23:00', 0, '2025-02-20 17:24:01', 30);
INSERT INTO `seat` VALUES (6, 1, 8, '2025-02-20 20:25:50', '2025-06-20 20:25:00', 0, '2025-02-20 20:26:07', 28790);-- ----------------------------
-- Table structure for shopping_cart_item
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart_item`;
CREATE TABLE `shopping_cart_item`  (`cart_item_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '购物项主键id',`user_id` bigint(20) NOT NULL COMMENT '用户主键id',`goods_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '关联商品id',`goods_count` int(11) NOT NULL DEFAULT 1 COMMENT '数量(最大为5)',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',PRIMARY KEY (`cart_item_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 102 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of shopping_cart_item
-- ----------------------------
INSERT INTO `shopping_cart_item` VALUES (71, 1, 10897, 1, 1, '2024-02-06 11:11:28', '2024-02-06 11:11:28');
INSERT INTO `shopping_cart_item` VALUES (72, 1, 10897, 1, 1, '2024-02-06 11:11:38', '2024-02-06 11:11:38');
INSERT INTO `shopping_cart_item` VALUES (73, 1, 10903, 1, 1, '2024-02-06 13:43:08', '2024-02-06 13:43:10');
INSERT INTO `shopping_cart_item` VALUES (74, 1, 10900, 1, 1, '2024-02-18 15:00:48', '2024-02-18 15:00:48');
INSERT INTO `shopping_cart_item` VALUES (75, 1, 10903, 1, 1, '2024-02-18 15:10:07', '2024-02-18 15:10:07');
INSERT INTO `shopping_cart_item` VALUES (76, 1, 10901, 1, 1, '2024-02-18 15:10:23', '2024-02-18 15:10:23');
INSERT INTO `shopping_cart_item` VALUES (77, 1, 10903, 1, 1, '2024-02-18 15:17:21', '2024-02-18 15:17:21');
INSERT INTO `shopping_cart_item` VALUES (78, 1, 10901, 1, 1, '2024-02-18 15:17:28', '2024-02-18 15:17:28');
INSERT INTO `shopping_cart_item` VALUES (79, 1, 10900, 1, 1, '2024-02-18 15:17:34', '2024-02-18 15:17:34');
INSERT INTO `shopping_cart_item` VALUES (80, 1, 10903, 1, 1, '2024-02-18 15:18:10', '2024-02-18 15:18:10');
INSERT INTO `shopping_cart_item` VALUES (81, 1, 10897, 1, 1, '2024-02-18 15:21:14', '2024-02-18 15:21:14');
INSERT INTO `shopping_cart_item` VALUES (82, 1, 10903, 1, 1, '2024-02-18 15:21:20', '2024-02-18 15:21:20');
INSERT INTO `shopping_cart_item` VALUES (83, 1, 10901, 1, 1, '2024-02-18 15:21:28', '2024-02-18 15:21:28');
INSERT INTO `shopping_cart_item` VALUES (84, 8, 10904, 1, 1, '2024-04-07 13:30:33', '2025-01-08 22:38:39');
INSERT INTO `shopping_cart_item` VALUES (85, 12, 10922, 3, 1, '2025-01-11 13:04:15', '2025-01-18 12:35:10');
INSERT INTO `shopping_cart_item` VALUES (86, 8, 10904, 1, 1, '2025-01-11 13:24:31', '2025-01-11 13:27:46');
INSERT INTO `shopping_cart_item` VALUES (87, 8, 10904, 1, 1, '2025-01-11 15:54:03', '2025-01-11 15:54:03');
INSERT INTO `shopping_cart_item` VALUES (88, 8, 10923, 3, 1, '2025-01-11 16:01:00', '2025-01-11 16:05:47');
INSERT INTO `shopping_cart_item` VALUES (89, 8, 10913, 1, 1, '2025-01-11 16:01:35', '2025-01-11 16:01:35');
INSERT INTO `shopping_cart_item` VALUES (90, 12, 10922, 4, 1, '2025-01-19 20:32:57', '2025-01-19 20:32:57');
INSERT INTO `shopping_cart_item` VALUES (91, 12, 10922, 2, 1, '2025-01-20 18:02:43', '2025-01-20 18:02:43');
INSERT INTO `shopping_cart_item` VALUES (92, 12, 10922, 2, 1, '2025-01-20 18:04:09', '2025-01-20 18:04:09');
INSERT INTO `shopping_cart_item` VALUES (93, 12, 10922, 3, 1, '2025-01-20 19:07:36', '2025-01-20 19:08:36');
INSERT INTO `shopping_cart_item` VALUES (94, 12, 10919, 2, 1, '2025-01-20 19:10:12', '2025-01-20 19:10:24');
INSERT INTO `shopping_cart_item` VALUES (95, 12, 10919, 1, 1, '2025-01-20 20:07:14', '2025-01-20 20:07:14');
INSERT INTO `shopping_cart_item` VALUES (96, 12, 10924, 2, 1, '2025-01-21 15:06:31', '2025-01-21 15:06:31');
INSERT INTO `shopping_cart_item` VALUES (97, 12, 10925, 3, 1, '2025-01-21 15:15:13', '2025-01-21 15:15:13');
INSERT INTO `shopping_cart_item` VALUES (98, 12, 10922, 2, 1, '2025-02-20 17:15:22', '2025-02-20 17:15:22');
INSERT INTO `shopping_cart_item` VALUES (99, 12, 10919, 3, 1, '2025-02-20 17:22:06', '2025-02-20 17:22:06');
INSERT INTO `shopping_cart_item` VALUES (100, 8, 10922, 1, 1, '2025-02-20 20:27:59', '2025-02-20 20:27:59');
INSERT INTO `shopping_cart_item` VALUES (101, 8, 10925, 3, 1, '2025-02-21 20:03:56', '2025-02-21 20:04:16');
INSERT INTO `shopping_cart_item` VALUES (102, 8, 10914, 1, 1, '2025-02-21 21:47:12', '2025-02-21 21:47:12');
INSERT INTO `shopping_cart_item` VALUES (103, 8, 10917, 1, 1, '2025-02-21 21:47:25', '2025-02-21 21:47:25');
INSERT INTO `shopping_cart_item` VALUES (104, 8, 10919, 1, 1, '2025-02-21 21:47:36', '2025-02-21 21:47:36');
INSERT INTO `shopping_cart_item` VALUES (105, 8, 10920, 1, 1, '2025-02-21 21:51:55', '2025-02-21 21:51:55');-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (`user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户主键id',`nick_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',`login_name` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '登陆名称(默认为手机号)',`password_md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'MD5加密后的密码',`introduce_sign` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '个性签名',`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货地址',`is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '注销标识字段(0-正常 1-已注销)',`locked_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '锁定标识字段(0-未锁定 1-已锁定)',`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '注册时间',PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (8, '15555653836', '15555653836', 'e10adc3949ba59abbe56e057f20f883e', '', '万达影城(维港城店)', 0, 0, '2024-04-07 13:30:03');
INSERT INTO `user` VALUES (12, '1', '1', 'c4ca4238a0b923820dcc509a6f75849b', '', 'A区2号包厢33号高级电脑', 0, 0, '2025-01-08 21:35:17');
INSERT INTO `user` VALUES (13, '12111', '13211111111', 'e10adc3949ba59abbe56e057f20f883e', '', '', 0, 0, '2025-02-20 17:48:30');SET FOREIGN_KEY_CHECKS = 1;

源码获取

如需交流/获取资料,请先【关注+私信】我,私信获取源码~

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。
如若转载,请注明出处:http://www.pswp.cn/diannao/93013.shtml
繁体地址,请注明出处:http://hk.pswp.cn/diannao/93013.shtml

如若内容造成侵权/违法违规/事实不符,请联系多彩编程网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

C语言————练习题册(答案版)

目录 每日更新5-10题&#xff0c;感兴趣可以订阅 一.理解函数、操作符、占位符 1.1 欢迎来到C语言的世界 1.2 输入和输出 1.3 浮点数的打印 1.4 字符串的打印 1.14 I am iron man 1.5 求和运算 1.6 计算比例 1.7 求商求余 1.8 不同数位上的数字 1.8.1 求个位数 1.8…

haproxy配置详解

1、haproxy简介 HAProxy是法国开发者 威利塔罗(Willy Tarreau) 在2000年使用C语言开发的一个开源软件 是一款具备高并发(万级以上)、高性能的TCP和HTTP负载均衡器 支持基于cookie的持久性&#xff0c;自动故障切换&#xff0c;支持正则表达式及web状态统计 企业版网站&#xff…

计网-TCP可靠传输

TCP&#xff08;传输控制协议&#xff09;的可靠传输是通过一系列机制保证数据准确、有序、不丢失地到达接收方。以下是TCP可靠传输的详细过程及核心机制&#xff1a;1. 数据分块与序列号&#xff08;Seq&#xff09;分块&#xff1a;应用层数据被分割成适合传输的TCP报文段&am…

数智管理学(三十九)

第三章 数智化对管理理论的冲击第三节 系统理论与生态化管理的强化系统理论作为理解企业运作与环境互动的重要框架&#xff0c;一直强调企业是一个由多个相互关联子系统构成的整体&#xff0c;其核心要素包括整体性、开放性、动态性和反馈机制。在传统管理视角下&#xff0c;这…

哈希表(c语言)

文章目录哈希表哈希表知识点哈希表概念负载因子哈希表的优缺点哈希冲突哈希函数常见哈希函数处理哈希冲突开放定址法线性探测二次探测链地址法哈希表的实现哈希表的核心:HashMap核心函数&#xff1a;从创建到销毁创建哈希表&#xff1a;hashmap_create()销毁哈希表:hashmap_des…

【Canvas与旗帜】条纹版大明三辰旗

【成图】【代码】<!DOCTYPE html> <html lang"utf-8"> <meta http-equiv"Content-Type" content"text/html; charsetutf-8"/> <head><title>十三条纹版大明三辰旗 Draft1</title><style type"text/…

【Java】空指针(NullPointerException)异常深度攻坚:从底层原理到架构级防御,老司机的实战经验

写Java代码这些年&#xff0c;空指针异常&#xff08;NullPointerException&#xff09;就像甩不掉的影子。线上排查问题时&#xff0c;十次有八次最后定位到的都是某个对象没处理好null值。但多数人解决问题只停留在加个if (obj ! null)的层面&#xff0c;没从根本上想过为什么…

【NLP舆情分析】基于python微博舆情分析可视化系统(flask+pandas+echarts) 视频教程 - 主页-评论用户时间占比环形饼状图实现

大家好&#xff0c;我是java1234_小锋老师&#xff0c;最近写了一套【NLP舆情分析】基于python微博舆情分析可视化系统(flaskpandasecharts)视频教程&#xff0c;持续更新中&#xff0c;计划月底更新完&#xff0c;感谢支持。今天讲解主页-评论用户时间占比环形饼状图实现 视频…

Redis面试精讲 Day 5:Redis内存管理与过期策略

【Redis面试精讲 Day 5】Redis内存管理与过期策略 开篇 欢迎来到"Redis面试精讲"系列的第5天&#xff01;今天我们将深入探讨Redis内存管理与过期策略&#xff0c;这是面试中经常被问及的核心知识点。对于后端工程师而言&#xff0c;理解Redis如何高效管理内存、处…

ICMPv6报文类型详解表

一、错误报文类型&#xff08;Type 1-127&#xff09;Type值名称Code范围触发条件示例典型用途1Destination Unreachable0-60: 无路由到目标1: 通信被管理员禁止2: 地址不可达3: 端口不可达4: 分片需要但DF标志设置5: 源路由失败6: 目的地址不可达网络故障诊断2Packet Too Big0…

配置nodejs

第一步确认 node.exe 和 npm 存在 例如安装目录D:\nodejs检查是否存在以下文件&#xff1a; node.exenpm.cmdnpx.cmd 第二步&#xff1a;添加环境变量 PATH 图形化操作步骤&#xff08;Windows&#xff09;&#xff1a; 右键「此电脑」→「属性」点击左侧 「高级系统设置」弹出…

MySQL的命令行客户端

MySQL中的一些程序&#xff1a;MySQL在安装完成的时候&#xff0c;一般都会包含如下程序&#xff1a;在Linux系统下&#xff0c;通过/usr/bin目录下&#xff0c;可以通过命令查看&#xff1a;以下是常用的MySQL程序&#xff1a;程序名作用mysqldMySQL的守护进程即MySQL服务器&a…

C# 值类型与引用类型的储存方式_堆栈_

目录 值类型 引用类型 修改stu3的值 stu也被修改了 为什么? &#xff08;对象之间&#xff09; 值类型中&#xff0c;值全在栈中单独存储&#xff0c;变量之间不会影响 结构体中&#xff0c;结构体全在栈中&#xff0c;结构体与结构体之间也不会相互影响 静态资源区 值类…

解锁永久会员的白噪音软件:睡眠助手

如今的年轻人压力普遍较大&#xff0c;学会解压至关重要。这期就为大家推荐一款优秀的白噪音软件&#xff0c;在压力大时听听&#xff0c;能起到不错的解压效果。 睡眠助手 文末获取 这款软件的特别版本十分出色&#xff0c;知晓的人不多。它已解锁永久会员&#xff0c;无需登…

uniapp使用css实现进度条带动画过渡效果

一、效果 二、实现原理 1.uni.createAnimation 动画函数 2.初始化uni.createAnimation方法 3.监听值的变化调用动画执行方法 三、代码 1.实现方式比较简单&#xff0c;目前是vue3的写法&#xff0c;vue2只需要稍微改动即可 <template><view class"layout_progre…

高级分布式系统调试:调试的科学与 USE 方法实战

高级分布式系统调试:调试的科学与 USE 方法实战 前言:从“救火”到“探案” 当一个复杂的分布式系统出现“灰色故障”——例如“服务有时会变慢”、“偶尔出现超时错误”——我们该从何处着手?随机地查看 Grafana 仪表盘,或者漫无目的地 tail -f 日志,往往效率低下,甚至…

栈算法之【有效括号】

目录 LeetCode-20题 LeetCode-20题 给定一个只包括 (&#xff0c;)&#xff0c;{&#xff0c;}&#xff0c;[&#xff0c;] 的字符串 s &#xff0c;判断字符串是否有效。 有效字符串需满足&#xff1a; 左括号必须用相同类型的右括号闭合。 左括号必须以正确的顺序闭合。 每…

大模型——Data Agent:超越 BI 与 AI 的边界

Data Agent:超越 BI 与 AI 的边界 1. 数据工具的演进路径 在数据分析领域,技术工具经历了多个阶段的演进。这些演进不仅反映了技术的进步,也体现了用户需求和使用场景的变化。 Excel 时代:告别手工作业,陷入“表格泥潭“,早期数据分析依赖 Excel,实现基础数据记录、计…

数据空间技术在智慧水库管理平台中的赋能

数据空间技术在智慧水库管理平台中的赋能&#xff1a;设备到应用的数据传输优化 数据空间技术为智慧水库管理平台提供了革命性的数据传输、处理和安全保障能力。以下是数据空间技术在设备到应用数据传输过程中的全面赋能方案&#xff1a; 数据空间赋能架构设计 #mermaid-svg-R2…

SpringBoot学习路径二--Spring Boot自动配置原理深度解析

SpringBoot最核心的功能就是自动装配&#xff0c;Starter作为SpringBoot的核心功能之一&#xff0c;基于自动配置代码提供了自动配置模块及依赖的能力&#xff0c;让软件集成变得简单、易用。使用SpringBoot时&#xff0c;我们只需引I人对应的Starter&#xff0c;SpringBoot启动…