1、evaluation of scientific development. Nature security type-nature security is to maintenance people of health value for target, through strengthening security based management, and risk management, and equipment management and technology supervision, ensure production in the people, and real, and sy

2、stem, and system, elements security reliable, and harmony unified, full control various against factors, achieved thought no slack, and management no empty document, and equipment no hidden, and system no blocked, and unit zero non-stopped. Quality and efficiency-quality benefit is to adhere to the

3、enterprise survival, profit and development business truth, adhere to the all activity is economic activity, all costs can be controlled, money should not be wasted management philosophy, management analysis, to improve management quality, improve cost control capacity and market competitiveness. In

4、novation of science and technology-science and technology innovation is to play the role of science and technology as the primary productive force, active use of new technologies, new materials, new processes, new equipment, increase investment in science and technology, strengthening scientific and

5、 technological training, speeding up transforming scientific and technological achievements, forming a number of proprietary technology, enhancing core competitiveness. Resource-saving-the-resources saving enterprise was to reduce coal consumption, water consumption, electricity at the core, enhance

6、 the operation of lean management to realize low consumption, high efficiency, reduce production costs. Second is to strengthen the business, financial, material, information and the optimization of organization and management, saving the internal transaction costs. Harmonious development of harmoni

7、ous development-is to construct a foreign environment for development. XING refers to the internal security firm and internal management of the internal management measures are effective, harmonious. Foreign currency means Enterprise coordinating development of homeopathy, well, get along with the n

8、eighbors better. (B) XX 2013 five enterprises building intrinsic safety power company goals are: unplanned outage 0 times. Class of disorders 0, 0 is equivalent forced outage rate. No personal injury accident, material and equipment accidents do not occur, no fire, no environmental pollution acciden

9、t. Enterprise integrated to achieve zero cases of violation, zero accidents, zero. Quality goal is: when generating capacity 7.5 billion-kilowatt, sales of over 7.11 billion kWh, total profits of 306.6 million Yuan, . BFS+、PI、MIS、SCM Information systems infrastructure, fully integrated information s

10、ystem to realize information resources sharing; to expand the breadth and depth of the portal system, information system of Enterprise Management Assistant role to play; to improve the day-to-day operation and maintenance operation record of promoting causes and transfer system; to strengthen the tr

11、aining數(shù)據(jù)庫課程設計報告題 目： 銀行賬戶管理系統(tǒng)院系名稱： 計算機學院 專業(yè)名稱： 軟件工程班 級：09級01班 學生姓名：*學號（8位）：*指導教師：*設計起止時間：2011年12月19日2011年12月30日supervision in large and medium goods vehicle. A is established large vehicles and small vehicles classification management of motor vehicle test mode, increased medium van car, and dangerou

12、s goods transport car, and school car test project; II is established motor vehicle test regulatory platform, achieved motor vehicle test full process video, and data remote regulatory; three is strictly motor vehicle identification management, equipped with unified of identification equipment and t

13、ool, using mobile identification Terminal, and law enforcement records instrument, technology identification means. As to 20XX years June 20 statewide motor vehicle keep volume for 567,408 car, and last year earlier than growth 75,814 car, growth 13.36%; this year January-June, vehicles management s

14、ection and license archives management section total accepted the motor vehicle registration business 42,543 car times, which registered registration 6,905 car times, and transfer registration 3,592 car times, and change registration 1033 car times, and mortgage registration 696 car times, and cance

15、llation registration 187 car times, and into business 980 car times, and Archives corrections 81 pieces times, and issued test qualified logo 25,429 car times, and other vehicles business 3,640 car times; supervision Survey Section relies on motor vehicle detection remote issued test qualified logo

16、software platform supervision motor vehicle test, and identification situation 7418l liangci, investigation motor vehicle exception business 30 car times, his pards business warning 244 article, vehicles and driving people sound video regulatory screenshots 1852 Zhang, checks motor vehicle archives

