銀行儲(chǔ)蓄業(yè)務(wù)管理系統(tǒng)說明

1、HYPERLINK N:整理后.N:整理后.HYPERLINK N:整理后.N:整理后.更多企業(yè)學(xué)院：HYPERLINK N:整理后.Shop./Shop/中小企業(yè)治理全能版183套講座+89700份資料HYPERLINK N:整理后.Shop40.shtml t _blank./Shop/40.shtml總經(jīng)理、高層治理49套講座+16388份資料HYPERLINK N:整理后.Shop38.shtml t _blank./Shop/38.shtml中層治理學(xué)院46套講座+6020份資料HYPERLINK N:整理后.Shop39.shtml t _blank./Shop/39.shtml國

2、學(xué)智慧、易經(jīng)46套講座HYPERLINK N:整理后.Shop41.shtml t _blank./Shop/41.shtml人力資源學(xué)院56套講座+27123份資料HYPERLINK N:整理后.Shop44.shtml t _blank./Shop/44.shtml各時(shí)期職員培訓(xùn)學(xué)院77套講座+ 324份資料HYPERLINK N:整理后.Shop49.shtml t _blank./Shop/49.shtml職員治理企業(yè)學(xué)院67套講座+ 8720份資料HYPERLINK N:整理后.Shop42.shtml t _blank./Shop/42.shtml工廠生產(chǎn)治理學(xué)院52套講座+ 13

3、920份資料HYPERLINK N:整理后.Shop43.shtml t _blank./Shop/43.shtml財(cái)務(wù)治理學(xué)院53套講座+ 17945份資料HYPERLINK N:整理后.Shop45.shtml t _blank./Shop/45.shtml銷售經(jīng)理學(xué)院56套講座+ 14350份資料HYPERLINK N:整理后.Shop46.shtml t _blank./Shop/46.shtml銷售人員培訓(xùn)學(xué)院72套講座+ 4879份資料HYPERLINK N:整理后.Shop47.shtml t _blank./Shop/47.shtml數(shù)據(jù)庫原理及應(yīng)用課程設(shè)計(jì)報(bào)告 專業(yè)： 信息治

4、理與信息系統(tǒng) 班級(jí)： 信息0801 學(xué)號(hào)： 081204112 姓名： 黃露 題目名稱：銀行儲(chǔ)蓄業(yè)務(wù)治理系統(tǒng) 完成日期： 2011.3.11 目錄一、系統(tǒng)定義.3二、需求分析.3（一）系統(tǒng)綜合需求（二）系統(tǒng)邏輯模型1數(shù)據(jù)流圖：2數(shù)據(jù)字典三、系統(tǒng)設(shè)計(jì).5（一）概念結(jié)構(gòu)設(shè)計(jì)E-R圖：（二）邏輯結(jié)構(gòu)設(shè)計(jì)四、詳細(xì)設(shè)計(jì)6（一）開發(fā)平臺(tái)及工具（二）數(shù)據(jù)庫分析五、源程序清單13六、設(shè)計(jì)心得18一、系統(tǒng)定義：銀行是一個(gè)國家正常運(yùn)轉(zhuǎn)必不可缺的機(jī)構(gòu)，當(dāng)今社會(huì)，幾乎是每個(gè)人都會(huì)涉及到儲(chǔ)蓄業(yè)務(wù)，為此，為方便用戶查詢和使用各種業(yè)務(wù)，可用計(jì)算機(jī)為工具對(duì)查詢治理為一體的各種服務(wù)。因此，如此的一個(gè)銀行儲(chǔ)蓄業(yè)務(wù)系統(tǒng)就應(yīng)運(yùn)而生了

