家庭理财系统的设计与实现VBSQL
家庭理财系统的设计与实现VB+SQL家庭理财系统的设计与实现摘要:理财系统是1 个企业或者家庭不可缺少的部分,企业很早就实施了理财的集中管理,而家庭使用的小型理财系统却只是凤毛麟角,理财是很小的 1 个部分,但大到企业,小到家庭都有10 分重要的意义。本论文介绍了家庭理财系统开发的整个过程。利用软件工程原 理,采用面向对象的编程方法,其开发主要包括后台数据库的建立、维护以及前端应用程序开发,实现了家庭理财的自动化和信息化。主要包括以下几个模 块:用户密码登陆,原始数据的汇入、修改、删除、导出等,从而实现对家庭 现金和信用卡的收入与支出进行有效、系统的管理,并使之更全面和灵活。论 文系统地分析了软件开发的背景及过程,首先介绍了软件的开发环境,其次介 绍了本软件的详细设计过程:数据库的设计以及具体界面的设计和功能,最后 对在本软件开发过程中的问题进行了总结。通过论文,可以了解到“晴空家庭 理财系统”的规划、设计过程,掌握系统的功能。 关键词:理财;收支管理; 查询;导出;软件工程The family manages finances the systemdesign andthe realization Abstract : The system of financial manage is very important to corporation and family, and it is an indispensabilitypart. As early as the corporation had focused on carry out the financial manage, however, it was rarity. Though financial manage was only a small part, but to corporation and family, it has veryimportant meaning.The thesis introduced the whole process which refer to the system of financial manage in family. Using the theory of software engineering and adopting the way of object oriented program, whose exploitation mainly includes the establishment & maintenance of back-end data-base and two facets of the process of front-end sapplication that achieve autoimmunization and information technology of the administrative systems of financial manage in family.It mainly consists of the following modules : the purview of user s system, investigating data-base and the confluence of initial data and so on, which make the availability of the cash in family into earning, or credit card out of charge, investigation and administration of systems more perfect and flexible.This thesis systematically analyzes the background and process of software s exploitation. Firstly it tells us the exploitative environment of software. Secondly it shows the process of designing the software in detail, such as the design of database and the achievement, as well as the design and functions of the concrete interface. Finally it concludes the problems that occur in the exploitative process of this software. According to read the thesis, you can realize the program in system of the Qingkong Financial Manage In Family, the progress of design and master the function of system. Keywords : Financial Manage ; Income and Expenses Managemen;t Query; Exporting ; Software Engineering 目 录摘要 1ABUSTRACT21 绪论 31.1 课题背景31.2 发展状况综述 31.3 开发背景与主要内容52 系统技术开发 62.1 可行性分析62.1.1 经济可行性 62.1.2 技术可行性和运行可行性62.2 面对对象的程序设计介绍 102.3系统开发理论介绍 112.3.1 系统规划阶段112.3.2 系统分析阶段112.3.3系统设计阶段112.3.4 系统实施阶段112.3.5 系统运行和维护阶段122.4开发设计思想122.5 运行环境123 系统规划 133.1 需求分析133.2 系统数据流图 143.3 系统结构设计和工作原理153.4 数据库设计163.4.1数据库系统概述163.4.2 数据库的基本结构 173.4.3 在 SQL Server 中创建表格 174 实现系统的详细过程194.1 界面制作194.2 数据库连接344.3功能实现简介365 系统测试和优化405.1 测试目的405.2 测试方法 405.3 测试步骤405.4 系统优化 416 结束语 42参考文献43 致谢词 44 注 : 不包括源代码.