• 【原创】基于SpringBoot的同城生鲜门店配送系统(SpringBoot配送系统毕业设计)

    项目类型：SpringBoot源码 

    用户类型：2个角色（管理员+用户）

    主要技术：SpringBoot+MySQL+Bootstrap

    开发工具：Idea

    数据库：MySQL

    数据库表：12张

    项目介绍：后端采用SpringBoot框架。前端使用的是Layui的一个网站模板。通过5种角色（超级管理员、门店、接单员、调度员、司机）使用,实现了包括了门店信息管理、生鲜管理、接单员管理、调度员管理、数据统计等多个不同的模块。

    🍅演示视频在底部🍅

    🍅文末获取联系🍅

    目录

    00完整的程序目录

    01管理员端功能介绍

    1.0用户登录

    1.1后台首页（数据大屏）

    1.2门店信息管理

    1.3生鲜信息管理

    1.4接单员账户信息管理

    1.5调度员账号信息管理

    1.6司机账户信息管理

    1.7配送汽车信息管理

    1.8订单管理

    1.9订单操作详情

    1.10公共栏

    02用户端功能介绍

    2.1门店生鲜供应申请

    2.2订单签收

    03接单员端功能介绍

    3.1订单接单处理（分配调度员）

    04调度员端功能介绍

    4.1订单调度处理

    05司机端功能介绍

    5.1完成配送并归还汽车

    06项目结构

    Idea版本目录

    07数据库设计

    08演示视频

    01管理员端功能介绍

    1.0用户登录

    1.1后台首页（数据大屏）

    1.2门店信息管理

    1.3生鲜信息管理

    1.4接单员账户信息管理

    1.5调度员账号信息管理

    1.6司机账户信息管理

    1.7配送汽车信息管理

    1.8订单管理

    1.9订单操作详情

    1.10公共栏

    02用户端功能介绍

    2.1门店生鲜供应申请

    2.2订单签收

    03接单员端功能介绍

    3.1订单接单处理（分配调度员）

    04调度员端功能介绍

    4.1订单调度处理

    05司机端功能介绍

    5.1完成配送并归还汽车

    06项目结构

    Idea版本目录

    07数据库设计

    08演示视频

    【原创】基于SpringBoot的生鲜门店配送系统（同城门店配送系统毕业设计）

    1.  
    2. -- ----------------------------
    3. -- Table structure for address
    4. -- ----------------------------
    5. DROP TABLE IF EXISTS `address`;
    6. CREATE TABLE `address`  (
    7.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地址id',
    8.   `uid` int(11) DEFAULT NULL COMMENT '门店id',
    9.   `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地址',
    10.   `uphone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收货人电话',
    11.   `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
    12.   `yb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮编',
    13.   PRIMARY KEY (`id`) USING BTREE
    14. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    15.  
    16.  
    17.  
    18. -- ----------------------------
    19. -- Table structure for admin
    20. -- ----------------------------
    21. DROP TABLE IF EXISTS `admin`;
    22. CREATE TABLE `admin`  (
    23.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
    24.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
    25.   `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
    26.   PRIMARY KEY (`id`) USING BTREE
    27. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    28.  
    29.  
    30. -- ----------------------------
    31. -- Table structure for board
    32. -- ----------------------------
    33. DROP TABLE IF EXISTS `board`;
    34. CREATE TABLE `board`  (
    35.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告id',
    36.   `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
    37.   `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '内容',
    38.   `editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布人',
    39.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
    40.   PRIMARY KEY (`id`) USING BTREE
    41. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    42.  
    43.  
    44. -- ----------------------------
    45. -- Table structure for car
    46. -- ----------------------------
    47. DROP TABLE IF EXISTS `car`;
    48. CREATE TABLE `car`  (
    49.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '汽车id',
    50.   `carno` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车牌号',
    51.   `carname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车辆名称',
    52.   `carcolor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '颜色',
    53.   `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '使用状态（1空闲 2在使用）',
    54.   `carprice` decimal(10, 2) DEFAULT NULL COMMENT '价格',
    55.   PRIMARY KEY (`id`) USING BTREE
    56. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    57.  
    58.  
    59.  
    60. -- ----------------------------
    61. -- Table structure for details
    62. -- ----------------------------
    63. DROP TABLE IF EXISTS `details`;
    64. CREATE TABLE `details`  (
    65.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
    66.   `uid` int(11) DEFAULT NULL COMMENT '门店id',
    67.   `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '门店名',
    68.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
    69.   `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单状态（0门店已申请，待接单员分配 1接单员分配调度员 2 调度员分配司机 3司机正在配送，待门店签收）',
    70.   `ordernum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
    71.   `cid` int(11) DEFAULT 0 COMMENT '配送汽车id',
    72.   `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '处理人类型',
    73.   PRIMARY KEY (`id`) USING BTREE
    74. ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    75.  
    76. -- ----------------------------
    77. -- Table structure for driver
    78. -- ----------------------------
    79. DROP TABLE IF EXISTS `driver`;
    80. CREATE TABLE `driver`  (
    81.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '司机id',
    82.   `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
    83.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
    84.   `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
    85.   `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
    86.   `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
    87.   `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '司机状态（0空闲 1忙碌）',
    88.   PRIMARY KEY (`id`) USING BTREE
    89. ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    90.  
    91.  
    92.  
    93. -- ----------------------------
    94. -- Table structure for monad
    95. -- ----------------------------
    96. DROP TABLE IF EXISTS `monad`;
    97. CREATE TABLE `monad`  (
    98.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收货单id',
    99.   `ordernum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请订单id',
    100.   `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '签收人',
    101.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '签收时间',
    102.   `isth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否退货退款',
    103.   `details` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '退款原因',
    104.   `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
    105.   `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
    106.   PRIMARY KEY (`id`) USING BTREE
    107. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    108.  
    109.  
    110. -- ----------------------------
    111. -- Table structure for product
    112. -- ----------------------------
    113. DROP TABLE IF EXISTS `product`;
    114. CREATE TABLE `product`  (
    115.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '生鲜id',
    116.   `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
    117.   `price` double(10, 2) DEFAULT NULL COMMENT '价格',
    118.   `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '生鲜类型',
    119.   `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '介绍',
    120.   `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
    121.   `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
    122.   PRIMARY KEY (`id`) USING BTREE
    123. ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    124.  
    125.  
    126.  
    127. -- ----------------------------
    128. -- Table structure for records
    129. -- ----------------------------
    130. DROP TABLE IF EXISTS `records`;
    131. CREATE TABLE `records`  (
    132.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '申请单id',
    133.   `sid` int(11) DEFAULT NULL COMMENT '门店id',
    134.   `sname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '门店名',
    135.   `ordernum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
    136.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
    137.   `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '申请单状态（0门店已申请，待接单员分配 1接单员分配调度员 2 调度员分配司机 3司机正在配送，待门店签收）',
    138.   `pid` int(11) DEFAULT NULL COMMENT '生鲜id',
    139.   `nums` int(11) DEFAULT NULL COMMENT '申请数量',
    140.   PRIMARY KEY (`id`) USING BTREE
    141. ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    142.  
    143. -- ----------------------------
    144. -- Table structure for store
    145. -- ----------------------------
    146. DROP TABLE IF EXISTS `store`;
    147. CREATE TABLE `store`  (
    148.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '门店id',
    149.   `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '门店名',
    150.   `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '门店地址',
    151.   `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
    152.   `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
    153.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
    154.   `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '负责人',
    155.   PRIMARY KEY (`id`) USING BTREE
    156. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    157.  
    158.  
    159. -- ----------------------------
    160. -- Table structure for storeproduct
    161. -- ----------------------------
    162. DROP TABLE IF EXISTS `storeproduct`;
    163. CREATE TABLE `storeproduct`  (
    164.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '库存id',
    165.   `pid` int(11) DEFAULT NULL COMMENT '生鲜id',
    166.   `nums` int(11) DEFAULT NULL COMMENT '库存数量',
    167.   `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '申请时间',
    168.   `sid` int(11) DEFAULT NULL COMMENT '门店id',
    169.   PRIMARY KEY (`id`) USING BTREE
    170. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    171.  
    172.  
    173. -- ----------------------------
    174. -- Table structure for user
    175. -- ----------------------------
    176. DROP TABLE IF EXISTS `user`;
    177. CREATE TABLE `user`  (
    178.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
    179.   `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
    180.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
    181.   `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
    182.   `card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证',
    183.   `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
    184.   `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
    185.   `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
    186.   `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1接单员 2调度员',
    187.   PRIMARY KEY (`id`) USING BTREE
    188. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    189.  
    190.  
    191.  
    192. SET FOREIGN_KEY_CHECKS = 1;

  • 相关阅读:
    聊聊Linux 的 Page Cache
    ESP32烧写Arduino编译的固件
    初识Docker
    面试官：大量请求 Redis 不存在的数据，从而影响数据库，该如何解决？
    ARM芯片层相关术语和缩写汇总(一）
    记录--编写一个能运行的简易ko
    漫谈信息模型（1）
    深度学习在医疗保健领域的应用：从图像识别到疾病预测
    设计模式-10组合模式（组合模式设计模式）详解
    oracle执行计划中，同一条语句块，在不同情况下执行计划不一样问题。子查询，union 导致索引失效。
  • 原文地址：https://blog.csdn.net/qq_59059632/article/details/126818419