[java]毕业设计基于java快递物流管理系统源码+数据库sql文件

最新推荐文章于 2024-05-30 14:59:09 发布

FL1768317420

最新推荐文章于 2024-05-30 14:59:09 发布

阅读量102

点赞数 2

分类专栏：毕设文章标签：数据库 java 课程设计

本文链接：https://blog.csdn.net/FL1768317420/article/details/139012112

版权

毕设专栏收录该内容

61 篇文章 0 订阅

订阅专栏

一个简单的快递物流管理系统,，适用于学习，毕业设计，作业。其中项目中已经提供sql文件具体内容如下：

/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.5.41 : Database - work_manager
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`work_manager` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `work_manager`;

/*Table structure for table `express_delivery` */

DROP TABLE IF EXISTS `express_delivery`;

CREATE TABLE `express_delivery` (
  `id` varchar(255) NOT NULL COMMENT '主键ID',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '修改时间',
  `send_user_id` varchar(255) DEFAULT NULL COMMENT '用户id',
  `send_name` varchar(100) DEFAULT '' COMMENT '发货人名字',
  `send_mobile` varchar(20) DEFAULT '' COMMENT '发货人手机号',
  `send_address` varchar(255) DEFAULT '' COMMENT '发货地址',
  `description` varchar(255) DEFAULT NULL COMMENT '快件描述',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `receive_name` varchar(100) DEFAULT '' COMMENT '收货人名字',
  `receive_mobile` varchar(20) DEFAULT '' COMMENT '收货人手机号',
  `receive_address` varchar(255) DEFAULT '' COMMENT '收货地址',
  `express_man_id` varchar(255) DEFAULT NULL COMMENT '快递员id',
  `is_receive` bit(1) DEFAULT NULL COMMENT '是否接单',
  `is_delivery` bit(1) DEFAULT NULL COMMENT '是否派送',
  `receive_date` datetime DEFAULT NULL COMMENT '接单时间',
  `delivery_date` datetime DEFAULT NULL COMMENT '派送时间',
  `order_status` int(11) DEFAULT NULL COMMENT '订单状态： 1（用户下单） ； 2（快递员接单） ； 3（派送中） ； 4（已收货）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递表';

/*Data for the table `express_delivery` */

insert  into `express_delivery`(`id`,`create_date`,`modify_date`,`send_user_id`,`send_name`,`send_mobile`,`send_address`,`description`,`remark`,`receive_name`,`receive_mobile`,`receive_address`,`express_man_id`,`is_receive`,`is_delivery`,`receive_date`,`delivery_date`,`order_status`) values ('0162ad2b-57f1-4b80-b8d0-10540c678dc1','2020-05-21 22:31:26','2020-05-21 22:52:04','5a526d7d-ecaa-4a79-90ab-244da9918424','dasdas','dsad','sadsa','dsad','asdsad','asdas','dasd','sadasdasd','a4a93faa-1998-40f6-bb70-66f76876b2f8','','','2020-05-21 22:31:26',NULL,4);
insert  into `express_delivery`(`id`,`create_date`,`modify_date`,`send_user_id`,`send_name`,`send_mobile`,`send_address`,`description`,`remark`,`receive_name`,`receive_mobile`,`receive_address`,`express_man_id`,`is_receive`,`is_delivery`,`receive_date`,`delivery_date`,`order_status`) values ('41ca77f6-93b0-4ea7-ad51-a817159aa740','2020-05-21 22:51:50','2020-05-21 22:51:50','5a526d7d-ecaa-4a79-90ab-244da9918424','4234','324234','2343','5235','23523','523432','532532','5325235','a4a93faa-1998-40f6-bb70-66f76876b2f8','',NULL,'2020-05-21 22:51:50',NULL,2);

/*Table structure for table `express_man` */

DROP TABLE IF EXISTS `express_man`;

CREATE TABLE `express_man` (
  `id` varchar(255) NOT NULL COMMENT '主键ID',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '修改时间',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `email` varchar(255) DEFAULT '' COMMENT '邮箱',
  `name` varchar(255) DEFAULT '' COMMENT '姓名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `username` varchar(100) DEFAULT NULL COMMENT '账号',
  PRIMARY KEY (`id`),
  KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='快递员表';

/*Data for the table `express_man` */

insert  into `express_man`(`id`,`create_date`,`modify_date`,`mobile`,`email`,`name`,`password`,`username`) values ('a4a93faa-1998-40f6-bb70-66f76876b2f8','2020-05-21 22:30:25','2020-05-21 22:30:25','2132','3123','123123','123','qq');

/*Table structure for table `sys_admin` */

DROP TABLE IF EXISTS `sys_admin`;

CREATE TABLE `sys_admin` (
  `id` varchar(64) NOT NULL COMMENT '主键ID',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '修改时间',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `email` varchar(255) DEFAULT '' COMMENT '邮箱',
  `name` varchar(255) DEFAULT '' COMMENT '姓名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `username` varchar(100) DEFAULT NULL COMMENT '账号',
  `memo` varchar(255) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理人员表';

/*Data for the table `sys_admin` */

insert  into `sys_admin`(`id`,`create_date`,`modify_date`,`mobile`,`email`,`name`,`password`,`username`,`memo`) values ('1','2020-04-14 11:47:53','2020-05-21 22:11:19','13402970419111','zhuzhe_mail@163.com111','Admin11','123','admin','');

/*Table structure for table `sys_config` */

DROP TABLE IF EXISTS `sys_config`;

CREATE TABLE `sys_config` (
  `id` varchar(60) NOT NULL COMMENT '主键',
  `name` varchar(60) DEFAULT NULL COMMENT '名称',
  `des` varchar(255) DEFAULT NULL COMMENT '描述',
  `value` varchar(255) DEFAULT NULL COMMENT '值',
  `status` bit(1) DEFAULT NULL COMMENT '状态\r\n0 禁用\r\n1 启用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_config` */

/*Table structure for table `sys_config_attributes` */

DROP TABLE IF EXISTS `sys_config_attributes`;

CREATE TABLE `sys_config_attributes` (
  `config_id` varchar(60) NOT NULL COMMENT '配置id',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `value` varchar(255) DEFAULT NULL COMMENT '值'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_config_attributes` */

/*Table structure for table `sys_log` */

DROP TABLE IF EXISTS `sys_log`;

CREATE TABLE `sys_log` (
  `id` varchar(64) NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `operator_id` varchar(64) DEFAULT NULL,
  `operator` varchar(50) DEFAULT NULL,
  `content` text,
  `memo` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `relation_id` varchar(64) DEFAULT NULL,
  `before_info` text,
  `after_info` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `sys_log` */

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_type` varchar(20) NOT NULL COMMENT '菜单类型：MENU 有子菜单,无url ; LEAF 无子菜单，直接对应url ; BUTTON 按钮，父菜单是LEAF',
  `parent_menu` bigint(20) DEFAULT NULL COMMENT '父菜单',
  `menu_name` varchar(20) DEFAULT NULL COMMENT '菜单名称',
  `menu_url` varchar(500) DEFAULT NULL COMMENT '菜单url',
  `menu_icon` varchar(200) DEFAULT NULL COMMENT '菜单图标',
  `menu_status` varchar(20) DEFAULT NULL COMMENT '菜单状态：DIS_ABLE ; ABLE',
  `auth_code` varchar(100) DEFAULT NULL COMMENT '权限码',
  `menu_order` int(11) DEFAULT NULL COMMENT '排序，越大越靠前',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10021 DEFAULT CHARSET=utf8 COMMENT='菜单按钮管理';

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10000,'MENU',NULL,'我的',NULL,NULL,'ABLE','admin',2);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10001,'LEAF',10000,'个人中心','page/SysAdmin/my.html',NULL,'ABLE','admin',2);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10005,'MENU',NULL,'快递员管理',NULL,NULL,'ABLE','admin',1);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10006,'LEAF',10005,'快递员列表','page/ExpressMan/ExpressMan.html',NULL,'ABLE','admin',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10007,'MENU',NULL,'用户管理',NULL,NULL,'ABLE','admin',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10008,'LEAF',10007,'用户列表','page/UserInfo/UserInfo.html',NULL,'ABLE','admin',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10010,'MENU',NULL,'我的寄件','',NULL,'ABLE','user',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10011,'LEAF',10010,'寄件列表','page/UserInfo/ExpressDelivery.html',NULL,'ABLE','user',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10012,'MENU',NULL,'我的派送','',NULL,'ABLE','express',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10013,'LEAF',10012,'派送列表','page/ExpressMan/ExpressDelivery.html',NULL,'ABLE','express',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10014,'LEAF',10010,'寄快递','page/UserInfo/createOrder.html',NULL,'ABLE','user',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10015,'LEAF',10016,'我的信息','page/UserInfo/my.html',NULL,'ABLE','user',1);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10016,'MENU',NULL,'我的',NULL,NULL,'ABLE','user',1);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10017,'MENU',NULL,'我的',NULL,NULL,'ABLE','express',1);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10018,'LEAF',10017,'我的信息','page/ExpressMan/my.html',NULL,'ABLE','express',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10019,'MENU',NULL,'快递管理',NULL,NULL,'ABLE','admin',0);
insert  into `sys_menu`(`id`,`menu_type`,`parent_menu`,`menu_name`,`menu_url`,`menu_icon`,`menu_status`,`auth_code`,`menu_order`) values (10020,'LEAF',10019,'快递列表','page/ExpressDelivery/ExpressDelivery.html',NULL,'ABLE','admin',0);

