C#第八章课后作业2

INSERT INTO Card(ID,[PassWord],Balance,UserName)
VALUES ('0023_ABC','abc',100,'张军')
INSERT INTO Card(ID,[PassWord],Balance,UserName)
VALUES ('0024_ABD','abd',200,'李公凯')
INSERT INTO Card(ID,[PassWord],Balance,UserName)
VALUES ('0023_ABE','abe',300,'朱俊')

UPDATE Card SET [PassWord]='0023abc'
WHERE [PassWord]='abc'
UPDATE Card SET [PassWord]='36ccd'
WHERE [PassWord]='abe'
UPDATE Card SET Balance='98'
WHERE Balance=100
UPDATE Card SET Balance='44'
WHERE Balance=200
INSERT INTO Card(ID,[PassWord],Balance,UserName)
VALUES ('0036_CCD','36ccd',100,'何柳')
INSERT INTO Card(ID,[PassWord],Balance,UserName)
VALUES ('0089_EDE','zhang',134,'张峻')
DELETE FROM Card
WHERE UserName='李公凯'