【YashanDB 知识库】statement 级别的触发器在 jdbc 接口调用 executeBatch 时被多次触发

drop table trig_test;
create table trig_test(t1 number,t2 number);drop table flag;
create table flag(t number);
create or replace trigger trig_01
before insert or update on trig_test
begin
  insert into flag values(1);
end;
/

//代码占位符
public static void main(String[]args){
    try(Connection conn = DBUtil.getConn()){
        conn.setAutoCommit(false);
        PreparedStatement ps = conn.prepareStatement("insert into trig_test(t1) values(?)");
        for(int i = 0; i < 100; i++){
            ps.setInt(1,i);
            ps.addBatch();
        }
        ps.executeBatch();
        conn.commit();
    }catch (Exception e){
        e.printStackTrace();
    }
}