基于ssm的关于汽车零部件加工的erp系统设计与实现-计算机毕业设计源码+LW文档

开发语言：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;