【正文】 第三章 系統(tǒng)需求分析 數(shù)據(jù)流程圖 現(xiàn)在所要做的是要準(zhǔn)確定義系統(tǒng)必須做什么以及系統(tǒng)必須具備的功能。現(xiàn)在我們所要做的就是要把軟件 “ 做什么 ” 的邏輯模型變換為 “ 怎么做 ” 的物理模型，即著手實(shí)現(xiàn)軟件的需求。我首先將整個(gè)系統(tǒng)化分為幾個(gè)小問題，小模塊，在系統(tǒng)中，我設(shè)計(jì)了 賬戶管理、用戶查詢、取款機(jī)、退出 4個(gè)小模塊。 ER 模型直接從現(xiàn)實(shí)世界抽象出實(shí) 體類型及實(shí)體間聯(lián)系，然后用 ER 圖來表示數(shù)據(jù)模型。 USE 用戶基本信息表 列名 數(shù)據(jù)類型 可否為空 說明 User_id CHARACTER（ 13） NOTNULL 賬號(hào)（索引） User_name CHARACTER（ 8） NULL 用戶姓名 Useer_pswd CHARACTER（ 6） NULL 用戶密碼 User_identify CHARACTER（ 18） NULL 用戶身份證 User_all NUMBER（ 6） NULL 總金額 User_status NUMBER（ 6） NULL 現(xiàn)在狀態(tài) User_address CHARACTER（ 10） NULL 用戶住址 User_new Data(8) null 開戶時(shí)間 Card 用戶卡信息表 管理員 賬戶 卡信息 取款機(jī) 普通信息 管理 管理 管理 管理 n 1 1 1 1 n n 1 1 列名 數(shù)據(jù)類型 可否為空 說明 User_id CHARACTER（ 13） NOTNULL 賬號(hào)（索引） Card_id CHARACTER（ 13） NULL 卡號(hào)（索引） card_pswd CHARACTER（ 6） NULL 卡密碼 call_all NUMBER（ 6） NULL 卡金額 User_status NUMBER（ 6） NULL 現(xiàn)在狀態(tài) Atm 取款機(jī)基本信息表 列名 數(shù)據(jù)類型 可否為空 說明 atm_id CHARACTER（ 3） NOTNULL 取款機(jī) id 號(hào)（索引） Atm_adress CHARACTER（ 20） NULL 安裝地點(diǎn) Atm_intall CHARACTER（ 6） NULL 安裝時(shí)間 Atm_delete NUMBER（ 6） NULL 拆除時(shí)間 Atmoutin 存款機(jī)存取款信息表 列名 數(shù)據(jù)類型 可否為空 說明 atm_id CHARACTER（ 3） NOTNULL 取款機(jī) ID 號(hào)（索引） User_id CHARACTER（ 13） NULL 用戶賬號(hào) Card_id CHARACTER（ 16） NULL 用戶卡號(hào) Atm_time Data NULL 存取款時(shí)間 Atm_outin CHARACTER（ 4） NULL 摘要 Atm_out NUMBER（ 6） NULL 取款金額 Atm_in Number(4) NULL 存款金額 User_all NUMBER（ 6） null 總金額 Bankoutin 用戶銀行存取款信息表 列名 數(shù)據(jù)類型 可否為空 說明 tms_id CHARACTER（ 6） NOTNULL 操作員 ID 號(hào)（索引） User_id CHARACTER（ 13） NULL 用戶賬號(hào) Card_id CHARACTER（ 16） NULL 用戶卡號(hào) bank_time Data NULL 存取款時(shí)間 bank_outin CHARACTER（ 4） NULL 摘要 Bank_out NUMBER（ 6） NULL 取款金額 bank_in Number(4) NULL 存款金額 bank_all NUMBER（ 6） null 總金額 Userall 用戶存取款信息表 列名 數(shù)據(jù)類型 可否為空 說明 User_id CHARACTER（ 13） NULL 用戶賬號(hào) Card_id CHARACTER（ 16） NULL 用戶卡號(hào) outin_time Data NULL 存取款時(shí)間 user_out NUMBER（ 6） NULL 取款金額 user_in Number(4) NULL 存款金額 User_all NUMBER（ 6） null 總金額 TMS 管理系統(tǒng)的用戶口令表 列名 數(shù)據(jù)類型 可否為空 說明 Tms_user CHARACTER（ 6） NULL 用戶名（索引） Tms_pswd CHARACTER（ 6） NULL 口令 第五章 系統(tǒng)實(shí)施 主要界面的功能及代碼 管理員登錄界面 此界面主要是為了增強(qiáng)銀行管理的安全性，不讓非法用戶進(jìn)入。 cMessageText=39。 user_in with moneyin。39。 outin with 存入 。但總體上來說還算是差強(qiáng)人意吧。You think it39。 blue eyes were filled with bleary civilian curiosity as to why one American would try to murder another one so far from home, and why the victim should laugh. Three The Germans and the dog were engaged in a mili tary operation which had an amusingly selfexplanatory name, a human enterprise which is seldom described in detail, whose name alone, when reported as news or history, gives many war enthusiasts a sort of postcoital satisfaction. It is, in the imagination of bat39。t have any. The most dangerous thing they found on his person was a twoinch pencil stub. Three inoffensive bangs came from far away. They came from Germa n rifles. The two scouts who had ditched Billy and Weary had just been shot. They had been lying in ambush for Germans. They had been discovered and shot from behind. Now they were dying in the snow, feeling nothing, turning the snow to the color of rasp berry sherbet. So it goes. So Roland Weary was the last of the Three Musketeers. And Weary, bugeyed with terror, was being disarmed. The corporal gave Weary39。s bulletproof Bible instead. A bulletproof Bible is a Bible small enough to be slipped into a soldier39。s all yours, you lucky lad.39。 They were brought at last to a stone cottage at a fork in the road. It was a collecting point for prisoners of war. Billy and Weary were taken inside, where it was warm and smoky. There vas a fire sizzling and popping in the fireplace. The fuel was furniture. There were about twenty other Americans in there, sitting on the floor w ith their bac ks to the wall, staring into the flamesthinking whatever there was to think, which was zero. Nobody talked. Nobody had any good war stories to tell. Billy and Weary found places for themselves, and Billy went to sleep w ith his head on the shoulder of an unprotesting captain . The captain was a chaplain. He was a rabbi. He had been shot through the hand. Billy traveled in time, opened his eyes, found himself staring into the glass eyes of a jade green mechanical owl. The owl wa s hanging upside down from a rod of stainless steel. The owl was Billy39。You39。 39。t they just extend the laws concerning people to dogs? That39。s bee a hard world to write in. I lowered my eyes, ashamed of myself, who still continued to write in such a world. It certainly has... The man apologized in a bit of a flurry discerning my sudden depression. That was rude. I39。t endure being exposed to the eyes of the world, ridiculed. So I quit writing, A sorry tale. He smiled and shook his head. No no, let39。s head a little, I left the park. Standing Woman(2) I came out on the main street, there were a lot of cars on the road but few pedestrians. A cattree about thirty to forty centimeters high was planted next to the sidewalk. Sometimes I e across a catpillar that has just been planted and still hasn39。t tell how far its legs have vegetized because of its trousers. It is male, thirty five or thirty six years old, tall, with a bit of a stoop. I approached him and held out my envelope as always. Registered mail, special delivery, please. The manpillar, nodding silent。m afraid I39。s e to this, I would have been better off if I39。s head. I also used to write things. He managed to suppress a smile. How many years is it now since I stopped writing? It feels like a long time. I stared at the man39。s head. This fellow here, I wonder what he was called before he became a dogpillar. No calling a dogpillar by its origin