public class org.hsqldb.test.TestHarness extends javax.swing.JFrame
minor version: 0
major version: 59
flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
this_class: org.hsqldb.test.TestHarness
super_class: javax.swing.JFrame
{
protected java.lang.String dbURL;
descriptor: Ljava/lang/String;
flags: (0x0004) ACC_PROTECTED
protected javax.swing.JTextArea textArea;
descriptor: Ljavax/swing/JTextArea;
flags: (0x0004) ACC_PROTECTED
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=4, locals=2, args_size=1
start local 0 0: aload 0
arraylength
ifne 2
1: iconst_1
anewarray java.lang.String
dup
iconst_0
ldc "testrecovery"
aastore
astore 0
2: StackMap locals:
StackMap stack:
ldc "org.hsqldb.jdbc.JDBCDriver"
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
3: goto 8
StackMap locals:
StackMap stack: java.lang.Exception
4: astore 1
start local 1 5: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "ERROR: failed to load HSQLDB JDBC driver."
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
6: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
7: return
end local 1 8: StackMap locals:
StackMap stack:
new org.hsqldb.test.TestHarness
new java.lang.StringBuilder
dup
ldc "jdbc:hsqldb:file:"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
iconst_0
aaload
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokespecial org.hsqldb.test.TestHarness.<init>:(Ljava/lang/String;)V
9: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 10 0 args [Ljava/lang/String;
5 8 1 e Ljava/lang/Exception;
Exception table:
from to target type
2 3 4 Class java.lang.Exception
MethodParameters:
Name Flags
args
public void <init>(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=4, locals=3, args_size=2
start local 0 start local 1 0: aload 0
ldc "HSQLDB Test Harness"
invokespecial javax.swing.JFrame.<init>:(Ljava/lang/String;)V
1: aload 0
aload 1
putfield org.hsqldb.test.TestHarness.dbURL:Ljava/lang/String;
2: aload 0
iconst_0
invokevirtual org.hsqldb.test.TestHarness.setDefaultCloseOperation:(I)V
3: aload 0
new org.hsqldb.test.TestHarness$1
dup
aload 0
invokespecial org.hsqldb.test.TestHarness$1.<init>:(Lorg/hsqldb/test/TestHarness;)V
invokevirtual org.hsqldb.test.TestHarness.addWindowListener:(Ljava/awt/event/WindowListener;)V
4: aload 0
invokevirtual org.hsqldb.test.TestHarness.initComponents:()V
5: aload 0
sipush 400
sipush 400
invokevirtual org.hsqldb.test.TestHarness.setSize:(II)V
6: aload 0
sipush 200
sipush 200
invokevirtual org.hsqldb.test.TestHarness.setLocation:(II)V
7: aload 0
iconst_1
invokevirtual org.hsqldb.test.TestHarness.setVisible:(Z)V
8: aload 0
ldc "sa"
ldc "password"
iconst_1
invokevirtual org.hsqldb.test.TestHarness.getConnection:(Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
astore 2
start local 2 9: aload 0
getfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
ldc "Database already exists."
invokevirtual javax.swing.JTextArea.setText:(Ljava/lang/String;)V
10: aload 2
invokeinterface java.sql.Connection.close:()V
end local 2 11: goto 14
StackMap locals: org.hsqldb.test.TestHarness java.lang.String
StackMap stack: java.sql.SQLException
12: pop
13: aload 0
invokevirtual org.hsqldb.test.TestHarness.doCreate:()V
14: StackMap locals:
StackMap stack:
return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 15 0 this Lorg/hsqldb/test/TestHarness;
0 15 1 url Ljava/lang/String;
9 11 2 c Ljava/sql/Connection;
Exception table:
from to target type
8 11 12 Class java.sql.SQLException
MethodParameters:
Name Flags
url
protected void initComponents();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=4, locals=7, args_size=1
start local 0 0: aload 0
invokevirtual org.hsqldb.test.TestHarness.getContentPane:()Ljava/awt/Container;
astore 1
start local 1 1: aload 0
new javax.swing.JTextArea
dup
invokespecial javax.swing.JTextArea.<init>:()V
putfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
2: new javax.swing.JPanel
dup
new java.awt.FlowLayout
dup
invokespecial java.awt.FlowLayout.<init>:()V
invokespecial javax.swing.JPanel.<init>:(Ljava/awt/LayoutManager;)V
astore 2
start local 2 3: new javax.swing.JButton
dup
ldc "Close Gracefully"
invokespecial javax.swing.JButton.<init>:(Ljava/lang/String;)V
astore 3
start local 3 4: aload 3
new org.hsqldb.test.TestHarness$2
dup
aload 0
invokespecial org.hsqldb.test.TestHarness$2.<init>:(Lorg/hsqldb/test/TestHarness;)V
invokevirtual javax.swing.JButton.addActionListener:(Ljava/awt/event/ActionListener;)V
5: new javax.swing.JButton
dup
ldc "Add Row"
invokespecial javax.swing.JButton.<init>:(Ljava/lang/String;)V
astore 4
start local 4 6: aload 4
new org.hsqldb.test.TestHarness$3
dup
aload 0
invokespecial org.hsqldb.test.TestHarness$3.<init>:(Lorg/hsqldb/test/TestHarness;)V
invokevirtual javax.swing.JButton.addActionListener:(Ljava/awt/event/ActionListener;)V
7: new javax.swing.JButton
dup
ldc "List Data"
invokespecial javax.swing.JButton.<init>:(Ljava/lang/String;)V
astore 5
start local 5 8: aload 5
new org.hsqldb.test.TestHarness$4
dup
aload 0
invokespecial org.hsqldb.test.TestHarness$4.<init>:(Lorg/hsqldb/test/TestHarness;)V
invokevirtual javax.swing.JButton.addActionListener:(Ljava/awt/event/ActionListener;)V
9: new javax.swing.JButton
dup
ldc "Kill"
invokespecial javax.swing.JButton.<init>:(Ljava/lang/String;)V
astore 6
start local 6 10: aload 6
new org.hsqldb.test.TestHarness$5
dup
aload 0
invokespecial org.hsqldb.test.TestHarness$5.<init>:(Lorg/hsqldb/test/TestHarness;)V
invokevirtual javax.swing.JButton.addActionListener:(Ljava/awt/event/ActionListener;)V
11: aload 2
aload 4
invokevirtual javax.swing.JPanel.add:(Ljava/awt/Component;)Ljava/awt/Component;
pop
12: aload 2
aload 5
invokevirtual javax.swing.JPanel.add:(Ljava/awt/Component;)Ljava/awt/Component;
pop
13: aload 2
aload 6
invokevirtual javax.swing.JPanel.add:(Ljava/awt/Component;)Ljava/awt/Component;
pop
14: aload 2
aload 3
invokevirtual javax.swing.JPanel.add:(Ljava/awt/Component;)Ljava/awt/Component;
pop
15: aload 1
new javax.swing.JScrollPane
dup
aload 0
getfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
invokespecial javax.swing.JScrollPane.<init>:(Ljava/awt/Component;)V
ldc "Center"
invokevirtual java.awt.Container.add:(Ljava/awt/Component;Ljava/lang/Object;)V
16: aload 1
aload 2
ldc "South"
invokevirtual java.awt.Container.add:(Ljava/awt/Component;Ljava/lang/Object;)V
17: return
end local 6 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 18 0 this Lorg/hsqldb/test/TestHarness;
1 18 1 main Ljava/awt/Container;
3 18 2 buttons Ljavax/swing/JPanel;
4 18 3 close Ljavax/swing/JButton;
6 18 4 create Ljavax/swing/JButton;
8 18 5 list Ljavax/swing/JButton;
10 18 6 kill Ljavax/swing/JButton;
protected void doInsert();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=4, locals=5, args_size=1
start local 0 0: aload 0
ldc "ABCD"
ldc "dcba"
iconst_0
invokevirtual org.hsqldb.test.TestHarness.getConnection:(Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
astore 1
start local 1 1: aload 1
ifnull 17
2: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
start local 2 3: aload 2
4: ldc "SELECT NEXT VALUE FOR MySeq FROM Dummy"
5: invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
start local 3 6: aload 3
invokeinterface java.sql.ResultSet.next:()Z
pop
7: aload 3
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 4
start local 4 8: aload 2
new java.lang.StringBuilder
dup
ldc "INSERT INTO MyTable (Id, Name) VALUES ("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
9: iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ", 'This is row #"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc "')"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
10: invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
11: aload 0
new java.lang.StringBuilder
dup
ldc "Row #"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " added"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.test.TestHarness.append:(Ljava/lang/String;)V
12: aload 2
invokeinterface java.sql.Statement.close:()V
13: aload 1
invokeinterface java.sql.Connection.close:()V
end local 4 end local 3 end local 2 end local 1 14: goto 17
StackMap locals:
StackMap stack: java.sql.SQLException
15: astore 1
start local 1 16: aload 1
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 1 17: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 18 0 this Lorg/hsqldb/test/TestHarness;
1 14 1 con Ljava/sql/Connection;
3 14 2 stmt Ljava/sql/Statement;
6 14 3 rs Ljava/sql/ResultSet;
8 14 4 id I
16 17 1 e Ljava/sql/SQLException;
Exception table:
from to target type
0 14 15 Class java.sql.SQLException
protected void doListing();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=4, locals=4, args_size=1
start local 0 0: aload 0
ldc "ABCD"
ldc "dcba"
iconst_0
invokevirtual org.hsqldb.test.TestHarness.getConnection:(Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
astore 1
start local 1 1: aload 1
ifnull 16
2: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
start local 2 3: aload 2
4: ldc "SELECT * FROM MyTable ORDER BY Id ASC"
5: invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
start local 3 6: aload 0
ldc "Listing 'MyTable'...."
invokevirtual org.hsqldb.test.TestHarness.append:(Ljava/lang/String;)V
7: goto 9
8: StackMap locals: java.sql.Connection java.sql.Statement java.sql.ResultSet
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc " "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
iconst_1
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc ", "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 3
iconst_2
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.test.TestHarness.append:(Ljava/lang/String;)V
9: StackMap locals:
StackMap stack:
aload 3
invokeinterface java.sql.ResultSet.next:()Z
ifne 8
10: aload 0
ldc "...done."
invokevirtual org.hsqldb.test.TestHarness.append:(Ljava/lang/String;)V
11: aload 2
invokeinterface java.sql.Statement.close:()V
12: aload 1
invokeinterface java.sql.Connection.close:()V
end local 3 end local 2 end local 1 13: goto 16
StackMap locals: org.hsqldb.test.TestHarness
StackMap stack: java.sql.SQLException
14: astore 1
start local 1 15: aload 1
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 1 16: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 17 0 this Lorg/hsqldb/test/TestHarness;
1 13 1 con Ljava/sql/Connection;
3 13 2 stmt Ljava/sql/Statement;
6 13 3 rs Ljava/sql/ResultSet;
15 16 1 e Ljava/sql/SQLException;
Exception table:
from to target type
0 13 14 Class java.sql.SQLException
private void append(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0002) ACC_PRIVATE
Code:
stack=4, locals=2, args_size=2
start local 0 start local 1 0: aload 0
getfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
invokevirtual javax.swing.JTextArea.getText:()Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "\n"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 1
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual javax.swing.JTextArea.setText:(Ljava/lang/String;)V
1: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/hsqldb/test/TestHarness;
0 2 1 s Ljava/lang/String;
MethodParameters:
Name Flags
s
protected void doClose();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=4, locals=3, args_size=1
start local 0 0: aload 0
ldc "sa"
ldc "password"
iconst_0
invokevirtual org.hsqldb.test.TestHarness.getConnection:(Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
astore 1
start local 1 1: aload 1
ifnull 9
2: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
start local 2 3: aload 2
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
4: aload 2
invokeinterface java.sql.Statement.close:()V
5: aload 1
invokeinterface java.sql.Connection.close:()V
end local 2 end local 1 6: goto 9
StackMap locals:
StackMap stack: java.sql.SQLException
7: astore 1
start local 1 8: aload 1
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 1 9: StackMap locals:
StackMap stack:
iconst_0
invokestatic java.lang.System.exit:(I)V
10: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 11 0 this Lorg/hsqldb/test/TestHarness;
1 6 1 con Ljava/sql/Connection;
3 6 2 stmt Ljava/sql/Statement;
8 9 1 e Ljava/sql/SQLException;
Exception table:
from to target type
0 6 7 Class java.sql.SQLException
protected void doCreate();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=4, locals=3, args_size=1
start local 0 0: aload 0
ldc "sa"
ldc ""
iconst_0
invokevirtual org.hsqldb.test.TestHarness.getConnection:(Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
astore 1
start local 1 1: aload 1
ifnull 22
2: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
start local 2 3: aload 2
ldc "SET PASSWORD 'password'"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
4: aload 2
ldc "CREATE USER abcd PASSWORD 'dcba'"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
5: aload 2
ldc "CREATE SEQUENCE MySeq"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
6: aload 2
7: ldc "CREATE TABLE MyTable (Id INT PRIMARY KEY, Name VARCHAR(100) NOT NULL)"
8: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
9: aload 2
ldc "CREATE TABLE Dummy (Blah VARCHAR(100) NOT NULL)"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
10: aload 2
11: ldc "INSERT INTO Dummy (Blah) VALUES ('dummy value')"
12: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
13: aload 2
ldc "GRANT ALL ON MyTable TO abcd"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
14: aload 2
ldc "GRANT ALL ON Dummy TO abcd"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
15: aload 2
ldc "GRANT ALL ON SEQUENCE MySeq TO abcd"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
16: aload 2
invokeinterface java.sql.Statement.close:()V
17: aload 1
invokeinterface java.sql.Connection.close:()V
18: aload 0
getfield org.hsqldb.test.TestHarness.textArea:Ljavax/swing/JTextArea;
ldc "Database created."
invokevirtual javax.swing.JTextArea.setText:(Ljava/lang/String;)V
end local 2 end local 1 19: goto 22
StackMap locals:
StackMap stack: java.sql.SQLException
20: astore 1
start local 1 21: aload 1
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 1 22: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 23 0 this Lorg/hsqldb/test/TestHarness;
1 19 1 con Ljava/sql/Connection;
3 19 2 stmt Ljava/sql/Statement;
21 22 1 e Ljava/sql/SQLException;
Exception table:
from to target type
0 19 20 Class java.sql.SQLException
protected java.sql.Connection getConnection(java.lang.String, java.lang.String, boolean);
descriptor: (Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/Connection;
flags: (0x0004) ACC_PROTECTED
Code:
stack=3, locals=5, args_size=4
start local 0 start local 1 start local 2 start local 3 0: new java.util.Properties
dup
invokespecial java.util.Properties.<init>:()V
astore 4
start local 4 1: aload 4
ldc "user"
aload 1
invokevirtual java.util.Properties.put:(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
pop
2: aload 4
ldc "password"
aload 2
invokevirtual java.util.Properties.put:(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
pop
3: aload 4
ldc "ifexists"
iload 3
invokestatic java.lang.String.valueOf:(Z)Ljava/lang/String;
invokevirtual java.util.Properties.put:(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
pop
4: aload 0
getfield org.hsqldb.test.TestHarness.dbURL:Ljava/lang/String;
aload 4
invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;
areturn
end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 5 0 this Lorg/hsqldb/test/TestHarness;
0 5 1 username Ljava/lang/String;
0 5 2 password Ljava/lang/String;
0 5 3 ifExists Z
1 5 4 props Ljava/util/Properties;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
username
password
ifExists
}
SourceFile: "TestHarness.java"
NestMembers:
org.hsqldb.test.TestHarness$1 org.hsqldb.test.TestHarness$2 org.hsqldb.test.TestHarness$3 org.hsqldb.test.TestHarness$4 org.hsqldb.test.TestHarness$5
InnerClasses:
org.hsqldb.test.TestHarness$1
org.hsqldb.test.TestHarness$2
org.hsqldb.test.TestHarness$3
org.hsqldb.test.TestHarness$4
org.hsqldb.test.TestHarness$5