基于ssm的關(guān)于汽車(chē)零部件加工的erp系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)腳本：
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 '創(chuàng)建時(shí)間',
? `wuliaobianhao` varchar(200) DEFAULT NULL COMMENT '物料編號(hào)',
? `wuliaomingcheng` varchar(200) NOT NULL COMMENT '物料名稱(chēng)',
? `wuliaotupian` varchar(200) DEFAULT NULL COMMENT '物料圖片',
? `wuliaoleixing` varchar(200) NOT NULL COMMENT '物料類(lèi)型',
? `shuliang` float NOT NULL COMMENT '數(shù)量',
? `wuliaodanjia` float DEFAULT NULL COMMENT '物料單價(jià)',
? `kucunweizhi` varchar(200) DEFAULT NULL COMMENT '庫(kù)存位置',
? `chukushijian` datetime DEFAULT NULL COMMENT '出庫(kù)時(shí)間',
? `chukushuoming` varchar(200) DEFAULT NULL COMMENT '出庫(kù)說(shuō)明',
? `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '員工工號(hào)',
? `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '員工姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='材料出庫(kù)';
/*!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','物料編號(hào)1','物料名稱(chēng)1','upload/cailiaochuku_wuliaotupian1.jpg','物料類(lèi)型1',1,1,'庫(kù)存位置1','2022-02-24 14:42:22','出庫(kù)說(shuō)明1','員工工號(hào)1','員工姓名1','是',''),(52,'2022-02-24 06:42:22','物料編號(hào)2','物料名稱(chēng)2','upload/cailiaochuku_wuliaotupian2.jpg','物料類(lèi)型2',2,2,'庫(kù)存位置2','2022-02-24 14:42:22','出庫(kù)說(shuō)明2','員工工號(hào)2','員工姓名2','是',''),(53,'2022-02-24 06:42:22','物料編號(hào)3','物料名稱(chēng)3','upload/cailiaochuku_wuliaotupian3.jpg','物料類(lèi)型3',3,3,'庫(kù)存位置3','2022-02-24 14:42:22','出庫(kù)說(shuō)明3','員工工號(hào)3','員工姓名3','是',''),(54,'2022-02-24 06:42:22','物料編號(hào)4','物料名稱(chēng)4','upload/cailiaochuku_wuliaotupian4.jpg','物料類(lèi)型4',4,4,'庫(kù)存位置4','2022-02-24 14:42:22','出庫(kù)說(shuō)明4','員工工號(hào)4','員工姓名4','是',''),(55,'2022-02-24 06:42:22','物料編號(hào)5','物料名稱(chēng)5','upload/cailiaochuku_wuliaotupian5.jpg','物料類(lèi)型5',5,5,'庫(kù)存位置5','2022-02-24 14:42:22','出庫(kù)說(shuō)明5','員工工號(hào)5','員工姓名5','是',''),(56,'2022-02-24 06:42:22','物料編號(hào)6','物料名稱(chēng)6','upload/cailiaochuku_wuliaotupian6.jpg','物料類(lèi)型6',6,6,'庫(kù)存位置6','2022-02-24 14:42:22','出庫(kù)說(shuō)明6','員工工號(hào)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 '創(chuàng)建時(shí)間',
? `wuliaobianhao` varchar(200) DEFAULT NULL COMMENT '物料編號(hào)',
? `wuliaomingcheng` varchar(200) NOT NULL COMMENT '物料名稱(chēng)',
? `wuliaotupian` varchar(200) DEFAULT NULL COMMENT '物料圖片',
? `wuliaoleixing` varchar(200) NOT NULL COMMENT '物料類(lèi)型',
? `shuliang` float NOT NULL COMMENT '數(shù)量',
? `wuliaodanjia` float DEFAULT NULL COMMENT '物料單價(jià)',
? `kucunweizhi` varchar(200) DEFAULT NULL COMMENT '庫(kù)存位置',
? `rukushijian` datetime DEFAULT NULL COMMENT '入庫(kù)時(shí)間',
? `rukushuoming` varchar(200) DEFAULT NULL COMMENT '入庫(kù)說(shuō)明',
? `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '員工工號(hào)',
? `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '員工姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='材料入庫(kù)';
/*!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','物料編號(hào)1','物料名稱(chēng)1','upload/cailiaoruku_wuliaotupian1.jpg','物料類(lèi)型1',1,1,'庫(kù)存位置1','2022-02-24 14:42:22','入庫(kù)說(shuō)明1','員工工號(hào)1','員工姓名1','是',''),(42,'2022-02-24 06:42:22','物料編號(hào)2','物料名稱(chēng)2','upload/cailiaoruku_wuliaotupian2.jpg','物料類(lèi)型2',2,2,'庫(kù)存位置2','2022-02-24 14:42:22','入庫(kù)說(shuō)明2','員工工號(hào)2','員工姓名2','是',''),(43,'2022-02-24 06:42:22','物料編號(hào)3','物料名稱(chēng)3','upload/cailiaoruku_wuliaotupian3.jpg','物料類(lèi)型3',3,3,'庫(kù)存位置3','2022-02-24 14:42:22','入庫(kù)說(shuō)明3','員工工號(hào)3','員工姓名3','是',''),(44,'2022-02-24 06:42:22','物料編號(hào)4','物料名稱(chēng)4','upload/cailiaoruku_wuliaotupian4.jpg','物料類(lèi)型4',4,4,'庫(kù)存位置4','2022-02-24 14:42:22','入庫(kù)說(shuō)明4','員工工號(hào)4','員工姓名4','是',''),(45,'2022-02-24 06:42:22','物料編號(hào)5','物料名稱(chēng)5','upload/cailiaoruku_wuliaotupian5.jpg','物料類(lèi)型5',5,5,'庫(kù)存位置5','2022-02-24 14:42:22','入庫(kù)說(shuō)明5','員工工號(hào)5','員工姓名5','是',''),(46,'2022-02-24 06:42:22','物料編號(hào)6','物料名稱(chēng)6','upload/cailiaoruku_wuliaotupian6.jpg','物料類(lèi)型6',6,6,'庫(kù)存位置6','2022-02-24 14:42:22','入庫(kù)說(shuō)明6','員工工號(hào)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 '創(chuàng)建時(shí)間',
? `chanpinbianhao` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品編號(hào)',
? `chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品名稱(chēng)',
? `chanpinleixing` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品類(lèi)型',
? `chanpintupian` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品圖片',
? `shuliang` int(11) DEFAULT NULL COMMENT '數(shù)量',
? `chanpinshuoming` longtext COMMENT '產(chǎn)品說(shuō)明',
? `cunfangweizhi` varchar(200) DEFAULT NULL COMMENT '存放位置',
? `chukushijian` datetime DEFAULT NULL COMMENT '出庫(kù)時(shí)間',
? `chukushuoming` varchar(200) DEFAULT NULL COMMENT '出庫(kù)說(shuō)明',
? `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '員工工號(hào)',
? `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '員工姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品出庫(kù)';
/*!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','產(chǎn)品編號(hào)1','產(chǎn)品名稱(chēng)1','產(chǎn)品類(lèi)型1','upload/chanpinchuku_chanpintupian1.jpg',1,'產(chǎn)品說(shuō)明1','存放位置1','2022-02-24 14:42:23','出庫(kù)說(shuō)明1','員工工號(hào)1','員工姓名1','是',''),(92,'2022-02-24 06:42:23','產(chǎn)品編號(hào)2','產(chǎn)品名稱(chēng)2','產(chǎn)品類(lèi)型2','upload/chanpinchuku_chanpintupian2.jpg',2,'產(chǎn)品說(shuō)明2','存放位置2','2022-02-24 14:42:23','出庫(kù)說(shuō)明2','員工工號(hào)2','員工姓名2','是',''),(93,'2022-02-24 06:42:23','產(chǎn)品編號(hào)3','產(chǎn)品名稱(chēng)3','產(chǎn)品類(lèi)型3','upload/chanpinchuku_chanpintupian3.jpg',3,'產(chǎn)品說(shuō)明3','存放位置3','2022-02-24 14:42:23','出庫(kù)說(shuō)明3','員工工號(hào)3','員工姓名3','是',''),(94,'2022-02-24 06:42:23','產(chǎn)品編號(hào)4','產(chǎn)品名稱(chēng)4','產(chǎn)品類(lèi)型4','upload/chanpinchuku_chanpintupian4.jpg',4,'產(chǎn)品說(shuō)明4','存放位置4','2022-02-24 14:42:23','出庫(kù)說(shuō)明4','員工工號(hào)4','員工姓名4','是',''),(95,'2022-02-24 06:42:23','產(chǎn)品編號(hào)5','產(chǎn)品名稱(chēng)5','產(chǎn)品類(lèi)型5','upload/chanpinchuku_chanpintupian5.jpg',5,'產(chǎn)品說(shuō)明5','存放位置5','2022-02-24 14:42:23','出庫(kù)說(shuō)明5','員工工號(hào)5','員工姓名5','是',''),(96,'2022-02-24 06:42:23','產(chǎn)品編號(hào)6','產(chǎn)品名稱(chēng)6','產(chǎn)品類(lèi)型6','upload/chanpinchuku_chanpintupian6.jpg',6,'產(chǎn)品說(shuō)明6','存放位置6','2022-02-24 14:42:23','出庫(kù)說(shuō)明6','員工工號(hào)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 '創(chuàng)建時(shí)間',
? `chanpinleixing` varchar(200) NOT NULL COMMENT '產(chǎn)品類(lèi)型',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品類(lèi)型';
/*!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','產(chǎn)品類(lèi)型1'),(72,'2022-02-24 06:42:23','產(chǎn)品類(lèi)型2'),(73,'2022-02-24 06:42:23','產(chǎn)品類(lèi)型3'),(74,'2022-02-24 06:42:23','產(chǎn)品類(lèi)型4'),(75,'2022-02-24 06:42:23','產(chǎn)品類(lèi)型5'),(76,'2022-02-24 06:42:23','產(chǎn)品類(lèi)型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 '創(chuàng)建時(shí)間',
? `chanpinbianhao` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品編號(hào)',
? `chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品名稱(chēng)',
? `chanpinleixing` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品類(lèi)型',
? `chanpintupian` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品圖片',
? `shuliang` int(11) DEFAULT NULL COMMENT '數(shù)量',
? `chanpinshuoming` longtext COMMENT '產(chǎn)品說(shuō)明',
? `cunfangweizhi` varchar(200) DEFAULT NULL COMMENT '存放位置',
? `rukushijian` datetime DEFAULT NULL COMMENT '入庫(kù)時(shí)間',
? `rukushuoming` varchar(200) DEFAULT NULL COMMENT '入庫(kù)說(shuō)明',
? `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '員工工號(hào)',
? `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '員工姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品入庫(kù)';
/*!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','產(chǎn)品編號(hào)1','產(chǎn)品名稱(chēng)1','產(chǎn)品類(lèi)型1','upload/chanpinruku_chanpintupian1.jpg',1,'產(chǎn)品說(shuō)明1','存放位置1','2022-02-24 14:42:23','入庫(kù)說(shuō)明1','員工工號(hào)1','員工姓名1','是',''),(102,'2022-02-24 06:42:23','產(chǎn)品編號(hào)2','產(chǎn)品名稱(chēng)2','產(chǎn)品類(lèi)型2','upload/chanpinruku_chanpintupian2.jpg',2,'產(chǎn)品說(shuō)明2','存放位置2','2022-02-24 14:42:23','入庫(kù)說(shuō)明2','員工工號(hào)2','員工姓名2','是',''),(103,'2022-02-24 06:42:23','產(chǎn)品編號(hào)3','產(chǎn)品名稱(chēng)3','產(chǎn)品類(lèi)型3','upload/chanpinruku_chanpintupian3.jpg',3,'產(chǎn)品說(shuō)明3','存放位置3','2022-02-24 14:42:23','入庫(kù)說(shuō)明3','員工工號(hào)3','員工姓名3','是',''),(104,'2022-02-24 06:42:23','產(chǎn)品編號(hào)4','產(chǎn)品名稱(chēng)4','產(chǎn)品類(lèi)型4','upload/chanpinruku_chanpintupian4.jpg',4,'產(chǎn)品說(shuō)明4','存放位置4','2022-02-24 14:42:23','入庫(kù)說(shuō)明4','員工工號(hào)4','員工姓名4','是',''),(105,'2022-02-24 06:42:23','產(chǎn)品編號(hào)5','產(chǎn)品名稱(chēng)5','產(chǎn)品類(lèi)型5','upload/chanpinruku_chanpintupian5.jpg',5,'產(chǎn)品說(shuō)明5','存放位置5','2022-02-24 14:42:23','入庫(kù)說(shuō)明5','員工工號(hào)5','員工姓名5','是',''),(106,'2022-02-24 06:42:23','產(chǎn)品編號(hào)6','產(chǎn)品名稱(chēng)6','產(chǎn)品類(lèi)型6','upload/chanpinruku_chanpintupian6.jpg',6,'產(chǎn)品說(shuō)明6','存放位置6','2022-02-24 14:42:23','入庫(kù)說(shuō)明6','員工工號(hào)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 '創(chuàng)建時(shí)間',
? `chanpinbianhao` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品編號(hào)',
? `chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品名稱(chēng)',
? `chanpinleixing` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品類(lèi)型',
? `chanpintupian` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品圖片',
? `shuliang` int(11) DEFAULT NULL COMMENT '數(shù)量',
? `chanpinshuoming` longtext COMMENT '產(chǎn)品說(shuō)明',
? `cunfangweizhi` varchar(200) DEFAULT NULL COMMENT '存放位置',
? `dengjishijian` date DEFAULT NULL COMMENT '登記時(shí)間',
? PRIMARY KEY (`id`),
? UNIQUE KEY `chanpinbianhao` (`chanpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品信息';
/*!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','產(chǎn)品名稱(chēng)1','產(chǎn)品類(lèi)型1','upload/chanpinxinxi_chanpintupian1.jpg',1,'產(chǎn)品說(shuō)明1','存放位置1','2022-02-24'),(82,'2022-02-24 06:42:23','2222222222','產(chǎn)品名稱(chēng)2','產(chǎn)品類(lèi)型2','upload/chanpinxinxi_chanpintupian2.jpg',2,'產(chǎn)品說(shuō)明2','存放位置2','2022-02-24'),(83,'2022-02-24 06:42:23','3333333333','產(chǎn)品名稱(chēng)3','產(chǎn)品類(lèi)型3','upload/chanpinxinxi_chanpintupian3.jpg',3,'產(chǎn)品說(shuō)明3','存放位置3','2022-02-24'),(84,'2022-02-24 06:42:23','4444444444','產(chǎn)品名稱(chēng)4','產(chǎn)品類(lèi)型4','upload/chanpinxinxi_chanpintupian4.jpg',4,'產(chǎn)品說(shuō)明4','存放位置4','2022-02-24'),(85,'2022-02-24 06:42:23','5555555555','產(chǎn)品名稱(chēng)5','產(chǎn)品類(lèi)型5','upload/chanpinxinxi_chanpintupian5.jpg',5,'產(chǎn)品說(shuō)明5','存放位置5','2022-02-24'),(86,'2022-02-24 06:42:23','6666666666','產(chǎn)品名稱(chēng)6','產(chǎn)品類(lèi)型6','upload/chanpinxinxi_chanpintupian6.jpg',6,'產(chǎn)品說(shuō)明6','存放位置6','2022-02-24');
/*!40000 ALTER TABLE `chanpinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