5、。本系統(tǒng)是一個(gè)簡單的儲(chǔ)蓄系統(tǒng)，能夠?qū)?chǔ)戶的信息進(jìn)行查詢修改以及刪除。二、需求分析：（一）系統(tǒng)綜合需求 本系統(tǒng)是銀行用戶的存取款系統(tǒng)。要緊功能是治理各個(gè)用戶存取款的相關(guān)數(shù)據(jù)。 儲(chǔ)戶填寫的存款單或取款單輸入系統(tǒng)，假如是存款，則系統(tǒng)記錄存款人姓名，住址（或電話號(hào)碼），身份證號(hào)碼，存款類型，存款金額，存款日期等信息，并打印存單給儲(chǔ)戶；假如是取款，則需要輸入帳號(hào)、取款金額等信息，核對(duì)正確后系統(tǒng)打印出清單給儲(chǔ)戶。（二）系統(tǒng)邏輯模型1數(shù)據(jù)流圖：圖1-1 系統(tǒng)數(shù)據(jù)流圖2數(shù)據(jù)字典數(shù)據(jù)名字：注冊(cè)申請(qǐng)表數(shù)據(jù)來源：儲(chǔ)戶數(shù)據(jù)目的：儲(chǔ)戶信息數(shù)據(jù)組成：姓名+密碼+住址+身份證號(hào)碼數(shù)據(jù)名字：儲(chǔ)戶信息表數(shù)據(jù)來源：儲(chǔ)戶數(shù)據(jù)目的：

6、身份驗(yàn)證數(shù)據(jù)組成：姓名+密碼+住址+身份證號(hào)碼+現(xiàn)有金額數(shù)據(jù)名字：利息清單數(shù)據(jù)來源：系統(tǒng)數(shù)據(jù)目的：儲(chǔ)戶數(shù)據(jù)組成：利息+姓名+取款時(shí)刻數(shù)據(jù)名字：存單數(shù)據(jù)來源：存款信息表數(shù)據(jù)目的：儲(chǔ)戶數(shù)據(jù)組成：姓名+到期時(shí)刻+存入類型+存入時(shí)刻+利率+存入金額 數(shù)據(jù)名字：取款單數(shù)據(jù)來源：儲(chǔ)戶 數(shù)據(jù)目的：儲(chǔ)戶信息表數(shù)據(jù)組成：姓名+到期時(shí)刻+存入類型+存入時(shí)刻+利率+取款金額+身份證號(hào)數(shù)據(jù)名字：存款單數(shù)據(jù)來源：儲(chǔ)戶數(shù)據(jù)目的： 存款信息表數(shù)據(jù)組成：姓名+到期時(shí)刻+存入類型+存入時(shí)刻+利率+存入金額+身份證號(hào)表1.1 系統(tǒng)數(shù)據(jù)字典三、系統(tǒng)設(shè)計(jì)：（一）概念結(jié)構(gòu)設(shè)計(jì)E-R圖：（二）邏輯結(jié)構(gòu)設(shè)計(jì)四、詳細(xì)設(shè)計(jì)（一）開發(fā)平臺(tái)及工具

7、開發(fā)工具M(jìn)icrosoft Visual C+ 6.0DBMS：Microsoft SQL Server 2000建模工具：Microsoft Visio,word編輯器講明：為了方便的實(shí)現(xiàn)系統(tǒng)以及個(gè)人熟悉程度的因素，選擇了VC+ 6.0的開發(fā)平臺(tái)。在Windows平臺(tái)上我們所學(xué)過的就只有MS SQL Server了，因此采納SQL Server2000來進(jìn)行開發(fā)。（二）銀行儲(chǔ)蓄業(yè)務(wù)數(shù)據(jù)庫分析1）本系統(tǒng)由三張表組成，具體如下：表名屬性(字段)名儲(chǔ)戶表賬號(hào)、身份證號(hào)、姓名、性不、身高、地址、存款余額存款單表存款單號(hào)、金額、存款方式、賬號(hào)、存款日期取款單表取款單號(hào)、金額、取款方式、賬號(hào)、取款日期系

