家庭理財系統的設計與實現
摘要：理財系統是1個企業或者家庭不可缺少的部分，企業很早就實施了理財的集中管理，而家庭使用的小型理財系統卻只是鳳毛麟角，理財是很小的1個部分，但大到企業，小到家庭都有10分重要的意義。
本論文介紹了家庭理財系統開發的整個過程。利用軟體工程原理，採用物件導向的'程式設計方法，其開發主要包括後臺資料庫的建立、維護以及前端應用程式開發，實現了家庭理財的自動化和資訊化。
主要包括以下幾個模組：使用者密碼登陸，原始資料的匯入、修改、刪除、匯出等，從而實現對家庭現金和信用卡的收入與支出進行有效、系統的管理，並使之更全面和靈活。
論文系統地分析了軟體開發的背景及過程，首先介紹了軟體的開發環境，其次介紹了本軟體的詳細設計過程：資料庫的設計以及具體介面的設計和功能，最後對在本軟體開發過程中的問題進行了總結。
通過論文，可以瞭解到“晴空家庭理財系統”的規劃、設計過程，掌握系統的功能。
關鍵詞：理財；收支管理；查詢；匯出；軟體工程
The family manages finances the system
design and the realization
Abstract：The system of financial manage is very important to corporation and family, and it is an indispensability part. 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 very important 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’s application 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 Management；Query；Exporting；Software Engineering
目 錄
摘要 1
ABUSTRACT 2
1 緒論 3
1.1 課題背景 3
1.2 發展狀況綜述 3
1.3 開發背景與主要內容 5
2 系統技術開發 6
2.1 可行性分析 6
2.1.1 經濟可行性 6
2.1.2 技術可行性和執行可行性 6
2.2 面對物件的程式設計介紹 10
2.3 系統開發理論介紹 11
2.3.1 系統規劃階段 11
2.3.2 系統分析階段 11
2.3.3 系統設計階段 11
2.3.4 系統實施階段 11
2.3.5 系統執行和維護階段 12
2.4 開發設計思想 12
2.5 執行環境 12
3 系統規劃 13
3.1 需求分析 13
3.2 系統資料流圖 14
3.3 系統結構設計和工作原理 15
3.4 資料庫設計 16
3.4.1 資料庫系統概述 16
3.4.2 資料庫的基本結構 17
3.4.3 在SQL Server中建立表格 17
4 實現系統的詳細過程 19
4.1 介面製作 19
4.2 資料庫連線 34
4.3 功能實現簡介 36
5 系統測試和優化 40
5.1 測試目的 40
5.2 測試方法 40
5.3 測試步驟 40
5.4 系統優化 41
6 結束語 42
參考文獻 43
致謝詞 44
注:不包括原始碼.
