Java基于ssm+mysql的物流管理系统的实现.zip

/* SQLyog Professional v12.09 (64 bit) MySQL - 5.7.24 : Database - ry-vue ********************************************************************* */ /*!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*/`ry-vue` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `ry-vue`; /*Table structure for table `bus_caigou_order` */ DROP TABLE IF EXISTS `bus_caigou_order`; CREATE TABLE `bus_caigou_order` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `cg_order_num` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '采购订单编号', `provider_id` int(11) DEFAULT NULL COMMENT '供应商', `cg_date` date DEFAULT NULL COMMENT '采购日期', `cgy` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '采购员', `state` int(11) DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `bus_caigou_order` */ insert into `bus_caigou_order`(`id`,`cg_order_num`,`provider_id`,`cg_date`,`cgy`,`state`) values (1,'CG001',1,'2020-05-13','cg001',0),(2,'CG002',2,'2020-05-04','xiaozhang',0); /*Table structure for table `bus_ck_check` */ DROP TABLE IF EXISTS `bus_ck_check`; CREATE TABLE `bus_ck_check` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ck_num` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '仓库编号', `ck_temp` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '温度', `check_person` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '检查人', `check_date` date DEFAULT NULL COMMENT '检查日期', KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `bus_ck_check` */ insert into `bus_ck_check`(`id`,`ck_num`,`ck_temp`,`check_person`,`check_date`) values (1,'CK3','24','小马','2020-05-13'),(2,'CK004','30','mg','2020-05-26'); /*Table structure for table `bus_customer` */ DROP TABLE IF EXISTS `bus_customer`; CREATE TABLE `bus_customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customername` varchar(255) DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `telephone` varchar(255) DEFAULT NULL, `connectionpersion` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `bank` varchar(255) DEFAULT NULL, `account` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `available` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*Data for the table `bus_customer` */ insert into `bus_customer`(`id`,`customername`,`zip`,`address`,`telephone`,`connectionpersion`,`phone`,`bank`,`account`,`email`,`fax`,`available`) values (1,'小张超市','222','武汉','027-9123131','张大明','15279230588','中国银行','654431331343413','213123@sina.com','430001','1'),(2,'小明超市','333','深圳','0755-9123131','张小明','13064154936','中国银行','654431331343413','213123@sina.com','430000','1'),(3,'快七超市','430000','武汉','027-11011011','雷生','13617020687','招商银行','6543123341334133','6666@66.com','545341','1'),(4,'丽云超市','332005','十里大道1039号','0792-13658745','射可可','13648524759','建设银行','36245684125509','13648524759@163.com','152632','1'),(8,'寻鲁超市','332005','十里大楼','0792-56214528','周三','15236987455','农业银行','362458651236509','15236987455@163.com','320156','1'),(9,'morty','0341','xxx','13976544647','morty','13976544647','工商','4555156356222','13976544647@163.com','0786','1'); /*Table structure for table `bus_customorder` */ DROP TABLE IF EXISTS `bus_customorder`; CREATE TABLE `bus_customorder` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `cust_name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '客户名称', `order_date` date DEFAULT NULL COMMENT '订单日期', `order_type` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '订单类型', `pay_type` char(10) COLLATE utf8_bin DEFAULT NULL COMMENT '付款方式', `state` char(10) COLLATE utf8_bin DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `bus_customorder` */ insert into `bus_customorder`(`id`,`cust_name`,`order_date`,`order_type`,`pay_type`,`state`) values (1,'苹果','2020-05-13','国内','到付','已派送'),(2,'中兴','2020-05-12','国内','0','0'),(3,'华为','2020-05-05','小区','0','0'); /*Table structure for table `bus_delivery` */ DROP TABLE IF EXISTS `bus_delivery`; CREATE TABLE `bus_delivery` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `goodsid` int(11) DEFAULT NULL COMMENT '商品', `delivery_time` datetime DEFAULT NULL COMMENT '配送时间', `delivery_person` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '配送人员', `address` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '配送地址', `operator` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '操作员', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `bus_delivery` */ insert into `bus_delivery`(`id`,`goodsid`,`delivery_time`,`delivery_person`,`address`,`operator`) values (1,1,'2020-05-07 00:00:00','超级玛丽','高新区','mmy'); /*Table structure for table `bus_goods` */ DROP TABLE IF EXISTS `bus_goods`; CREATE TABLE `bus_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `goodsname` varchar(255) DEFAULT NULL, `produceplace` varchar(255) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `goodspackage` varchar(255) DEFAULT NULL, `productcode` varchar(255) DEFAULT NULL, `promitcode` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `price` double(10,2) DEFAULT NULL, `number` int(11) DEFAULT NULL, `dangernum` int(11) DEFAULT NULL, `goodsimg` varchar(255) DEFAULT NULL, `available` int(11) DEFAULT NULL, `providerid` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*Data for the table `bus_goods` */ insert into `bus_goods`(`id`,`goodsname`,`produceplace`,`size`,`goodspackage`,`productcode`,`promitcode`,`description`,`price`,`number`,`dangernum`,`goodsimg`,`available`,`providerid`) values (1,'娃哈哈','武汉','120ML','瓶','PH12345','PZ1234','小孩子都爱的',2.00,487,10,'2018-12-25/userface1.jpg',1,3),(2,'旺旺雪饼[小包]','仙桃','包','袋','PH12312312','PZ12312','好吃不上火',4.00,1109,10,'2018-12-25/userface2.jpg',1,1),(3,'旺旺大礼包','仙桃','盒','盒','11','11','111',28.00,1021,100,'2018-12-25/userface3.jpg',1,1),(4,'娃哈哈','武汉','200ML','瓶','11','111','12321',3.00,1100,10,'2018-12-25/userface4.jpg',1,3); /*Table structure for table `bus_inport` */ DROP TABLE IF EXISTS `bus_inport`; CREATE TABLE `bus_inport` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `paytype` varchar(255) DEFAULT NULL COMMENT '支付类型', `inporttime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '进货时间', `operateperson` varchar(255) DEFAULT NULL COMMENT '操作员', `number` int(11) DEFAULT NULL COMMENT '进货数量', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `inportprice` double(10,2) DEFAULT NULL COMMENT '进货价格', `providerid` int(11) DEFAULT NULL COMMENT '供货商', `goodsid` int(11) DEFAULT NULL COMMENT '商品id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT