银行ATM存取款机系统

【文件属性】：

文件名称：银行ATM存取款机系统

文件大小：483KB

文件格式：DOC

更新时间：2016-01-07 08:18:21

银行ATM

网上找的觉得挺有用的银行ATM存取款机系统 print '开始转账，请稍后......' print '交易正在进行，请稍后......' update Cardinfo set balance=balance-@money where customerID=(select customerID from UserInfo where customerName='张三') print '交易成功！交易金额：'+convert(varchar(20),@money) select @carod1=CarID,@ymoney1=balance from Cardinfo where customerID=(select customerID from UserInfo where customerName='张三') print '卡号'+@carod1+'余额'+convert(varchar(20),@ymoney1) select @curid1=curID,@type1=savingName,@name1=customerName from tradelnfo inner join Cardinfo on tradelnfo.CarID=Cardinfo.CarID inner join UserInfo on Cardinfo.customerID=UserInfo.customerID inner join deposit on Cardinfo.savingID=deposit.savingID where customerName='张三' update tradelnfo set