public class org.hsqldb.sample.TriggerSample implements org.hsqldb.trigger.Trigger
minor version: 0
major version: 59
flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
this_class: org.hsqldb.sample.TriggerSample
super_class: java.lang.Object
{
static final java.io.PrintWriter out;
descriptor: Ljava/io/PrintWriter;
flags: (0x0018) ACC_STATIC, ACC_FINAL
static final java.lang.String drv;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "org.hsqldb.jdbc.JDBCDriver"
static final java.lang.String url;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "jdbc:hsqldb:mem:trigger-sample"
static final java.lang.String usr;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "SA"
static final java.lang.String pwd;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: ""
static final java.lang.String impl;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
static final java.lang.String tn;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "trig_test"
static final java.lang.String drop_test_table_stmt;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "DROP TABLE trig_test IF EXISTS"
static final java.lang.String create_test_table_stmt;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "CREATE TABLE trig_test(id INTEGER PRIMARY KEY, value VARCHAR(20))"
static final java.lang.String drop_audit_table_stmt;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "DROP TABLE audit IF EXISTS"
static final java.lang.String create_audit_table_stmt;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "CREATE TABLE audit(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1), op VARCHAR(6), tn VARCHAR(20), ors LONGVARCHAR, nrs LONGVARCHAR, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"
static final java.lang.String audit_insert_stmt;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "INSERT INTO audit(op, tn, ors, nrs) VALUES(?, ?, ?, ?)"
static void <clinit>();
descriptor: ()V
flags: (0x0008) ACC_STATIC
Code:
stack=3, locals=0, args_size=0
0: new java.io.PrintWriter
dup
getstatic java.lang.System.out:Ljava/io/PrintStream;
invokespecial java.io.PrintWriter.<init>:(Ljava/io/OutputStream;)V
putstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
1: ldc Lorg/hsqldb/sample/TriggerSample;
invokevirtual java.lang.Class.getName:()Ljava/lang/String;
putstatic org.hsqldb.sample.TriggerSample.impl:Ljava/lang/String;
2: return
LocalVariableTable:
Start End Slot Name Signature
public void <init>();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
invokespecial java.lang.Object.<init>:()V
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 1 0 this Lorg/hsqldb/sample/TriggerSample;
public void fire(int, java.lang.String, java.lang.String, java.lang.Object[], java.lang.Object[]);
descriptor: (ILjava/lang/String;Ljava/lang/String;[Ljava/lang/Object;[Ljava/lang/Object;)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=4, locals=10, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: ldc Lorg/hsqldb/sample/TriggerSample;
dup
astore 6
monitorenter
1: aload 4
ifnonnull 2
ldc "null"
goto 3
2: StackMap locals: java.lang.Class
StackMap stack:
aload 4
invokestatic org.hsqldb.lib.StringUtil.arrayToString:(Ljava/lang/Object;)Ljava/lang/String;
3: StackMap locals:
StackMap stack: java.lang.String
astore 7
start local 7 4: aload 5
ifnonnull 5
ldc "null"
goto 6
5: StackMap locals: java.lang.String
StackMap stack:
aload 5
invokestatic org.hsqldb.lib.StringUtil.arrayToString:(Ljava/lang/Object;)Ljava/lang/String;
6: StackMap locals:
StackMap stack: java.lang.String
astore 8
start local 8 7: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc "----------------------------------------"
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
8: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
aload 2
iload 1
aload 3
invokestatic org.hsqldb.sample.TriggerSample.getTriggerDescriptor:(Ljava/lang/String;ILjava/lang/String;)Ljava/lang/String;
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
9: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
new java.lang.StringBuilder
dup
ldc "old row : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 7
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
10: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
new java.lang.StringBuilder
dup
ldc "new row : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 8
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
11: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
invokevirtual java.io.PrintWriter.flush:()V
12: ldc "TRIG_TEST"
aload 3
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 21
13: iload 1
tableswitch { // 6 - 8
6: 14
7: 21
8: 19
default: 21
}
14: StackMap locals: java.lang.String
StackMap stack:
aload 5
iconst_0
aaload
checkcast java.lang.Number
invokevirtual java.lang.Number.intValue:()I
istore 9
start local 9 15: iload 9
bipush 11
if_icmpge 16
iconst_1
goto 17
StackMap locals: int
StackMap stack:
16: iconst_0
StackMap locals:
StackMap stack: int
17: ldc "ID < 11"
invokestatic org.hsqldb.sample.TriggerSample.doAssert:(ZLjava/lang/String;)V
18: goto 21
end local 9 19: StackMap locals:
StackMap stack:
ldc "unchangable"
aload 4
iconst_1
aaload
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 21
20: aload 5
iconst_1
aload 4
iconst_1
aaload
aastore
21: StackMap locals:
StackMap stack:
iload 1
aload 3
aload 7
aload 8
invokestatic org.hsqldb.sample.TriggerSample.doAuditStep:(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
end local 8 end local 7 22: aload 6
monitorexit
23: goto 26
StackMap locals: org.hsqldb.sample.TriggerSample int java.lang.String java.lang.String java.lang.Object[] java.lang.Object[] java.lang.Class
StackMap stack: java.lang.Throwable
24: aload 6
monitorexit
25: athrow
26: StackMap locals:
StackMap stack:
return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 27 0 this Lorg/hsqldb/sample/TriggerSample;
0 27 1 typ I
0 27 2 trn Ljava/lang/String;
0 27 3 tn Ljava/lang/String;
0 27 4 or [Ljava/lang/Object;
0 27 5 nr [Ljava/lang/Object;
4 22 7 ors Ljava/lang/String;
7 22 8 nrs Ljava/lang/String;
15 19 9 ID I
Exception table:
from to target type
1 23 24 any
24 25 24 any
MethodParameters:
Name Flags
typ
trn
tn
or
nr
private static void doAssert(boolean, java.lang.String);
descriptor: (ZLjava/lang/String;)V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: iload 0
ifne 2
1: sipush 458
aload 1
invokestatic org.hsqldb.error.Error.error:(ILjava/lang/String;)Lorg/hsqldb/HsqlException;
athrow
2: StackMap locals:
StackMap stack:
return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 b Z
0 3 1 msg Ljava/lang/String;
MethodParameters:
Name Flags
b
msg
private static void doAuditStep(int, java.lang.String, java.lang.String, java.lang.String);
descriptor: (ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=3, locals=7, args_size=4
start local 0 start local 1 start local 2 start local 3 0: iload 0
tableswitch { // 3 - 5
3: 1
4: 1
5: 1
default: 12
}
1: StackMap locals:
StackMap stack:
invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
astore 4
start local 4 2: aload 4
ldc "INSERT INTO audit(op, tn, ors, nrs) VALUES(?, ?, ?, ?)"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 3: aload 5
iconst_1
iload 0
invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
4: aload 5
iconst_2
aload 1
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
5: aload 5
iconst_3
aload 2
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
6: aload 5
iconst_4
aload 3
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
7: aload 5
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
8: aload 4
invokeinterface java.sql.Connection.close:()V
9: goto 12
end local 5 end local 4 StackMap locals:
StackMap stack: java.sql.SQLException
10: astore 6
start local 6 11: aload 6
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 6 12: StackMap locals:
StackMap stack:
return
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 13 0 typ I
0 13 1 tn Ljava/lang/String;
0 13 2 ors Ljava/lang/String;
0 13 3 nrs Ljava/lang/String;
2 10 4 conn Ljava/sql/Connection;
3 10 5 stmt Ljava/sql/PreparedStatement;
11 12 6 se Ljava/sql/SQLException;
Exception table:
from to target type
1 9 10 Class java.sql.SQLException
MethodParameters:
Name Flags
typ
tn
ors
nrs
public static java.lang.String getWhenSpec(int);
descriptor: (I)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: iload 0
tableswitch { // 0 - 8
0: 2
1: 2
2: 2
3: 2
4: 2
5: 2
6: 1
7: 1
8: 1
default: 3
}
1: StackMap locals:
StackMap stack:
ldc "BEFORE"
areturn
2: StackMap locals:
StackMap stack:
ldc "AFTER"
areturn
3: StackMap locals:
StackMap stack:
ldc ""
areturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 type I
MethodParameters:
Name Flags
type
public static java.lang.String getOperationSpec(int);
descriptor: (I)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: iload 0
tableswitch { // 0 - 8
0: 1
1: 3
2: 2
3: 1
4: 3
5: 2
6: 1
7: 3
8: 2
default: 4
}
1: StackMap locals:
StackMap stack:
ldc "INSERT"
areturn
2: StackMap locals:
StackMap stack:
ldc "UPDATE"
areturn
3: StackMap locals:
StackMap stack:
ldc "DELETE"
areturn
4: StackMap locals:
StackMap stack:
ldc ""
areturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 5 0 type I
MethodParameters:
Name Flags
type
public static java.lang.String getQueueSpec(int);
descriptor: (I)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=3, locals=1, args_size=1
start local 0 0: iload 0
ifge 1
ldc ""
goto 2
1: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "QUEUE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 0
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
2: StackMap locals:
StackMap stack: java.lang.String
areturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 qs I
MethodParameters:
Name Flags
qs
public static java.lang.String getForEachSpec(int);
descriptor: (I)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: iload 0
tableswitch { // 3 - 8
3: 1
4: 1
5: 1
6: 1
7: 1
8: 1
default: 2
}
1: StackMap locals:
StackMap stack:
ldc "FOR EACH ROW"
areturn
2: StackMap locals:
StackMap stack:
ldc "FOR EACH STATEMENT"
areturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 type I
MethodParameters:
Name Flags
type
public static java.lang.String getTriggerDDL(java.lang.String, int, java.lang.String, int, java.lang.String);
descriptor: (Ljava/lang/String;ILjava/lang/String;ILjava/lang/String;)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=2, locals=6, args_size=5
start local 0 start local 1 start local 2 start local 3 start local 4 0: new java.lang.StringBuilder
dup
invokespecial java.lang.StringBuilder.<init>:()V
astore 5
start local 5 1: aload 5
ldc "CREATE TRIGGER "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
2: aload 5
aload 0
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
3: aload 5
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
4: aload 5
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getWhenSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
5: aload 5
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
6: aload 5
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
7: aload 5
ldc " ON "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
8: aload 5
aload 2
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
9: aload 5
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
10: aload 5
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getForEachSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
11: aload 5
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
12: aload 5
iload 3
invokestatic org.hsqldb.sample.TriggerSample.getQueueSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
13: aload 5
ldc " CALL \""
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
14: aload 5
aload 4
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
15: aload 5
ldc "\""
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
16: aload 5
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
areturn
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 17 0 trn Ljava/lang/String;
0 17 1 typ I
0 17 2 tab Ljava/lang/String;
0 17 3 qs I
0 17 4 impl Ljava/lang/String;
1 17 5 sb Ljava/lang/StringBuilder;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
trn
typ
tab
qs
impl
public static java.lang.String getTriggerDescriptor(java.lang.String, int, java.lang.String);
descriptor: (Ljava/lang/String;ILjava/lang/String;)Ljava/lang/String;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=2, locals=4, args_size=3
start local 0 start local 1 start local 2 0: new java.lang.StringBuilder
dup
invokespecial java.lang.StringBuilder.<init>:()V
astore 3
start local 3 1: aload 3
ldc "TRIGGER : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
2: aload 3
aload 0
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
3: aload 3
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
4: aload 3
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getWhenSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
5: aload 3
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
6: aload 3
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
7: aload 3
ldc " ON "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
8: aload 3
aload 2
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
9: aload 3
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
10: aload 3
iload 1
invokestatic org.hsqldb.sample.TriggerSample.getForEachSpec:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
11: aload 3
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
areturn
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 12 0 trn Ljava/lang/String;
0 12 1 typ I
0 12 2 tab Ljava/lang/String;
1 12 3 sb Ljava/lang/StringBuilder;
MethodParameters:
Name Flags
trn
typ
tab
private static java.sql.Connection getConnection();
descriptor: ()Ljava/sql/Connection;
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=3, locals=1, args_size=0
0: ldc "org.hsqldb.jdbc.JDBCDriver"
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
1: ldc "jdbc:hsqldb:mem:trigger-sample"
ldc "SA"
ldc ""
invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
2: areturn
3: StackMap locals:
StackMap stack: java.sql.SQLException
astore 0
start local 0 4: aload 0
athrow
end local 0 5: StackMap locals:
StackMap stack: java.lang.Exception
astore 0
start local 0 6: new java.sql.SQLException
dup
aload 0
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokespecial java.sql.SQLException.<init>:(Ljava/lang/String;)V
athrow
end local 0 LocalVariableTable:
Start End Slot Name Signature
4 5 0 se Ljava/sql/SQLException;
6 7 0 e Ljava/lang/Exception;
Exception table:
from to target type
0 2 3 Class java.sql.SQLException
0 2 5 Class java.lang.Exception
Exceptions:
throws java.sql.SQLException
private static void createTrigger(java.sql.Statement, java.lang.String, int);
descriptor: (Ljava/sql/Statement;Ljava/lang/String;I)V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=6, locals=3, args_size=3
start local 0 start local 1 start local 2 0: aload 0
aload 1
iload 2
ldc "trig_test"
iconst_0
getstatic org.hsqldb.sample.TriggerSample.impl:Ljava/lang/String;
invokestatic org.hsqldb.sample.TriggerSample.getTriggerDDL:(Ljava/lang/String;ILjava/lang/String;ILjava/lang/String;)Ljava/lang/String;
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
1: return
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 stmt Ljava/sql/Statement;
0 2 1 trn Ljava/lang/String;
0 2 2 typ I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
stmt
trn
typ
private static void setup();
descriptor: ()V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=3, locals=2, args_size=0
0: invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
astore 0
start local 0 1: aload 0
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 1
start local 1 2: aload 1
ldc "DROP TABLE trig_test IF EXISTS"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
3: aload 1
ldc "CREATE TABLE trig_test(id INTEGER PRIMARY KEY, value VARCHAR(20))"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
4: aload 1
ldc "DROP TABLE audit IF EXISTS"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
5: aload 1
ldc "CREATE TABLE audit(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1), op VARCHAR(6), tn VARCHAR(20), ors LONGVARCHAR, nrs LONGVARCHAR, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
6: aload 1
ldc "tibr_trig_test"
bipush 6
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
7: aload 1
ldc "tia_trig_test"
iconst_0
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
8: aload 1
ldc "tiar_trig_test"
iconst_3
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
9: aload 1
ldc "tubr_trig_test"
bipush 8
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
10: aload 1
ldc "tua_trig_test"
iconst_2
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
11: aload 1
ldc "tuar_trig_test"
iconst_5
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
12: aload 1
ldc "tdbr_trig_test"
bipush 7
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
13: aload 1
ldc "tda_trig_test"
iconst_1
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
14: aload 1
ldc "tdar_trig_test"
iconst_4
invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
15: aload 1
invokeinterface java.sql.Statement.close:()V
16: aload 0
invokeinterface java.sql.Connection.close:()V
17: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
1 18 0 conn Ljava/sql/Connection;
2 18 1 stmt Ljava/sql/Statement;
Exceptions:
throws java.sql.SQLException
private static void doSomeWork();
descriptor: ()V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=2, locals=3, args_size=0
0: invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
astore 0
start local 0 1: aload 0
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 1
start local 1 2: aload 0
iconst_0
invokeinterface java.sql.Connection.setAutoCommit:(Z)V
3: aload 1
ldc "INSERT INTO trig_test VALUES (1, 'hello')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
4: aload 1
ldc "INSERT INTO trig_test VALUES (2, 'now what?')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
5: aload 1
ldc "INSERT INTO trig_test VALUES (3, 'unchangable')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
6: aload 1
ldc "INSERT INTO trig_test VALUES (4, 'goodbye')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
7: aload 0
invokeinterface java.sql.Connection.commit:()V
8: ldc "trig_test"
invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
9: aload 1
ldc "UPDATE trig_test SET value = 'all done'"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
10: aload 0
invokeinterface java.sql.Connection.commit:()V
11: ldc "trig_test"
invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
12: aload 1
ldc "DELETE FROM trig_test"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
13: aload 0
invokeinterface java.sql.Connection.rollback:()V
14: ldc "trig_test"
invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
15: aload 1
ldc "INSERT INTO trig_test VALUES(11, 'whatever')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
16: goto 19
StackMap locals: java.sql.Connection java.sql.Statement
StackMap stack: java.sql.SQLException
17: astore 2
start local 2 18: aload 2
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 2 19: StackMap locals:
StackMap stack:
aload 1
ldc "INSERT INTO trig_test VALUES(10, 'whatever')"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
20: aload 0
invokeinterface java.sql.Connection.commit:()V
21: ldc "trig_test"
invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
22: aload 1
invokeinterface java.sql.Statement.close:()V
23: aload 0
invokeinterface java.sql.Connection.close:()V
24: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
1 25 0 conn Ljava/sql/Connection;
2 25 1 stmt Ljava/sql/Statement;
18 19 2 se Ljava/sql/SQLException;
Exception table:
from to target type
15 16 17 Class java.sql.SQLException
Exceptions:
throws java.sql.SQLException
private static void dumpTable(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=4, locals=7, args_size=1
start local 0 0: invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
astore 1
start local 1 1: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
start local 2 2: aload 2
new java.lang.StringBuilder
dup
ldc "select * from "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
start local 3 3: aload 3
invokeinterface java.sql.ResultSet.getMetaData:()Ljava/sql/ResultSetMetaData;
astore 4
start local 4 4: aload 4
invokeinterface java.sql.ResultSetMetaData.getColumnCount:()I
istore 5
start local 5 5: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
invokevirtual java.io.PrintWriter.println:()V
6: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc "****************************************"
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
7: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
new java.lang.StringBuilder
dup
ldc "DUMP FOR TABLE: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
8: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc "****************************************"
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
9: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
invokevirtual java.io.PrintWriter.flush:()V
10: goto 20
11: StackMap locals: java.lang.String java.sql.Connection java.sql.Statement java.sql.ResultSet java.sql.ResultSetMetaData int
StackMap stack:
getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc "["
invokevirtual java.io.PrintWriter.print:(Ljava/lang/String;)V
12: iconst_1
istore 6
start local 6 13: goto 18
14: StackMap locals: int
StackMap stack:
getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
aload 3
iload 6
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.io.PrintWriter.print:(Ljava/lang/String;)V
15: iload 6
iload 5
if_icmpge 17
16: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc " : "
invokevirtual java.io.PrintWriter.print:(Ljava/lang/String;)V
17: StackMap locals:
StackMap stack:
iinc 6 1
StackMap locals:
StackMap stack:
18: iload 6
iload 5
if_icmple 14
end local 6 19: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
ldc "]"
invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
20: StackMap locals:
StackMap stack:
aload 3
invokeinterface java.sql.ResultSet.next:()Z
ifne 11
21: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
invokevirtual java.io.PrintWriter.println:()V
22: getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
invokevirtual java.io.PrintWriter.flush:()V
23: aload 3
invokeinterface java.sql.ResultSet.close:()V
24: aload 2
invokeinterface java.sql.Statement.close:()V
25: aload 1
invokeinterface java.sql.Connection.close:()V
26: return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 27 0 tn Ljava/lang/String;
1 27 1 conn Ljava/sql/Connection;
2 27 2 stmt Ljava/sql/Statement;
3 27 3 rs Ljava/sql/ResultSet;
4 27 4 rsmd Ljava/sql/ResultSetMetaData;
5 27 5 count I
13 19 6 i I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
tn
private static void runSample();
descriptor: ()V
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
Code:
stack=1, locals=0, args_size=0
0: invokestatic org.hsqldb.sample.TriggerSample.setup:()V
1: invokestatic org.hsqldb.sample.TriggerSample.doSomeWork:()V
2: ldc "audit"
invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
3: return
LocalVariableTable:
Start End Slot Name Signature
Exceptions:
throws java.sql.SQLException
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=0, locals=1, args_size=1
start local 0 0: invokestatic org.hsqldb.sample.TriggerSample.runSample:()V
1: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 args [Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
args
}
SourceFile: "TriggerSample.java"