文件名称:bank
- 所属分类:
- JSP源码/Java
- 资源属性:
- [C/C++] [源码]
- 上传时间:
- 2013-03-26
- 文件大小:
- 4.59mb
- 下载次数:
- 0次
- 提 供 者:
- fra***
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
开发语言:Java
数据库设计:使用了六张表,分别为:管理员表(admin)、ATM机表(ATM)、ATM机出纳
表(ATMOutIn)、银行柜台出纳表(BankOutIn)、银行卡表(card)、用户
表(users)。
三个触发器,分别为:冻结用户账号操作(userstatus_update)、
ATM机存取款操作(ATMOutIn_insert)和
银行存取款操作(BankOutIn_insert)。
一个视图、一个虚表:用户操作查询
(allInfo(userId,cunquTime,cunquAddress,cunquMoney,cunq
uSummary,balanceMoney))。
银行业务功能:设置管理员账号,赋予管理员权限以实现开户、销户、存款、取款、查询、办卡和挂失功能。
ATM功能:ATM机连接系统数据库,实现用户登录、存(取)款以及用户查询功能。
用户管理:通过登录功能获得系统数据库中自己的用户信息,并有权限修改系统允许用
户修改的信息。
-Development languages: Java Database Design: use six tables: the the administrator table (admin), ATM machine the table (ATM) ATM machine cashier table (ATMOutIn), bank counter the cashier table (BankOutIn), bank card table ( card), the user table (users). Three triggers: the to freeze user account operations (userstatus_update), ATM machine access models the operation (ATMOutIn_insert) and the bank deposit and withdrawal operation (BankOutIn_insert). A view, a virtual table: user action query (allInfo (userId, cunquTime, cunquAddress, cunquMoney, cunq uSummary, balanceMoney)). Banking functions: set the administrator account, given administrator privileges in order to achieve the account, cancel the account, deposits, withdrawals, inquiries, do card and report the loss of function. ATM functions: ATM machine connected to the system database, user login, deposit (whichever), as well as the user' s query function. User management: system database user information by logging feature,
数据库设计:使用了六张表,分别为:管理员表(admin)、ATM机表(ATM)、ATM机出纳
表(ATMOutIn)、银行柜台出纳表(BankOutIn)、银行卡表(card)、用户
表(users)。
三个触发器,分别为:冻结用户账号操作(userstatus_update)、
ATM机存取款操作(ATMOutIn_insert)和
银行存取款操作(BankOutIn_insert)。
一个视图、一个虚表:用户操作查询
(allInfo(userId,cunquTime,cunquAddress,cunquMoney,cunq
uSummary,balanceMoney))。
银行业务功能:设置管理员账号,赋予管理员权限以实现开户、销户、存款、取款、查询、办卡和挂失功能。
ATM功能:ATM机连接系统数据库,实现用户登录、存(取)款以及用户查询功能。
用户管理:通过登录功能获得系统数据库中自己的用户信息,并有权限修改系统允许用
户修改的信息。
-Development languages: Java Database Design: use six tables: the the administrator table (admin), ATM machine the table (ATM) ATM machine cashier table (ATMOutIn), bank counter the cashier table (BankOutIn), bank card table ( card), the user table (users). Three triggers: the to freeze user account operations (userstatus_update), ATM machine access models the operation (ATMOutIn_insert) and the bank deposit and withdrawal operation (BankOutIn_insert). A view, a virtual table: user action query (allInfo (userId, cunquTime, cunquAddress, cunquMoney, cunq uSummary, balanceMoney)). Banking functions: set the administrator account, given administrator privileges in order to achieve the account, cancel the account, deposits, withdrawals, inquiries, do card and report the loss of function. ATM functions: ATM machine connected to the system database, user login, deposit (whichever), as well as the user' s query function. User management: system database user information by logging feature,
(系统自动生成,下载前可以参看下载内容)
下载文件列表
银行账户管理\account.sql
............\使用说明.doc
............\实验报告-打印版.doc
............\实验报告-电子版.doc
............\银行账户管理系统\.classpath
............\................\.project
............\................\bin\com\connection\DBConnection.class
............\................\...\...\dao\AdminDao.class
............\................\...\...\...\AllInfoDao.class
............\................\...\...\...\ATMDao.class
............\................\...\...\...\ATMOutInDao.class
............\................\...\...\...\BankOutInDao.class
............\................\...\...\...\CardDao.class
............\................\...\...\...\UsersDao.class
............\................\...\...\.to\Admin.class
............\................\...\...\...\AllInfo.class
............\................\...\...\...\ATM.class
............\................\...\...\...\ATMOutIn.class
............\................\...\...\...\BankOutIn.class
............\................\...\...\...\Card.class
............\................\...\...\...\Users.class
............\................\...\...\frame\AdminLoginJFrame$AdminFrame$CunKuan.class
............\................\...\...\.....\AdminLoginJFrame$AdminFrame$KaiHu.class
............\................\...\...\.....\AdminLoginJFrame$AdminFrame$QuKuan.class
............\................\...\...\.....\AdminLoginJFrame$AdminFrame$XiaoHu.class
............\................\...\...\.....\AdminLoginJFrame$AdminFrame.class
............\................\...\...\.....\AdminLoginJFrame$BanKa.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun$ChaXunCaoZuo.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun$ChaxunUserInfo$ChaxunKaInfo$KaCaoZuo.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun$ChaxunUserInfo$ChaxunKaInfo$KaUpdate.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun$ChaxunUserInfo$ChaxunKaInfo.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun$ChaxunUserInfo.class
............\................\...\...\.....\AdminLoginJFrame$ChaXun.class
............\................\...\...\.....\AdminLoginJFrame$GuaShi.class
............\................\...\...\.....\AdminLoginJFrame.class
............\................\...\...\.....\AdminOtherCaoZuo$ATMCunQu$ATMCunQuInfo.class
............\................\...\...\.....\AdminOtherCaoZuo$ATMCunQu.class
............\................\...\...\.....\AdminOtherCaoZuo$ATMYue$ATMInfo.class
............\................\...\...\.....\AdminOtherCaoZuo$ATMYue.class
............\................\...\...\.....\AdminOtherCaoZuo$JieGua.class
............\................\...\...\.....\AdminOtherCaoZuo$TongJi$UserInfo.class
............\................\...\...\.....\AdminOtherCaoZuo$TongJi.class
............\................\...\...\.....\AdminOtherCaoZuo$UserStatus.class
............\................\...\...\.....\AdminOtherCaoZuo.class
............\................\...\...\.....\ATMLoginJFrame$UserGuanLi$ATMCun.class
............\................\...\...\.....\ATMLoginJFrame$UserGuanLi$ATMQu.class
............\................\...\...\.....\ATMLoginJFrame$UserGuanLi$UserChaXun.class
............\................\...\...\.....\ATMLoginJFrame$UserGuanLi.class
............\................\...\...\.....\ATMLoginJFrame.class
............\................\...\...\.....\MainFrame.class
............\................\...\...\.....\MessageJDialog.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaXunCaoZuo$CaoZuoChaXun.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaXunCaoZuo.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaxunUserInfo$ChaxunKaInfo$KaCaoZuo.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaxunUserInfo$ChaxunKaInfo$KaMimaXiuGai.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaxunUserInfo$ChaxunKaInfo.class
............\................\...\...\.....\UserLoginJFrame$UserGuanLi$ChaxunUserInfo.c