毕 业 设 计（论 文）
题目：小型企业办公自动化系统的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对小型企业办公信息管理混乱，出错率高，信息安全性差，
劳动强度大，费时费力等问题，采用小型企业办公自动化系统可以有效管理，使
信息管理能够更加科学和规范。
小型企业办公自动化系统在 Eclipse 环境中，使用 Java 语言进行编码，使用
Mysql 创建数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，
其管理员管理部门经理，管理总经理，管理员工和员工留言以及员工工资，管理
内部邮件，管理审批流程，管理离职申请。部门经理给员工发放工资，审核并回
复员工留言，管理员工工资，审核员工的离职申请信息，查询和下载内部邮件以
及审批流程。总经理查询下载内部邮件和审批流程，审核员工离职申请，查询员
工工资，查询员工和部门经理。员工发布留言，发布内部邮件，发布离职申请，
查询通知公告和审批流程，查看员工本人工资。
总之，小型企业办公自动化系统集中管理信息，有着保密性强，效率高，存
储空间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机
化。
关键词：小型企业办公自动化系统；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic management of office
information of small enterprises, high error rate, poor information security, high labor
intensity, and time-consuming and labor-intensive issues, the use of small enterprise
office automation systems can be effectively managed, and information management
can be more scientific and standardized.
The office automation system for small enterprises uses Java language for coding
in the Eclipse environment, and uses Mysql to create data tables to save the data
generated by the system. The system can provide information display and
corresponding services. The administrator manages department managers, manages
general managers, manages staff and staff messages and staff salaries, manages
internal mail, manages the approval process, and manages resignation applications.
Department managers pay employees wages, review and reply to employee messages,
manage employee wages, review employee resignation application information, query
and download internal emails and approval procedures. The general manager inquires
about downloading internal emails and approval procedures, reviews employee
resignation applications, inquires about employee salary, and inquires about
employees and department managers. Employees post messages, post internal emails,
post resignation applications, query notice announcements and approval procedures,
and check their own salaries.
In short, the office automation system of small enterprises centralizes
management information, which has many advantages such as strong confidentiality,
high efficiency, large storage space, and low cost. It can reduce the cost of
information management and realize the computerization of information management.
Key Words：Small business office automation system; Java language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
2.4 VUE 框架 ..........................................................................................................4
第 3 章 系统分析.......................................6
3.1 可行性分析 .....................................................................................................6
3.1.1 技术可行性 ..........................................................................................6
3.1.2 经济可行性 ..........................................................................................6
3.1.3 操作可行性 ..........................................................................................6
3.2 系统流程 .........................................................................................................7
3.2.1 操作流程 ..............................................................................................7
3.2.2 登录流程 ..............................................................................................7
3.2.3 删除信息流程 ......................................................................................8
3.2.4 添加信息流程 ......................................................................................9
3.3 性能需求 .........................................................................................................9
3.4 功能需求 .......................................................................................................10
第 4 章 系统设计......................................15
4.1 设计原则 .......................................................................................................15
4.2 功能结构设计 ...............................................................................................15
4.3 数据库设计 ...................................................................................................17
IV
4.3.1 数据库概念设计 ................................................................................18
4.3.2 数据库物理设计 ................................................................................21
第 5 章 系统实现......................................26
5.1 管理员功能实现 ...........................................................................................26
5.1.1 部门经理管理 ....................................................................................26
5.1.2 总经理管理 ........................................................................................26
5.1.3 审批流程管理 ....................................................................................27
5.1.4 通知公告管理 ....................................................................................27
5.2 部门经理功能实现 .......................................................................................28
5.2.1 员工管理 ............................................................................................28
5.2.2 员工留言管理 ....................................................................................28
5.2.3 员工工资管理 ....................................................................................29
5.3 总经理功能实现 ...........................................................................................29
5.3.1 审批流程管理 ....................................................................................29
5.3.2 离职申请管理 ....................................................................................30
5.3.3 内部邮件管理 ....................................................................................30
5.4 员工功能实现 ...............................................................................................31
5.4.1 新增留言 ............................................................................................31
5.4.2 员工工资管理 ....................................................................................31
5.4.3 新增内部邮件 ....................................................................................32
第 6 章 系统测试......................................33
6.1 功能测试 .......................................................................................................33
6.1.1 登录功能测试 ....................................................................................33
6.1.2 修改密码功能测试 ............................................................................34
6.2 测试结果 .......................................................................................................34
结 论...............................................35
致 谢...............................................36
参考文献.............................................37
