幸福網咖訂座點餐小程序的設計與實現

文章目錄

    • 前言
    • 詳細視頻演示
    • 具體實現截圖
      • 后端框架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
英文地址，請注明出處：http://en.pswp.cn/diannao/93013.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

C語言————練習題冊（答案版）

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配置詳解

haproxy配置詳解

1、haproxy簡介 HAProxy是法國開發者 威利塔羅(Willy Tarreau) 在2000年使用C語言開發的一個開源軟件 是一款具備高并發(萬級以上)、高性能的TCP和HTTP負載均衡器 支持基于cookie的持久性&#xff0c;自動故障切換&#xff0c;支持正則表達式及web狀態統計 企業版網站&#xff…
閱讀更多...
計網-TCP可靠傳輸

計網-TCP可靠傳輸

TCP&#xff08;傳輸控制協議&#xff09;的可靠傳輸是通過一系列機制保證數據準確、有序、不丟失地到達接收方。以下是TCP可靠傳輸的詳細過程及核心機制&#xff1a;1. 數據分塊與序列號&#xff08;Seq&#xff09;分塊&#xff1a;應用層數據被分割成適合傳輸的TCP報文段&am…
閱讀更多...
數智管理學（三十九）

數智管理學（三十九）

第三章 數智化對管理理論的沖擊第三節 系統理論與生態化管理的強化系統理論作為理解企業運作與環境互動的重要框架&#xff0c;一直強調企業是一個由多個相互關聯子系統構成的整體&#xff0c;其核心要素包括整體性、開放性、動態性和反饋機制。在傳統管理視角下&#xff0c;這…
閱讀更多...
哈希表(c語言)

哈希表(c語言)

文章目錄哈希表哈希表知識點哈希表概念負載因子哈希表的優缺點哈希沖突哈希函數常見哈希函數處理哈希沖突開放定址法線性探測二次探測鏈地址法哈希表的實現哈希表的核心:HashMap核心函數&#xff1a;從創建到銷毀創建哈希表&#xff1a;hashmap_create()銷毀哈希表:hashmap_des…
閱讀更多...
【Canvas與旗幟】條紋版大明三辰旗

【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】空指針(NullPointerException)異常深度攻堅：從底層原理到架構級防御，老司機的實戰經驗

寫Java代碼這些年&#xff0c;空指針異常&#xff08;NullPointerException&#xff09;就像甩不掉的影子。線上排查問題時&#xff0c;十次有八次最后定位到的都是某個對象沒處理好null值。但多數人解決問題只停留在加個if (obj ! null)的層面&#xff0c;沒從根本上想過為什么…
閱讀更多...
【NLP輿情分析】基于python微博輿情分析可視化系統(flask+pandas+echarts) 視頻教程 - 主頁-評論用戶時間占比環形餅狀圖實現

【NLP輿情分析】基于python微博輿情分析可視化系統(flask+pandas+echarts) 視頻教程 - 主頁-評論用戶時間占比環形餅狀圖實現

大家好&#xff0c;我是java1234_小鋒老師&#xff0c;最近寫了一套【NLP輿情分析】基于python微博輿情分析可視化系統(flaskpandasecharts)視頻教程&#xff0c;持續更新中&#xff0c;計劃月底更新完&#xff0c;感謝支持。今天講解主頁-評論用戶時間占比環形餅狀圖實現 視頻…
閱讀更多...
Redis面試精講 Day 5：Redis內存管理與過期策略

Redis面試精講 Day 5：Redis內存管理與過期策略

【Redis面試精講 Day 5】Redis內存管理與過期策略 開篇 歡迎來到"Redis面試精講"系列的第5天&#xff01;今天我們將深入探討Redis內存管理與過期策略&#xff0c;這是面試中經常被問及的核心知識點。對于后端工程師而言&#xff0c;理解Redis如何高效管理內存、處…
閱讀更多...
ICMPv6報文類型詳解表

ICMPv6報文類型詳解表

一、錯誤報文類型&#xff08;Type 1-127&#xff09;Type值名稱Code范圍觸發條件示例典型用途1Destination Unreachable0-60: 無路由到目標1: 通信被管理員禁止2: 地址不可達3: 端口不可達4: 分片需要但DF標志設置5: 源路由失敗6: 目的地址不可達網絡故障診斷2Packet Too Big0…
閱讀更多...
配置nodejs

