java触发器如何创建表_java – H2 – 如何创建一个数据库触发器,将行更改记录到另一个表？...

声明此触发器：

CREATE TRIGGER my_trigger

BEFORE UPDATE

ON my_table

FOR EACH ROW

CALL "com.example.MyTrigger"

使用Java / JDBC实现触发器：

public class MyTrigger implements Trigger {

@Override

public void init(Connection conn, String schemaName,

String triggerName, String tableName, boolean before, int type)

throws SQLException {}

@Override

public void fire(Connection conn, Object[] oldRow, Object[] newRow)

throws SQLException {

try (PreparedStatement stmt = conn.prepareStatement(

"INSERT INTO log (field1, field2, ...) " +

"VALUES (?, ?, ...)")

) {

stmt.setObject(1, newRow[0]);

stmt.setObject(2, newRow[1]);

...

stmt.executeUpdate();

}

}

@Override

public void