17、716 pieces times, and medium bus, and medium above truck, and Of hazardous chemicals, vehicles and school buses and other key vehicle inspection record of 420. (C) based on their own, and strict adherence to defense, more cheating, false false fugitive suspects, robbery suspect vehicles and the Inte

18、rnet crackdown. DMV full play to the first line of Defense position control, investigating cheating, fake identification and robbery suspect vehicles through operational work, and carefully examine the documents and legal proof, check traffic violations, traffic accidents, the fugitive suspect suspe

19、cted vehicles and theft than to work, further tight car, driving management business formalities review procedures. . Truck driver information management platform. Motor vehicles and traffic police departments, State transport authority to further clarify the Division of labour, implementation respo

20、nsibility, strengthen our collaboration and management together, reinforcing the management of drivers on which strongly synthetic warfare and information warfare. 3 strictly implemented. From May 1 up, a is implemented complex road and bad weather driving exam, currently DMV is urged contractors pa

21、rty in treasures driving school increased simulation Highway, and continuous urgent detours, and snow days, and wet sliding road, and burst situation disposal, subjects II field to driving exam project, is expected一. 設計目的銀行賬戶管理是銀行業(yè)務流程中十分重要的且必備的環(huán)節(jié)，由于銀行有大量數(shù)據(jù)需要處理，全部采用人工方式明顯不現(xiàn)實：這不僅需要花費很高的成本，而且處理事務的效率和質(zhì)量

22、都存在很大的問題，出于這些問題的考慮，使用計算機來處理這類問題就成為一個相當理想的方案。利用計算機可以極大地降低成本，更重要的是可以幾乎沒有錯誤地高效地處理所有的事務，所以做一款基于銀行賬戶管理方面的系統(tǒng)是十分必要的。本次課程設計通過對銀行賬戶管理系統(tǒng)中銀行業(yè)務流程的基本實現(xiàn)以及用戶環(huán)節(jié)的事務處理，旨在體驗數(shù)據(jù)庫設計和實現(xiàn)的基本過程中掌握數(shù)據(jù)庫模式的設計、分析和實現(xiàn)方法，了解數(shù)據(jù)庫應用系統(tǒng)軟件開發(fā)的一般過程。二. 設計內(nèi)容分別完成銀行業(yè)務功能、ATM功能和用戶管理功能，并設計數(shù)據(jù)庫以支持這些功能的實現(xiàn)，最后通過代碼進行具體實現(xiàn)以及數(shù)據(jù)庫鏈接。所用數(shù)據(jù)庫：SQL Server 2008開發(fā)語言：

23、Java數(shù)據(jù)庫設計：使用了六張表，分別為：管理員表（admin）、ATM機表(ATM)、ATM機出納表（ATMOutIn）、銀行柜臺出納表（BankOutIn）、銀行卡表（card）、用戶表（users）。三個觸發(fā)器，分別為：凍結(jié)用戶賬號操作（userstatus_update）、ATM機存取款操作（ATMOutIn_insert）和銀行存取款操作（BankOutIn_insert）。一個視圖、一個虛表：用戶操作查詢（allInfo(userId,cunquTime,cunquAddress,cunquMoney,cunquSummary,balanceMoney)）。銀行業(yè)務功能：設置管理員

24、賬號，賦予管理員權(quán)限以實現(xiàn)開戶、銷戶、存款、取款、查詢、辦卡和掛失功能。ATM功能：ATM機連接系統(tǒng)數(shù)據(jù)庫，實現(xiàn)用戶登錄、存（取）款以及用戶查詢功能。用戶管理：通過登錄功能獲得系統(tǒng)數(shù)據(jù)庫中自己的用戶信息，并有權(quán)限修改系統(tǒng)允許用戶修改的信息。三概要設計1功能模塊圖；2各個模塊詳細的功能描述。銀行業(yè)務功能： 管理員登錄在數(shù)據(jù)庫中添加管理員數(shù)據(jù)，管理員可登錄系統(tǒng)并有權(quán)限完成與 用戶相關所有操作。 開戶收集用戶信息，為用戶分配賬號并通過程序在系統(tǒng)數(shù)據(jù)庫中添加用戶信息。 銷戶根據(jù)賬號在數(shù)據(jù)庫中查找用戶，確認用戶身份信息后，管理員通過程序刪除數(shù)據(jù)庫中用戶信息。 存款根據(jù)卡號在數(shù)據(jù)庫中查找用戶，依據(jù)存入金額

