银行信贷系统

1基于mssqlserver的银行信贷管理系统的设计与实现计算机应用专业研究生：指导老师：【摘要】随着银行业信息化的不断发展，银行信贷业务的管理系统建设，实现信贷业务进行管理信息化成为了当前发展趋势。课题在ASP.NET技术框架下，利用了SQLServer数据库技术，研究了针对信贷业务的管理系统。目前，所实现的银行信贷系统中，主要表现出操作不够便利、数据访问效率低等缺点，逐渐地无法适应当前银行业发展的需求。课题分析、设计、实现、测试了基于B/S模式的信贷管理系统，提供给银行如：信贷过程管理、信贷客户管理、信用评级管理、贷后管理等操作功能。本文的信贷管理系统将在三层架构下运行，具有数据传输效率高、维护方便等特点，主要研究内容如下。首先，作者对银行信贷系统进行需求分析，先根据银行信贷系统的建设目标，设计了系统的用例图、系统数据流图，包括了：顶层数据、安全数据、查询数据等流程，同时，论文分析了银行信贷系统的运行性能和业务性能；其次，作者对银行信贷系统的总体架构进行设计，分析设计了系统的功能模块、功能流程、应用层次、网络拓扑结构，其次根据需求分析，具体地设计了系统的业务功能；同时，利用UML建模设计序列图和状态图的，设计了系统数据库，分别就数据库表字段信息、E-R关系图进行设计。最后，分别就设计与实现银行信贷系统的模块有：信用评级管理模块、系统用户登录模块、信贷流程管理模块、授信额度管理模块、信贷客户信息管理模块、贷后信息管理模块、系统数据管理模块等，分别就模块的操作界面、功能操作代码、以及数据处理流程，进行了详细地设计与实现。本课题设计与实现的银行信贷管理系统，在浏览器下运行和操作，相对于C/S模式下的系统来说，提高了系统的可操作性、便利性，更加方便了系统的数据维护。系统的测试显示，通过系统的测试与分析，如数据添加、查询、删除等操作功能运行稳定，得出系统的测试结果，其性能与功能指标，页面响应时间均保持在200毫秒范围内，信贷管理系统的功能与运行性能，均满足业务需2求，也符合通信类系统的特性需求。银行信贷管理系统的研究，将在一定程度上提高银行信贷部门的业务管理水平，提高银行信贷业务操作的效率，具有较好的研究价值。关键词：银行信贷；信贷管理；数据库；B/S模式；SQLServer3DesignandImplementationofManagementSystemforBankcreditBasedonMSSQLServerComputerApplicationsGraduatestudent:Advisor:【Abstract】Withthecontinuousdevelopmentofinformationtechnologyinthebankingsector,theconstructionofbankcreditbusinessmanagementsystemandimplementationofinformationmanagementforcreditbusinesshavebecometothecurrenttrends.ThemanagementsystemofcreditbusinesshasbeenresearchedbasedonASP.NETframeworktechnology,andusingtheSQLServerdatabasetechnologyinthisthesis.Currently,manybankcreditsystemswhichhadbeenrealizedmaybenotconvenientoperationandlowefficiencyofdataaccess.Thatwillbenotmeettothecurrentdemandofthegraduallydevelopforthebankingsector.Theninthisthesis,thecreditmanagementsystemhasbeenanalyzed,designed,implementedandtestedbasedonB/Smode.Thissystemwillhavemanyfunctions,suchascreditprocessmanagementmodule,customercreditmanagementmodule,creditratingmanagementmodule,loanmanagementmoduleandotheroperationsfunctions.Meanwhile,thecreditmanagementsystemwillrununderthethree-tierstructure,thatmayhavehighefficiencydatatransmission,andeasymaintenance.Themaincontentsofthisthesiswillbeasfollows.Firstly,theneedsofbankcreditmanagementsystemhavebeenanalyzedbyauthor.Theusecasediagramanddataflowdiagramofthissystemhavebeendesignedaccordingtotheconstructionobjectives.Thedataflowdiagramhasincludedtheprocessesofthetop-leveldata,securitydata,querydataetc..Meanwhile,theoperationperformanceandbusinessperformanceofthebankcreditmanagementsystemhavebeenanalyzed.Secondly,theoverallarchitectureofthebankcredit4managementsystemhasbeendesignedbyauthor.Thefunctionmodulesandfunctionalprocesseshavebeendesigned.Thenthebusinessfunctionmodulesofthesystemhavebeendetaileddesignedinaccordancewithrequirementsanalysis.Meanwhile,thedatabasewhichisrequiredforthedatastoringofthesystemhasbeendesigned.Thedatafieldinformationtable,ERdiagramandclassdiagramrelationsofthecreditdatahavebeendetaileddesigned.Finally,thefunctionmodulesofthebankcreditmanagementsystemhavebeendesignedandimplemented,suchastheuser'sloginmodule,creditcustomerinformationmanagementmodule,managementmodulelineofcredit,creditprocessmanagementmodule,thecreditratingmanagementmodule,post-loaninformationmanagementmodule,systemdatamanagementmoduleetc..Theuserinterface,functionoperationcodeandthedataprocessingofthesemoduleshavebeendetaileddesignedandimplemented.Inthisthesis,thebankcreditmanagementsystemhasbeendesignedandimplemented,andthissystemwillberunningandoperatedbasedonthebrowser.WiththerespecttoasystembasedonC/Smode,thissystemwillhavebeenimprovedthebetteroperabilityandconvenience.Andthefunctionofdatamaintenancewillbeenmoreconvenientinthissystem.Thesystemtestinghasshowedthatthebasicfunctionofdataadding,deleting,queryingandverificationofsystemclienthavebeenimplementedaccuratelyinaccordancewiththefunctionaltestingofmanyusers.Then,theaccesstestofsystempagehasshowedthatthepageresponsetimehasbeenmaintainedintherangeof200ms.Thefunctionalandoperationalperformanceofthecreditmanagementsystemhavebemeetingtothebusinessneedsandthecommunicationsneedsofsystemcharacteristics.Theresearchofcreditmanagementforbankwillimprovethelevelofbusinesscreditmanagementsystemforbankcreditdepartments.Thathassomegoodresearchvalueandwillimprovetheefficiencyofbankcreditbusinessoperations.Keywords:Bankcredit;Creditmanagement;Database;B/Smode;SQLServer大学硕士毕业论文基于mssqlserver的银行信贷管理系统的设计与实现1目录第一章绪论..............................................................................................11.1研究背景和意义.............................................................................................11.1.1研究背景...............................................................................................11.1.2研究意义...............................................................................................21.2国内外研究现状.............................................................................................41.2.1国外研究现状.......................................................................................41.2.2国内研究现状..................................................................................