毕 业 设 计（论 文）
题目：基于 java web 个人财务管理系统
I
摘 要
随着软件信息技术的兴起，许多手工作业也升级为软件管理数据，本次针对
个人财务数据的管理，开发一款个人财务管理系统，该系统可以解决许多信息管
理上面的难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。
这次开发的个人财务管理系统对收支信息，公告信息，还贷信息进行综合管
理，系统也能统计并分析收入与支出方面的数据信息等。经过前面自己查阅的网
络知识，加上自己在学校课堂上学习的知识，决定开发系统选择 B/S 模式这种高
效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网站访
问，采用的主流的 Java 语言这种面向对象的语言进行个人财务管理系统程序的
开发，在数据库的选择上面，选择功能强大的 MySQL 数据库进行数据的存放操
作。
个人财务管理系统运用于实际生活，不仅让财务数据的管理时间缩短，数据
检索容易，也能让各种财务数据的统计结果更加简洁易懂。
关键词：个人财务管理系统；收支管理；还贷助手；报表
II
Abstract
With the rise of software information technology, many manual operations have
also been upgraded to software management data. This time, a personal financial
management system has been developed for the management of college students'
personal financial data. This system can solve many problems in information
management, such as the long processing time of data and the failure to correct errors
in data in time.
The personal financial management system developed this time comprehensively
manages the income and expenditure information, announcement information and
loan repayment information. The system can also count and analyze the data
information of income and expenditure. After consulting the network knowledge and
learning in the school classroom, I decided to choose B/S mode to complete the
system function development. This mode allows the operator to visit the website
based on the browser. The mainstream Java language, an object-oriented language, is
used to develop the personal financial management system program. In terms of
database selection, the powerful MySQL database is selected for data storage.
The application of personal financial management system in real life not only
shortens the management time of financial data, makes data retrieval easy, but also
makes the statistical results of various financial data more concise and
understandable.
Key Words ： Personal financial management system; Revenue and expenditure
management; Loan repayment assistant; report form
III
目 录
摘 要................................................I
ABSTRACT ............................................II
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 研究现状 .........................................................................................................2
1.4 论文结构安排 .................................................................................................2
2 相关技术............................................4
2.1 JSP 技术介绍 ...................................................................................................4
2.2 B/S 架构介绍 ...................................................................................................4
2.3 MYSQL 数据库介绍........................................................................................5
2.4 JAVA 语言介绍 ...............................................................................................6
3 系统分析............................................7
3.1 系统可行性分析 ..............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 ..................................................................................................8
3.2.1 系统安全性 ..........................................................................................8
3.2.2 数据完整性 ..........................................................................................8
3.2.3 系统可扩展性 .......................................................................................9
3.3 系统流程分析 ..................................................................................................9
3.3.1 系统登录流程 .....................................................................................10
3.3.2 信息添加流程 .....................................................................................11
3.3.3 信息删除流程 .....................................................................................11
IV
3.4 系统功能分析 ................................................................................................12
4 系统设计...........................................15
4.1 系统概要设计 ................................................................................................15
4.2 系统功能结构设计 ........................................................................................15
4.3 数据库设计 ....................................................................................................16
4.3.1 数据库 E-R 图设计.............................................................................16
4.3.2 数据库表结构设计 ............................................................................19
5 系统实现...........................................22
5.1 管理员功能介绍 ............................................................................................22
5.1.1 学生管理 .............................................................................................22
5.1.2 公告信息管理 ....................................................................................22
5.1.3 收支管理管理 ....................................................................................23
5.1.4 还贷助手管理 .....................................................................................24
5.1.5 公告类型管理 .....................................................................................24
5.1.6 收支类型管理 .....................................................................................25
5.2 学生用户功能介绍 .......................................................................................25
5.2.1 收支管理 .............................................................................................25
5.2.2 公告管理 .............................................................................................26
5.2.3 还贷助手管理 .....................................................................................26
6 系统测试 ...........................................28
6.1 本系统测试 .................................................................................................28
6.1.1 登录功能测试 .....................................................................................28
6.1.2 修改密码功能测试 .............................................................................29
6.1.3 登记收支类型功能测试 .....................................................................31
6.1.4 增加公告信息功能测试 .....................................................................32
6.2 测试结果分析 ................................................................................................33
结 论...............................................35
参考文献.............................................37
