class org.hsqldb.util.DatabaseManagerCommon
minor version: 0
major version: 59
flags: flags: (0x0020) ACC_SUPER
this_class: org.hsqldb.util.DatabaseManagerCommon
super_class: java.lang.Object
{
private static java.util.Random rRandom;
descriptor: Ljava/util/Random;
flags: (0x000a) ACC_PRIVATE, ACC_STATIC
static java.lang.String[] selectHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] insertHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] updateHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] deleteHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] createTableHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] dropTableHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] createIndexHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] dropIndexHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] checkpointHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] scriptHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] shutdownHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] setHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] testHelp;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String[] testDataSql;
descriptor: [Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static void <clinit>();
descriptor: ()V
flags: (0x0008) ACC_STATIC
Code:
stack=4, locals=0, args_size=0
0: new java.util.Random
dup
ldc 100
invokespecial java.util.Random.<init>:(J)V
putstatic org.hsqldb.util.DatabaseManagerCommon.rRandom:Ljava/util/Random;
1: iconst_2
anewarray java.lang.String
dup
iconst_0
2: ldc "SELECT * FROM "
aastore
dup
iconst_1
3: ldc "SELECT [LIMIT n m] [DISTINCT] \n{ selectExpression | table.* | * } [, ... ] \n[INTO [CACHED|TEMP|TEXT] newTable] \nFROM tableList \n[WHERE Expression] \n[ORDER BY selectExpression [{ASC | DESC}] [, ...] ] \n[GROUP BY Expression [, ...] ] \n[UNION [ALL] selectStatement]"
aastore
4: putstatic org.hsqldb.util.DatabaseManagerCommon.selectHelp:[Ljava/lang/String;
5: iconst_2
anewarray java.lang.String
dup
iconst_0
6: ldc "INSERT INTO "
aastore
dup
iconst_1
7: ldc "INSERT INTO table [ (column [,...] ) ] \n{ VALUES(Expression [,...]) [,...] | SelectStatement }"
aastore
8: putstatic org.hsqldb.util.DatabaseManagerCommon.insertHelp:[Ljava/lang/String;
9: iconst_2
anewarray java.lang.String
dup
iconst_0
10: ldc "UPDATE "
aastore
dup
iconst_1
11: ldc "UPDATE table SET column = Expression [, ...] \n[WHERE Expression]"
aastore
12: putstatic org.hsqldb.util.DatabaseManagerCommon.updateHelp:[Ljava/lang/String;
13: iconst_2
anewarray java.lang.String
dup
iconst_0
14: ldc "DELETE FROM "
aastore
dup
iconst_1
ldc "DELETE FROM table [WHERE Expression]"
aastore
15: putstatic org.hsqldb.util.DatabaseManagerCommon.deleteHelp:[Ljava/lang/String;
16: iconst_2
anewarray java.lang.String
dup
iconst_0
17: ldc "CREATE TABLE "
aastore
dup
iconst_1
18: ldc "CREATE [TEMP] [CACHED|MEMORY|TEXT] TABLE name \n( columnDefinition [, ...] ) \n\ncolumnDefinition: \ncolumn DataType [ [NOT] NULL] [PRIMARY KEY] \nDataType: \n{ INTEGER | DOUBLE | VARCHAR | DATE | TIME |... }"
aastore
19: putstatic org.hsqldb.util.DatabaseManagerCommon.createTableHelp:[Ljava/lang/String;
20: iconst_2
anewarray java.lang.String
dup
iconst_0
21: ldc "DROP TABLE "
aastore
dup
iconst_1
ldc "DROP TABLE table"
aastore
22: putstatic org.hsqldb.util.DatabaseManagerCommon.dropTableHelp:[Ljava/lang/String;
23: iconst_2
anewarray java.lang.String
dup
iconst_0
24: ldc "CREATE INDEX "
aastore
dup
iconst_1
25: ldc "CREATE [UNIQUE] INDEX index ON \ntable (column [, ...])"
aastore
26: putstatic org.hsqldb.util.DatabaseManagerCommon.createIndexHelp:[Ljava/lang/String;
27: iconst_2
anewarray java.lang.String
dup
iconst_0
28: ldc "DROP INDEX "
aastore
dup
iconst_1
ldc "DROP INDEX table.index"
aastore
29: putstatic org.hsqldb.util.DatabaseManagerCommon.dropIndexHelp:[Ljava/lang/String;
30: iconst_2
anewarray java.lang.String
dup
iconst_0
31: ldc "CHECKPOINT"
aastore
dup
iconst_1
ldc "(HSQLDB SQL only)"
aastore
32: putstatic org.hsqldb.util.DatabaseManagerCommon.checkpointHelp:[Ljava/lang/String;
33: iconst_2
anewarray java.lang.String
dup
iconst_0
34: ldc "SCRIPT"
aastore
dup
iconst_1
ldc "SCRIPT ['file']\n\n(HSQLDB SQL only)"
aastore
35: putstatic org.hsqldb.util.DatabaseManagerCommon.scriptHelp:[Ljava/lang/String;
36: iconst_2
anewarray java.lang.String
dup
iconst_0
37: ldc "SHUTDOWN"
aastore
dup
iconst_1
38: ldc "SHUTDOWN [COMPACT|IMMEDIATELY|SCRIPT]\n\n(HSQLDB SQL only)"
aastore
39: putstatic org.hsqldb.util.DatabaseManagerCommon.shutdownHelp:[Ljava/lang/String;
40: iconst_2
anewarray java.lang.String
dup
iconst_0
41: ldc "SET "
aastore
dup
iconst_1
42: ldc "SET AUTOCOMMIT { TRUE | FALSE }\nSET DATABASE COLLATION \"<collationname>\"\nSET FILES CHECKPOINT DEFRAG <size>\nSET DATABASE INITIAL SCHEMA <schemaname>\nSET FILES LOG SIZE <size>\nSET MAXROWS maxrows\nSET PASSWORD <password>\nSET FILES READ { ONLY | WRITE }\nSET SCHEMA <schemaname>\nSET TABLE <tablename> READ { ONLY | WRITE }\nSET TABLE <tablename> SOURCE { ON | OFF }\nSET TABLE <tablename> SOURCE \"<file>\" [DESC]\n\n\n(HSQLDB SQL only)"
aastore
43: putstatic org.hsqldb.util.DatabaseManagerCommon.setHelp:[Ljava/lang/String;
44: iconst_2
anewarray java.lang.String
dup
iconst_0
45: ldc "-->>>TEST<<<-- ;\n--#1000;\nDROP TABLE Test IF EXISTS;\nCREATE TABLE Test(\n Id INTEGER PRIMARY KEY,\n FirstName VARCHAR(20),\n Name VARCHAR(50),\n ZIP INTEGER) ;\nINSERT INTO Test \n VALUES(#,'Julia','Peterson-Clancy',#) ;\nUPDATE Test SET Name='Hans' WHERE Id=# ;\nSELECT * FROM Test WHERE Id=# ;\nDELETE FROM Test WHERE Id=# ;\nDROP TABLE Test IF EXISTS;"
aastore
dup
iconst_1
46: ldc "This test script is parsed by the DatabaseManager\nIt may be changed manually. Rules:\n- it must start with -->>>TEST<<<--.\n- each line must end with ';' (no spaces after)\n- lines starting with -- are comments\n- lines starting with --#<count> means set new count\n"
aastore
47: putstatic org.hsqldb.util.DatabaseManagerCommon.testHelp:[Ljava/lang/String;
48: bipush 8
anewarray java.lang.String
dup
iconst_0
49: ldc "SELECT * FROM Product"
aastore
dup
iconst_1
50: ldc "SELECT * FROM Invoice"
aastore
dup
iconst_2
51: ldc "SELECT * FROM Item"
aastore
dup
iconst_3
52: ldc "SELECT * FROM Customer a INNER JOIN Invoice i ON a.ID=i.CustomerID"
aastore
dup
iconst_4
53: ldc "SELECT * FROM Customer a LEFT OUTER JOIN Invoice i ON a.ID=i.CustomerID"
aastore
dup
iconst_5
54: ldc "SELECT * FROM Invoice d INNER JOIN Item i ON d.ID=i.InvoiceID"
aastore
dup
bipush 6
55: ldc "SELECT * FROM Customer WHERE Street LIKE '1%' ORDER BY Lastname"
aastore
dup
bipush 7
56: ldc "SELECT a.id, a.firstname, a.lastname, count(i.Total) \"COUNT\", COALESCE(sum(i.Total), 0) \"TOTAL\", COALESCE(AVG(i.Total),0) \"AVG\" FROM Customer a LEFT OUTER JOIN Invoice i ON a.ID=i.CustomerID GROUP BY a.id, a.firstname, a.lastname"
aastore
57: putstatic org.hsqldb.util.DatabaseManagerCommon.testDataSql:[Ljava/lang/String;
58: return
LocalVariableTable:
Start End Slot Name Signature
static java.lang.String random(java.lang.String[]);
descriptor: ([Ljava/lang/String;)Ljava/lang/String;
flags: (0x0008) ACC_STATIC
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
aload 0
arraylength
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
aaload
areturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 1 0 s [Ljava/lang/String;
MethodParameters:
Name Flags
s
static int random(int);
descriptor: (I)I
flags: (0x0008) ACC_STATIC
Code:
stack=2, locals=1, args_size=1
start local 0 0: getstatic org.hsqldb.util.DatabaseManagerCommon.rRandom:Ljava/util/Random;
iload 0
invokevirtual java.util.Random.nextInt:(I)I
ireturn
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 1 0 i I
MethodParameters:
Name Flags
i
static void createTestTables(java.sql.Statement);
descriptor: (Ljava/sql/Statement;)V
flags: (0x0008) ACC_STATIC
Code:
stack=4, locals=3, args_size=1
start local 0 0: bipush 8
anewarray java.lang.String
dup
iconst_0
1: ldc "DROP TABLE Item IF EXISTS;"
aastore
dup
iconst_1
ldc "DROP TABLE Invoice IF EXISTS;"
aastore
dup
iconst_2
2: ldc "DROP TABLE Product IF EXISTS;"
aastore
dup
iconst_3
ldc "DROP TABLE Customer IF EXISTS;"
aastore
dup
iconst_4
3: ldc "CREATE TABLE Customer(ID INTEGER PRIMARY KEY,FirstName VARCHAR(20),LastName VARCHAR(20),Street VARCHAR(20),City VARCHAR(20));"
aastore
dup
iconst_5
4: ldc "CREATE TABLE Product(ID INTEGER PRIMARY KEY,Name VARCHAR(20),Price DECIMAL(10,2));"
aastore
dup
bipush 6
5: ldc "CREATE TABLE Invoice(ID INTEGER PRIMARY KEY,CustomerID INTEGER,Total DECIMAL(10,2), FOREIGN KEY (CustomerId) REFERENCES Customer(ID) ON DELETE CASCADE);"
aastore
dup
bipush 7
6: ldc "CREATE TABLE Item(InvoiceID INTEGER,Item INTEGER,ProductID INTEGER,Quantity INTEGER,Cost DECIMAL(10,2),PRIMARY KEY(InvoiceID,Item), FOREIGN KEY (InvoiceId) REFERENCES Invoice (ID) ON DELETE CASCADE, FOREIGN KEY (ProductId) REFERENCES Product(ID) ON DELETE CASCADE);"
aastore
7: astore 1
start local 1 8: iconst_0
istore 2
start local 2 9: goto 14
10: StackMap locals: java.lang.String[] int
StackMap stack:
aload 0
aload 1
iload 2
aaload
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
11: goto 13
StackMap locals:
StackMap stack: java.sql.SQLException
12: pop
13: StackMap locals:
StackMap stack:
iinc 2 1
StackMap locals:
StackMap stack:
14: iload 2
aload 1
arraylength
if_icmplt 10
end local 2 15: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 16 0 sStatement Ljava/sql/Statement;
8 16 1 demo [Ljava/lang/String;
9 15 2 i I
Exception table:
from to target type
10 11 12 Class java.sql.SQLException
MethodParameters:
Name Flags
sStatement
static java.lang.String createTestData(java.sql.Statement);
descriptor: (Ljava/sql/Statement;)Ljava/lang/String;
flags: (0x0008) ACC_STATIC
Code:
stack=5, locals=9, args_size=1
start local 0 0: bipush 15
anewarray java.lang.String
dup
iconst_0
1: ldc "White"
aastore
dup
iconst_1
ldc "Karsen"
aastore
dup
iconst_2
ldc "Smith"
aastore
dup
iconst_3
ldc "Ringer"
aastore
dup
iconst_4
ldc "May"
aastore
dup
iconst_5
ldc "King"
aastore
dup
bipush 6
ldc "Fuller"
aastore
dup
bipush 7
2: ldc "Miller"
aastore
dup
bipush 8
ldc "Ott"
aastore
dup
bipush 9
ldc "Sommer"
aastore
dup
bipush 10
ldc "Schneider"
aastore
dup
bipush 11
ldc "Steel"
aastore
dup
bipush 12
ldc "Peterson"
aastore
dup
bipush 13
3: ldc "Heiniger"
aastore
dup
bipush 14
ldc "Clancy"
aastore
4: astore 1
start local 1 5: bipush 15
anewarray java.lang.String
dup
iconst_0
6: ldc "Mary"
aastore
dup
iconst_1
ldc "James"
aastore
dup
iconst_2
ldc "Anne"
aastore
dup
iconst_3
ldc "George"
aastore
dup
iconst_4
ldc "Sylvia"
aastore
dup
iconst_5
ldc "Robert"
aastore
dup
bipush 6
ldc "Janet"
aastore
dup
bipush 7
7: ldc "Michael"
aastore
dup
bipush 8
ldc "Andrew"
aastore
dup
bipush 9
ldc "Bill"
aastore
dup
bipush 10
ldc "Susanne"
aastore
dup
bipush 11
ldc "Laura"
aastore
dup
bipush 12
ldc "Bob"
aastore
dup
bipush 13
ldc "Julia"
aastore
dup
bipush 14
8: ldc "John"
aastore
9: astore 2
start local 2 10: iconst_4
anewarray java.lang.String
dup
iconst_0
11: ldc "Upland Pl."
aastore
dup
iconst_1
ldc "College Av."
aastore
dup
iconst_2
ldc "- 20th Ave."
aastore
dup
iconst_3
ldc "Seventh Av."
aastore
12: astore 3
start local 3 13: bipush 12
anewarray java.lang.String
dup
iconst_0
14: ldc "New York"
aastore
dup
iconst_1
ldc "Dallas"
aastore
dup
iconst_2
ldc "Boston"
aastore
dup
iconst_3
ldc "Chicago"
aastore
dup
iconst_4
ldc "Seattle"
aastore
dup
iconst_5
15: ldc "San Francisco"
aastore
dup
bipush 6
ldc "Berne"
aastore
dup
bipush 7
ldc "Oslo"
aastore
dup
bipush 8
ldc "Paris"
aastore
dup
bipush 9
ldc "Lyon"
aastore
dup
bipush 10
ldc "Palo Alto"
aastore
dup
bipush 11
16: ldc "Olten"
aastore
17: astore 4
start local 4 18: bipush 6
anewarray java.lang.String
dup
iconst_0
19: ldc "Iron"
aastore
dup
iconst_1
ldc "Ice Tea"
aastore
dup
iconst_2
ldc "Clock"
aastore
dup
iconst_3
ldc "Chair"
aastore
dup
iconst_4
ldc "Telephone"
aastore
dup
iconst_5
ldc "Shoe"
aastore
20: astore 5
start local 5 21: bipush 50
istore 6
start local 6 22: iconst_0
istore 7
start local 7 23: goto 34
24: StackMap locals: java.sql.Statement java.lang.String[] java.lang.String[] java.lang.String[] java.lang.String[] java.lang.String[] int int
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "INSERT INTO Customer VALUES("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 7
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",'"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
25: aload 2
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)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 1
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
26: ldc "','"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
sipush 554
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 3
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
27: ldc "','"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 4
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)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;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
28: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
29: aload 0
new java.lang.StringBuilder
dup
ldc "INSERT INTO Product VALUES("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 7
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",'"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
30: aload 5
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)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 5
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:([Ljava/lang/String;)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
31: ldc "',"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
bipush 20
iconst_2
bipush 120
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
imul
iadd
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;
32: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
33: iinc 7 1
StackMap locals:
StackMap stack:
34: iload 7
iload 6
if_icmplt 24
end local 7 35: iconst_0
istore 7
start local 7 36: goto 49
37: StackMap locals:
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "INSERT INTO Invoice VALUES("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 7
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
38: iload 6
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",0.0)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
39: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
40: bipush 20
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
iconst_2
iadd
istore 8
start local 8 41: goto 47
42: StackMap locals: int
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "INSERT INTO Item VALUES("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 7
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 8
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
43: ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 6
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
44: iconst_1
bipush 24
invokestatic org.hsqldb.util.DatabaseManagerCommon.random:(I)I
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",1.5)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
45: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
46: iinc 8 -1
StackMap locals:
StackMap stack:
47: iload 8
ifge 42
end local 8 48: iinc 7 1
StackMap locals:
StackMap stack:
49: iload 7
iload 6
if_icmplt 37
end local 7 50: aload 0
ldc "UPDATE Product SET Price=ROUND(Price*.1,2)"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
51: aload 0
52: ldc "UPDATE Item SET Cost=Cost*(SELECT Price FROM Product prod WHERE ProductID=prod.ID)"
53: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
54: aload 0
55: ldc "UPDATE Invoice SET Total=(SELECT SUM(Cost*Quantity) FROM Item WHERE InvoiceID=Invoice.ID)"
56: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
57: ldc "SELECT * FROM Customer"
areturn
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 58 0 sStatement Ljava/sql/Statement;
5 58 1 name [Ljava/lang/String;
10 58 2 firstname [Ljava/lang/String;
13 58 3 street [Ljava/lang/String;
18 58 4 city [Ljava/lang/String;
21 58 5 product [Ljava/lang/String;
22 58 6 max I
23 35 7 i I
36 50 7 i I
41 48 8 j I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
sStatement
static java.lang.String readFile(java.lang.String);
descriptor: (Ljava/lang/String;)Ljava/lang/String;
flags: (0x0008) ACC_STATIC
Code:
stack=3, locals=5, args_size=1
start local 0 0: new java.io.FileReader
dup
aload 0
invokespecial java.io.FileReader.<init>:(Ljava/lang/String;)V
astore 1
start local 1 1: new java.io.BufferedReader
dup
aload 1
invokespecial java.io.BufferedReader.<init>:(Ljava/io/Reader;)V
astore 2
start local 2 2: new java.lang.StringBuilder
dup
invokespecial java.lang.StringBuilder.<init>:()V
astore 3
start local 3 3: aconst_null
astore 4
start local 4 4: goto 7
5: StackMap locals: java.lang.String java.io.FileReader java.io.BufferedReader java.lang.StringBuilder java.lang.String
StackMap stack:
aload 3
aload 4
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
6: aload 3
bipush 10
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
7: StackMap locals:
StackMap stack:
aload 2
invokevirtual java.io.BufferedReader.readLine:()Ljava/lang/String;
dup
astore 4
ifnonnull 5
8: aload 2
invokevirtual java.io.BufferedReader.close:()V
9: aload 1
invokevirtual java.io.FileReader.close:()V
10: aload 3
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
11: areturn
end local 4 end local 3 end local 2 end local 1 12: StackMap locals: java.lang.String
StackMap stack: java.io.IOException
astore 1
start local 1 13: aload 1
invokevirtual java.io.IOException.toString:()Ljava/lang/String;
areturn
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 14 0 file Ljava/lang/String;
1 12 1 reader Ljava/io/FileReader;
2 12 2 read Ljava/io/BufferedReader;
3 12 3 b Ljava/lang/StringBuilder;
4 12 4 s Ljava/lang/String;
13 14 1 e Ljava/io/IOException;
Exception table:
from to target type
0 11 12 Class java.io.IOException
MethodParameters:
Name Flags
file
static void writeFile(java.lang.String, java.lang.String);
descriptor: (Ljava/lang/String;Ljava/lang/String;)V
flags: (0x0008) ACC_STATIC
Code:
stack=3, locals=3, args_size=2
start local 0 start local 1 0: new java.io.FileWriter
dup
aload 0
invokespecial java.io.FileWriter.<init>:(Ljava/lang/String;)V
astore 2
start local 2 1: aload 2
aload 1
invokevirtual java.lang.String.toCharArray:()[C
invokevirtual java.io.FileWriter.write:([C)V
2: aload 2
invokevirtual java.io.FileWriter.close:()V
end local 2 3: goto 6
StackMap locals:
StackMap stack: java.io.IOException
4: astore 2
start local 2 5: aload 2
invokevirtual java.io.IOException.printStackTrace:()V
end local 2 6: StackMap locals:
StackMap stack:
return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 file Ljava/lang/String;
0 7 1 text Ljava/lang/String;
1 3 2 write Ljava/io/FileWriter;
5 6 2 e Ljava/io/IOException;
Exception table:
from to target type
0 3 4 Class java.io.IOException
MethodParameters:
Name Flags
file
text
static long testStatement(java.sql.Statement, java.lang.String, int);
descriptor: (Ljava/sql/Statement;Ljava/lang/String;I)J
flags: (0x0008) ACC_STATIC
Code:
stack=5, locals=8, args_size=3
start local 0 start local 1 start local 2 0: invokestatic java.lang.System.currentTimeMillis:()J
lstore 3
start local 3 1: aload 1
bipush 35
invokevirtual java.lang.String.indexOf:(I)I
iconst_m1
if_icmpne 3
2: iconst_1
istore 2
3: StackMap locals: long
StackMap stack:
iconst_0
istore 5
start local 5 4: goto 20
5: StackMap locals: int
StackMap stack:
aload 1
astore 6
start local 6 6: StackMap locals: java.lang.String
StackMap stack:
aload 6
ldc "#r#"
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
istore 7
start local 7 7: iload 7
iconst_m1
if_icmpne 9
8: goto 13
9: StackMap locals: int
StackMap stack:
new java.lang.StringBuilder
dup
aload 6
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
invokestatic java.lang.Math.random:()D
iload 5
i2d
dmul
d2i
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
10: aload 6
iload 7
iconst_3
iadd
invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
11: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
end local 7 12: goto 6
13: StackMap locals:
StackMap stack:
aload 6
bipush 35
invokevirtual java.lang.String.indexOf:(I)I
istore 7
start local 7 14: iload 7
iconst_m1
if_icmpne 16
15: goto 18
16: StackMap locals: int
StackMap stack:
new java.lang.StringBuilder
dup
aload 6
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
aload 6
iload 7
iconst_1
iadd
invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
end local 7 17: goto 13
18: StackMap locals:
StackMap stack:
aload 0
aload 6
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
end local 6 19: iinc 5 1
StackMap locals:
StackMap stack:
20: iload 5
iload 2
if_icmplt 5
end local 5 21: invokestatic java.lang.System.currentTimeMillis:()J
lload 3
lsub
lreturn
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 22 0 sStatement Ljava/sql/Statement;
0 22 1 sql Ljava/lang/String;
0 22 2 max I
1 22 3 start J
4 21 5 i I
6 19 6 s Ljava/lang/String;
7 12 7 j I
14 17 7 j I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
sStatement
sql
max
private void <init>();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
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/util/DatabaseManagerCommon;
}
SourceFile: "DatabaseManagerCommon.java"