摘 要
分布式家庭理财系统是一个经典的信息管理系统。在互联网科技日渐发达的时代下，移动支付、在线理财的产品众多，家庭消费与投资在各大平台较为分散，有一个集成化管理这些分散信息的系统变得十分必要。本系统从投资理财与家庭收支管理角度出发，以各大平台的在线交易、家庭消费、家庭投资场景为基础进行系统分析、设计与实现，从而方便各家庭成员更加高效、便捷地管理家庭财产。
本系统后端采用MySQL作为数据库并使用Java作为开发语言，基于Spring Cloud微服务应用架构实现了家庭投资理财的用户、收支、股票与基金、资产与债务、月末/年末报表微服务场景，前端主要采用Node.js，基于Ant.Design Pro实现与用户之间的友好交互。用户可通过前端进行以下操作：家庭收入、支出的记录与图形化呈现，股票、基金市场的动态查询与图形化展示和购买记录，资产与负债的记录与查询和分析呈现，月末/年末家庭整体财务状况分析与汇报。
关键词：家庭理财，分布式，MySQL，Java，微服务
ABSTRACT
Distributed family financial management system is a classic information management system. In the era of increasingly developed Internet technology, there are many products of mobile payment and online financial management, and family consumption and investment are decentralized in each major platform, so it is necessary to centrally manage these decentralized information. From the perspective of investment and financial management and family income and expenditure management, the system is analyzed, designed and implemented on the basis of online transaction, family consumption and family investment scenarios of major platforms, so as to facilitate family members to manage family property more efficiently and conveniently.
The back-end of the system mainly uses MySQL database and Java language, based on the Spring Cloud microservice application architecture to realize the micro service scenarios of family investment and financial management users, revenue and expenditure, stocks and funds, assets and liabilities, month end / year-end reports. The front-end mainly uses Node.js, and realizes friendly interaction with users based on Ant.Design Pro. Users can perform the following operations through the front end: record and graphical presentation of household income and expenditure, dynamic query and graphical display and purchase record of stock and fund market, record and query and analysis presentation of assets and liabilities, and analysis and report of the overall financial status of the family at the end of the month / the end of the year.
Key Words: Family finance, MySQL, Java, microservice
目  录
第1章 引言 1
1.1 选题背景 1
1.2 研究目标和意义 1
1.3 研究思路与内容 2
第2章 开发技术理论基础 3
2.1 相关技术介绍 3
2.2 开发工具介绍 3
第3章 系统分析与设计 5
3.1 需求分析 5
3.2 系统设计的原则 6
3.3 系统整体架构设计 7
3.4 系统模块设计 8
3.4.1 收入、支出微服务设计 8
3.4.2 股市与基金微服务设计 9
3.4.3 资产与债务微服务设计 10
3.4.4 月末、年末报表微服务设计 10
3.5 数据库与数据表设计 11
3.5.1 数据库概念结构设计 11
3.5.2 数据逻辑结构设计 14
第4章 系统实现与测试 18
4.1 开发环境与运行环境介绍 18
4.1.1 开发环境介绍 18
4.1.2 运行环境介绍 18
4.2 数据库与数据表实现 19
4.2.1 后台数据表结构 19
4.2.2 数据库表创建 20
4.3 功能模块实现 20
4.3.1 前后端总体架构搭建 20
4.3.2 收入、支出微服务实现 21
4.3.3 股市与基金微服务实现 23
4.3.4 资产与负债微服务实现 26
4.3.5 月末、年末报表微服务 28
4.4 系统测试 28
4.4.1 前端系统测试 28
4.4.2 后端系统测试 28
第5章 结论 31
参考文献 32
致谢 33
附录 34
附录一：数据库表创建详情 34
附录二：收入、支出微服务代码 42
附录三：股市与基金微服务代码 44
附录四：资产与负债微服务代码 45