DB_51Aspx/农行取款机系统.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

create database Bank	--创建数据库
use Bank
go
--卡信息(用于登陆)
if exists(select * from sysobjects where name='CardInfo')
drop table CardInfo
go
create table CardInfo
(
	Id int primary key identity(1,1),
	CardId numeric(18, 0),
	CardName varchar(20),
	CardPwd varchar(20),
	CardMoney money
)
--记录表(用于记录历史详情)
if exists(select * from sysobjects where name='Notes')
drop table Notes
go
create table Notes
(
	Id int primary key identity(1,1),
	showName varchar(20),
	showText varchar(100)
)
select * from CardInfo where CardId=6224123142384012
select * from Notes
insert into Notes values('admin','与'+convert(varchar(30),GETDATE())+'取出了100元')
insert into CardInfo values(6224123142384012,'Admin','scce',1000000),
										(6224123142384013,'Guest','123',0)
select * from CardInfo where CardId=1111111111111111 and CardPwd='scce'
select * from CardInfo where CardId=1111111111111111 and CardPwd=''
select * from CardInfo where CardId=6224123142384012 and CardPwd='scce'
--取钱的存储过程
if exists(select * from sysobjects where name='proc_GetMoney')
drop proc proc_GetMoney
go
create proc proc_GetMoney(@name varchar(20),@money money)
as
begin
	update CardInfo set CardMoney-=@money where CardName=@name
	insert into Notes values(@name,'于'+convert(varchar(30),YEAR(GETDATE()))+'年'+convert(varchar(30),MONTH(GETDATE()))+'月'+convert(varchar(30),DAY(GETDATE()))+'日'+convert(varchar(30),DATEPART(HH,GETDATE()))+'时'+convert(varchar(30),DATEPART(MI,GETDATE()))+'分'+convert(varchar(30),DATEPART(SS,GETDATE()))+'秒'+'取出了'+convert(varchar(10),@money)+'元')
	--insert into Notes values(@name,'于'+convert(varchar(30),GETDATE())+'取出了'+convert(varchar(10),@money)+'元')
	--print convert(varchar(30),YEAR(GETDATE()))+'年'+convert(varchar(30),MONTH(GETDATE()))+'月'+convert(varchar(30),DAY(GETDATE()))+'日'+convert(varchar(30),DATEPART(HH,GETDATE()))+'时'+convert(varchar(30),DATEPART(MI,GETDATE()))+'分'+convert(varchar(30),DATEPART(SS,GETDATE()))+'秒'
end
go
select * from cardinfo
select * from Notes where showName='Admin'
exec proc_GetMoney admin,10
select * from Notes where showName='Admin'
update CardInfo set CardId=10002 where CardName='Guest'
select * from CardInfo
select * from CardInfo where CardId=10002 and CardPwd='123'
select * from Notes where showName='Guest' order by Id desc
select GETDATE()
select DATEPART(MI,GETDATE())
--存钱的存储过程
if exists(select * from sysobjects where name='proc_SaveMoney')
drop proc proc_SaveMoney
go