|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
public interface Trigger
A class that implements this interface can be used as a trigger.
| Field Summary | |
|---|---|
static int |
DELETE
The trigger is called for DELETE statements. |
static int |
INSERT
The trigger is called for INSERT statements. |
static int |
SELECT
The trigger is called for SELECT statements. |
static int |
UPDATE
The trigger is called for UPDATE statements. |
| Method Summary | |
|---|---|
void |
close()
This method is called when the database is closed. |
void |
fire(java.sql.Connection conn,
java.lang.Object[] oldRow,
java.lang.Object[] newRow)
This method is called for each triggered action. |
void |
init(java.sql.Connection conn,
java.lang.String schemaName,
java.lang.String triggerName,
java.lang.String tableName,
boolean before,
int type)
This method is called by the database engine once when initializing the trigger. |
void |
remove()
This method is called when the trigger is dropped. |
| Field Detail |
|---|
static final int INSERT
static final int UPDATE
static final int DELETE
static final int SELECT
| Method Detail |
|---|
void init(java.sql.Connection conn,
java.lang.String schemaName,
java.lang.String triggerName,
java.lang.String tableName,
boolean before,
int type)
throws java.sql.SQLException
conn - a connection to the database (a system connection)schemaName - the name of the schematriggerName - the name of the trigger used in the CREATE TRIGGER
statementtableName - the name of the tablebefore - whether the fire method is called before or after the
operation is performedtype - the operation type: INSERT, UPDATE, DELETE, SELECT, or a
combination (this parameter is a bit field)
java.sql.SQLException
void fire(java.sql.Connection conn,
java.lang.Object[] oldRow,
java.lang.Object[] newRow)
throws java.sql.SQLException
The row arrays contain all columns of the table, in the same order as defined in the table.
conn - a connection to the databaseoldRow - the old row, or null if no old row is available (for
INSERT)newRow - the new row, or null if no new row is available (for
DELETE)
java.sql.SQLException - if the operation must be undone
void close()
throws java.sql.SQLException
java.sql.SQLException
void remove()
throws java.sql.SQLException
java.sql.SQLException
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||