8、統(tǒng)表差不多信息2）表間關(guān)系如下：一個(gè)存款單或取款單屬于一個(gè)用戶，一個(gè)用戶能夠擁有多次存款單或取款單。用戶通過存款操作與存款單建立聯(lián)系，通過取款操作與取款單建立聯(lián)系。3）數(shù)據(jù)預(yù)備前期預(yù)備工作：以system賬戶登錄，創(chuàng)建新賬戶create user dy identified by lyjn;grant dba to dy;connect dy/dyorcl;各個(gè)表的具體信息和創(chuàng)建表的代碼如下：儲(chǔ)戶表(luser)字段(屬性)含義字段(屬性)名字段(屬性)類型賬號(hào)acnumVARCHAR(5)身份證號(hào)idNUMBER姓名nameVARCHAR2(20)性不sexVARCHAR2(2)身高h(yuǎn)eig

9、htNUMBER(3,2)地址addressVARCHAR2(20)存款余額(億)Balance(billion)INT創(chuàng)建儲(chǔ)戶表的代碼如下：CREATE TABLE luser(acnum VARCHAR2(5) NOT NULL ,id NUMBER NOT NULL ,name VARCHAR2(20) NOT NULL ,sex VARCHAR2(2) CHECK(sex IN (男,女) ) , height NUMBER(3,2) NOT NULL,address VARCHAR2(20) NOT NULL ,balance INT NOT NULL );ALTER TABLE l

10、user添加主鍵約束ADD CONSTRAINT XPKluser PRIMARY KEY (acnum);存款單表(depositslip)字段(屬性)含義字段(屬性)名字段(屬性)類型存款單號(hào)dps_numNUMBER賬號(hào)acnumVARCHAR2(5)存款時(shí)刻dps_timeTIMESTAMP金額(億)moneyINT存款方式dps_wayVARCHAR2(10)創(chuàng)建存款單表的代碼如下：CREATE TABLE depositslip(dps_num NUMBER NOT NULL ,money INT CHECK(money=0) ,dps_way VARCHAR2(10) NOT N

11、ULL ,acnum VARCHAR2(5) NOT NULL ,dps_time TIMESTAMP NULL );ALTER TABLE depositslip 添加主鍵約束ADD CONSTRAINT XPKdepositslip PRIMARY KEY (dps_num,acnum);ALTER TABLE depositslip在depositslip表中的acnum字段中添加外鍵約束ADD (CONSTRAINT R_5 FOREIGN KEY (acnum) REFERENCES luser(acnum);取款單表(drawslip)字段(屬性)含義字段(屬性)名字段(屬性)類型

12、取款單號(hào)dw_numNUMBER賬號(hào)acnumVARCHAR2(5)取款時(shí)刻dw_timeTIMESTAMP金額(億)MoneyINT取款方式dw_wayVARCHAR2(10)創(chuàng)建取款單表的代碼如下：CREATE TABLE drawslip(dw_num NUMBER NOT NULL ,money INT CHECK(money=0),dw_way VARCHAR2(10) NOT NULL ,acnum VARCHAR2(5) NOT NULL ,dw_time TIMESTAMP NULL );ALTER TABLE drawslip 添加主鍵約束ADD CONSTRAINT XPK

13、drawslip PRIMARY KEY (dw_num,acnum);ALTER TABLE drawslip 在drawslip表中的acnum字段中添加外鍵約束ADD (CONSTRAINT R_6 FOREIGN KEY (acnum) REFERENCES luser(acnum);4）插入(insert)數(shù)據(jù)1、插入儲(chǔ)戶表(luser)數(shù)據(jù)insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (00001, 3422101, 劉忠田, 男,1.72 ,北京市朝陽區(qū), 345);insert i

14、nto luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (00002, 3422102, 周正義, 男,1.78, 天津市寶坻區(qū), 123);insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (00003, 3422103, 陳光標(biāo), 男,1.80, 南京市新街口, 333);insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (00004

15、, 3422104, 張茵, 女,1.65, 上海市黃浦區(qū), 234);insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (00005, 3422105, 陳麗華, 女,1.70, 香港市旺角區(qū), 111);2、插入存款單表(depositslip)數(shù)據(jù)insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98001,00001, 120,to_date(08-08-2009,dd-mm-yyyy), 整存整

16、取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98002,00001, 300,to_date(10-08-2009,dd-mm-yyyy), 整存整取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98003,00002, 100,to_date(12-08-2009,dd-mm-yyyy), 整存零取);insert into depositslip (DPS_NUM, ACNUM

17、, MONEY, DPS_TIME, DPS_WAY)values (98004,00002, 150,to_date(12-09-2009,dd-mm-yyyy), 整存零取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98005,00003, 200,to_date(15-08-2009,dd-mm-yyyy), 零存整取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98006,0

18、0003, 100,to_date(14-09-2009,dd-mm-yyyy), 零存整取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98007,00003, 80,to_date(23-09-2009,dd-mm-yyyy), 零存整取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98008,00004, 80,to_date(23-08-2009,dd-mm-yyyy), 零存

19、零取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98009,00004, 180,to_date(24-09-2009,dd-mm-yyyy), 零存零取);insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98010,00005, 190,to_date(24-08-2009,dd-mm-yyyy), 通知存款);insert into depositslip (DPS_NUM, ACNU

20、M, MONEY, DPS_TIME, DPS_WAY)values (98011,00005, 210,to_date(30-09-2009,dd-mm-yyyy), 通知存款);3、插入取款單表(drawslip)數(shù)據(jù)insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52001,00001, 75,to_date(08-08-2010,dd-mm-yyyy), 柜臺(tái));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (5

21、2002,00002, 27,to_date(08-09-2010,dd-mm-yyyy), 取款機(jī));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52003,00002,100,to_date(12-10-2010,dd-mm-yyyy), 柜臺(tái));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52004,00003,47,to_date(15-08-2010,dd-mm-yyyy), 取款機(jī));insert i

