qt和mysql图书管理系统_SQLite+Qt 图书管理系统设计（具体实现）

--------------检查出版年份-----------------

CREATE TRIGGER Tr_check_date AFTER insert ON book

FOR EACH ROW

WHEN(

(select Book_ID from book where publish_year > (SELECT strftime('%Y',date('now')) )

)is not null)

BEGIN

SELECT RAISE(ROLLBACK, 'IMPOSSIBLE DATE') ;

END;

--------------检查输入时 库存与数量是否相等-----------------

CREATE TRIGGER Tr_check_number BEFORE insert ON book

FOR EACH ROW

WHEN

( new.Number <> new.Stocks )

BEGIN

SELECT RAISE(ROLLBACK, 'ANY WRONG ABOUT NUMBER?');

END;

--------------借出检查是否有余量-----------------

CREATE TRIGGER Tr_borrow_check BEFORE insert ON record

FOR EACH ROW

WHEN 0=(select Stocks from book where Book_ID=new.Book_ID)

BEGIN

SELECT RAISE(ROLLBACK, 'NO REMAINING') ;

END;

---