1.记实数据库的某个用户对于数据库的操作,首先要一个记实操作信息的表: Java代码/ j& ~ b' ]4 p( [/ Z/ h4 R5 B u3 q; a
1 create table mylog(
" x+ T8 K" Y _( j% q/ I9 U, M0 ^ 2 user_name varchar2(10),
- X1 K& `% k/ T F: K \8 J 3 oper_time date,
% g/ p; A, S% s) f7 Y" K 4 operate_type varchar2(10): ~, A+ b5 l6 R$ M
5* )4 I8 a8 r2 j3 J0 q( T5 R, t
2.对应的trigger,下面以oracle的dept表为例子:
% Q9 ~$ C4 }! F Java代码
( ^5 j% W# w, @" ^# i, e SQL> create or replace trigger my_tri
# |5 o1 T- E2 W* ?' Q2 K 2 after insert or update or delete on dept- \1 B* w/ @5 A( q) v" O1 s) c
3 begin
; q+ {* { f& o" B1 d0 T3 x 4 if inserting then
# c+ ^: n& F/ V# K 5 insert into mylog values(user,sysdate,'insert');
7 D' v1 o0 {0 } 6 elsif updating then! j& R r6 y8 X
7 insert into mylog values(user,sysdate,'update');; j3 G; s9 b1 B. M* }7 y
8 else% f- v5 \) u1 }1 Q
9 insert into mylog values(user,sysdate,'delete');
; F# m1 K3 t6 _0 C' J% R0 B 10 end if;
1 _" y2 q& T4 W, S1 W6 G: P2 S 11 end; |