I
毕业设计(论文)
办公自动化管理系统的设计与实现
学生姓名
XXX
学 号
XXXXXXXX
分院名称
XXXXXXXX
专业班级
XXXXX
指导教师
XXXX
填写日期
XXXX 年 XX 月
II
摘 要
随着计算机应用的普及、成熟，越来越多公司开始采用网上信息管理系统，网上信
息管理系统的运行可以有效的提高企业管理效率。因此，为满足企业办公管理方面的需
求，开发了办公自动化管理系统。
本文重点阐述了办公自动化管理系统的开发过程，以实际运用为开发背景，基于
SSM 框架，运用了 Java 技术和 MYSQL 作为系统数据库进行开发，充分保证系统的安
全性和稳定性。本系统界面良好，操作简单方便，通过系统概述、系统分析、系统设计、
数据库设计、系统测试这几个部分，详细的说明了系统的开发过程，最后并对整个开发
过程进行了总结，实现了办公管理的重要功能。
本系统的使用使管理人员从繁重的工作中解脱出来，实现无纸化办公，能够有效的
提高企业办公管理效率。
关键词：办公自动化管理，Java 技术，数据库，SSM 框架
III
ABSTRACT
With the popularization and maturity of computer applications, more and more
companies have begun to adopt online information management systems. The operation of
online information management systems can effectively improve corporate management
efficiency. Therefore, in order to meet the needs of corporate office management, an office
automation management system has been developed.
This article focuses on the development process of the office automation management
system, based on the actual application of the development background, based on the SSM
framework, using Java technology and MYSQL as the system database for development, fully
ensuring the security and stability of the system. The system has a good interface, simple and
convenient operation. Through the system overview, system analysis, system design, database
design, and system testing, the development process of the system is explained in detail.
Finally, the whole development process is summarized and realized An important function of
office management.
The use of this system frees managers from heavy work, realizes paperless office, and
can effectively improve the efficiency of corporate office management.
Keywords: Office automation management, Java technology, database, SSM framework
IV
目 录
1 引言.........................................................................................................................................1
1.1 课题背景.......................................................................................................................1
1.2 研究现状.......................................................................................................................1
1.3 论文结构安排...............................................................................................................2
2 系统关键技术.........................................................................................................................3
2.1 JAVA 技术 ....................................................................................................................3
2.2 B/S 结构.........................................................................................................................3
2.3 MYSQL 数据库.............................................................................................................4
2.4 SSM 框架.......................................................................................................................4
3 系统分析.................................................................................................................................6
3.1 可行性分析...................................................................................................................6
3.1.1 技术可行性.........................................................................................................6
3.1.2 经济可行性.........................................................................................................6
3.1.3 运行可行性.........................................................................................................6
3.1.4 法律可行性.........................................................................................................6
3.2 系统性能分析...............................................................................................................7
3.3 系统功能分析...............................................................................................................7
3.4 系统流程分析...............................................................................................................9
3.4.1 操作流程.............................................................................................................9
3.4.2 添加信息流程.....................................................................................................9
3.4.3 修改信息流程图...............................................................................................10
3.4.4 删除信息流程...................................................................................................10
4 系统设计...............................................................................................................................11
4.1 系统概要设计.............................................................................................................11
4.2 系统结构设计.............................................................................................................11
4.3 系统顺序图设计.........................................................................................................12
4.4 数据库设计.................................................................................................................13
4.4.1 数据库 E-R 图设计 ..........................................................................................13
4.4.2 数据库表设计...................................................................................................15
5 系统的实现...........................................................................................................................19
5.1 管理员功能模块的实现.............................................................................................19
5.1.1 管理员登录界面...............................................................................................19
5.1.2 员工管理界面...................................................................................................19
V
5.1.3 部门管理界面...................................................................................................20
5.1.4 员工档案管理界面...........................................................................................20
5.1.5 公司公告管理界面...........................................................................................21
5.1.6 员工请假管理界面...........................................................................................22
5.2 员工功能模块的实现.................................................................................................22
5.2.1 员工登录界面...................................................................................................22
5.2.2 系统主界面.......................................................................................................23
5.2.3 添加员工考勤界面...........................................................................................23
5.2.4 员工请假界面...................................................................................................24
5.3 部门功能模块的实现.................................................................................................24
5.3.1 工作内容管理界面...........................................................................................24
5.3.2 工作报表管理界面...........................................................................................25
6 系统测试...............................................................................................................................26
6.1 测试定义.....................................................................................................................26
6.2 测试方法.....................................................................................................................26
6.3 测试内容.....................................................................................................................27
6.4 测试结论.....................................................................................................................27
结论...........................................................................................................................................29
致谢...........................................................................................................................................30
参考文献...................................................................................................................................31