22、nto drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52005,00004,26,to_date(12-09-2010,dd-mm-yyyy), 取款機(jī));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52006,00005,100,to_date(23-09-2010,dd-mm-yyyy), 柜臺(tái));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (

23、52007,00005,150,to_date(10-10-2010,dd-mm-yyyy), 柜臺(tái));insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52008,00005,39,to_date(31-10-2010,dd-mm-yyyy), 取款機(jī));5）索引建立索引遵循的規(guī)律：1.建立在where子句經(jīng)常引用的列上，2.經(jīng)常需要排序的列上，3.連接屬性列上等在存款單表的存款單號(hào)字段和賬號(hào)字段建立組合索引CREATE UNIQUE INDEX XPKdepositslip ON depositslip(

24、dps_num ASC,acnum ASC);在存款單表的賬號(hào)字段建立索引CREATE INDEX XIF1depositslip ON depositslip(acnum ASC);在取款單表的取款單號(hào)字段和賬號(hào)字段建立組合索引CREATE UNIQUE INDEX XPKdrawslip ON drawslip(dw_num ASC,acnum ASC);在取款單表的賬號(hào)字段建立索引CREATE INDEX XIF1drawslip ON drawslip(acnum ASC);在儲(chǔ)戶表的賬戶字段上建立索引，方便查詢CREATE UNIQUE INDEX XPKluser ON luser

25、(acnum ASC);6）觸發(fā)器1、插入存款，對(duì)應(yīng)儲(chǔ)戶表的相應(yīng)儲(chǔ)戶的余額(balance)增加插入記錄包含的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDps AFTER INSERT ON depositslip FOR EACH ROWDECLAREn_ac VARCHAR2(5);n_mo INT;BEGINn_ac:=:new.acnum;n_mo:=:new.money;update luser set balance=balance+n_mo where luser.acnum=n_ac;END OperatingDps;2、刪除存款

26、，對(duì)應(yīng)儲(chǔ)戶表的相應(yīng)儲(chǔ)戶的余額(balance)減去所刪除記錄的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDps2 AFTER DELETE ON depositslip FOR EACH ROWDECLAREo_ac VARCHAR2(5);o_mo INT;BEGINo_ac:=:old.acnum;o_mo:=:old.money;update luser set balance=balance-o_mo where luser.acnum=o_ac;END OperatingDps2;3、插入取款，對(duì)應(yīng)儲(chǔ)戶表的相應(yīng)儲(chǔ)戶的余額(balance

27、)減少插入記錄包含的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDw AFTER INSERT ON drawslip FOR EACH ROWDECLAREn_ac VARCHAR2(5);n_mo INT;BEGINn_ac:=:new.acnum;n_mo:=:new.money;update luser set balance=balance-n_mo where luser.acnum=n_ac;END OperatingDw;4、刪除取款，對(duì)應(yīng)儲(chǔ)戶表的相應(yīng)儲(chǔ)戶的余額(balance)加上所刪除記錄的金額數(shù)(money)CREATE OR

