收藏 分享(赏)

数据库课程设计实验报告-银行账户管理系统.doc

上传人:dreamzhangning 文档编号:4034271 上传时间:2018-12-05 格式:DOC 页数:123 大小:1.98MB
下载 相关 举报
数据库课程设计实验报告-银行账户管理系统.doc_第1页
第1页 / 共123页
数据库课程设计实验报告-银行账户管理系统.doc_第2页
第2页 / 共123页
数据库课程设计实验报告-银行账户管理系统.doc_第3页
第3页 / 共123页
数据库课程设计实验报告-银行账户管理系统.doc_第4页
第4页 / 共123页
数据库课程设计实验报告-银行账户管理系统.doc_第5页
第5页 / 共123页
点击查看更多>>
资源描述

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

4、. Innovation 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

5、 and 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, enh

6、ance 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 har

7、monious 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 alo

8、ng with the neighbors 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 pol

9、lution accident. 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

10、 information system 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 str

11、engthen the trainingsupervision 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 dangerous goods transport car, and school car test project; II is established motor vehicle test r

12、egulatory 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 tool, using mobile identification Terminal, and law enforcement records instrument, technol

13、ogy 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 section and license archives management section total accepted the motor vehicle registrati

14、on 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 cancellation registration 187 car times, and into business 980 car times, and Archives correcti

15、ons 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 software platform“ supervision motor vehicle test, and identification situation 7418l lia

16、ngci, 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 716 pieces times, and medium bus, and medium above truck, and Of hazardous chemicals, ve

17、hicles 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 Internet crackdown. DMV full play to the “first line of Defense“ position control, investiga

18、ting 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 suspected vehicles and theft than to work, further tight car, driving management business f

19、ormalities review procedures. . Truck driver information management platform. Motor vehicles and traffic police departments, State transport authority to further clarify the Division of labour, implementation responsibility, strengthen our collaboration and management together, reinforcing the manag

20、ement 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 party in treasures driving school increased simulation Highway, and continuous urgent de

21、tours, and snow days, and wet sliding road, and burst situation disposal, subjects II field to driving exam project, is expected数据库课程设计报告题 目: 银行账户管理系统院系名称: 计算机学院专业名称: 软件工程班 级: 09 级 01 班学生姓名: *学号(8 位): *指导教师: *设计起止时间:2011 年 12 月 19 日2011 年 12 月 30 日evaluation of scientific development. Nature securit

22、y 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 system, and system, elements security reliable, and ha

23、rmony 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 enterprise “survival, profit and development“ busine

24、ss 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. Innovation of science and technology-science and t

25、echnology 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 technological training, speeding up transformin

26、g 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 the operation of lean management to realize low

27、 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 harmonious development-is to construct a “foreign“ envi

28、ronment 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 neighbors better.“ (B) XX 2013 five ente

29、rprises 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 accident. Enterprise integrated to achieve ze

30、ro 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 system to realize information resources

31、 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 trainingsupervision in large and medium

32、goods vehicle. A is established large vehicles and small vehicles classification management of motor vehicle test mode, increased medium van car, and dangerous goods transport car, and school car test project; II is established motor vehicle test regulatory platform, achieved motor vehicle test full

33、 process video, and data remote regulatory; three is strictly motor vehicle identification management, equipped with unified of identification equipment and tool, using mobile identification Terminal, and law enforcement records instrument, technology identification means. As to 20XX years June 20 s

34、tatewide 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 section and license archives management section total accepted the motor vehicle registration business 42,543 car times, which registered regis

35、tration 6,905 car times, and transfer registration 3,592 car times, and change registration 1033 car times, and mortgage registration 696 car times, and cancellation registration 187 car times, and into business 980 car times, and Archives corrections 81 pieces times, and issued test qualified logo

36、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 software platform“ supervision motor vehicle test, and identification situation 7418l liangci, investigation motor vehicle exception business

37、 30 car times, his pards business warning 244 article, vehicles and driving people sound video regulatory screenshots 1852 Zhang, checks motor vehicle archives 716 pieces times, and medium bus, and medium above truck, and Of hazardous chemicals, vehicles and school buses and other key vehicle inspec

38、tion record of 420. (C) based on their own, and strict adherence to defense, more cheating, false false fugitive suspects, robbery suspect vehicles and the Internet crackdown. DMV full play to the “first line of Defense“ position control, investigating cheating, fake identification and robbery suspe

39、ct vehicles through operational work, and carefully examine the documents and legal proof, check traffic violations, traffic accidents, the fugitive suspect suspected vehicles and theft than to work, further tight car, driving management business formalities review procedures. . Truck driver informa

40、tion management platform. Motor vehicles and traffic police departments, State transport authority to further clarify the Division of labour, implementation responsibility, strengthen our collaboration and management together, reinforcing the management of drivers on which strongly synthetic warfare

41、 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 party in treasures driving school increased simulation Highway, and continuous urgent detours, and snow days, and wet sliding road, and burs

42、t situation disposal, subjects II field to driving exam project, is expected一. 设计目的银行账户管理是银行业务流程中十分重要的且必备的环节,由于银行有大量数据需要处理,全部采用人工方式明显不现实:这不仅需要花费很高的成本,而且处理事务的效率和质量都存在很大的问题,出于这些问题的考虑,使用计算机来处理这类问题就成为一个相当理想的方案。利用计算机可以极大地降低成本,更重要的是可以几乎没有错误地高效地处理所有的事务,所以做一款基于银行账户管理方面的系统是十分必要的。本次课程设计通过对银行账户管理系统中银行业务流程的基本实现

43、以及用户环节的事务处理,旨在体验数据库设计和实现的基本过程中掌握数据库模式的设计、分析和实现方法,了解数据库应用系统软件开发的一般过程。二. 设计内容分别完成银行业务功能、ATM 功能和用户管理功能,并设计数据库以支持这些功能的实现,最后通过代码进行具体实现以及数据库链接。所用数据库:SQL Server 2008开发语言:Java数据库设计:使用了六张表,分别为:管理员表(admin) 、ATM 机表(ATM)、ATM 机出纳表(ATMOutIn) 、银行柜台出纳表(BankOutIn) 、银行卡表(card) 、用户表(users) 。三个触发器,分别为:冻结用户账号操作(userstat

44、us_update) 、ATM 机存取款操作(ATMOutIn_insert)和银行存取款操作(BankOutIn_insert) 。一个视图、一个虚表:用户操作查询(allInfo(userId,cunquTime,cunquAddress,cunquMoney,cunquSummary,balanceMoney)) 。银行业务功能:设置管理员账号,赋予管理员权限以实现开户、销户、存款、取款、查询、办卡和挂失功能。ATM 功能:ATM 机连接系统数据库,实现用户登录、存(取)款以及用户查询功能。用户管理:通过登录功能获得系统数据库中自己的用户信息,并有权限修改系统允许用户修改的信息。eval

45、uation 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 system

46、, 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 ente

47、rprise “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

48、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

49、 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 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, savi

展开阅读全文
相关资源
猜你喜欢
相关搜索
资源标签

当前位置:首页 > 实用文档 > 课程设计

本站链接:文库   一言   我酷   合作


客服QQ:2549714901微博号:道客多多官方知乎号:道客多多

经营许可证编号: 粤ICP备2021046453号世界地图

道客多多©版权所有2020-2025营业执照举报