【正文】
function of Customer Information sharing and management swiftly and accurately, the goal is to realize the function of loan control and management. The main part in this system is customer management. There are modules of customer management, business management, interest management, synthesize management, finance personnel (branch anization) information management, statement management, system management this system. This thesis gives the setup process of the Commercial Bank Credit Manage System of FoShan. The developing tool for this system is the Windows application software DELPHI 7, and it the database software SQL Server 2021 is also used in the system. Keywords Customer Information, Credit Manage, ADO, Stored Procedure, Transaction, C/S 目 錄 第一章 前言 .......................................................................................................................... 1 第二章 系統(tǒng)設(shè)計要求 ............................................................................................................ 2 ............................................................................................. 2 信貸系統(tǒng)設(shè)計要求 .................................................................................................... 2 ................................................................................................. 3 系統(tǒng)基本功能分析 .................................................................................................... 4 ............................................................................................. 4 第三章 系統(tǒng)開發(fā)環(huán)境和工具 .................................................................................................. 8 ........................................................................................................... 8 ................................................................................................12 開發(fā)平臺 .............................................................................................................12 開發(fā)工具 .............................................................................................................12 ..........................................................................................................13 第四章 系統(tǒng)功能設(shè)計 ...........................................................................................................17 系統(tǒng)結(jié)構(gòu) ..................................................................................................................17 ................................................................................................17 ................................................................................................17 ..............................................................................................................18 數(shù)據(jù)庫系統(tǒng)關(guān)系結(jié)構(gòu)圖 ........................................................................................18 數(shù)據(jù)庫系統(tǒng)結(jié)構(gòu)定義 ............................................................................................19 ................................................................................................23 ................................................................................................25 第五章 系統(tǒng)的實現(xiàn)及關(guān)鍵技術(shù) .............................................................................................28 Delphi下的數(shù)據(jù)庫訪問技術(shù) ....................................................................................28 SQL Server服務(wù)器 中使用事務(wù) ................................................................................29 SQL Server 服務(wù)器中使用存儲過程 ........................................................................30 程序的模塊設(shè)計 ......................................................................................................31 ..................................................................................36 在錄入畫面中按 Enter跳轉(zhuǎn)到下一個輸入框 ........................................................36 .....................................................................................36 .....................................................................................38 第六章 系統(tǒng)功能測試 ................