25、，管理員通過程序修改數(shù)據(jù)庫中用戶的金額信息。 取款根據(jù)卡號在數(shù)據(jù)庫中查找用戶，通過密碼確認用戶，依據(jù)取出金額，經(jīng)判斷取出金額合法后（不大于余額），管理員通過程序修改數(shù)據(jù)庫中用戶的金額信息。 查詢以用戶卡號、賬號或身份證號之一為關鍵字，在數(shù)據(jù)庫中查找用戶，依據(jù)業(yè)務需求顯示用戶信息（開戶人信息、用戶近期操作記錄）。 辦卡為用戶賬號綁定卡號，由管理員通過程序?qū)⒖ㄌ栆约坝脩粼O置的密碼存入系統(tǒng)數(shù)據(jù)庫相應用戶信息中。 掛失根據(jù)賬號在數(shù)據(jù)庫中查找用戶，用戶提供登錄密碼確認用戶身份信息后，管理員通過程序?qū)?shù)據(jù)庫中用戶卡狀態(tài)信息由“使用”改為“凍結(jié)”。ATM功能： 登錄ATM機依據(jù)用戶卡號和密碼在系統(tǒng)數(shù)據(jù)庫中查

26、詢用戶信息，在信息匹配的情況下進入用戶操作界面。 存款ATM機依據(jù)用戶存入金額，通過程序修改數(shù)據(jù)庫中用戶的金額信息。 取款ATM機依據(jù)取出金額， 通過對比本機余額和數(shù)據(jù)庫中用戶余額，若金額合法則通過程序修改數(shù)據(jù)庫中用戶的金額信息，否則彈出錯誤信息。用戶管理： 登錄依據(jù)用戶賬號和密碼由管理員或ATM機在系統(tǒng)數(shù)據(jù)庫中查詢用戶信息，在信息匹配的情況下用戶獲得用戶管理權(quán)限。 查詢個人信息打印數(shù)據(jù)庫中記錄的用戶個人信息。 修改個人信息收集用戶新信息，由管理員操作，修改數(shù)據(jù)庫中用戶擁有修改權(quán)限的相應數(shù)據(jù)。 查詢近期操作依據(jù)用戶提供所要查詢時間范圍，由管理員或ATM機通過程序查詢系統(tǒng)數(shù)據(jù)庫中用戶的操作記錄。

27、四詳細設計1功能函數(shù)的調(diào)用關系圖public static void mian(String args)AdminLoginJFrame() AdminDao管理員登錄界面 ChaxunKaInfo(String userId) KaMimaXiuGai(String cardId)UserLoginJFrame()MainFrame()用戶登錄界面 KaCaoZuo(String times,String cardId)主界面 ChaXunCaoZuo(Users user) UserGuanLi(String ATMId,String cardId) ATMLoginJFrame()act

