文件名称：银行存储系统
文件大小：131KB
文件格式：DOC
更新时间：2016-01-28 09:41:58
数据库
ALTER TABLE drawslip 添加主键约束 ADD CONSTRAINT XPKdrawslip PRIMARY KEY (dw_num,acnum); ALTER TABLE drawslip 在drawslip表中的acnum字段中添加外键约束 ADD (CONSTRAINT R_6 FOREIGN KEY (acnum) REFERENCES luser(acnum)); 五、插入(insert)数据 1、插入储户表(luser)数据 insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE) values ('00001', 3422101, '刘忠田', '男',1.72 ,'北京市朝阳区', 345); insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE) values ('00002', 3422102, '周正义', '男',1.78, '天津市宝坻区', 123); insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE) values ('00003', 3422103, '陈光标', '男',1.80, '南京市新街口', 333); insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE) values ('00004', 3422104, '张茵', '女',1.65, '上海市黄浦区', 234); insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE) values ('00005', 3422105, '陈丽华', '女',1.70, '香港市旺角区', 111); 2、插入存款单表(depositslip)数据 insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY) values (98001,'00001', 120,to_date('08-08-2009','dd-mm-yyyy'), '整存整取'); insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY) values (98002,'00001', 300,to_date('10-08-2009','dd-mm-yyyy'), '整存整取');