基于mssqlserver的银行信贷管理系统的设计与实现计算机应用专业.docx

1、基于mssqlserver的银行信贷管理系统的设计与实现计算机应用专业基于mssqlserver的银行信贷管理系统的设计与实现计算机应用专业研究生： 指导老师：【摘要】随着银行业信息化的不断发展，银行信贷业务的管理系统建设，实现信贷业务进行管理信息化成为了当前发展趋势。课题在ASP.NET技术框架下，利用了SQL Server数据库技术，研究了针对信贷业务的管理系统。目前，所实现的银行信贷系统中，主要表现出操作不够便利、数据访问效率低等缺点，逐渐地无法适应当前银行业发展的需求。课题分析、设计、实现、测试了基于B/S模式的信贷管理系统，提供给银行如：信贷过程管理、信贷客户管理、信用评级管理、贷后

2、管理等操作功能。本文的信贷管理系统将在三层架构下运行，具有数据传输效率高、维护方便等特点，主要研究内容如下。首先，作者对银行信贷系统进行需求分析，先根据银行信贷系统的建设目标，设计了系统的用例图、系统数据流图，包括了：顶层数据、安全数据、查询数据等流程，同时，论文分析了银行信贷系统的运行性能和业务性能；其次，作者对银行信贷系统的总体架构进行设计，分析设计了系统的功能模块、功能流程、应用层次、网络拓扑结构，其次根据需求分析，具体地设计了系统的业务功能；同时，利用UML建模设计序列图和状态图的，设计了系统数据库，分别就数据库表字段信息、E-R关系图进行设计。最后，分别就设计与实现银行信贷系统的模块

3、有：信用评级管理模块、系统用户登录模块、信贷流程管理模块、授信额度管理模块、信贷客户信息管理模块、贷后信息管理模块、系统数据管理模块等，分别就模块的操作界面、功能操作代码、以及数据处理流程，进行了详细地设计与实现。本课题设计与实现的银行信贷管理系统，在浏览器下运行和操作，相对于C/S模式下的系统来说，提高了系统的可操作性、便利性，更加方便了系统的数据维护。系统的测试显示，通过系统的测试与分析，如数据添加、查询、删除等操作功能运行稳定，得出系统的测试结果，其性能与功能指标，页面响应时间均保持在200毫秒范围内，信贷管理系统的功能与运行性能，均满足业务需求，也符合通信类系统的特性需求。银行信贷管理

4、系统的研究，将在一定程度上提高银行信贷部门的业务管理水平，提高银行信贷业务操作的效率，具有较好的研究价值。关键词：银行信贷；信贷管理；数据库；B/S模式；SQL ServerDesign and Implementation of Management System for Bank credit Based on MS SQL ServerComputer ApplicationsGraduate student: Advisor: 【Abstract】With the continuous development of information technology in the banki

5、ng sector, the construction of bank credit business management system and implementation of information management for credit business have become to the current trends.The management system of credit business has been researched based on ASP.NET framework technology, and using the SQL Server databa

6、se technology in this thesis.Currently, many bank credit systems which had been realized maybe not convenient operation and low efficiency of data access.That will be not meet to the current demand of the gradually develop for the banking sector.Then in this thesis,the credit management system has b

7、een analyzed,designed,implemented and tested based on B/S mode. This system will have many functions,such as credit process management module, customer credit management module, credit rating management module, loan management module and other operations functions.Meanwhile,the credit management sys

8、tem will run under the three-tier structure,that may have high efficiency data transmission,and easy maintenance. The main contents of this thesis will be as follows.Firstly, the needs of bank credit management system have been analyzed by author.The use case diagram and data flow diagram of this sy

9、stem have been designed according to the construction objectives.The data flow diagram has included the processes of the top-level data, security data, query data etc.Meanwhile,the operation performance and business performance of the bank credit management system have been analyzed.Secondly, the ov

10、erall architecture of the bank credit management system has been designed by author.The function modules and functional processes have been designed.Then the business function modules of the system have been detailed designed in accordance with requirements analysis. Meanwhile, the database which is

11、 required for the data storing of the system has been designed.The data field information table,ER diagram and class diagram relations of the credit data have been detailed designed.Finally, the function modules of the bank credit management system have been designed and implemented,such as the user

12、s login module,credit customer information management module, management module line of credit, credit process management module, the credit rating management module, post-loan information management module, system data management module etc.The user interface,function operation code and the data pr

13、ocessing of these modules have been detailed designed and implemented.In this thesis, the bank credit management system has been designed and implemented,and this system will be running and operated based on the browser.With the respect to a system based on C/S mode,this system will have been improv

14、ed the better operability and convenience.And the function of data maintenance will been more convenient in this system.The system testing has showed that the basic function of data adding,deleting,querying and verification of system client have been implemented accurately in accordance with the fun

15、ctional testing of many users. Then,the access test of system page has showed that the page response time has been maintained in the range of 200 ms.The functional and operational performance of the credit management system have be meeting to the business needs and the communications needs of system

16、 characteristics.The research of credit management for bank will improve the level of business credit management system for bank credit departments.That has some good research value and will improve the efficiency of bank credit business operations.Keywords: Bank credit; Credit management; Database; B/S mode; SQL Server第一章 绪论论文首先研究银行信贷系统的课题研究背景，针对银行信贷系统进行国内外研究现状的分析，并对课题的研究意义进行阐述，明确地介绍了课题的主要研究内容和工作以及章节的安排。1.1 研究背景和意义1.1.1 研究背景伴随互联网和网络技术的高速发展，银行信息主管部