28、ionPerformed(ActionEvent e)ATM機登錄界面UserChaXun(String cardId) 用戶類 卡查詢操作卡密修改操作卡操作記錄 查詢近期 操作用戶管理登錄方法用戶信息查詢2重點設計及編碼數(shù)據(jù)庫設計：create database accountuse accountcreate table users(userId varchar(10) not null, /*用戶賬號，主鍵*/userName varchar(10) not null, /*用戶名*/userPassword varchar(10) not null, /*密碼*/idNo varcha

29、r(20) not null, /*身份證號碼,唯一*/userMoney numeric(10,2) default 0, /*總金額，不能小于零*/userStatus varchar(4) check (userStatus=使用 or userStatus=凍結(jié)) default 使用, /*用戶狀態(tài)（使用，凍結(jié)），默認是使用中*/userAddress varchar(30) not null, /*用戶地址*/startTime DateTime, /*開戶時間，應該是開戶時的系統(tǒng)時間，不應該人為輸入*/primary key(userId), /*設置主鍵*/)-用戶的狀態(tài)一旦變

30、成凍結(jié)狀態(tài)，那么卡也應該不能使用create trigger userstatus_updateon usersafter updateasif update(userStatus)begin if (select userStatus from inserted) = 凍結(jié)update card set cardStatus = 凍結(jié) where userId = (select userId from deleted)if (select userStatus from inserted) = 使用update card set cardStatus = 使用 where userId =

