摘要
网络的广泛应用给生活带来了十分的便利。所以把地方废物回收机构管理与现在网络相结合,利用java技术建设地方废物回收机构管理系统,实现地方废物回收机构的信息化。则对于进一步提高地方废物回收机构管理发展,丰富地方废物回收机构管理经验能起到不少的促进作用。
地方废物回收机构管理系统能够通过互联网得到广泛的、全面的宣传,让尽可能多的用户了解和熟知地方废物回收机构管理系统的便捷高效,不仅为用户提供了服务,而且也推广了自己,让更多的用户了解自己。对于地方废物回收机构而言,若拥有自己的系统,通过系统得到更好的管理,同时提升了形象。
本系统设计的现状和趋势,从需求、结构、数据库等方面的设计到系统的实现,分别为管理员和员工的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案,借助java编程语言和MySQL数据库等实现系统的全部功能,接下来对系统进行测试,测试系统是否有漏洞和测试用户权限来完善系统,最终系统完成达到相关标准。
关键字:地方废物回收机构管理;java;MySQL数据库
Abstract
The wide application of the network has brought very convenience to life.Therefore, the management of local waste recycling institutions is combined with the current network, and java technology is used to build the management system, and realize the informatization of local waste recycling institutions.It can play a promoting role in further improving the management and development of local waste recycling institutions and enriching the management experience of local waste recycling institutions.
The management system of local waste recycling agencies can be widely and comprehensively publicized through the Internet, so that as many users can know and know the convenience and efficiency of the local waste recycling agency management system, which not only provides services for users, but also promotes itself, so that more users can understand themselves.For local waste recycling agencies, if they have their own system, they are better managed through the system and improve their image.
The current situation and trend of the system design, from the requirements, structure, database design to the implementation of the system, are the implementation of administrators and employees respectively.The content of the paper shows the development process in terms of system design, description, implementation, analysis and testing.The system chooses a feasible development scheme according to the actual situation, using the java programming language and the MySQL database to realize all the functions, then the system to test, test whether the system has vulnerabilities and test user rights to improve the system, and finally the system meets the relevant standards.
Keywords: Local waste recycling agency management; java; MySQL database
目录
目录 III
第一章 概述 1
1.1 研究背景 1
1.2 开发意义 1
1.3 研究现状 1
1.4 研究内容 2
1.5 论文结构 2
第二章 开发技术介绍 1
2.1 系统开发平台 1
2.2 平台开发相关技术 1
2.2.1 Java技术 1
2.2.2 mysql数据库介绍 1
2.2.3 MySQL环境配置 1
2.2.4 B/S架构 2
2.2.5 SpringBoot框架 2
第三章 系统分析 1
3.1 可行性分析 1
3.1.1技术可行性 1
3.1.2操作可行性 1
3.1.3 经济可行性 1
3.2性能需求分析 1
3.3功能分析 2
第四章 系统设计 4
4.1功能结构 4
4.2 数据库设计 4
4.2.1 数据库E/R图 4
4.2.2 数据库表 5
第五章 系统功能实现 19
5.1管理员功能模块 19
5.2 员工功能模块 26
第六章 系统测试 30
第七章 总结与心得体会 31
7.1 总结 31
7.2 心得体会 31
致谢 1
参考文献 2
数据库部分设计:
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongzuorizhi`
--
DROP TABLE IF EXISTS `gongzuorizhi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongzuorizhi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`rizhibiaoti` varchar(200) DEFAULT NULL COMMENT '日志标题',
`nianfen` varchar(200) DEFAULT NULL COMMENT '年份',
`yuefen` varchar(200) DEFAULT NULL COMMENT '月份',
`riqi` date DEFAULT NULL COMMENT '日期',
`jilushijian` date DEFAULT NULL COMMENT '记录时间',
`rizhineirong` longtext COMMENT '日志内容',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1648353539874 DEFAULT CHARSET=utf8 COMMENT='工作日志';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gongzuorizhi`
--
LOCK TABLES `gongzuorizhi` WRITE;
/*!40000 ALTER TABLE `gongzuorizhi` DISABLE KEYS */;
INSERT INTO `gongzuorizhi` VALUES (41,'2022-03-27 03:46:21','日志标题1','年份1','月份1','2022-03-27','2022-03-27','日志内容1','员工工号1','员工姓名1'),(42,'2022-03-27 03:46:21','日志标题2','年份2','月份2','2022-03-27','2022-03-27','日志内容2','员工工号2','员工姓名2'),(43,'2022-03-27 03:46:21','日志标题3','年份3','月份3','2022-03-27','2022-03-27','日志内容3','员工工号3','员工姓名3'),(44,'2022-03-27 03:46:21','日志标题4','年份4','月份4','2022-03-27','2022-03-27','日志内容4','员工工号4','员工姓名4'),(45,'2022-03-27 03:46:21','日志标题5','年份5','月份5','2022-03-27','2022-03-27','日志内容5','员工工号5','员工姓名5'),(46,'2022-03-27 03:46:21','日志标题6','年份6','月份6','2022-03-27','2022-03-27','日志内容6','员工工号6','员工姓名6'),(1648353539873,'2022-03-27 03:58:58','阿斯顿是a','2022','3月份','2022-03-28','2022-03-27','<p>阿斯弗阿斯顿发士大夫撒地方阿斯蒂芬 </p><p>阿斯蒂芬阿三打算地方</p>','11','张三');
/*!40000 ALTER TABLE `gongzuorizhi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huishoujiage`
--
DROP TABLE IF EXISTS `huishoujiage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huishoujiage` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huishoudidian` varchar(200) NOT NULL COMMENT '回收地点',
`huishouwupin` varchar(200) NOT NULL COMMENT '回收物品',
`huishoujiage` int(11) NOT NULL COMMENT '回收价格',
`gengxinshijian` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1648353906723 DEFAULT CHARSET=utf8 COMMENT='回收价格';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huishoujiage`
--
LOCK TABLES `huishoujiage` WRITE;
/*!40000 ALTER TABLE `huishoujiage` DISABLE KEYS */;
INSERT INTO `huishoujiage` VALUES (151,'2022-03-27 03:46:21','回收地点1','回收物品1',1,'2022-03-27 11:46:21'),(152,'2022-03-27 03:46:21','回收地点2','回收物品2',2,'2022-03-27 11:46:21'),(153,'2022-03-27 03:46:21','回收地点3','回收物品3',3,'2022-03-27 11:46:21'),(154,'2022-03-27 03:46:21','回收地点4','回收物品4',4,'2022-03-27 11:46:21'),(155,'2022-03-27 03:46:21','回收地点5','回收物品5',5,'2022-03-27 11:46:21'),(156,'2022-03-27 03:46:21','回收地点6','回收物品6',6,'2022-03-27 11:46:21'),(1648353906722,'2022-03-27 04:05:06','阿斯蒂芬阿三','阿斯蒂芬阿三',111,'2022-03-16 00:00:00');
/*!40000 ALTER TABLE `huishoujiage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menu`
--
DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`menujson` longtext COMMENT '菜单',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='菜单';
/*!40101 SET character_set_client = @saved_cs_client */;