/*Table structure for table `user_info` */

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `id` varchar(255) NOT NULL COMMENT '主键ID',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '修改时间',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `email` varchar(255) DEFAULT '' COMMENT '邮箱',
  `name` varchar(255) DEFAULT '' COMMENT '姓名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `username` varchar(100) DEFAULT NULL COMMENT '账号',
  PRIMARY KEY (`id`),
  KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `user_info` */

insert  into `user_info`(`id`,`create_date`,`modify_date`,`mobile`,`email`,`name`,`password`,`username`) values ('5a526d7d-ecaa-4a79-90ab-244da9918424','2020-05-21 22:12:08','2020-05-21 22:12:08','121212','121212','21313','123','qq');
insert  into `user_info`(`id`,`create_date`,`modify_date`,`mobile`,`email`,`name`,`password`,`username`) values ('81613a68-73cd-4fff-ad36-b95ea35e3ad3','2020-05-21 21:09:52','2020-05-21 21:09:52','12345','123456','asdfg','123','zz');

/*Table structure for table `user_receiver` */

DROP TABLE IF EXISTS `user_receiver`;

CREATE TABLE `user_receiver` (
  `id` varchar(255) NOT NULL COMMENT '主键',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '修改时间',
  `user_id` varchar(64) DEFAULT NULL COMMENT '用户id',
  `name` varchar(100) DEFAULT '' COMMENT '名字',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `area_name` varchar(255) DEFAULT '' COMMENT '地区名称',
  `address` varchar(255) DEFAULT '' COMMENT '地址',
  `has_default` bit(1) DEFAULT b'0' COMMENT '是否默认',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收货地址信息';

/*Data for the table `user_receiver` */

/*Table structure for table `user_role` */

DROP TABLE IF EXISTS `user_role`;

CREATE TABLE `user_role` (
  `id` varchar(255) NOT NULL COMMENT '主键ID',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户、快递员、管理员的id',
  `role` varchar(100) DEFAULT NULL COMMENT 'admin , user, express',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

/*Data for the table `user_role` */

insert  into `user_role`(`id`,`user_id`,`role`) values ('00e287fd-d8dd-4749-9812-702f1bcd97de','a4a93faa-1998-40f6-bb70-66f76876b2f8','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('1','1','admin');
insert  into `user_role`(`id`,`user_id`,`role`) values ('1cc69087-ee50-4b2c-b8af-7fd725d8ccc1','a2f0f157-73f0-4f2f-bd73-e73820c57016','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('234f5aeb-631a-4ec2-8673-2bd2c384088c','16249087-3eb0-4dd7-bc1b-e5c0e9cc9ed2','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('250595f3-cd49-451f-a334-ce692f50470b','0f8431b6-f17e-4513-9392-8961781e8ee8','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('2ed7aa37-c011-4081-879e-75c748ec07df','81613a68-73cd-4fff-ad36-b95ea35e3ad3','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('3a5e2007-4c95-4426-9d4d-e0d30d883777','a2d09ac3-fb01-4392-aed7-9372c6e731f2','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('3feced55-efe7-490e-ba78-7285a739d61c','5a526d7d-ecaa-4a79-90ab-244da9918424','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('517527dc-b839-4005-b45f-28b0daa5d5cf','7de3b458-d816-42c0-8546-ee0dbf8a8a43','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('74440917-8e0e-4cec-8b85-e51d2f699f14','804eb024-b5f5-4a35-9c4a-09bae87acac7','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('83b94122-e408-4ecb-924f-68721b6e6e98','fc165b4d-7ae7-469b-b277-0b3200f7589a','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('8fb22d2f-821a-44be-9b81-5b33edb7de3f','e3f5d9de-4ab9-4805-b851-e8609ae4d6c2','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('a1c21f95-da43-4ea6-b087-0afb7ebc2bd6','2f551923-fbf4-4b20-b624-93aa596bc859','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('b2e8c59f-93fb-4f73-9645-bc0bc5618a4d','1f6af244-b2fa-417d-9fb7-64d97b79b5e4','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('cef37e94-1b0e-4176-b050-29bf9532722c','501bf1f6-b06a-4eb7-8c83-ca50a07429cc','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('d3f6f2ae-07db-467b-995c-62456a84de5a','34e64eff-1738-4985-830a-59650fb7fd79','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('d7dea7e5-547a-44f5-b94e-19a03541bc80','718005b3-a2c2-4d42-a617-00d9df34d248','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('dd3c8e8f-be34-4a09-98c9-40120d53adc6','27f4c59d-eee3-42e4-84f5-a47f7b2c9e26','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('e1c16686-6000-4691-a406-884f3f14b780','d1edcb85-824e-4099-b713-b07bf4df8be8','express');
insert  into `user_role`(`id`,`user_id`,`role`) values ('e790d68c-a191-4c94-9373-afa2fa3952da','0eecdbb8-481c-4339-8f85-21a0d20437d0','user');
insert  into `user_role`(`id`,`user_id`,`role`) values ('f43067cd-7685-4a63-95db-c3e5196b0a5c','aec0cc88-9672-462a-8a67-1efda73caedc','express');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

web文件夹截图：

cms文件夹

启动代码：

package com.manager.cms;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class CmsApplication {

    public static void main(String[] args) {
        SpringApplication.run(CmsApplication.class, args);
    }

}

源码下载地址：

https://download.csdn.net/download/FL1768317420/89320342