Java数据库编程技术 第四章习题

3  为读者‘张无忌’办理借阅《红楼梦》书籍的手续

BEGIN;
INSERT INTO book()
VALUES('6','红楼梦','author6','pubComp6','2018-08-02','100','40');

INSERT INTO reader()
VALUES('7','张无忌','0','CHINA');

INSERT INTO borrow()
VALUES('7','6','2018-08-02 16:50:54','2018-08-05 16:57:04',NULL);

UPDATE `book` SET `bCount`=`bCount`-1
WHERE `bName`='红楼梦';

UPDATE `reader` set `lendNum`=`lendNum`+1
WHERE `rName`='张无忌';

COMMIT;

4  读者 ‘刘冰冰’缴纳罚金归还图书手续

BEGIN;
INSERT INTO book()
VALUES('7','西游记','author7','pubComp7','2018-08-02','100','30');

INSERT INTO reader()
VALUES('8','刘冰冰','1','CHINA');

INSERT INTO borrow()
VALUES('8