在项目中使用到Oracle数据库的Update触发器,先记录下来方便以后查阅。
预备知识和格式以后再编辑吧,先把内容贴出来。
CREATE OR REPLACE TRIGGER demo_trigger
AFTER UPDATE ON tb_goods
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN( NEW.AMOUNT = 10 OR NEW.AMOUNT = 0)
DECLARE
MSG VARCHAR2(100);
RECEIVER NUMBER;
SENDER NUMBER;
goUrl VARCHAR2(200);
STATE VARCHAR2(2);
-- Params VARCHAR2(30);
--Pvalue NUMBER;
BEGIN
MSG := '您的商品' || :NEW.GOODSNAME;
SENDER := 0;
STATE := '0';
goUrl := 'goodsAction_query.action';
SELECT S.USER_ID INTO RECEIVER FROM TB_SHOP S WHERE S.SHOP_ID = :NEW.SHOPID;
IF :NEW.AMOUNT = 10 THEN
MSG := MSG || '库存数量不足10件,请及时补货!';
INSERT INTO TB_ME