31、 (select userId from deleted) end create table card(cardId varchar(20) primary key, /*卡號，主鍵*/userId varchar(10) not null, /*用戶賬號，外鍵，參照users表的userId*/cardPassword varchar(10) not null, /*卡密碼*/cardStatus varchar(5) check (cardStatus in (使用,凍結(jié),掛失) default 使用, /*卡狀態(tài)（使用，凍結(jié)，掛失）,默認是使用*/-cardMoney numeric(1

32、0,2) check(cardMoney =0),foreign key (userId) references users(userId)on delete cascade /*當刪除用戶帳號時，他的卡號會及聯(lián)刪除*/)-管理員表create table admin(adminId varchar(10) not null primary key, /*操作員號碼，主鍵*/adminName varchar(10) not null, /*操作員名字*/adminPassword varchar(20) not null, /*操作員密碼*/BankAddress varchar(20) n

33、ot null /*操作員所在銀行地址*/) insert into admin values(001,沈萬三,123,工商銀行長安分行)-創(chuàng)建一個ATM表，至少應該含有編號以及ATM機里的總金額create table ATM(ATMId varchar(10) primary key, /*ATM機ID*/ ATMMoney numeric(20,2) check (ATMMoney =0), /*ATM機里的總錢數(shù),不允許用戶的取款數(shù)大于它的總錢數(shù)，所以它的總錢數(shù)不能小于*/ ATMAddress varchar(20) /*ATM機的地點*/)insert into ATM value

34、s(000, 10000, 長安區(qū))insert into ATM values(111, 50000, 長安區(qū))-用戶ATM機存取款信息表create table ATMOutIn (ATMId varchar(10), /*取款機號，外鍵，參照ATM表的ATMId*/cardId varchar(20) not null, /*用戶卡號，外鍵，參照card表的cardId*/ATMTime DateTime, /*在ATM機存取款時間（應該是進行存取款時的系統(tǒng)時間*/ATMCunQu numeric(10,2), /*ATM機存款金額*/ATMSummary varchar(30), /*

35、存取款摘要*/balanceMoney numeric(10,2) default 0, /*經(jīng)過操作后賬號中的金額*/foreign key(ATMId) references ATM(ATMId) on delete cascade,foreign key(cardId) references card(cardId) on delete cascade)-創(chuàng)建一個觸發(fā)器，當產(chǎn)生這一信息時，賬號上的錢也會隨之改動create trigger ATMOutIn_inserton ATMOutIn after insertas declare num_rows int select num_r

36、ows = rowcountif num_rows = 0 /*未插入成功*/ return if num_rows0 /*數(shù)據(jù)插入成功*/ begin update users set userMoney = userMoney + (select ATMCunQu from Inserted) where userId in (select userId from card c,inserted i where c.cardId = i.cardId) update ATM set ATMMoney = ATMMoney + (select ATMCunQu from Inserted)

37、where ATMId in (select ATMId from inserted) /*對應的atm機的總金額也會隨之改變*/ declare balanceMoney numeric(10,2) /*賬號余額*/ select balanceMoney = (select userMoney from users where userId in (select userId from card c,inserted i where c.cardId = i.cardId) update ATMOutIn set balanceMoney = (balanceMoney) where ca

38、rdId in (select cardId from inserted) and atmtime in (select atmtime from inserted) /*完成了賬號金額的修改，再將新的金額插入到信息表中，就是剩余的總余額了(注意修改的只是一個賬號此次的操作*/end-用戶銀行存取款信息信息表create table BankOutIn (adminId varchar(10) not null, /*操作員號碼，外鍵，參照操作員表的adminId*/cardId varchar(20) not null, /*用戶卡號,外鍵，參照用戶信息表*/BankTime DateTim

39、e, /*銀行存款時間*/BankCunQu numeric(10,2), /*銀行存款*/BankSummary varchar(30),balanceMoney numeric(10,2) default 0, /*經(jīng)過操作后賬號中的金額*/foreign key (adminId) references admin(adminId) on delete cascade,foreign key (cardId) references card(cardId) on delete cascade)-創(chuàng)建一個觸發(fā)器，當插入這條數(shù)據(jù)時會自動修改users表里的金額信息create trigger

40、 BankOutIn_inserton BankOutIn for insertas declare num_rows int select num_rows = rowcountif num_rows = 0 /*未插入成功*/ return if num_rows0 /*數(shù)據(jù)插入成功*/ begin update users set userMoney = userMoney + (select BankCunQu from Inserted) where users.userId = (select userId from card c,inserted i where c.cardId

41、 = i.cardId) declare balanceMoney numeric(10,2) select balanceMoney = (select userMoney from users where userId = (select userId from card c,inserted i where c.cardId = i.cardId ) update BankOutIn set balanceMoney = (balanceMoney) where cardId = (select cardId from inserted) and banktime = (select b

42、anktime from inserted) /*完成了賬號金額的修改，再將新的金額插入到信息表中，就是剩余的總余額了(要注意這個信息總額的唯一性)*/ end-總信息可以用其它的表推出，建一個視圖，一個虛表，來綜合他們的信息create view allInfo(userId,cunquTime,cunquAddress,cunquMoney,cunquSummary,balanceMoney)asselect userId,bankTime,BankAddress,bankCunqu,bankSummary,balanceMoneyfrom bankoutin b,admin a,card

43、 cwhere b.adminId = a.adminId and c.cardId = b.cardIdunionselect userId,ATMTime, ATMAddress,ATMCunqu,ATMSummary,balanceMoneyfrom atmoutin a,card c,ATM atmwhere c.cardId = a.cardId and a.atmid = atm.atmid 數(shù)據(jù)庫鏈接：package com.connection;import java.sql.Connection;import java.sql.DriverManager;import jav

44、a.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/* * 定義一個數(shù)據(jù)庫的連接及關閉資源的類 * author Administrator * */public class DBConnection /* * 創(chuàng)建數(shù)據(jù)庫的鏈接 * return 返回一個數(shù)據(jù)庫的鏈接 */public static Connection getConnection()Connection conn = null;try Class.forName(com.microsoft.jdbc.sqlserver

45、.SQLServerDriver); /加載數(shù)據(jù)庫驅(qū)動String url = jdbc:microsoft:sqlserver:/localhost:1433;databaseName=account; String username = sa; /數(shù)據(jù)庫用戶名String password = 1126; /數(shù)據(jù)庫密碼conn = DriverManager.getConnection(url,username,password); /獲得數(shù)據(jù)庫的鏈接 catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.p

46、rintStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return conn;/* * 關閉數(shù)據(jù)庫資源 * param obj 數(shù)據(jù)庫打開的資源對象（在此處用Object，因為鏈接數(shù)據(jù)庫是會打開多個資源） */public static void closeObject(Object obj)if(obj != null)if(obj instanceof ResultSet)try (ResultSet) obj).close(); catch (SQLExc

47、eption e) / TODO Auto-generated catch blocke.printStackTrace();if(obj instanceof PreparedStatement)try (PreparedStatement) obj).close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();-if(obj instanceof Connection)try (Connection) obj).close(); catch (SQLException e) / T

