个人理财分析系统设计与实现毕业设计.doc

毕业论文 个人理财分析系统设计与实现 Personal Wealth Management System Design and Implementation 摘要 本文设计的个人理财软件是一款通过对个人（家庭）收支、资产及负债信息进行管理，提供财务分析报表的数据库访问软件。 设计按照“面向对象软件工程”的要求进行，采用PowerDesigner对系统进行分析和设计，用Visualbasic进行系统实现。使用FlexCell、DTPicker、Listbar等高级控件。创建通用数据访问模块OperatDataBase.bas。此模块规范ADO数据访问流程，只需修改连接字符串即可实现对多种不同数据库系统的访问。通过对计算账户余额算法的研究，我掌握了利用SQL语句进行数据库访问的技巧。 本论文实现的个人理财软件可完成收支记账管理、资产、负债管理、数据导出、多账簿多用户操作及各种财务报表的自动生成。在各种常用Windows操作系统下都可以正常工作,达到了预期的设计目标。 关键字：数据库，ADO， Visual Basic，理财 Personal Wealth Management System Design and Implementation Abstract This design is a personal wealth management software through manage the information of a family’s income and expenditure, assets and liabilities to provide financial analysis statements and database access software. Designed in accordance with the object-oriented software engineering requirements, uses PowerDesigner to carry on the analysis and the design the system, the system Execution is through Visualbasic. Use FlexCell, DTPicker, Listbar and other High-level controls software. Then founds the general data accessing module: OperatDataBase.bas. This module Standard the Process of ADO data access, only a modification of the connection character string then to realize a visit of many kinds of different databases system. By calculating account balances algorithm research, I have grasped the skill of using the SQLsentence to visit database. In this paper, personal wealth management software to achieve complete revenue expenditure account management, asset-liability management, data derived, and multi-accounts books of operation and the automatic generation of financial statements. It can work commonly under each kind of Windows operating system so it can achieve the anticipated design. Key word: Database，ADO， Visual Basic，Personal financing 目录 摘要 I Abstract II 目录 III 第一章 绪论 1 1.1 什么是个人(家庭)理财 1 1.2 个人理财分析中最重要的四份财务报表 1 1.3 常见个人理财软件分析 2 第二章 系统功能介绍 3 2.1 系统简介 3 2.2 系统主要功能 3 2.3 系统特点 4 2.4 系统运行界面 4 第三章 系统设计 7 3.1 系统需求分析 7 3.2 系