基于SSM框架的快递预约寄件系统的设计与实现（普通毕设级别，含代码，带沙箱支付功能）

访问地址（暂时好像访问不了）

目前有些地方例如注册或者登陆等地方有可能会存在报错的问题，但刷新一下就可以了，具体原因没时间去修改了，如果需要的话大家可以看看问题是什么，大家将就看一下吧哈哈哈
普通用户：普通用户登陆地址
管理员：管理员登陆地址
代码下载地址：代码下载
普通用户、快递员可自行注册登陆，系统内现设有
用户名test，密码123654的用户；
用户名express，密码123456的快递员；（该快递员地址为北京市北京市西城区测试地址）
（用户选择快递员寄出后就可以在对应的快递员账号看见订单，使用沙箱支付可以下载支付宝的沙箱模拟软件）
用户名admin，密码admin的管理员。
大家可以点一点试一试。好久以前做的系统，很初级很low哈哈哈哈。

数据库脚本

/*
 Navicat Premium Data Transfer

 Source Server         : express
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : express

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 20/12/2020 17:49:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `a_id` int(5) NOT NULL AUTO_INCREMENT,
  `a_account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `a_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`a_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for complaint
-- ----------------------------
DROP TABLE IF EXISTS `complaint`;
CREATE TABLE `complaint`  (
  `co_id` int(11) NOT NULL AUTO_INCREMENT,
  `o_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `co_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `co_time` datetime(0) NOT NULL,
  PRIMARY KEY (`co_id`) USING BTREE,
  INDEX `co_oid`(`o_id`) USING BTREE,
  CONSTRAINT `co_oid` FOREIGN KEY (`o_id`) REFERENCES `orders` (`o_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for courier
-- ----------------------------
DROP TABLE IF EXISTS `courier`;
CREATE TABLE `courier`  (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `c_city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_county` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`c_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for evaluation
-- ----------------------------
DROP TABLE IF EXISTS `evaluation`;
CREATE TABLE `evaluation`  (
  `e_id` int(10) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) NULL DEFAULT NULL,
  `e_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `e_grade` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `e_time` datetime(0) NOT NULL,
  `c_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`e_id`) USING BTREE,
  INDEX `e_o_id`(`o_id`) USING BTREE,
  INDEX `e_u_id`(`u_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 83 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for logistics
-- ----------------------------
DROP TABLE IF EXISTS `logistics`;
CREATE TABLE `logistics`  (
  `o_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `l_id` int(32) NOT NULL AUTO_INCREMENT,
  `c_id` int(11) NOT NULL,
  `l_next` int(11) NULL DEFAULT NULL,
  `l_status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `l_time` datetime(0) NOT NULL,
  PRIMARY KEY (`l_id`) USING BTREE,
  INDEX `cid`(`c_id`) USING BTREE,
  INDEX `nextid`(`l_next`) USING BTREE,
  INDEX `o_id`(`o_id`) USING BTREE,
  CONSTRAINT `cid` FOREIGN KEY (`c_id`) REFERENCES `courier` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `nextid` FOREIGN KEY (`l_next`) REFERENCES `courier` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `o_id` FOREIGN KEY (`o_id`) REFERENCES `orders` (`o_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `o_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_id` int(11) NULL DEFAULT NULL,
  `c_id` int(11) NOT NULL,
  `o_saddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_sphone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_sname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_raddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_rphone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_rname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `o_money` double(10, 0) NOT NULL,
  `o_note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `o_status` int(1) NOT NULL DEFAULT 0,
  `o_time` datetime(0) NOT NULL,
  PRIMARY KEY (`o_id`) USING BTREE,
  INDEX `u_id`(`u_id`) USING BTREE,
  INDEX `c_id`(`c_id`) USING BTREE,
  CONSTRAINT `c_id` FOREIGN KEY (`c_id`) REFERENCES `courier` (`c_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `u_id` FOREIGN KEY (`u_id`) REFERENCES `users` (`u_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `u_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `u_province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `u_city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `u_county` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `u_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`u_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

系统用例图

一般用户可以注册为系统用户登录系统，一般用户使用后可以注销退出登录。一般用户进入系统后即可选择快递员填写寄件信息，如若需要上门取件，勾选上门取件即可，提交订单支付运费完成预约寄件；提交订单后可以进行评价反馈，一般用户可以查看评价信息、写评论和删除自己的评论；一般用户也可以对订单信息进行投诉处理，一般用户可以写投诉信息；一般用户可以通过手机号或快递单号查询快递的物流信息；一般用户可以查看用户信息，点击修改个人信息即可修改用户信息，点击保存即可保存修改后的个人信息。

快递员通过注册后登录到系统内，使用过后也可退出登录；快递员可对一般用户提交的寄件信息进行查询，分为已经处理、待取件和待处理的信息；快递员对一般用户提交的寄件信息进行处理，如果快递信息核对无误后选择下一站中转站即可寄出，如有误将修改订单信息的状态为问题订单，无法寄出，并反馈给一般用户；快递员对收至本站的快递进行快递物流更新反馈给一般用户以供查询；快递员可以查看一般用户反馈的评价信息；快递员可以查看快递员信息以及修改快递员信息，可以保存修改后的快递员信息。

管理员可以管理一般用户提交的订单信息，查询订单信息和删除订单信息；管理员管理系统内的一般用户信息，对一般用户信息进行增删改查的处理；管理员管理系统内的快递员信息，对快递员信息进行增删改查的处理；管理员管理系统内的投诉信息，对投诉信息进行查询和处理；管理员能够查看评价反馈信息，也可删除一般用户反馈的评价信息。

系统功能模块设计

快递预约寄件系统主要分为六个功能模块。其中包括注册登录模块、预约寄件模块、订单处理模块、个人信息编辑模块、评价处理模块和管理员模块。