基于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;