开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS `cailiaochuku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cailiaochuku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`wuliaobianhao` varchar(200) DEFAULT NULL COMMENT ‘物料编号’,
`wuliaomingcheng` varchar(200) NOT NULL COMMENT ‘物料名称’,
`wuliaotupian` varchar(200) DEFAULT NULL COMMENT ‘物料图片’,
`wuliaoleixing` varchar(200) NOT NULL COMMENT ‘物料类型’,
`shuliang` float NOT NULL COMMENT ‘数量’,
`wuliaodanjia` float DEFAULT NULL COMMENT ‘物料单价’,
`kucunweizhi` varchar(200) DEFAULT NULL COMMENT ‘库存位置’,
`chukushijian` datetime DEFAULT NULL COMMENT ‘出库时间’,
`chukushuoming` varchar(200) DEFAULT NULL COMMENT ‘出库说明’,
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT ‘员工工号’,
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT ‘员工姓名’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’材料出库’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `cailiaochuku`
—
LOCK TABLES `cailiaochuku` WRITE;
/*!40000 ALTER TABLE `cailiaochuku` DISABLE KEYS */;
INSERT INTO `cailiaochuku` VALUES (51,’2022-02-24 06:42:22′,’物料编号1′,’物料名称1′,’upload/cailiaochuku_wuliaotupian1.jpg’,’物料类型1′,1,1,’库存位置1′,’2022-02-24 14:42:22′,’出库说明1′,’员工工号1′,’员工姓名1′,’是’,”),(52,’2022-02-24 06:42:22′,’物料编号2′,’物料名称2′,’upload/cailiaochuku_wuliaotupian2.jpg’,’物料类型2′,2,2,’库存位置2′,’2022-02-24 14:42:22′,’出库说明2′,’员工工号2′,’员工姓名2′,’是’,”),(53,’2022-02-24 06:42:22′,’物料编号3′,’物料名称3′,’upload/cailiaochuku_wuliaotupian3.jpg’,’物料类型3′,3,3,’库存位置3′,’2022-02-24 14:42:22′,’出库说明3′,’员工工号3′,’员工姓名3′,’是’,”),(54,’2022-02-24 06:42:22′,’物料编号4′,’物料名称4′,’upload/cailiaochuku_wuliaotupian4.jpg’,’物料类型4′,4,4,’库存位置4′,’2022-02-24 14:42:22′,’出库说明4′,’员工工号4′,’员工姓名4′,’是’,”),(55,’2022-02-24 06:42:22′,’物料编号5′,’物料名称5′,’upload/cailiaochuku_wuliaotupian5.jpg’,’物料类型5′,5,5,’库存位置5′,’2022-02-24 14:42:22′,’出库说明5′,’员工工号5′,’员工姓名5′,’是’,”),(56,’2022-02-24 06:42:22′,’物料编号6′,’物料名称6′,’upload/cailiaochuku_wuliaotupian6.jpg’,’物料类型6′,6,6,’库存位置6′,’2022-02-24 14:42:22′,’出库说明6′,’员工工号6′,’员工姓名6′,’是’,”);
/*!40000 ALTER TABLE `cailiaochuku` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `cailiaoruku`
—
DROP TABLE IF EXISTS `cailiaoruku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cailiaoruku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`wuliaobianhao` varchar(200) DEFAULT NULL COMMENT ‘物料编号’,
`wuliaomingcheng` varchar(200) NOT NULL COMMENT ‘物料名称’,
`wuliaotupian` varchar(200) DEFAULT NULL COMMENT ‘物料图片’,
`wuliaoleixing` varchar(200) NOT NULL COMMENT ‘物料类型’,
`shuliang` float NOT NULL COMMENT ‘数量’,
`wuliaodanjia` float DEFAULT NULL COMMENT ‘物料单价’,
`kucunweizhi` varchar(200) DEFAULT NULL COMMENT ‘库存位置’,
`rukushijian` datetime DEFAULT NULL COMMENT ‘入库时间’,
`rukushuoming` varchar(200) DEFAULT NULL COMMENT ‘入库说明’,
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT ‘员工工号’,
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT ‘员工姓名’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT=’材料入库’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `cailiaoruku`
—
LOCK TABLES `cailiaoruku` WRITE;
/*!40000 ALTER TABLE `cailiaoruku` DISABLE KEYS */;
INSERT INTO `cailiaoruku` VALUES (41,’2022-02-24 06:42:22′,’物料编号1′,’物料名称1′,’upload/cailiaoruku_wuliaotupian1.jpg’,’物料类型1′,1,1,’库存位置1′,’2022-02-24 14:42:22′,’入库说明1′,’员工工号1′,’员工姓名1′,’是’,”),(42,’2022-02-24 06:42:22′,’物料编号2′,’物料名称2′,’upload/cailiaoruku_wuliaotupian2.jpg’,’物料类型2′,2,2,’库存位置2′,’2022-02-24 14:42:22′,’入库说明2′,’员工工号2′,’员工姓名2′,’是’,”),(43,’2022-02-24 06:42:22′,’物料编号3′,’物料名称3′,’upload/cailiaoruku_wuliaotupian3.jpg’,’物料类型3′,3,3,’库存位置3′,’2022-02-24 14:42:22′,’入库说明3′,’员工工号3′,’员工姓名3′,’是’,”),(44,’2022-02-24 06:42:22′,’物料编号4′,’物料名称4′,’upload/cailiaoruku_wuliaotupian4.jpg’,’物料类型4′,4,4,’库存位置4′,’2022-02-24 14:42:22′,’入库说明4′,’员工工号4′,’员工姓名4′,’是’,”),(45,’2022-02-24 06:42:22′,’物料编号5′,’物料名称5′,’upload/cailiaoruku_wuliaotupian5.jpg’,’物料类型5′,5,5,’库存位置5′,’2022-02-24 14:42:22′,’入库说明5′,’员工工号5′,’员工姓名5′,’是’,”),(46,’2022-02-24 06:42:22′,’物料编号6′,’物料名称6′,’upload/cailiaoruku_wuliaotupian6.jpg’,’物料类型6′,6,6,’库存位置6′,’2022-02-24 14:42:22′,’入库说明6′,’员工工号6′,’员工姓名6′,’是’,”);
/*!40000 ALTER TABLE `cailiaoruku` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chanpinchuku`
—
DROP TABLE IF EXISTS `chanpinchuku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinchuku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chanpinbianhao` varchar(200) DEFAULT NULL COMMENT ‘产品编号’,
`chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT ‘产品名称’,
`chanpinleixing` varchar(200) DEFAULT NULL COMMENT ‘产品类型’,
`chanpintupian` varchar(200) DEFAULT NULL COMMENT ‘产品图片’,
`shuliang` int(11) DEFAULT NULL COMMENT ‘数量’,
`chanpinshuoming` longtext COMMENT ‘产品说明’,
`cunfangweizhi` varchar(200) DEFAULT NULL COMMENT ‘存放位置’,
`chukushijian` datetime DEFAULT NULL COMMENT ‘出库时间’,
`chukushuoming` varchar(200) DEFAULT NULL COMMENT ‘出库说明’,
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT ‘员工工号’,
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT ‘员工姓名’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT=’产品出库’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chanpinchuku`
—
LOCK TABLES `chanpinchuku` WRITE;
/*!40000 ALTER TABLE `chanpinchuku` DISABLE KEYS */;
INSERT INTO `chanpinchuku` VALUES (91,’2022-02-24 06:42:23′,’产品编号1′,’产品名称1′,’产品类型1′,’upload/chanpinchuku_chanpintupian1.jpg’,1,’产品说明1′,’存放位置1′,’2022-02-24 14:42:23′,’出库说明1′,’员工工号1′,’员工姓名1′,’是’,”),(92,’2022-02-24 06:42:23′,’产品编号2′,’产品名称2′,’产品类型2′,’upload/chanpinchuku_chanpintupian2.jpg’,2,’产品说明2′,’存放位置2′,’2022-02-24 14:42:23′,’出库说明2′,’员工工号2′,’员工姓名2′,’是’,”),(93,’2022-02-24 06:42:23′,’产品编号3′,’产品名称3′,’产品类型3′,’upload/chanpinchuku_chanpintupian3.jpg’,3,’产品说明3′,’存放位置3′,’2022-02-24 14:42:23′,’出库说明3′,’员工工号3′,’员工姓名3′,’是’,”),(94,’2022-02-24 06:42:23′,’产品编号4′,’产品名称4′,’产品类型4′,’upload/chanpinchuku_chanpintupian4.jpg’,4,’产品说明4′,’存放位置4′,’2022-02-24 14:42:23′,’出库说明4′,’员工工号4′,’员工姓名4′,’是’,”),(95,’2022-02-24 06:42:23′,’产品编号5′,’产品名称5′,’产品类型5′,’upload/chanpinchuku_chanpintupian5.jpg’,5,’产品说明5′,’存放位置5′,’2022-02-24 14:42:23′,’出库说明5′,’员工工号5′,’员工姓名5′,’是’,”),(96,’2022-02-24 06:42:23′,’产品编号6′,’产品名称6′,’产品类型6′,’upload/chanpinchuku_chanpintupian6.jpg’,6,’产品说明6′,’存放位置6′,’2022-02-24 14:42:23′,’出库说明6′,’员工工号6′,’员工姓名6′,’是’,”);
/*!40000 ALTER TABLE `chanpinchuku` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chanpinleixing`
—
DROP TABLE IF EXISTS `chanpinleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chanpinleixing` varchar(200) NOT NULL COMMENT ‘产品类型’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT=’产品类型’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chanpinleixing`
—
LOCK TABLES `chanpinleixing` WRITE;
/*!40000 ALTER TABLE `chanpinleixing` DISABLE KEYS */;
INSERT INTO `chanpinleixing` VALUES (71,’2022-02-24 06:42:23′,’产品类型1′),(72,’2022-02-24 06:42:23′,’产品类型2′),(73,’2022-02-24 06:42:23′,’产品类型3′),(74,’2022-02-24 06:42:23′,’产品类型4′),(75,’2022-02-24 06:42:23′,’产品类型5′),(76,’2022-02-24 06:42:23′,’产品类型6′);
/*!40000 ALTER TABLE `chanpinleixing` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chanpinruku`
—
DROP TABLE IF EXISTS `chanpinruku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinruku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chanpinbianhao` varchar(200) DEFAULT NULL COMMENT ‘产品编号’,
`chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT ‘产品名称’,
`chanpinleixing` varchar(200) DEFAULT NULL COMMENT ‘产品类型’,
`chanpintupian` varchar(200) DEFAULT NULL COMMENT ‘产品图片’,
`shuliang` int(11) DEFAULT NULL COMMENT ‘数量’,
`chanpinshuoming` longtext COMMENT ‘产品说明’,
`cunfangweizhi` varchar(200) DEFAULT NULL COMMENT ‘存放位置’,
`rukushijian` datetime DEFAULT NULL COMMENT ‘入库时间’,
`rukushuoming` varchar(200) DEFAULT NULL COMMENT ‘入库说明’,
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT ‘员工工号’,
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT ‘员工姓名’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT=’产品入库’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chanpinruku`
—
LOCK TABLES `chanpinruku` WRITE;
/*!40000 ALTER TABLE `chanpinruku` DISABLE KEYS */;
INSERT INTO `chanpinruku` VALUES (101,’2022-02-24 06:42:23′,’产品编号1′,’产品名称1′,’产品类型1′,’upload/chanpinruku_chanpintupian1.jpg’,1,’产品说明1′,’存放位置1′,’2022-02-24 14:42:23′,’入库说明1′,’员工工号1′,’员工姓名1′,’是’,”),(102,’2022-02-24 06:42:23′,’产品编号2′,’产品名称2′,’产品类型2′,’upload/chanpinruku_chanpintupian2.jpg’,2,’产品说明2′,’存放位置2′,’2022-02-24 14:42:23′,’入库说明2′,’员工工号2′,’员工姓名2′,’是’,”),(103,’2022-02-24 06:42:23′,’产品编号3′,’产品名称3′,’产品类型3′,’upload/chanpinruku_chanpintupian3.jpg’,3,’产品说明3′,’存放位置3′,’2022-02-24 14:42:23′,’入库说明3′,’员工工号3′,’员工姓名3′,’是’,”),(104,’2022-02-24 06:42:23′,’产品编号4′,’产品名称4′,’产品类型4′,’upload/chanpinruku_chanpintupian4.jpg’,4,’产品说明4′,’存放位置4′,’2022-02-24 14:42:23′,’入库说明4′,’员工工号4′,’员工姓名4′,’是’,”),(105,’2022-02-24 06:42:23′,’产品编号5′,’产品名称5′,’产品类型5′,’upload/chanpinruku_chanpintupian5.jpg’,5,’产品说明5′,’存放位置5′,’2022-02-24 14:42:23′,’入库说明5′,’员工工号5′,’员工姓名5′,’是’,”),(106,’2022-02-24 06:42:23′,’产品编号6′,’产品名称6′,’产品类型6′,’upload/chanpinruku_chanpintupian6.jpg’,6,’产品说明6′,’存放位置6′,’2022-02-24 14:42:23′,’入库说明6′,’员工工号6′,’员工姓名6′,’是’,”);
/*!40000 ALTER TABLE `chanpinruku` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chanpinxinxi`
—
DROP TABLE IF EXISTS `chanpinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chanpinbianhao` varchar(200) DEFAULT NULL COMMENT ‘产品编号’,
`chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT ‘产品名称’,
`chanpinleixing` varchar(200) DEFAULT NULL COMMENT ‘产品类型’,
`chanpintupian` varchar(200) DEFAULT NULL COMMENT ‘产品图片’,
`shuliang` int(11) DEFAULT NULL COMMENT ‘数量’,
`chanpinshuoming` longtext COMMENT ‘产品说明’,
`cunfangweizhi` varchar(200) DEFAULT NULL COMMENT ‘存放位置’,
`dengjishijian` date DEFAULT NULL COMMENT ‘登记时间’,
PRIMARY KEY (`id`),
UNIQUE KEY `chanpinbianhao` (`chanpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT=’产品信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chanpinxinxi`
—
LOCK TABLES `chanpinxinxi` WRITE;
/*!40000 ALTER TABLE `chanpinxinxi` DISABLE KEYS */;
INSERT INTO `chanpinxinxi` VALUES (81,’2022-02-24 06:42:23′,’1111111111′,’产品名称1′,’产品类型1′,’upload/chanpinxinxi_chanpintupian1.jpg’,1,’产品说明1′,’存放位置1′,’2022-02-24′),(82,’2022-02-24 06:42:23′,’2222222222′,’产品名称2′,’产品类型2′,’upload/chanpinxinxi_chanpintupian2.jpg’,2,’产品说明2′,’存放位置2′,’2022-02-24′),(83,’2022-02-24 06:42:23′,’3333333333′,’产品名称3′,’产品类型3′,’upload/chanpinxinxi_chanpintupian3.jpg’,3,’产品说明3′,’存放位置3′,’2022-02-24′),(84,’2022-02-24 06:42:23′,’4444444444′,’产品名称4′,’产品类型4′,’upload/chanpinxinxi_chanpintupian4.jpg’,4,’产品说明4′,’存放位置4′,’2022-02-24′),(85,’2022-02-24 06:42:23′,’5555555555′,’产品名称5′,’产品类型5′,’upload/chanpinxinxi_chanpintupian5.jpg’,5,’产品说明5′,’存放位置5′,’2022-02-24′),(86,’2022-02-24 06:42:23′,’6666666666′,’产品名称6′,’产品类型6′,’upload/chanpinxinxi_chanpintupian6.jpg’,6,’产品说明6′,’存放位置6′,’2022-02-24′);
/*!40000 ALTER TABLE `chanpinxinxi` ENABLE KEYS */;
UNLOCK TABLES;