摘要
　　　銀行保險(xiǎn)是銀行與保險(xiǎn)兩大金融行業(yè)融合的產(chǎn)物，是銀行和保險(xiǎn)公司在90年代中期開(kāi)始的新型合作形式，是在金融服務(wù)融合和金融服務(wù)一體化的基礎(chǔ)上發(fā)展起來(lái)的，是對(duì)銀行資產(chǎn)負(fù)債業(yè)務(wù)的重要補(bǔ)充。近年來(lái)銀行代理保險(xiǎn)業(yè)務(wù)持續(xù)快速增長(zhǎng)，2010年全國(guó)銀保渠道保費(fèi)收入已達(dá)3503.79億元，占保險(xiǎn)業(yè)保費(fèi)總量的71.29%，成為保險(xiǎn)公司保險(xiǎn)銷售的三大渠道之首，也成為銀行重要的中間業(yè)務(wù)收入來(lái)源。
　　　但在銀行保險(xiǎn)銷售業(yè)務(wù)高速增長(zhǎng)的同時(shí)，如何利用計(jì)算機(jī)技術(shù)準(zhǔn)確統(tǒng)計(jì)銀行代理保險(xiǎn)的銷售數(shù)據(jù)，實(shí)現(xiàn)不同公司、不同產(chǎn)品的緯度統(tǒng)計(jì)分析，及時(shí)通報(bào)銷售情況，并以此作為銀行營(yíng)業(yè)網(wǎng)點(diǎn)績(jī)效考核，資源分配的重要依據(jù)日益成為商業(yè)銀行需要解決的一個(gè)重要問(wèn)題。
　　　本文正是結(jié)合實(shí)際工作流程，使用ASP動(dòng)態(tài)網(wǎng)頁(yè)技術(shù)作為開(kāi)發(fā)平臺(tái)，應(yīng)用軟件工程方法，采用三層架構(gòu)體系和SQL Server數(shù)據(jù)庫(kù)系統(tǒng)等計(jì)算機(jī)技術(shù)，結(jié)合B/S實(shí)現(xiàn)模式，在對(duì)建設(shè)銀行基層網(wǎng)點(diǎn)代理銷售保險(xiǎn)業(yè)務(wù)流程進(jìn)行充分研究的前提下，設(shè)計(jì)開(kāi)發(fā)一套銀行保險(xiǎn)銷售臺(tái)賬管理系統(tǒng)，實(shí)現(xiàn)銀行營(yíng)業(yè)網(wǎng)點(diǎn)代理保險(xiǎn)銷售業(yè)務(wù)數(shù)據(jù)及時(shí)、準(zhǔn)確、高效地統(tǒng)計(jì)匯總，以提高管理效率和質(zhì)量，節(jié)約人力資源，為經(jīng)營(yíng)決策和資源分配提供支持。同時(shí)考慮到該系統(tǒng)的實(shí)用性及可拓展性，在系統(tǒng)需求分析及設(shè)計(jì)環(huán)節(jié)，采用臺(tái)賬定義通用模塊，以增加該軟件良好的適用性及可擴(kuò)展性。
　　　出于操作方便性考慮，系統(tǒng)的實(shí)現(xiàn)采用了B/S模式，即數(shù)據(jù)的錄入操作在客戶端操作，服務(wù)器只用來(lái)保存數(shù)據(jù)；管理人員和需要查閱信息的終端通過(guò)瀏覽器即可完成操作，無(wú)需安裝額外的軟件。
　　　在組織結(jié)構(gòu)上，本文首先介紹論文研究背景、選題意義及系統(tǒng)的特點(diǎn)，對(duì)開(kāi)發(fā)工具、體系結(jié)構(gòu)、開(kāi)發(fā)方法和系統(tǒng)開(kāi)發(fā)運(yùn)行平臺(tái)進(jìn)行了簡(jiǎn)單介紹。其次從業(yè)務(wù)需求、功能需求及其他需求三個(gè)方面對(duì)系統(tǒng)需求進(jìn)行詳細(xì)分析，設(shè)計(jì)部分從系統(tǒng)目標(biāo)、原則著手，提出系統(tǒng)的總體架構(gòu)設(shè)計(jì)方案，然后結(jié)合業(yè)務(wù)需求，在系統(tǒng)總體架構(gòu)下，分別對(duì)七個(gè)子系統(tǒng)進(jìn)行詳細(xì)地分析和設(shè)計(jì)，最后對(duì)論文進(jìn)行總結(jié)，對(duì)系統(tǒng)的進(jìn)一步完善提出展望。
　　　
　　　關(guān)鍵詞：銀行保險(xiǎn)；臺(tái)賬；管理系統(tǒng)
Abstract
　　　Bank Insurance is the fusion of banking and insurance. It is a new cooperation form between banks and insurance which began in the mid-1990s, and developed from the financial services integration. It is also an important complement to liability business. The bank insurance agency businesses in recent years increase rapidly. In 2010, bank insurance premium income reached 350.379 billion yuan, accounting for 71.29% of the total insurance premiums. It has become the first of the three marketing channels of insurance company and also the income source of bank’s intermediate business
　　　However, while the rapid growth of bank insurance sales, many problems arose, such as how to use computer technology to add up accurate statistics on bank insurance agency sales data, to realize latitude statistical analysis for different products in different companies, to report timely information about sales. The method of solving these problems has become an important issue for checking the performance appraisal of bank branches and allocating resources
　　　With the actual workflow, using ASP dynamic web technology as a development platform, applying software engineering approach, the three-tier system and SQL Server database system, such as computer technology, combined with the B / S mode, the grass-roots network in the Construction Bank selling insurance business processes as prerequisites of our study, we try to design a set of bank insurance sales ledger management system , so that we can get bank branches agent insurance sales data timely, improve management efficiency and quality and provide support for business decision-making and resource allocation. And at the same time, taking into account the practicality and scalability of the system, we use the ledger definition of generic modules to increase the applicability of the software system during the process of design and analysis of the system requirements
　　　Taking into account of the convenience in implementation of the system we used the B/S mode, i.e. through data entry operation, the server is only used to save the data; terminal management and access to information through a browser to complete the operation, without having to install additional software.
　　　In terms of structure, this dissertation first introduces the thesis researching background, the significance of the topic, the development tools, structure, development methodologies and system development, operation platform, followed by business requirements, functional requirements and other needs of three detailed analysis of aspects of system requirements. Then it briefly introduces the design part of the system goals, principles, proceed with proposed overall system structure design. And then combined with business needs, we put forward the overall system structure, detail analysis and design of seven subsystems. And finally the dissertation summarizes the prospect the further improvement of the system.
　　　Keywords: Bank Insurance; Agency; Management System
目　　錄
第一章 引言 1
1.1 研究背景及選題意義 1
1.1.1 研究背景 1
1.1.2 選題意義 2
1.2 國(guó)內(nèi)外現(xiàn)狀 2
1.3 論文研究的主要內(nèi)容 3
1.4論文的組織結(jié)構(gòu)安排 3
第二章 相關(guān)技術(shù)介紹 5
2.1 B/S結(jié)構(gòu) 5
2.2 ASP動(dòng)態(tài)網(wǎng)頁(yè)技術(shù) 7
2.3 Microsoft SQL Server數(shù)據(jù)庫(kù)系統(tǒng) 8
2.4 JavaScript 8
2.5 IIS 9
2.6 小結(jié) 9
第三章 系統(tǒng)需求分析 10
3.1 業(yè)務(wù)需求分析 10
3.1.1 銀行保險(xiǎn)銷售管理流程分析 10
3.1.2 業(yè)務(wù)流程存在的可通過(guò)計(jì)算機(jī)技術(shù)解決或改進(jìn)的問(wèn)題及對(duì)策分析 13
3.1.3 其他通用臺(tái)賬需求 15
3.2 系統(tǒng)功能需求分析 15
3.2.1 系統(tǒng)功能劃分 15
3.2.2 身份驗(yàn)證子系統(tǒng)需求分析 16
3.2.3 數(shù)據(jù)錄入子系統(tǒng)需求分析 16
3.2.4 查詢統(tǒng)計(jì)子系統(tǒng)需求分析 17
3.2.5 用戶管理子系統(tǒng)需求分析 18
3.2.6 機(jī)構(gòu)管理子系統(tǒng)需求分析 19
3.2.7 臺(tái)賬定義子系統(tǒng)需求分析 20
3.2.8 信息發(fā)布 21
3.3 系統(tǒng)的其他需求 22
3.4 小結(jié) 22
第四章 系統(tǒng)總體設(shè)計(jì) 23
4.1 設(shè)計(jì)目標(biāo) 23
4.2 設(shè)計(jì)原則 23
4.3 總體結(jié)構(gòu) 24
4.3.1 系統(tǒng)物理架構(gòu) 24
4.3.2 系統(tǒng)軟件架構(gòu) 24
4.4 小結(jié) 25
第五章 系統(tǒng)詳細(xì)設(shè)計(jì) 26
5.1 身份驗(yàn)證子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 26
5.1.2 用戶登錄 26
5.1.3 更改密碼 29
5.1.4 重置密碼 31
5.2 臺(tái)賬定義子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 31
5.2.1 臺(tái)賬定義的屬性 32
5.2.2 臺(tái)賬字段的屬性 33
5.2.3 臺(tái)賬定義子系統(tǒng)的處理流程 36
5.3 數(shù)據(jù)錄入子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 37
5.4 查詢統(tǒng)計(jì)子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 39
5.4.1 按機(jī)構(gòu)查詢 39
5.4.2 按關(guān)鍵字查詢 41
5.4.3 按條件查詢 42
5.5 用戶管理子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 42
5.6 機(jī)構(gòu)管理子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 44
5.7 信息發(fā)布子系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 46
5.8 小結(jié) 47
第六章 總結(jié)及展望 48
6.1 總結(jié) 48
6.2 展望 48
參考文獻(xiàn) 50
致謝 51