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: .line 130
            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: .line 135
            ldc Lorg/hsqldb/sample/TriggerSample;
            invokevirtual java.lang.Class.getName:()Ljava/lang/String;
            putstatic org.hsqldb.sample.TriggerSample.impl:Ljava/lang/String;
         2: .line 147
            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 // org.hsqldb.sample.TriggerSample this
         0: .line 128
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
            return
        end local 0 // org.hsqldb.sample.TriggerSample this
      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 // org.hsqldb.sample.TriggerSample this
        start local 1 // int typ
        start local 2 // java.lang.String trn
        start local 3 // java.lang.String tn
        start local 4 // java.lang.Object[] or
        start local 5 // java.lang.Object[] nr
         0: .line 168
            ldc Lorg/hsqldb/sample/TriggerSample;
            dup
            astore 6
            monitorenter
         1: .line 169
            aload 4 /* or */
            ifnonnull 2
            ldc "null"
            goto 3
         2: .line 170
      StackMap locals: java.lang.Class
      StackMap stack:
            aload 4 /* or */
            invokestatic org.hsqldb.lib.StringUtil.arrayToString:(Ljava/lang/Object;)Ljava/lang/String;
         3: .line 169
      StackMap locals:
      StackMap stack: java.lang.String
            astore 7 /* ors */
        start local 7 // java.lang.String ors
         4: .line 171
            aload 5 /* nr */
            ifnonnull 5
            ldc "null"
            goto 6
         5: .line 172
      StackMap locals: java.lang.String
      StackMap stack:
            aload 5 /* nr */
            invokestatic org.hsqldb.lib.StringUtil.arrayToString:(Ljava/lang/Object;)Ljava/lang/String;
         6: .line 171
      StackMap locals:
      StackMap stack: java.lang.String
            astore 8 /* nrs */
        start local 8 // java.lang.String nrs
         7: .line 174
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            ldc "----------------------------------------"
            invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
         8: .line 175
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            aload 2 /* trn */
            iload 1 /* typ */
            aload 3 /* tn */
            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: .line 176
            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 /* ors */
            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: .line 177
            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 /* nrs */
            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: .line 178
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            invokevirtual java.io.PrintWriter.flush:()V
        12: .line 180
            ldc "TRIG_TEST"
            aload 3 /* tn */
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 21
        13: .line 181
            iload 1 /* typ */
            tableswitch { // 6 - 8
                    6: 14
                    7: 21
                    8: 19
              default: 21
          }
        14: .line 189
      StackMap locals: java.lang.String
      StackMap stack:
            aload 5 /* nr */
            iconst_0
            aaload
            checkcast java.lang.Number
            invokevirtual java.lang.Number.intValue:()I
            istore 9 /* ID */
        start local 9 // int ID
        15: .line 191
            iload 9 /* ID */
            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: .line 193
            goto 21
        end local 9 // int ID
        19: .line 198
      StackMap locals:
      StackMap stack:
            ldc "unchangable"
            aload 4 /* or */
            iconst_1
            aaload
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 21
        20: .line 199
            aload 5 /* nr */
            iconst_1
            aload 4 /* or */
            iconst_1
            aaload
            aastore
        21: .line 212
      StackMap locals:
      StackMap stack:
            iload 1 /* typ */
            aload 3 /* tn */
            aload 7 /* ors */
            aload 8 /* nrs */
            invokestatic org.hsqldb.sample.TriggerSample.doAuditStep:(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
        end local 8 // java.lang.String nrs
        end local 7 // java.lang.String ors
        22: .line 168
            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: .line 214
      StackMap locals:
      StackMap stack:
            return
        end local 5 // java.lang.Object[] nr
        end local 4 // java.lang.Object[] or
        end local 3 // java.lang.String tn
        end local 2 // java.lang.String trn
        end local 1 // int typ
        end local 0 // org.hsqldb.sample.TriggerSample this
      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 // boolean b
        start local 1 // java.lang.String msg
         0: .line 218
            iload 0 /* b */
            ifne 2
         1: .line 222
            sipush 458
            aload 1 /* msg */
            invokestatic org.hsqldb.error.Error.error:(ILjava/lang/String;)Lorg/hsqldb/HsqlException;
            athrow
         2: .line 224
      StackMap locals:
      StackMap stack:
            return
        end local 1 // java.lang.String msg
        end local 0 // boolean b
      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 // int typ
        start local 1 // java.lang.String tn
        start local 2 // java.lang.String ors
        start local 3 // java.lang.String nrs
         0: .line 232
            iload 0 /* typ */
            tableswitch { // 3 - 5
                    3: 1
                    4: 1
                    5: 1
              default: 12
          }
         1: .line 238
      StackMap locals:
      StackMap stack:
            invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
            astore 4 /* conn */
        start local 4 // java.sql.Connection conn
         2: .line 239
            aload 4 /* conn */
            ldc "INSERT INTO audit(op, tn, ors, nrs) VALUES(?, ?, ?, ?)"
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* stmt */
        start local 5 // java.sql.PreparedStatement stmt
         3: .line 241
            aload 5 /* stmt */
            iconst_1
            iload 0 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         4: .line 242
            aload 5 /* stmt */
            iconst_2
            aload 1 /* tn */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         5: .line 243
            aload 5 /* stmt */
            iconst_3
            aload 2 /* ors */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         6: .line 244
            aload 5 /* stmt */
            iconst_4
            aload 3 /* nrs */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         7: .line 245
            aload 5 /* stmt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
         8: .line 246
            aload 4 /* conn */
            invokeinterface java.sql.Connection.close:()V
         9: .line 247
            goto 12
        end local 5 // java.sql.PreparedStatement stmt
        end local 4 // java.sql.Connection conn
      StackMap locals:
      StackMap stack: java.sql.SQLException
        10: astore 6 /* se */
        start local 6 // java.sql.SQLException se
        11: .line 248
            aload 6 /* se */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 6 // java.sql.SQLException se
        12: .line 252
      StackMap locals:
      StackMap stack:
            return
        end local 3 // java.lang.String nrs
        end local 2 // java.lang.String ors
        end local 1 // java.lang.String tn
        end local 0 // int typ
      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 // int type
         0: .line 256
            iload 0 /* type */
            tableswitch { // 0 - 8
                    0: 2
                    1: 2
                    2: 2
                    3: 2
                    4: 2
                    5: 2
                    6: 1
                    7: 1
                    8: 1
              default: 3
          }
         1: .line 261
      StackMap locals:
      StackMap stack:
            ldc "BEFORE"
            areturn
         2: .line 269
      StackMap locals:
      StackMap stack:
            ldc "AFTER"
            areturn
         3: .line 272
      StackMap locals:
      StackMap stack:
            ldc ""
            areturn
        end local 0 // int type
      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 // int type
         0: .line 279
            iload 0 /* type */
            tableswitch { // 0 - 8
                    0: 1
                    1: 3
                    2: 2
                    3: 1
                    4: 3
                    5: 2
                    6: 1
                    7: 3
                    8: 2
              default: 4
          }
         1: .line 284
      StackMap locals:
      StackMap stack:
            ldc "INSERT"
            areturn
         2: .line 289
      StackMap locals:
      StackMap stack:
            ldc "UPDATE"
            areturn
         3: .line 294
      StackMap locals:
      StackMap stack:
            ldc "DELETE"
            areturn
         4: .line 297
      StackMap locals:
      StackMap stack:
            ldc ""
            areturn
        end local 0 // int type
      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 // int qs
         0: .line 303
            iload 0 /* qs */
            ifge 1
            ldc ""
            goto 2
         1: .line 304
      StackMap locals:
      StackMap stack:
            new java.lang.StringBuilder
            dup
            ldc "QUEUE "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            iload 0 /* qs */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         2: .line 303
      StackMap locals:
      StackMap stack: java.lang.String
            areturn
        end local 0 // int qs
      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 // int type
         0: .line 309
            iload 0 /* type */
            tableswitch { // 3 - 8
                    3: 1
                    4: 1
                    5: 1
                    6: 1
                    7: 1
                    8: 1
              default: 2
          }
         1: .line 317
      StackMap locals:
      StackMap stack:
            ldc "FOR EACH ROW"
            areturn
         2: .line 320
      StackMap locals:
      StackMap stack:
            ldc "FOR EACH STATEMENT"
            areturn
        end local 0 // int type
      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 // java.lang.String trn
        start local 1 // int typ
        start local 2 // java.lang.String tab
        start local 3 // int qs
        start local 4 // java.lang.String impl
         0: .line 329
            new java.lang.StringBuilder
            dup
            invokespecial java.lang.StringBuilder.<init>:()V
            astore 5 /* sb */
        start local 5 // java.lang.StringBuilder sb
         1: .line 331
            aload 5 /* sb */
            ldc "CREATE TRIGGER "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 332
            aload 5 /* sb */
            aload 0 /* trn */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 333
            aload 5 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
         4: .line 334
            aload 5 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getWhenSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         5: .line 335
            aload 5 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
         6: .line 336
            aload 5 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         7: .line 337
            aload 5 /* sb */
            ldc " ON "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         8: .line 338
            aload 5 /* sb */
            aload 2 /* tab */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         9: .line 339
            aload 5 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
        10: .line 340
            aload 5 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getForEachSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        11: .line 341
            aload 5 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
        12: .line 342
            aload 5 /* sb */
            iload 3 /* qs */
            invokestatic org.hsqldb.sample.TriggerSample.getQueueSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        13: .line 343
            aload 5 /* sb */
            ldc " CALL \""
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        14: .line 344
            aload 5 /* sb */
            aload 4 /* impl */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        15: .line 345
            aload 5 /* sb */
            ldc "\""
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        16: .line 347
            aload 5 /* sb */
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            areturn
        end local 5 // java.lang.StringBuilder sb
        end local 4 // java.lang.String impl
        end local 3 // int qs
        end local 2 // java.lang.String tab
        end local 1 // int typ
        end local 0 // java.lang.String trn
      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 // java.lang.String trn
        start local 1 // int typ
        start local 2 // java.lang.String tab
         0: .line 353
            new java.lang.StringBuilder
            dup
            invokespecial java.lang.StringBuilder.<init>:()V
            astore 3 /* sb */
        start local 3 // java.lang.StringBuilder sb
         1: .line 355
            aload 3 /* sb */
            ldc "TRIGGER : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 356
            aload 3 /* sb */
            aload 0 /* trn */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 357
            aload 3 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
         4: .line 358
            aload 3 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getWhenSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         5: .line 359
            aload 3 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
         6: .line 360
            aload 3 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getOperationSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         7: .line 361
            aload 3 /* sb */
            ldc " ON "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         8: .line 362
            aload 3 /* sb */
            aload 2 /* tab */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         9: .line 363
            aload 3 /* sb */
            bipush 32
            invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
            pop
        10: .line 364
            aload 3 /* sb */
            iload 1 /* typ */
            invokestatic org.hsqldb.sample.TriggerSample.getForEachSpec:(I)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        11: .line 366
            aload 3 /* sb */
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            areturn
        end local 3 // java.lang.StringBuilder sb
        end local 2 // java.lang.String tab
        end local 1 // int typ
        end local 0 // java.lang.String trn
      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: .line 372
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
         1: .line 374
            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: .line 375
      StackMap locals:
      StackMap stack: java.sql.SQLException
            astore 0 /* se */
        start local 0 // java.sql.SQLException se
         4: .line 376
            aload 0 /* se */
            athrow
        end local 0 // java.sql.SQLException se
         5: .line 377
      StackMap locals:
      StackMap stack: java.lang.Exception
            astore 0 /* e */
        start local 0 // java.lang.Exception e
         6: .line 378
            new java.sql.SQLException
            dup
            aload 0 /* e */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokespecial java.sql.SQLException.<init>:(Ljava/lang/String;)V
            athrow
        end local 0 // java.lang.Exception e
      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 // java.sql.Statement stmt
        start local 1 // java.lang.String trn
        start local 2 // int typ
         0: .line 384
            aload 0 /* stmt */
            aload 1 /* trn */
            iload 2 /* typ */
            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: .line 385
            return
        end local 2 // int typ
        end local 1 // java.lang.String trn
        end local 0 // java.sql.Statement stmt
      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: .line 389
            invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
            astore 0 /* conn */
        start local 0 // java.sql.Connection conn
         1: .line 390
            aload 0 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 1 /* stmt */
        start local 1 // java.sql.Statement stmt
         2: .line 392
            aload 1 /* stmt */
            ldc "DROP TABLE trig_test IF EXISTS"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         3: .line 393
            aload 1 /* stmt */
            ldc "CREATE TABLE trig_test(id INTEGER PRIMARY KEY, value VARCHAR(20))"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         4: .line 394
            aload 1 /* stmt */
            ldc "DROP TABLE audit IF EXISTS"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         5: .line 395
            aload 1 /* stmt */
            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: .line 396
            aload 1 /* stmt */
            ldc "tibr_trig_test"
            bipush 6
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
         7: .line 397
            aload 1 /* stmt */
            ldc "tia_trig_test"
            iconst_0
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
         8: .line 398
            aload 1 /* stmt */
            ldc "tiar_trig_test"
            iconst_3
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
         9: .line 399
            aload 1 /* stmt */
            ldc "tubr_trig_test"
            bipush 8
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        10: .line 400
            aload 1 /* stmt */
            ldc "tua_trig_test"
            iconst_2
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        11: .line 401
            aload 1 /* stmt */
            ldc "tuar_trig_test"
            iconst_5
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        12: .line 402
            aload 1 /* stmt */
            ldc "tdbr_trig_test"
            bipush 7
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        13: .line 403
            aload 1 /* stmt */
            ldc "tda_trig_test"
            iconst_1
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        14: .line 404
            aload 1 /* stmt */
            ldc "tdar_trig_test"
            iconst_4
            invokestatic org.hsqldb.sample.TriggerSample.createTrigger:(Ljava/sql/Statement;Ljava/lang/String;I)V
        15: .line 405
            aload 1 /* stmt */
            invokeinterface java.sql.Statement.close:()V
        16: .line 406
            aload 0 /* conn */
            invokeinterface java.sql.Connection.close:()V
        17: .line 407
            return
        end local 1 // java.sql.Statement stmt
        end local 0 // java.sql.Connection conn
      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: .line 411
            invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
            astore 0 /* conn */
        start local 0 // java.sql.Connection conn
         1: .line 412
            aload 0 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 1 /* stmt */
        start local 1 // java.sql.Statement stmt
         2: .line 414
            aload 0 /* conn */
            iconst_0
            invokeinterface java.sql.Connection.setAutoCommit:(Z)V
         3: .line 415
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES (1, 'hello')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         4: .line 416
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES (2, 'now what?')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         5: .line 417
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES (3, 'unchangable')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         6: .line 418
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES (4, 'goodbye')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         7: .line 419
            aload 0 /* conn */
            invokeinterface java.sql.Connection.commit:()V
         8: .line 420
            ldc "trig_test"
            invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
         9: .line 421
            aload 1 /* stmt */
            ldc "UPDATE trig_test SET value = 'all done'"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        10: .line 422
            aload 0 /* conn */
            invokeinterface java.sql.Connection.commit:()V
        11: .line 423
            ldc "trig_test"
            invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
        12: .line 424
            aload 1 /* stmt */
            ldc "DELETE FROM trig_test"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        13: .line 425
            aload 0 /* conn */
            invokeinterface java.sql.Connection.rollback:()V
        14: .line 426
            ldc "trig_test"
            invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
        15: .line 429
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES(11, 'whatever')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        16: .line 430
            goto 19
      StackMap locals: java.sql.Connection java.sql.Statement
      StackMap stack: java.sql.SQLException
        17: astore 2 /* se */
        start local 2 // java.sql.SQLException se
        18: .line 431
            aload 2 /* se */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 2 // java.sql.SQLException se
        19: .line 434
      StackMap locals:
      StackMap stack:
            aload 1 /* stmt */
            ldc "INSERT INTO trig_test VALUES(10, 'whatever')"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        20: .line 435
            aload 0 /* conn */
            invokeinterface java.sql.Connection.commit:()V
        21: .line 436
            ldc "trig_test"
            invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
        22: .line 437
            aload 1 /* stmt */
            invokeinterface java.sql.Statement.close:()V
        23: .line 438
            aload 0 /* conn */
            invokeinterface java.sql.Connection.close:()V
        24: .line 439
            return
        end local 1 // java.sql.Statement stmt
        end local 0 // java.sql.Connection conn
      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 // java.lang.String tn
         0: .line 443
            invokestatic org.hsqldb.sample.TriggerSample.getConnection:()Ljava/sql/Connection;
            astore 1 /* conn */
        start local 1 // java.sql.Connection conn
         1: .line 444
            aload 1 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 2 /* stmt */
        start local 2 // java.sql.Statement stmt
         2: .line 445
            aload 2 /* stmt */
            new java.lang.StringBuilder
            dup
            ldc "select * from "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* tn */
            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 /* rs */
        start local 3 // java.sql.ResultSet rs
         3: .line 446
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.getMetaData:()Ljava/sql/ResultSetMetaData;
            astore 4 /* rsmd */
        start local 4 // java.sql.ResultSetMetaData rsmd
         4: .line 447
            aload 4 /* rsmd */
            invokeinterface java.sql.ResultSetMetaData.getColumnCount:()I
            istore 5 /* count */
        start local 5 // int count
         5: .line 449
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            invokevirtual java.io.PrintWriter.println:()V
         6: .line 450
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            ldc "****************************************"
            invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
         7: .line 451
            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 /* tn */
            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: .line 452
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            ldc "****************************************"
            invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
         9: .line 453
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            invokevirtual java.io.PrintWriter.flush:()V
        10: .line 455
            goto 20
        11: .line 456
      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: .line 458
            iconst_1
            istore 6 /* i */
        start local 6 // int i
        13: goto 18
        14: .line 459
      StackMap locals: int
      StackMap stack:
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            aload 3 /* rs */
            iload 6 /* i */
            invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
            invokevirtual java.io.PrintWriter.print:(Ljava/lang/String;)V
        15: .line 461
            iload 6 /* i */
            iload 5 /* count */
            if_icmpge 17
        16: .line 462
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            ldc " : "
            invokevirtual java.io.PrintWriter.print:(Ljava/lang/String;)V
        17: .line 458
      StackMap locals:
      StackMap stack:
            iinc 6 /* i */ 1
      StackMap locals:
      StackMap stack:
        18: iload 6 /* i */
            iload 5 /* count */
            if_icmple 14
        end local 6 // int i
        19: .line 466
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            ldc "]"
            invokevirtual java.io.PrintWriter.println:(Ljava/lang/String;)V
        20: .line 455
      StackMap locals:
      StackMap stack:
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 11
        21: .line 469
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            invokevirtual java.io.PrintWriter.println:()V
        22: .line 470
            getstatic org.hsqldb.sample.TriggerSample.out:Ljava/io/PrintWriter;
            invokevirtual java.io.PrintWriter.flush:()V
        23: .line 471
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.close:()V
        24: .line 472
            aload 2 /* stmt */
            invokeinterface java.sql.Statement.close:()V
        25: .line 473
            aload 1 /* conn */
            invokeinterface java.sql.Connection.close:()V
        26: .line 474
            return
        end local 5 // int count
        end local 4 // java.sql.ResultSetMetaData rsmd
        end local 3 // java.sql.ResultSet rs
        end local 2 // java.sql.Statement stmt
        end local 1 // java.sql.Connection conn
        end local 0 // java.lang.String tn
      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: .line 478
            invokestatic org.hsqldb.sample.TriggerSample.setup:()V
         1: .line 479
            invokestatic org.hsqldb.sample.TriggerSample.doSomeWork:()V
         2: .line 480
            ldc "audit"
            invokestatic org.hsqldb.sample.TriggerSample.dumpTable:(Ljava/lang/String;)V
         3: .line 481
            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 // java.lang.String[] args
         0: .line 484
            invokestatic org.hsqldb.sample.TriggerSample.runSample:()V
         1: .line 485
            return
        end local 0 // java.lang.String[] args
      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"