配置nodejs

第一步確認 node.exe 和 npm 存在 例如安裝目錄D:\nodejs檢查是否存在以下文件&#xff1a; node.exenpm.cmdnpx.cmd 第二步&#xff1a;添加環境變量 PATH 圖形化操作步驟&#xff08;Windows&#xff09;&#xff1a; 右鍵「此電腦」→「屬性」點擊左側 「高級系統設置」彈出…
閱讀更多...
MySQL的命令行客戶端

MySQL的命令行客戶端

MySQL中的一些程序&#xff1a;MySQL在安裝完成的時候&#xff0c;一般都會包含如下程序&#xff1a;在Linux系統下&#xff0c;通過/usr/bin目錄下&#xff0c;可以通過命令查看&#xff1a;以下是常用的MySQL程序&#xff1a;程序名作用mysqldMySQL的守護進程即MySQL服務器&a…
閱讀更多...
C# 值類型與引用類型的儲存方式_堆棧_

C# 值類型與引用類型的儲存方式_堆棧_

目錄 值類型 引用類型 修改stu3的值 stu也被修改了 為什么? &#xff08;對象之間&#xff09; 值類型中&#xff0c;值全在棧中單獨存儲&#xff0c;變量之間不會影響 結構體中&#xff0c;結構體全在棧中&#xff0c;結構體與結構體之間也不會相互影響 靜態資源區 值類…
閱讀更多...
解鎖永久會員的白噪音軟件：睡眠助手

解鎖永久會員的白噪音軟件：睡眠助手

如今的年輕人壓力普遍較大&#xff0c;學會解壓至關重要。這期就為大家推薦一款優秀的白噪音軟件&#xff0c;在壓力大時聽聽&#xff0c;能起到不錯的解壓效果。 睡眠助手 文末獲取 這款軟件的特別版本十分出色&#xff0c;知曉的人不多。它已解鎖永久會員&#xff0c;無需登…
閱讀更多...
uniapp使用css實現進度條帶動畫過渡效果

uniapp使用css實現進度條帶動畫過渡效果

一、效果 二、實現原理 1.uni.createAnimation 動畫函數 2.初始化uni.createAnimation方法 3.監聽值的變化調用動畫執行方法 三、代碼 1.實現方式比較簡單&#xff0c;目前是vue3的寫法&#xff0c;vue2只需要稍微改動即可 <template><view class"layout_progre…
閱讀更多...
高級分布式系統調試：調試的科學與 USE 方法實戰

高級分布式系統調試：調試的科學與 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 的邊界

Data Agent：超越 BI 與 AI 的邊界 1. 數據工具的演進路徑 在數據分析領域，技術工具經歷了多個階段的演進。這些演進不僅反映了技術的進步，也體現了用戶需求和使用場景的變化。 Excel 時代：告別手工作業，陷入“表格泥潭“，早期數據分析依賴 Excel，實現基礎數據記錄、計…
閱讀更多...
數據空間技術在智慧水庫管理平臺中的賦能

數據空間技術在智慧水庫管理平臺中的賦能

數據空間技術在智慧水庫管理平臺中的賦能&#xff1a;設備到應用的數據傳輸優化 數據空間技術為智慧水庫管理平臺提供了革命性的數據傳輸、處理和安全保障能力。以下是數據空間技術在設備到應用數據傳輸過程中的全面賦能方案&#xff1a; 數據空間賦能架構設計 #mermaid-svg-R2…
閱讀更多...
SpringBoot學習路徑二--Spring Boot自動配置原理深度解析

SpringBoot學習路徑二--Spring Boot自動配置原理深度解析

SpringBoot最核心的功能就是自動裝配&#xff0c;Starter作為SpringBoot的核心功能之一&#xff0c;基于自動配置代碼提供了自動配置模塊及依賴的能力&#xff0c;讓軟件集成變得簡單、易用。使用SpringBoot時&#xff0c;我們只需引I人對應的Starter&#xff0c;SpringBoot啟動…
閱讀更多...
最新文章

Copyright @ 2022~2023