个人理财分析系统设计与实现论文

毕业论文

个人理财分析系统设计与实现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系统性能要求 (7)

3.3硬件配置要求 (7)

3.4软件开发所需软件配置要求 (8)

3.5系统结构设计图 (9)

3.6数据库分析设计 (9)

3.6.1 系统E-R图 (11)

3.6.2 数据字典 (12)

3.6.3 创建表关系 (14)

3.6.4 创建查询 (15)

第四章系统实现 (18)

4.1系统主界面 (18)

4.1.1 创建工程项目 (18)

4.1.2 创建系统主窗体 (19)

4.1.3 主窗口菜单 (21)

4.2公用模块 (23)

4.2.1 OperatDataBase.bas (23)

4.2.2 PublicVar.bas (23)

4.3ADO数据访问技术 (24)

4.3.1 从 Microsoft Visual Basic 引用 ADO 的步骤 (24)

4.3.2 在 Visual Basic 中创建 ADO 对象 (25)

4.4F LEX C ELL表格控件 (25)