48、ODO Auto-generated catch blocke.printStackTrace();程序入口函數(shù)：package com.main;import com.frame.MainFrame;public class Begin /* * param args */public static void main(String args) / TODO Auto-generated method stubnew MainFrame();五測試數(shù)據(jù)及運行結(jié)果1正常測試數(shù)據(jù)和運行結(jié)果管理員登錄：登錄名：沈萬三 登錄密碼：123管理員操作：1. 查詢用戶信息2. 開戶ATM機操作1. 登錄2

49、. 查詢2異常測試數(shù)據(jù)及運行結(jié)果1.查詢失敗 3. ATM機存款失敗六調(diào)試情況，設計技巧及體會1改進方案本系統(tǒng)基本實現(xiàn)了銀行賬戶管理的基本功能，不過在細節(jié)方面處理的不夠完善，細化功能也做的不夠好，此外，交互界面美工基本沒做。對于此，在接下來的時間里我將對系統(tǒng)不斷完善，盡力做到盡善盡美。2體會在課程設計的兩周中，我在數(shù)據(jù)庫設計以及代碼編寫方面都遇到了不少問題，所幸在同學們的幫助下以及借助網(wǎng)絡查找相應問題，總算按時完成了課程設計關于上機的任務。在此過程中我通過數(shù)據(jù)庫設計和實現(xiàn)的基本過程中掌握數(shù)據(jù)庫模式的設計、分析和實現(xiàn)方法，了解數(shù)據(jù)庫應用系統(tǒng)軟件開發(fā)的一般過程，獲益匪淺。七參考文獻數(shù)據(jù)庫系統(tǒng)原理與

50、應用 孟彩霞、喬平安、張榮 編著八附錄：數(shù)據(jù)庫設計：create database accountuse accountcreate table users(userId varchar(10) not null, /*用戶賬號，主鍵*/userName varchar(10) not null, /*用戶名*/userPassword varchar(10) not null, /*密碼*/idNo varchar(20) not null, /*身份證號碼,唯一*/userMoney numeric(10,2) default 0, /*總金額，不能小于零*/userStatus varc

51、har(4) check (userStatus=使用 or userStatus=凍結(jié)) default 使用, /*用戶狀態(tài)（使用，凍結(jié)），默認是使用中*/userAddress varchar(30) not null, /*用戶地址*/startTime DateTime, /*開戶時間，應該是開戶時的系統(tǒng)時間，不應該人為輸入*/primary key(userId), /*設置主鍵*/)-用戶的狀態(tài)一旦變成凍結(jié)狀態(tài)，那么卡也應該不能使用create trigger userstatus_updateon usersafter updateasif update(userStatus)

52、begin if (select userStatus from inserted) = 凍結(jié)update card set cardStatus = 凍結(jié) where userId = (select userId from deleted)if (select userStatus from inserted) = 使用update card set cardStatus = 使用 where userId = (select userId from deleted) end create table card(cardId varchar(20) primary key, /*卡號，主鍵

53、*/userId varchar(10) not null, /*用戶賬號，外鍵，參照users表的userId*/cardPassword varchar(10) not null, /*卡密碼*/cardStatus varchar(5) check (cardStatus in (使用,凍結(jié),掛失) default 使用, /*卡狀態(tài)（使用，凍結(jié)，掛失）,默認是使用*/-cardMoney numeric(10,2) check(cardMoney =0),foreign key (userId) references users(userId)on delete cascade /*當刪除用戶帳號時，他的卡號會及聯(lián)刪除*/)-管理員表create table admin(adminId varchar(10) not null p