I
银行 OA 系统的
设计与实现
I
摘 要
在互联网信息技术时代中，企业管理更多的是使用管理系统进行智能化控制，
提高单位的核心竞争力，适应快节奏的生产活动。银行 OA 系统是为企业提供的
一整套便于企业管理的应用软件，是目前企业管理的必备系统。通过走访了解，
市面上许多现成的银行 OA 系统无法满足中小企业发展的现状，无论是系统架构
还是业务流程都比较落后，只有重新开发一套全新的银行 OA 系统才能适应企业
需求。
银行 OA 系统基于 JAVA 编写，使用 SpringBoot 架构，数据库选择轻量级的
关系型 Mysql 数据库，系统前台使用 H5、CSS3、JS 和 DIV 等技术开发。系统
包括管理员、经理、员工三个角色，分别进行员工管理、办公管理、请假管理、
任务管理等操作。本文首先阐述银行 OA 系统的背景和意义，然后对系统的技术
进行分析，接着进行系统需求分析，功能设计和系统实现，最后进行系统测试，
完善系统功能和操作流程。
关键词：银行 OA、办公自动化、员工管理、JAVA、数据库
II
Abstract
In the era of Internet information technology, enterprise management is more to
use the management system for intelligent control, improve the core competitiveness
of the unit, adapt to the fast-paced production activities. Bank OA system is a set of
application software which is convenient for enterprise management. It is a necessary
system for enterprise management. Through the visit, we know that many existing
bank OA systems on the market can not meet the current situation of the development
of small and medium-sized enterprises. Both the system architecture and business
process are relatively backward. Only by redeveloping a new bank OA system can we
meet the needs of enterprises.
Bank OA system is written based on Java, using springboot architecture, database
selection lightweight relational MySQL database, system foreground using H5, CSS3,
JS and div technology development. The system includes three roles: administrator,
manager and employee. They are responsible for employee management, office
management, leave management and task management. This paper first describes the
background and significance of bank OA system, then analyzes the technology of the
system, then analyzes the system requirements, functional design and system
implementation, and finally tests the system to improve the system function and
operation process.
Keywords: Bank OA, office automation, employee management, Java, database
III
目 录
摘 要 ............................................................................................................................I
ABSTRACT .......................................................................................................................II
第 1 章 引言..................................................................................................................1
1.1 研究动机与目的..................................................................................................1
1.2 研究意义..............................................................................................................1
1.3 国内外研究现状..................................................................................................2
第 2 章 相关技术介绍..................................................................................................4
2.1 数据库技术.........................................................................................................4
2.2 编程环境.............................................................................................................4
2.3 B/S 结构..............................................................................................................4
第 3 章 需求分析..........................................................................................................6
3.1 需求分析概述.....................................................................................................6
3.2 系统需求分析.....................................................................................................6
3.2.1 非功能性需求................................................................................................6
3.2.2 功能需求........................................................................................................7
3.3 可行性分析.......................................................................................................10
3.3.1 操作可行性..................................................................................................10
3.3.2 经济可行性..................................................................................................11
3.3.3 技术可行性..................................................................................................11
3.4 系统开发环境需求...........................................................................................11
第 4 章 系统设计........................................................................................................12
4.1 系统总体设计 ....................................................................................................12
4.1.1 界面层设计..................................................................................................12
4.1.2 数据层设计..................................................................................................12
4.1.3 业务逻辑层设计..........................................................................................12
4.2 系统功能设计 ....................................................................................................13
4.2.1 系统登录设计..............................................................................................14
4.2.2 员工管理设计..............................................................................................14
4.2.3 日常工作管理设计......................................................................................14
4.2.4 员工任务管理设计......................................................................................14
IV
4.2.5 申请管理设计..............................................................................................14
4.3 数据库设计.......................................................................................................15
4.3.1ER 图设计.....................................................................................................15
4.3.2 数据库表设计..............................................................................................15
第 5 章 系统实现........................................................................................................19
5.1 系统登录 ...........................................................................................................19
5.2 系统主界面实现 ...............................................................................................19
5.4 员工基本档案 ...................................................................................................20
5.5 部门经理管理 ...................................................................................................21
5.6 日常工作管理 ...................................................................................................22
5.7 工作任务管理 ...................................................................................................22
5.8 信息申请管理 ...................................................................................................23
第 6 章 系统测试........................................................................................................25
6.1 测试环境...........................................................................................................25
6.2 功能测试...........................................................................................................25
6.3 测试结论...........................................................................................................28
总 结............................................................................................................................29
谢 辞..........................................................................................................................30
参考文献......................................................................................................................31
