设计题目：固定资产管理系统的设计与实现
I
摘 要
网络技术和计算机技术发展至今，已经拥有了深厚的理论基础，并在现实中
进行了充分运用，尤其是基于计算机运行的软件更是受到各界的关注。加上现在
人们已经步入信息时代，所以对于信息的宣传和管理就很关键。因此固定资产信
息的管理计算机化，系统化是必要的。设计开发固定资产管理系统不仅会节约人
力和管理成本，还会安全保存庞大的数据量，对于固定资产信息的维护和检索也
不需要花费很多时间，非常的便利。
固定资产管理系统是在 MySQL 中建立数据表保存信息，运用 SSM 框架和
Java 语言编写。并按照软件设计开发流程进行设计实现。系统具备友好性且功能
完善。管理员管理资产，资产折旧，资产维修，资产报废等信息。员工查询资产，
查询资产折旧，资产维修，资产报废信息。
固定资产管理系统在让固定资产信息规范化的同时，也能及时通过数据输入
的有效性规则检测出错误数据，让数据的录入达到准确性的目的，进而提升固定
资产管理系统提供的数据的可靠性，让系统数据的错误率降至最低。
关键词：固定资产管理系统；MySQL；SSM 框架
II
Abstract
Network technology and computer technology have developed so far, they
already have a solid theoretical foundation and have been fully used in reality,
especially the software based on computer operation has attracted the attention of all
walks of life. In addition, now that people have entered the information age, the
promotion and management of information is very important. Therefore, it is
necessary to computerize and systemize the management of fixed asset information.
The design and development of a fixed asset management system will not only save
manpower and management costs, but also store a huge amount of data safely. The
maintenance and retrieval of fixed asset information does not require a lot of time,
which is very convenient.
The fixed asset management system is to establish a data table in MySQL to save
the information, using the SSM framework and Java language to write. And in
accordance with the software design and development process for design and
implementation. The system is friendly and fully functional. The administrator
manages assets, asset depreciation, asset maintenance, asset retirement and other
information. Employees inquire about assets, inquire about asset depreciation, asset
maintenance, and asset retirement information.
While the fixed asset management system standardizes the fixed asset
information, it can also detect incorrect data in a timely manner through the validity
rules of data input, so that the data entry can achieve the purpose of accuracy, thereby
improving the reliability of the data provided by the fixed asset management system ,
To minimize the error rate of system data.
Key Words：Fixed asset management system; MySQL; SSM framework
III
目 录
1 绪论 ...............................................1
1.1 选题背景 .........................................................................................................1
1.2 选题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
2 系统开发技术........................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 SSM 框架 .........................................................................................................3
2.3 MYSQL 数据库 ...............................................................................................4
3 系统分析............................................5
3.1 可行性研究 ......................................................................................................5
3.1.1 经济可行性 ...........................................................................................5
3.1.2 时间可行性 ...........................................................................................5
3.1.3 操作可行性 ...........................................................................................5
3.2 系统性能分析 ..................................................................................................6
3.2.1 系统易用性 ...........................................................................................6
3.2.2 系统健壮性 ...........................................................................................6
3.2.3 系统安全性 ...........................................................................................6
3.3 系统流程分析 .................................................................................................6
3.4 系统功能分析 ..................................................................................................8
4 系统设计...........................................11
4.1 系统目标 ........................................................................................................11
4.2 功能结构设计 ................................................................................................12
4.3 数据库设计 ....................................................................................................13
4.3.1 数据库 E-R 图.....................................................................................13
4.3.2 数据库表结构 ....................................................................................16
IV
5 系统实现...........................................19
5.1 管理员功能实现 ...........................................................................................19
5.1.1 资产维修管理 ....................................................................................19
5.1.2 资产折旧管理 ....................................................................................19
5.1.3 资产管理 ............................................................................................20
5.1.4 员工管理 ............................................................................................20
5.2 员工功能实现 ...............................................................................................21
5.2.1 查询资产维修 ....................................................................................21
5.2.2 查询资产折旧 ....................................................................................21
5.2.3 查询资产 ............................................................................................22
6 系统测试 ...........................................23
6.1 系统测试的类型 ...........................................................................................23
6.2 功能测试 .......................................................................................................24
6.3 可用性测试 ...................................................................................................24
6.4 测试结果分析 ...............................................................................................24
结 论...............................................25
参考文献.............................................27
致 谢...............................................28
