如何用java创建触发器

java是应用程序，可以通过jdbc接口调用触发器：

create or replace trigger bj_customer

before update on customer

for each row

begin

update order set

cu_no=:new.cu_no，

cu_name=:new.cu_name，

cu_address=:new.cu_addess，

where cu_no=:old.cu_no；

end

调用executeUpdate方法即可

final Timer machinetimer = new Timer()

machinetimer.schedule(new TimerTask() {

@Override

public void run() {

//定时执行的方法

XXXX()

}

}, 1000, 1000)

第一个 1000 代表系统运行后，这个定时任务多久会执行。

第二个 1000 代表每次执行间隔时间

如果有不懂的可以再来问我

最基本的触发器是针对表的Insert、Update、Delete这三种 *** 作来的。触发器可以建立在表上，也可以建立在视图上。建立在表上的触发器会在表内容发生改变时触发。建立在视图上的触发器会在视图内容改变时触发。注意，视图触发器仅会在明确对视图进行 *** 作的SQL语句执行时才会触发，当基本表的内容发生改变而引起视图内容变化时，不会触发视图触发器。\x0d\x0a\x0d\x0a下面是建立表触发器的代码：\x0d\x0acreate or replace trigger tg_E_CONTACT\x0d\x0abefore update or insert or delete on E_CONTACT\x0d\x0afor each row\x0d\x0abegin\x0d\x0aif inserting then\x0d\x0ainsert into [email protected]\x0d\x0avalues\x0d\x0a(:new.TELEPHONE, :new.EMPLOYEEID, :new.STATUS)\x0d\x0aelse\x0d\x0aif updating then\x0d\x0aupdate [email protected] s\x0d\x0aset s.TELEPHONE = :new.TELEPHONE,\x0d\x0as.EMPLOYEEID = :new.EMPLOYEEID,\x0d\x0as.STATUS = :new.STATUS\x0d\x0awhere s.employeeid = :old.employeeid\x0d\x0aelse\x0d\x0aif deleting then\x0d\x0adelete from [email protected] s\x0d\x0awhere s.employeeid = :old.employeeid\x0d\x0aend if\x0d\x0aend if\x0d\x0aend if\x0d\x0aend\x0d\x0a下面是建立视图触发器的代码：（注意里面的instead of）\x0d\x0acreate or replace trigger tg_E_CONTACT\x0d\x0abefore instead of update or instead of insert or instead of delete on E_CONTACT\x0d\x0afor each row\x0d\x0abegin\x0d\x0aif inserting then\x0d\x0ainsert into [email protected]\x0d\x0avalues\x0d\x0a(:new.TELEPHONE, :new.EMPLOYEEID, :new.STATUS)\x0d\x0aelse\x0d\x0aif updating then\x0d\x0aupdate [email protected] s\x0d\x0aset s.TELEPHONE = :new.TELEPHONE,\x0d\x0as.EMPLOYEEID = :new.EMPLOYEEID,\x0d\x0as.STATUS = :new.STATUS\x0d\x0awhere s.employeeid = :old.employeeid\x0d\x0aelse\x0d\x0aif deleting then\x0d\x0adelete from [email protected] s\x0d\x0awhere s.employeeid = :old.employeeid\x0d\x0aend if\x0d\x0aend if\x0d\x0aend if\x0d\x0aend

---