• 【原创】基于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;

  • 相关阅读:
    Vite知识体系简述
    5.PHPwhile,foreach和for循环
    Podman安装与使用
    基于微信小程序的教学教务管理系统（后台Java+SSM+MySQL）
    【风力发电】山顶的白色“大风车”你了解吗？
    使用Docker安装JupyterHub
    （附源码）springboot西安酷跑健身房管理系统 毕业设计 345421
    PyQt5 不规则窗口的显示
    【Java实战】工作中如何规范定义Java常量
    Java NIO三大核心组件
  • 原文地址：https://blog.csdn.net/qq_59059632/article/details/126818419