测试和交易.sql

QL SERVER 应用开发 银行ATM(取款机）系统 数据库设计 我在学校的 SQL项目,模拟 银行ATM(取款机）系统

use bankDB
GO
--插入测试数据和交易信息：
insert into userInfo(customerName,PID,telephone,address)
values('张三','123456789012345','0100-67898978','北京海淀')

insert into userInfo(customerName,PID,telephone,address)
values('李四','321245678912345678','0478-44443333',NULL)

select * from userInfo

insert into cardInfo(cardID,curType,savingType,openMoney,balance,pass,IsReportLoss,customerID)
values('1010 3576 1212 1134','RMB','定期',1,1,'888888',0,2)

insert into cardInfo(cardID,curType,savingType,openMoney,balance,pass,IsReportLoss,customerID)
values('1010 3576 1234 5678','RMB','活期',1000,1000,'888888',0,1)

select * from cardInfo

insert into transInfo(transType,cardID,transMoney,remark)
values('支取','1010 3576 1234 5678',900,null)

update cardInfo set balance=balance-900 where cardID='1010 3576 1234 5678'

insert into transInfo(transType,cardID,transMoney,remark)
values('存入','1010 3576 1212 1134',5000,null)

update cardInfo set balance=balance+5000 where cardID='1010 3576 1212 1134'
GO
select * from cardInfo
select * from transInfo
GO