银行保险销售台账管理系统的设计与实现.doc

摘要
　　　银行保险是银行与保险两大金融行业融合的产物，是银行和保险公司在90年代中期开始的新型合作形式，是在金融服务融合和金融服务一体化的基础上发展起来的，是对银行资产负债业务的重要补充。近年来银行代理保险业务持续快速增长，2010年全国银保渠道保费收入已达3503.79亿元，占保险业保费总量的71.29%，成为保险公司保险销售的三大渠道之首，也成为银行重要的中间业务收入来源。
　　　但在银行保险销售业务高速增长的同时，如何利用计算机技术准确统计银行代理保险的销售数据，实现不同公司、不同产品的纬度统计分析，及时通报销售情况，并以此作为银行营业网点绩效考核，资源分配的重要依据日益成为商业银行需要解决的一个重要问题。
　　　本文正是结合实际工作流程，使用ASP动态网页技术作为开发平台，应用软件工程方法，采用三层架构体系和SQL Server数据库系统等计算机技术，结合B/S实现模式，在对建设银行基层网点代理销售保险业务流程进行充分研究的前提下，设计开发一套银行保险销售台账管理系统，实现银行营业网点代理保险销售业务数据及时、准确、高效地统计汇总，以提高管理效率和质量，节约人力资源，为经营决策和资源分配提供支持。同时考虑到该系统的实用性及可拓展性，在系统需求分析及设计环节，采用台账定义通用模块，以增加该软件良好的适用性及可扩展性。
　　　出于操作方便性考虑，系统的实现采用了B/S模式，即数据的录入操作在客户端操作，服务器只用来保存数据；管理人员和需要查阅信息的终端通过浏览器即可完成操作，无需安装额外的软件。
　　　在组织结构上，本文首先介绍论文研究背景、选题意义及系统的特点，对开发工具、体系结构、开发方法和系统开发运行平台进行了简单介绍。其次从业务需求、功能需求及其他需求三个方面对系统需求进行详细分析，设计部分从系统目标、原则着手，提出系统的总体架构设计方案，然后结合业务需求，在系统总体架构下，分别对七个子系统进行详细地分析和设计，最后对论文进行总结，对系统的进一步完善提出展望。
　　　
　　　关键词：银行保险；台账；管理系统
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 国内外现状 2
1.3 论文研究的主要内容 3
1.4论文的组织结构安排 3
第二章 相关技术介绍 5
2.1 B/S结构 5
2.2 ASP动态网页技术 7
2.3 Microsoft SQL Server数据库系统 8
2.4 JavaScript 8
2.5 IIS 9
2.6 小结 9
第三章 系统需求分析 10
3.1 业务需求分析 10
3.1.1 银行保险销售管理流程分析 10
3.1.2 业务流程存在的可通过计算机技术解决或改进的问题及对策分析 13
3.1.3 其他通用台账需求 15
3.2 系统功能需求分析 15
3.2.1 系统功能划分 15
3.2.2 身份验证子系统需求分析 16
3.2.3 数据录入子系统需求分析 16
3.2.4 查询统计子系统需求分析 17
3.2.5 用户管理子系统需求分析 18
3.2.6 机构管理子系统需求分析 19
3.2.7 台账定义子系统需求分析 20
3.2.8 信息发布 21
3.3 系统的其他需求 22
3.4 小结 22
第四章 系统总体设计 23
4.1 设计目标 23
4.2 设计原则 23
4.3 总体结构 24
4.3.1 系统物理架构 24
4.3.2 系统软件架构 24
4.4 小结 25
第五章 系统详细设计 26
5.1 身份验证子系统的设计与实现 26
5.1.2 用户登录 26
5.1.3 更改密码 29
5.1.4 重置密码 31
5.2 台账定义子系统的设计与实现 31
5.2.1 台账定义的属性 32
5.2.2 台账字段的属性 33
5.2.3 台账定义子系统的处理流程 36
5.3 数据录入子系统的设计与实现 37
5.4 查询统计子系统的设计与实现 39
5.4.1 按机构查询 39
5.4.2 按关键字查询 41
5.4.3 按条件查询 42
5.5 用户管理子系统的设计与实现 42
5.6 机构管理子系统的设计与实现 44
5.7 信息发布子系统的设计与实现 46
5.8 小结 47
第六章 总结及展望 48
6.1 总结 48
6.2 展望 48
参考文献 50
致谢 51