28、 REPLACE TRIGGER OperatingDw2 AFTER DELETE ON drawslip FOR EACH ROWDECLAREo_ac VARCHAR2(5);o_mo INT;BEGINo_ac:=:old.acnum;o_mo:=:old.money;update luser set balance=balance+o_mo where luser.acnum=o_ac;END OperatingDw2;5、插入的取款金額(money)大于對(duì)應(yīng)用戶的余額(balance)時(shí)，系統(tǒng)報(bào)錯(cuò)CREATE OR REPLACE TRIGGER OperatingDw3 AFTE

29、R insert ON drawslip FOR EACH ROWDECLAREn_ac VARCHAR2(5);n_mo INT;n_ba INT;BEGINn_ac:=:new.acnum;n_mo:=:new.money;select balance into n_ba from luser where acnum=n_ac;if n_mon_ba thenRAISE_APPLICATION_ERROR(-20000, 存款余額不足！請(qǐng)重新插入存款！);end if;END OperatingDw3;五、源程序清單#include#include#includeusing namespa

30、ce std;const int Max=100;void Wait();class User /用戶類的聲明public: User() CurrentAcount=0; /初始化當(dāng)前的賬戶 void Resert1(User *u,double A) u-CurrentAcount=u-CurrentAcount+A; void Resert2(User *u,double A) u-CurrentAcount=u-CurrentAcount-A; char *getname() /取得用戶名 return name; long getNum() /取得帳戶號(hào) return Num; do

31、uble getCurrentAcount() return CurrentAcount; void output() /輸出相關(guān)信息 cout用戶名：nameendl; cout賬 號(hào)：Numendl; cout余 額：CurrentAcountname,name); this-Num=Num; void Deposit(User *u,double Acount) /存款 u-Resert1(u,Acount); void out(User *u,double acount) /取款 if(acountu-getCurrentAcount() cout余額不足.n; else coutRe

32、sert2(u,acount); void Locate(User *u) /查詢余額 u-output(); private: char name20; long Num; double CurrentAcount; ;class DoBank /銀行治理類的聲明public: DoBank() User a; top=-1; fstream file(f:User.txt,ios:in); /以讀的方式打開文件 while(1) file.read(char*)&a,sizeof(a); if(!file) break; top+; btop=a; file.close(); /關(guān)閉文件

33、void Work(); void addUser(char *name,int Num) User *p=equal(Num); if(p=NULL) top+; btop.addUser(name,Num); cout成功載入nnn; else cout該用戶已存在.n; User *equal(long Num) int i; for(i=0;itop;i+) if(bi.getNum()=Num) return &bi; return NULL; DoBank() /析構(gòu)函數(shù) fstream file(f:User.txt,ios:out); /以寫的方式打開文件 for (int i

34、=0;i=top;i+) file.write(char *)&bi,sizeof(bi); file.close(); /關(guān)閉文件 private: User bMax; int top;void Wait() int i=0; while(i999999999) i+; void Menu() /顯示功能菜單 coutnnnn; cout 1、用戶維護(hù)n; cout 2、存款n; cout 3、取款n;cout 4、查詢n; coutnumber; while(number!=0) if(int)number53) cout對(duì)不起，你的輸入有誤。n; else switch(number) /輸入功能代號(hào) case 1: coutname; coutNum; addUser(name,Num); break; case 2: coutNum; us=equal(Num); if(us=NULL) cout不存在該用戶.n; else coutTAcount; us-Deposit(us,TAcount); cout成功存入.nnn; break; case 3: coutNum; us=equal