基于SSM+mysql的物流管理系统设计与实现（源码）.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssms772z -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Current Database: `ssms772z` -- /*!40000 DROP DATABASE IF EXISTS `ssms772z`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssms772z` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssms772z`; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','upload/1647948798829.png'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `huowudingdan` -- DROP TABLE IF EXISTS `huowudingdan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `huowudingdan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `wuliudanhao` varchar(200) DEFAULT NULL COMMENT '物流单号', `huowumingcheng` varchar(200) NOT NULL COMMENT '货物名称', `huowuleixing` varchar(200) NOT NULL COMMENT '货物类型', `huowuzhongliang` varchar(200) NOT NULL COMMENT '货物重量', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `fahuoren` varchar(200) DEFAULT NULL COMMENT '发货人', `fahuodizhi` varchar(200) DEFAULT NULL COMMENT '发货地址', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `shouhuoren` varchar(200) DEFAULT NULL COMMENT '收货人', `shouhuorenshouji` varchar(200) DEFAULT NULL COMMENT '收货人手机', `shouhuodizhi` varchar(200) DEFAULT NULL COMMENT '收货地址', `kehuzhanghao` varchar(200) DEFAULT NULL COMMENT '客户账号', `kehuxingming` varchar(200) DEFAULT NULL COMMENT '客户姓名', `dengjishijian` datetime DEFAULT NULL COMMENT '登记时间', `dingdanbeizhu` longtext COMMENT '订单备注', `fahuozhuangtai` varchar(200) DEFAULT NULL COMMENT '发货状态', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`), UNIQUE KEY `wuliudanhao` (`wuliudanhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1647948524383 DEFAULT CHARSET=utf8 COMMENT='货物订单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `huowudingdan` -- LOCK TABLES `huowudingdan` WRITE; /*!40000 ALTER TABLE `huowudingdan` DISABLE KEYS */; INSERT INTO `huowudingdan` VALUES (31,'2022-03-22 11:24:15','1111111111','货物名称1','货物类型1','货物重量1','upload/huowudingdan_tupian1.jpg','发货人1','发货地址1','13823888881','收货人1','13823888881','收货地址1','客户账号1','客户姓名1','2022-03-22 19:24:15','订单备注1','已发货',1),(32,'2022-03-22 11:24:15','2222222222','货物名称2','货物类型2','货物重量2','upload/huowudingdan_tupian2.jpg','发货人2','发货地址2','13823888882','收货人2','13823888882','收货地址2','客户账号2','客户姓名2','2022-03-22 19:24:15','订单备注2','已发货',2),(33,'2022-03-22 11:24:15','3333333333','货物名称3','货物类型3','货物重量3','upload/huowudingdan_tupian3.jpg','发货人3','发货地址3','13823888883','收货人3','13823888883','收货地址3','客户账号3','客户姓名3','2022-03-22 19:24:15','订单备注3','已发货',3),(34,'2022-03-22 11:24:15','4444444444','货物名称4','货物类型4','货物重量4','upload/huowudingdan_tupian4.jpg','发货人4','发货地址4','13823888884','收货人4','13823888884','收货地址4','客户账号4','客户姓名4','2022-03-22 19:24:15','订单备注4','已发货',4),(35,'2022-03-22 11:24:15','5555555555','货物名称5','货物类型5','货物重量5','upload/huowudingdan_tupian5.jpg','发货人5','发货地址5','13823888885','收货人5','13823888885','收货地址5','客户账号5','客户姓名5','2022-03-22 19:24:15','订单备注5','已发货',5),(36,'2022-03-22 11:24:15','6666666666','货物名称6','货物类型6','货物重量6','upload/huowudingdan_tupian6.jpg','发货人6','发货地址6','13823888886','收货人6','13823888886','收货地址6','客户账号6','客户姓名6','2022-03-22 19:24:15','订单备注6','已发货',6),(1647948524382,'2022-03-22 11:28:44','1647948490484','阿斯蒂芬','按时的发生','2kg','upload/1647948484799.jpg','张三','北京朝阳111号','13922222222','王五','13955555555','上海浦东111号','11','张三','2022-03-22 19:28:10','阿斯蒂芬阿斯蒂芬撒地方撒发斯蒂芬','已发货',1647948403479); /*!40000 ALTER TABLE `huowudingdan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `huowuqingkuang` -- DROP TABLE IF EXISTS `huowuqingkuang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `huowuqingkuang` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `wuliudanhao` varchar(200) DEFAULT NULL COMMENT '物流单号', `huowumingcheng` varchar(200) NOT NULL COMMENT '货物名称', `huowuleixing` varchar(200) NOT NULL COMMENT '货物类型', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `huowuzhongliang` varchar(200) NOT NULL COMMENT '货物重量', `fahuoren` varchar(200) DEFAULT NULL COMMENT '发货人', `fahuodizhi` varchar(200) DEFAULT NULL COMMENT '发货地址', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `shouhuoren` varchar(200) DEFAULT NULL COMMENT '收货人', `shouhuorenshouji` varchar(200) DEFAULT NULL COMMENT '收货人手机', `shouhuodizhi` varchar(200) DEFAULT NULL COMMENT '收货地址', `kehuzhanghao` varchar(200) DEFAULT NULL COMMENT '客户账号', `kehuxingming` varchar(200) DEFAULT NULL COMMENT '客户姓名', `dingdanbeizhu` longtext COMMENT '订单备注', `feiyong` int(11) NOT NULL COMMENT '费用', `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名', `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号', `shoujianshijian` datetime DEFAULT NULL COMMENT '收件时间', `zhuangtai` varchar(200) NOT NULL COMMENT '状态', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1647948585555 DEFAULT CHARSET=utf8 COMMENT='货物情况'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `huowuqingkuang` -- LOCK TABLES `huowuqingkuang` WRITE; /*!40000 ALTER TABLE `huowuqingkuang` DISABLE KEYS */; INSERT INTO `huowuqingkuang` VALUES (41,'2022-03-22 11:24:15','物流单号1','货物名称1','货物类型1','upload/huowuqingkuang_tupian1.jpg','货物重量1','发货人1','发货地址1','13823888881','收货人1','13823888881','收货地址1','客户账