|
|||||||||
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 databaseschemaName
- 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, or DELETE
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 undonevoid 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 |