public class org.h2.tools.Shell extends org.h2.util.Tool implements java.lang.Runnable
minor version: 0
major version: 59
flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
this_class: org.h2.tools.Shell
super_class: org.h2.util.Tool
{
private static final int MAX_ROW_BUFFER;
descriptor: I
flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
ConstantValue: 5000
private static final int HISTORY_COUNT;
descriptor: I
flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
ConstantValue: 20
private static final char BOX_VERTICAL;
descriptor: C
flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
ConstantValue: 124
private java.io.PrintStream err;
descriptor: Ljava/io/PrintStream;
flags: (0x0002) ACC_PRIVATE
private java.io.InputStream in;
descriptor: Ljava/io/InputStream;
flags: (0x0002) ACC_PRIVATE
private java.io.BufferedReader reader;
descriptor: Ljava/io/BufferedReader;
flags: (0x0002) ACC_PRIVATE
private java.sql.Connection conn;
descriptor: Ljava/sql/Connection;
flags: (0x0002) ACC_PRIVATE
private java.sql.Statement stat;
descriptor: Ljava/sql/Statement;
flags: (0x0002) ACC_PRIVATE
private boolean listMode;
descriptor: Z
flags: (0x0002) ACC_PRIVATE
private int maxColumnSize;
descriptor: I
flags: (0x0002) ACC_PRIVATE
private final java.util.ArrayList<java.lang.String> history;
descriptor: Ljava/util/ArrayList;
flags: (0x0012) ACC_PRIVATE, ACC_FINAL
Signature: Ljava/util/ArrayList<Ljava/lang/String;>;
private boolean stopHide;
descriptor: Z
flags: (0x0002) ACC_PRIVATE
private java.lang.String serverPropertiesDir;
descriptor: Ljava/lang/String;
flags: (0x0002) ACC_PRIVATE
public void <init>();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=3, locals=1, args_size=1
start local 0 0: aload 0
invokespecial org.h2.util.Tool.<init>:()V
1: aload 0
getstatic java.lang.System.err:Ljava/io/PrintStream;
putfield org.h2.tools.Shell.err:Ljava/io/PrintStream;
2: aload 0
getstatic java.lang.System.in:Ljava/io/InputStream;
putfield org.h2.tools.Shell.in:Ljava/io/InputStream;
3: aload 0
bipush 100
putfield org.h2.tools.Shell.maxColumnSize:I
4: aload 0
new java.util.ArrayList
dup
invokespecial java.util.ArrayList.<init>:()V
putfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
5: aload 0
ldc "~"
putfield org.h2.tools.Shell.serverPropertiesDir:Ljava/lang/String;
6: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/h2/tools/Shell;
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0089) ACC_PUBLIC, ACC_STATIC, ACC_VARARGS
Code:
stack=2, locals=1, args_size=1
start local 0 0: new org.h2.tools.Shell
dup
invokespecial org.h2.tools.Shell.<init>:()V
aload 0
invokevirtual org.h2.tools.Shell.runTool:([Ljava/lang/String;)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
public void setErr(java.io.PrintStream);
descriptor: (Ljava/io/PrintStream;)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: aload 0
aload 1
putfield org.h2.tools.Shell.err:Ljava/io/PrintStream;
1: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/h2/tools/Shell;
0 2 1 err Ljava/io/PrintStream;
MethodParameters:
Name Flags
err
public void setIn(java.io.InputStream);
descriptor: (Ljava/io/InputStream;)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: aload 0
aload 1
putfield org.h2.tools.Shell.in:Ljava/io/InputStream;
1: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/h2/tools/Shell;
0 2 1 in Ljava/io/InputStream;
MethodParameters:
Name Flags
in
public void setInReader(java.io.BufferedReader);
descriptor: (Ljava/io/BufferedReader;)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: aload 0
aload 1
putfield org.h2.tools.Shell.reader:Ljava/io/BufferedReader;
1: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/h2/tools/Shell;
0 2 1 reader Ljava/io/BufferedReader;
MethodParameters:
Name Flags
reader
public void runTool(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0081) ACC_PUBLIC, ACC_VARARGS
Code:
stack=5, locals=9, args_size=2
start local 0 start local 1 0: aconst_null
astore 2
start local 2 1: ldc ""
astore 3
start local 3 2: ldc ""
astore 4
start local 4 3: aconst_null
astore 5
start local 5 4: iconst_0
istore 6
start local 6 5: goto 34
6: StackMap locals: org.h2.tools.Shell java.lang.String[] java.lang.String java.lang.String java.lang.String java.lang.String int
StackMap stack:
aload 1
iload 6
aaload
astore 7
start local 7 7: aload 7
ldc "-url"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 10
8: aload 1
iinc 6 1
iload 6
aaload
astore 2
9: goto 33
StackMap locals: java.lang.String
StackMap stack:
10: aload 7
ldc "-user"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 13
11: aload 1
iinc 6 1
iload 6
aaload
astore 3
12: goto 33
StackMap locals:
StackMap stack:
13: aload 7
ldc "-password"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 16
14: aload 1
iinc 6 1
iload 6
aaload
astore 4
15: goto 33
StackMap locals:
StackMap stack:
16: aload 7
ldc "-driver"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 20
17: aload 1
iinc 6 1
iload 6
aaload
astore 8
start local 8 18: aload 8
invokestatic org.h2.util.JdbcUtils.loadUserClass:(Ljava/lang/String;)Ljava/lang/Class;
pop
end local 8 19: goto 33
StackMap locals:
StackMap stack:
20: aload 7
ldc "-sql"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 23
21: aload 1
iinc 6 1
iload 6
aaload
astore 5
22: goto 33
StackMap locals:
StackMap stack:
23: aload 7
ldc "-properties"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 26
24: aload 0
aload 1
iinc 6 1
iload 6
aaload
putfield org.h2.tools.Shell.serverPropertiesDir:Ljava/lang/String;
25: goto 33
StackMap locals:
StackMap stack:
26: aload 7
ldc "-help"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifne 27
aload 7
ldc "-?"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 29
27: StackMap locals:
StackMap stack:
aload 0
invokevirtual org.h2.tools.Shell.showUsage:()V
28: return
29: StackMap locals:
StackMap stack:
aload 7
ldc "-list"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 32
30: aload 0
iconst_1
putfield org.h2.tools.Shell.listMode:Z
31: goto 33
32: StackMap locals:
StackMap stack:
aload 0
aload 7
invokevirtual org.h2.tools.Shell.showUsageAndThrowUnsupportedOption:(Ljava/lang/String;)Ljava/sql/SQLException;
pop
end local 7 33: StackMap locals:
StackMap stack:
iinc 6 1
StackMap locals:
StackMap stack:
34: aload 1
ifnull 35
iload 6
aload 1
arraylength
if_icmplt 6
end local 6 35: StackMap locals:
StackMap stack:
aload 2
ifnull 39
36: invokestatic org.h2.Driver.load:()Lorg/h2/Driver;
pop
37: aload 0
aload 2
aload 3
aload 4
invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
38: aload 0
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
39: StackMap locals:
StackMap stack:
aload 5
ifnonnull 42
40: aload 0
invokevirtual org.h2.tools.Shell.promptLoop:()V
41: goto 50
42: StackMap locals:
StackMap stack:
new org.h2.util.ScriptReader
dup
new java.io.StringReader
dup
aload 5
invokespecial java.io.StringReader.<init>:(Ljava/lang/String;)V
invokespecial org.h2.util.ScriptReader.<init>:(Ljava/io/Reader;)V
astore 6
start local 6 43: StackMap locals: org.h2.util.ScriptReader
StackMap stack:
aload 6
invokevirtual org.h2.util.ScriptReader.readStatement:()Ljava/lang/String;
astore 7
start local 7 44: aload 7
ifnonnull 46
45: goto 48
46: StackMap locals: java.lang.String
StackMap stack:
aload 0
aload 7
invokevirtual org.h2.tools.Shell.execute:(Ljava/lang/String;)V
end local 7 47: goto 43
48: StackMap locals:
StackMap stack:
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
ifnull 50
49: aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
end local 6 50: 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 51 0 this Lorg/h2/tools/Shell;
0 51 1 args [Ljava/lang/String;
1 51 2 url Ljava/lang/String;
2 51 3 user Ljava/lang/String;
3 51 4 password Ljava/lang/String;
4 51 5 sql Ljava/lang/String;
5 35 6 i I
7 33 7 arg Ljava/lang/String;
18 19 8 driver Ljava/lang/String;
43 50 6 r Lorg/h2/util/ScriptReader;
44 47 7 s Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
args
public void runTool(java.sql.Connection, java.lang.String[]);
descriptor: (Ljava/sql/Connection;[Ljava/lang/String;)V
flags: (0x0081) ACC_PUBLIC, ACC_VARARGS
Code:
stack=2, locals=3, args_size=3
start local 0 start local 1 start local 2 0: aload 0
aload 1
putfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
1: aload 0
aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
2: aload 0
aload 2
invokevirtual org.h2.tools.Shell.runTool:([Ljava/lang/String;)V
3: return
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/h2/tools/Shell;
0 4 1 conn Ljava/sql/Connection;
0 4 2 args [Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
conn
args
private void showHelp();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
ldc "Commands are case insensitive; SQL statements end with ';'"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
1: aload 0
ldc "help or ? Display this help"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
2: aload 0
ldc "list Toggle result list / stack trace mode"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
3: aload 0
ldc "maxwidth Set maximum column width (default is 100)"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
4: aload 0
ldc "autocommit Enable or disable autocommit"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
5: aload 0
ldc "history Show the last 20 statements"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
6: aload 0
ldc "quit or exit Close the connection and exit"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
7: aload 0
ldc ""
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
8: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 9 0 this Lorg/h2/tools/Shell;
private void promptLoop();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=6, locals=9, args_size=1
start local 0 0: aload 0
ldc ""
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
1: aload 0
new java.lang.StringBuilder
dup
ldc "Welcome to H2 Shell "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
invokestatic org.h2.engine.Constants.getFullVersion:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
2: aload 0
ldc "Exit with Ctrl+C"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
3: aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
ifnull 5
4: aload 0
invokevirtual org.h2.tools.Shell.showHelp:()V
5: StackMap locals:
StackMap stack:
aconst_null
astore 1
start local 1 6: aload 0
getfield org.h2.tools.Shell.reader:Ljava/io/BufferedReader;
ifnonnull 8
7: aload 0
new java.io.BufferedReader
dup
new java.io.InputStreamReader
dup
aload 0
getfield org.h2.tools.Shell.in:Ljava/io/InputStream;
invokespecial java.io.InputStreamReader.<init>:(Ljava/io/InputStream;)V
invokespecial java.io.BufferedReader.<init>:(Ljava/io/Reader;)V
putfield org.h2.tools.Shell.reader:Ljava/io/BufferedReader;
8: StackMap locals: java.lang.String
StackMap stack:
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
ifnonnull 11
9: aload 0
invokevirtual org.h2.tools.Shell.connect:()V
10: aload 0
invokevirtual org.h2.tools.Shell.showHelp:()V
11: StackMap locals:
StackMap stack:
aload 1
ifnonnull 14
12: aload 0
ldc "sql> "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
13: goto 15
14: StackMap locals:
StackMap stack:
aload 0
ldc "...> "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
15: StackMap locals:
StackMap stack:
aload 0
invokevirtual org.h2.tools.Shell.readLine:()Ljava/lang/String;
astore 2
start local 2 16: aload 2
ifnonnull 18
17: goto 105
18: StackMap locals: java.lang.String
StackMap stack:
aload 2
invokevirtual java.lang.String.trim:()Ljava/lang/String;
astore 3
start local 3 19: aload 3
invokevirtual java.lang.String.isEmpty:()Z
ifeq 21
20: goto 8
21: StackMap locals: java.lang.String
StackMap stack:
aload 3
ldc ";"
invokevirtual java.lang.String.endsWith:(Ljava/lang/String;)Z
istore 4
start local 4 22: iload 4
ifeq 25
23: aload 2
iconst_0
aload 2
bipush 59
invokevirtual java.lang.String.lastIndexOf:(I)I
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 2
24: aload 3
iconst_0
aload 3
invokevirtual java.lang.String.length:()I
iconst_1
isub
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 3
25: StackMap locals: int
StackMap stack:
aload 3
invokestatic org.h2.util.StringUtils.toLowerEnglish:(Ljava/lang/String;)Ljava/lang/String;
astore 5
start local 5 26: ldc "exit"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifne 105
ldc "quit"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 28
27: goto 105
28: StackMap locals: java.lang.String
StackMap stack:
ldc "help"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifne 29
ldc "?"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 31
29: StackMap locals:
StackMap stack:
aload 0
invokevirtual org.h2.tools.Shell.showHelp:()V
30: goto 8
StackMap locals:
StackMap stack:
31: ldc "list"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 39
32: aload 0
aload 0
getfield org.h2.tools.Shell.listMode:Z
ifeq 33
iconst_0
goto 34
StackMap locals:
StackMap stack: org.h2.tools.Shell
33: iconst_1
StackMap locals: org.h2.tools.Shell java.lang.String java.lang.String java.lang.String int java.lang.String
StackMap stack: org.h2.tools.Shell int
34: putfield org.h2.tools.Shell.listMode:Z
35: aload 0
new java.lang.StringBuilder
dup
ldc "Result list mode is now "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.h2.tools.Shell.listMode:Z
ifeq 36
ldc "on"
goto 37
StackMap locals: org.h2.tools.Shell java.lang.String java.lang.String java.lang.String int java.lang.String
StackMap stack: org.h2.tools.Shell java.lang.StringBuilder
36: ldc "off"
StackMap locals: org.h2.tools.Shell java.lang.String java.lang.String java.lang.String int java.lang.String
StackMap stack: org.h2.tools.Shell java.lang.StringBuilder java.lang.String
37: invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
38: goto 8
StackMap locals:
StackMap stack:
39: ldc "history"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 53
40: iconst_0
istore 6
start local 6 41: aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
invokevirtual java.util.ArrayList.size:()I
istore 7
start local 7 42: goto 47
43: StackMap locals: int int
StackMap stack:
aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
iload 6
invokevirtual java.util.ArrayList.get:(I)Ljava/lang/Object;
checkcast java.lang.String
astore 8
start local 8 44: aload 8
bipush 10
bipush 32
invokevirtual java.lang.String.replace:(CC)Ljava/lang/String;
bipush 13
bipush 32
invokevirtual java.lang.String.replace:(CC)Ljava/lang/String;
astore 8
45: aload 0
new java.lang.StringBuilder
dup
ldc "#"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iconst_1
iload 6
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ": "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 8
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
end local 8 46: iinc 6 1
StackMap locals:
StackMap stack:
47: iload 6
iload 7
if_icmplt 43
end local 7 end local 6 48: aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
invokevirtual java.util.ArrayList.isEmpty:()Z
ifne 51
49: aload 0
ldc "To re-run a statement, type the number and press and enter"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
50: goto 8
51: StackMap locals:
StackMap stack:
aload 0
ldc "No history"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
52: goto 8
StackMap locals:
StackMap stack:
53: aload 5
ldc "autocommit"
invokevirtual java.lang.String.startsWith:(Ljava/lang/String;)Z
ifeq 64
54: aload 5
ldc "autocommit"
invokevirtual java.lang.String.length:()I
invokestatic org.h2.util.StringUtils.trimSubstring:(Ljava/lang/String;I)Ljava/lang/String;
astore 5
55: ldc "true"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 58
56: aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
iconst_1
invokeinterface java.sql.Connection.setAutoCommit:(Z)V
57: goto 62
StackMap locals:
StackMap stack:
58: ldc "false"
aload 5
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 61
59: aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
iconst_0
invokeinterface java.sql.Connection.setAutoCommit:(Z)V
60: goto 62
61: StackMap locals:
StackMap stack:
aload 0
ldc "Usage: autocommit [true|false]"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
62: StackMap locals:
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "Autocommit is now "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.getAutoCommit:()Z
invokevirtual java.lang.StringBuilder.append:(Z)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
63: goto 8
StackMap locals:
StackMap stack:
64: aload 5
ldc "maxwidth"
invokevirtual java.lang.String.startsWith:(Ljava/lang/String;)Z
ifeq 72
65: aload 5
ldc "maxwidth"
invokevirtual java.lang.String.length:()I
invokestatic org.h2.util.StringUtils.trimSubstring:(Ljava/lang/String;I)Ljava/lang/String;
astore 5
66: aload 0
aload 5
invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
putfield org.h2.tools.Shell.maxColumnSize:I
67: goto 70
StackMap locals:
StackMap stack: java.lang.NumberFormatException
68: pop
69: aload 0
ldc "Usage: maxwidth <integer value>"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
70: StackMap locals:
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "Maximum column width is now "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.h2.tools.Shell.maxColumnSize:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
71: goto 8
72: StackMap locals:
StackMap stack:
iconst_1
istore 6
start local 6 73: aload 1
ifnonnull 86
74: aload 2
invokestatic org.h2.util.StringUtils.isNumber:(Ljava/lang/String;)Z
ifeq 84
75: aload 2
invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
istore 7
start local 7 76: iload 7
ifeq 77
iload 7
aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
invokevirtual java.util.ArrayList.size:()I
if_icmple 79
77: StackMap locals: int int
StackMap stack:
aload 0
ldc "Not found"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
78: goto 87
79: StackMap locals:
StackMap stack:
aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
iload 7
iconst_1
isub
invokevirtual java.util.ArrayList.get:(I)Ljava/lang/Object;
checkcast java.lang.String
astore 1
80: iconst_0
istore 6
81: aload 0
aload 1
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
82: iconst_1
istore 4
end local 7 83: goto 87
84: StackMap locals:
StackMap stack:
aload 2
astore 1
85: goto 87
86: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
aload 1
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 2
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 1
87: StackMap locals:
StackMap stack:
iload 4
ifeq 8
88: iload 6
ifeq 92
89: aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
iconst_0
aload 1
invokevirtual java.util.ArrayList.add:(ILjava/lang/Object;)V
90: aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
invokevirtual java.util.ArrayList.size:()I
bipush 20
if_icmple 92
91: aload 0
getfield org.h2.tools.Shell.history:Ljava/util/ArrayList;
bipush 20
invokevirtual java.util.ArrayList.remove:(I)Ljava/lang/Object;
pop
92: StackMap locals:
StackMap stack:
aload 0
aload 1
invokevirtual org.h2.tools.Shell.execute:(Ljava/lang/String;)V
93: aconst_null
astore 1
end local 6 end local 5 end local 4 end local 3 end local 2 94: goto 8
StackMap locals: org.h2.tools.Shell java.lang.String
StackMap stack: java.sql.SQLException
95: astore 2
start local 2 96: aload 0
new java.lang.StringBuilder
dup
ldc "SQL Exception: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
97: aconst_null
astore 1
end local 2 98: goto 8
99: StackMap locals:
StackMap stack: java.io.IOException
astore 2
start local 2 100: aload 0
aload 2
invokevirtual java.io.IOException.getMessage:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
101: goto 105
end local 2 102: StackMap locals:
StackMap stack: java.lang.Exception
astore 2
start local 2 103: aload 0
new java.lang.StringBuilder
dup
ldc "Exception: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
104: aload 2
aload 0
getfield org.h2.tools.Shell.err:Ljava/io/PrintStream;
invokevirtual java.lang.Exception.printStackTrace:(Ljava/io/PrintStream;)V
end local 2 105: StackMap locals:
StackMap stack:
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
ifnull 112
106: aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
107: aload 0
ldc "Connection closed"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
108: goto 112
StackMap locals:
StackMap stack: java.sql.SQLException
109: astore 2
start local 2 110: aload 0
new java.lang.StringBuilder
dup
ldc "SQL Exception: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
111: aload 2
aload 0
getfield org.h2.tools.Shell.err:Ljava/io/PrintStream;
invokevirtual java.sql.SQLException.printStackTrace:(Ljava/io/PrintStream;)V
end local 2 112: StackMap locals:
StackMap stack:
return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 113 0 this Lorg/h2/tools/Shell;
6 113 1 statement Ljava/lang/String;
16 94 2 line Ljava/lang/String;
19 94 3 trimmed Ljava/lang/String;
22 94 4 end Z
26 94 5 lower Ljava/lang/String;
41 48 6 i I
42 48 7 size I
44 46 8 s Ljava/lang/String;
73 94 6 addToHistory Z
76 83 7 pos I
96 98 2 e Ljava/sql/SQLException;
100 102 2 e Ljava/io/IOException;
103 105 2 e Ljava/lang/Exception;
110 112 2 e Ljava/sql/SQLException;
Exception table:
from to target type
66 67 68 Class java.lang.NumberFormatException
8 17 95 Class java.sql.SQLException
18 20 95 Class java.sql.SQLException
21 27 95 Class java.sql.SQLException
28 94 95 Class java.sql.SQLException
8 17 99 Class java.io.IOException
18 20 99 Class java.io.IOException
21 27 99 Class java.io.IOException
28 94 99 Class java.io.IOException
8 17 102 Class java.lang.Exception
18 20 102 Class java.lang.Exception
21 27 102 Class java.lang.Exception
28 94 102 Class java.lang.Exception
106 108 109 Class java.sql.SQLException
private void connect();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=5, locals=9, args_size=1
start local 0 0: ldc "jdbc:h2:~/test"
astore 1
start local 1 1: ldc ""
astore 2
start local 2 2: aconst_null
astore 3
start local 3 3: ldc "null"
aload 0
getfield org.h2.tools.Shell.serverPropertiesDir:Ljava/lang/String;
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 6
4: new java.util.Properties
dup
invokespecial java.util.Properties.<init>:()V
astore 4
start local 4 5: goto 8
end local 4 6: StackMap locals: java.lang.String java.lang.String java.lang.String
StackMap stack:
new java.lang.StringBuilder
dup
aload 0
getfield org.h2.tools.Shell.serverPropertiesDir:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "/"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc ".h2.server.properties"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
7: invokestatic org.h2.util.SortedProperties.loadProperties:(Ljava/lang/String;)Lorg/h2/util/SortedProperties;
astore 4
start local 4 8: StackMap locals: java.util.Properties
StackMap stack:
aconst_null
astore 5
start local 5 9: iconst_0
istore 6
start local 6 10: iconst_0
istore 7
start local 7 11: StackMap locals: java.lang.String int int
StackMap stack:
aload 4
iload 7
invokestatic java.lang.Integer.toString:(I)Ljava/lang/String;
invokevirtual java.util.Properties.getProperty:(Ljava/lang/String;)Ljava/lang/String;
astore 8
start local 8 12: aload 8
ifnonnull 14
13: goto 17
14: StackMap locals: java.lang.String
StackMap stack:
iconst_1
istore 6
15: aload 8
astore 5
end local 8 16: iinc 7 1
goto 11
end local 7 17: StackMap locals:
StackMap stack:
iload 6
ifeq 24
18: new org.h2.server.web.ConnectionInfo
dup
aload 5
invokespecial org.h2.server.web.ConnectionInfo.<init>:(Ljava/lang/String;)V
astore 7
start local 7 19: aload 7
getfield org.h2.server.web.ConnectionInfo.url:Ljava/lang/String;
astore 1
20: aload 7
getfield org.h2.server.web.ConnectionInfo.user:Ljava/lang/String;
astore 2
21: aload 7
getfield org.h2.server.web.ConnectionInfo.driver:Ljava/lang/String;
astore 3
end local 7 end local 6 end local 5 end local 4 22: goto 24
StackMap locals: org.h2.tools.Shell java.lang.String java.lang.String java.lang.String
StackMap stack: java.io.IOException
23: pop
24: StackMap locals:
StackMap stack:
aload 0
new java.lang.StringBuilder
dup
ldc "[Enter] "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
25: aload 0
ldc "URL "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
26: aload 0
aload 1
invokevirtual org.h2.tools.Shell.readLine:(Ljava/lang/String;)Ljava/lang/String;
invokevirtual java.lang.String.trim:()Ljava/lang/String;
astore 1
27: aload 3
ifnonnull 29
28: aload 1
invokestatic org.h2.util.JdbcUtils.getDriver:(Ljava/lang/String;)Ljava/lang/String;
astore 3
29: StackMap locals:
StackMap stack:
aload 3
ifnull 31
30: aload 0
new java.lang.StringBuilder
dup
ldc "[Enter] "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
31: StackMap locals:
StackMap stack:
aload 0
ldc "Driver "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
32: aload 0
aload 3
invokevirtual org.h2.tools.Shell.readLine:(Ljava/lang/String;)Ljava/lang/String;
invokevirtual java.lang.String.trim:()Ljava/lang/String;
astore 3
33: aload 0
new java.lang.StringBuilder
dup
ldc "[Enter] "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
34: aload 0
ldc "User "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
35: aload 0
aload 2
invokevirtual org.h2.tools.Shell.readLine:(Ljava/lang/String;)Ljava/lang/String;
astore 2
36: StackMap locals:
StackMap stack:
aload 0
invokevirtual org.h2.tools.Shell.readPassword:()Ljava/lang/String;
astore 4
start local 4 37: aload 0
aload 3
new java.lang.StringBuilder
dup
aload 1
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ";IFEXISTS=TRUE"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
aload 2
aload 4
invokestatic org.h2.util.JdbcUtils.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
38: goto 49
39: StackMap locals: org.h2.tools.Shell java.lang.String java.lang.String java.lang.String java.lang.String
StackMap stack: java.sql.SQLException
astore 5
start local 5 40: aload 5
invokevirtual java.sql.SQLException.getErrorCode:()I
ldc 90146
if_icmpne 48
41: aload 0
ldc "Type the same password again to confirm database creation."
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
42: aload 0
invokevirtual org.h2.tools.Shell.readPassword:()Ljava/lang/String;
astore 6
start local 6 43: aload 4
aload 6
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 46
44: aload 0
aload 3
aload 1
aload 2
aload 4
invokestatic org.h2.util.JdbcUtils.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
45: goto 49
46: StackMap locals: java.sql.SQLException java.lang.String
StackMap stack:
aload 0
ldc "Passwords don't match. Try again."
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
47: goto 36
end local 6 48: StackMap locals:
StackMap stack:
aload 5
athrow
end local 5 end local 4 49: StackMap locals:
StackMap stack:
aload 0
aload 0
getfield org.h2.tools.Shell.conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
50: aload 0
ldc "Connected"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
51: return
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 52 0 this Lorg/h2/tools/Shell;
1 52 1 url Ljava/lang/String;
2 52 2 user Ljava/lang/String;
3 52 3 driver Ljava/lang/String;
5 6 4 prop Ljava/util/Properties;
8 22 4 prop Ljava/util/Properties;
9 22 5 data Ljava/lang/String;
10 22 6 found Z
11 17 7 i I
12 16 8 d Ljava/lang/String;
19 22 7 info Lorg/h2/server/web/ConnectionInfo;
37 49 4 password Ljava/lang/String;
40 49 5 ex Ljava/sql/SQLException;
43 48 6 password2 Ljava/lang/String;
Exception table:
from to target type
3 22 23 Class java.io.IOException
37 38 39 Class java.sql.SQLException
Exceptions:
throws java.io.IOException, java.sql.SQLException
protected void print(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0004) ACC_PROTECTED
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: aload 0
getfield org.h2.tools.Shell.out:Ljava/io/PrintStream;
aload 1
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
1: aload 0
getfield org.h2.tools.Shell.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.flush:()V
2: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 this Lorg/h2/tools/Shell;
0 3 1 s Ljava/lang/String;
MethodParameters:
Name Flags
s
private void println(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0002) ACC_PRIVATE
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: aload 0
getfield org.h2.tools.Shell.out:Ljava/io/PrintStream;
aload 1
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
1: aload 0
getfield org.h2.tools.Shell.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.flush:()V
2: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 this Lorg/h2/tools/Shell;
0 3 1 s Ljava/lang/String;
MethodParameters:
Name Flags
s
private java.lang.String readPassword();
descriptor: ()Ljava/lang/String;
flags: (0x0002) ACC_PRIVATE
Code:
stack=4, locals=3, args_size=1
start local 0 0: ldc "java.lang.System.console"
iconst_0
anewarray java.lang.Object
invokestatic org.h2.util.Utils.callStaticMethod:(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/Object;
astore 1
start local 1 1: aload 0
ldc "Password "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
2: aload 1
ldc "readPassword"
iconst_0
anewarray java.lang.Object
invokestatic org.h2.util.Utils.callMethod:(Ljava/lang/Object;Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/Object;
checkcast char[]
astore 2
start local 2 3: aload 2
ifnonnull 4
aconst_null
goto 5
StackMap locals: java.lang.Object char[]
StackMap stack:
4: new java.lang.String
dup
aload 2
invokespecial java.lang.String.<init>:([C)V
StackMap locals:
StackMap stack: java.lang.String
5: areturn
end local 2 end local 1 6: StackMap locals: org.h2.tools.Shell
StackMap stack: java.lang.Exception
pop
7: new java.lang.Thread
dup
aload 0
ldc "Password hider"
invokespecial java.lang.Thread.<init>:(Ljava/lang/Runnable;Ljava/lang/String;)V
astore 1
start local 1 8: aload 0
iconst_0
putfield org.h2.tools.Shell.stopHide:Z
9: aload 1
invokevirtual java.lang.Thread.start:()V
10: aload 0
ldc "Password > "
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
11: aload 0
invokevirtual org.h2.tools.Shell.readLine:()Ljava/lang/String;
astore 2
start local 2 12: aload 0
iconst_1
putfield org.h2.tools.Shell.stopHide:Z
13: aload 1
invokevirtual java.lang.Thread.join:()V
14: goto 16
StackMap locals: org.h2.tools.Shell java.lang.Thread java.lang.String
StackMap stack: java.lang.InterruptedException
15: pop
16: StackMap locals:
StackMap stack:
aload 0
ldc "\b\b"
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
17: aload 2
areturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 18 0 this Lorg/h2/tools/Shell;
1 6 1 console Ljava/lang/Object;
3 6 2 password [C
8 18 1 passwordHider Ljava/lang/Thread;
12 18 2 p Ljava/lang/String;
Exception table:
from to target type
0 5 6 Class java.lang.Exception
13 14 15 Class java.lang.InterruptedException
Exceptions:
throws java.io.IOException
public void run();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=2, locals=1, args_size=1
start local 0 0: goto 5
1: StackMap locals:
StackMap stack:
aload 0
ldc "\b\b><"
invokevirtual org.h2.tools.Shell.print:(Ljava/lang/String;)V
2: ldc 10
invokestatic java.lang.Thread.sleep:(J)V
3: goto 5
StackMap locals:
StackMap stack: java.lang.InterruptedException
4: pop
5: StackMap locals:
StackMap stack:
aload 0
getfield org.h2.tools.Shell.stopHide:Z
ifeq 1
6: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/h2/tools/Shell;
Exception table:
from to target type
2 3 4 Class java.lang.InterruptedException
private java.lang.String readLine(java.lang.String);
descriptor: (Ljava/lang/String;)Ljava/lang/String;
flags: (0x0002) ACC_PRIVATE
Code:
stack=1, locals=3, args_size=2
start local 0 start local 1 0: aload 0
invokevirtual org.h2.tools.Shell.readLine:()Ljava/lang/String;
astore 2
start local 2 1: aload 2
invokevirtual java.lang.String.isEmpty:()Z
ifeq 2
aload 1
goto 3
StackMap locals: java.lang.String
StackMap stack:
2: aload 2
StackMap locals:
StackMap stack: java.lang.String
3: areturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/h2/tools/Shell;
0 4 1 defaultValue Ljava/lang/String;
1 4 2 s Ljava/lang/String;
Exceptions:
throws java.io.IOException
MethodParameters:
Name Flags
defaultValue
private java.lang.String readLine();
descriptor: ()Ljava/lang/String;
flags: (0x0002) ACC_PRIVATE
Code:
stack=3, locals=2, args_size=1
start local 0 0: aload 0
getfield org.h2.tools.Shell.reader:Ljava/io/BufferedReader;
invokevirtual java.io.BufferedReader.readLine:()Ljava/lang/String;
astore 1
start local 1 1: aload 1
ifnonnull 3
2: new java.io.IOException
dup
ldc "Aborted"
invokespecial java.io.IOException.<init>:(Ljava/lang/String;)V
athrow
3: StackMap locals: java.lang.String
StackMap stack:
aload 1
areturn
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/h2/tools/Shell;
1 4 1 line Ljava/lang/String;
Exceptions:
throws java.io.IOException
private void execute(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0002) ACC_PRIVATE
Code:
stack=5, locals=7, args_size=2
start local 0 start local 1 0: aload 1
invokestatic org.h2.util.StringUtils.isWhitespaceOrEmpty:(Ljava/lang/String;)Z
ifeq 2
1: return
2: StackMap locals:
StackMap stack:
invokestatic java.lang.System.nanoTime:()J
lstore 2
start local 2 3: aconst_null
astore 4
start local 4 4: aload 0
getfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
aload 1
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
ifeq 14
5: aload 0
getfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 4
6: aload 0
aload 4
aload 0
getfield org.h2.tools.Shell.listMode:Z
invokevirtual org.h2.tools.Shell.printResult:(Ljava/sql/ResultSet;Z)I
istore 5
start local 5 7: invokestatic java.lang.System.nanoTime:()J
lload 2
lsub
lstore 2
8: aload 0
new java.lang.StringBuilder
dup
ldc "("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
iload 5
iconst_1
if_icmpne 10
9: ldc " row, "
goto 11
StackMap locals: org.h2.tools.Shell java.lang.String long java.sql.ResultSet int
StackMap stack: org.h2.tools.Shell java.lang.StringBuilder
10: ldc " rows, "
StackMap locals: org.h2.tools.Shell java.lang.String long java.sql.ResultSet int
StackMap stack: org.h2.tools.Shell java.lang.StringBuilder java.lang.String
11: invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
getstatic java.util.concurrent.TimeUnit.NANOSECONDS:Ljava/util/concurrent/TimeUnit;
lload 2
invokevirtual java.util.concurrent.TimeUnit.toMillis:(J)J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
12: invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
end local 5 13: goto 23
14: StackMap locals:
StackMap stack:
aload 0
getfield org.h2.tools.Shell.stat:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getUpdateCount:()I
istore 5
start local 5 15: invokestatic java.lang.System.nanoTime:()J
lload 2
lsub
lstore 2
16: aload 0
new java.lang.StringBuilder
dup
ldc "(Update count: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ", "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
17: getstatic java.util.concurrent.TimeUnit.NANOSECONDS:Ljava/util/concurrent/TimeUnit;
lload 2
invokevirtual java.util.concurrent.TimeUnit.toMillis:(J)J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
18: invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
end local 5 19: goto 23
StackMap locals:
StackMap stack: java.lang.Throwable
20: astore 6
21: aload 4
invokestatic org.h2.util.JdbcUtils.closeSilently:(Ljava/sql/ResultSet;)V
22: aload 6
athrow
23: StackMap locals:
StackMap stack:
aload 4
invokestatic org.h2.util.JdbcUtils.closeSilently:(Ljava/sql/ResultSet;)V
end local 4 24: goto 29
StackMap locals: org.h2.tools.Shell java.lang.String long
StackMap stack: java.sql.SQLException
25: astore 4
start local 4 26: aload 0
new java.lang.StringBuilder
dup
ldc "Error: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
invokevirtual java.sql.SQLException.toString:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
27: aload 0
getfield org.h2.tools.Shell.listMode:Z
ifeq 29
28: aload 4
aload 0
getfield org.h2.tools.Shell.err:Ljava/io/PrintStream;
invokevirtual java.sql.SQLException.printStackTrace:(Ljava/io/PrintStream;)V
end local 4 29: StackMap locals:
StackMap stack:
return
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 30 0 this Lorg/h2/tools/Shell;
0 30 1 sql Ljava/lang/String;
3 30 2 time J
4 24 4 rs Ljava/sql/ResultSet;
7 13 5 rowCount I
15 19 5 updateCount I
26 29 4 e Ljava/sql/SQLException;
Exception table:
from to target type
4 20 20 any
3 24 25 Class java.sql.SQLException
MethodParameters:
Name Flags
sql
private int printResult(java.sql.ResultSet, boolean);
descriptor: (Ljava/sql/ResultSet;Z)I
flags: (0x0002) ACC_PRIVATE
Code:
stack=2, locals=3, args_size=3
start local 0 start local 1 start local 2 0: iload 2
ifeq 2
1: aload 0
aload 1
invokevirtual org.h2.tools.Shell.printResultAsList:(Ljava/sql/ResultSet;)I
ireturn
2: StackMap locals:
StackMap stack:
aload 0
aload 1
invokevirtual org.h2.tools.Shell.printResultAsTable:(Ljava/sql/ResultSet;)I
ireturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 this Lorg/h2/tools/Shell;
0 3 1 rs Ljava/sql/ResultSet;
0 3 2 asList Z
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
rs
asList
private int printResultAsTable(java.sql.ResultSet);
descriptor: (Ljava/sql/ResultSet;)I
flags: (0x0002) ACC_PRIVATE
Code:
stack=5, locals=9, args_size=2
start local 0 start local 1 0: aload 1
invokeinterface java.sql.ResultSet.getMetaData:()Ljava/sql/ResultSetMetaData;
astore 2
start local 2 1: aload 2
invokeinterface java.sql.ResultSetMetaData.getColumnCount:()I
istore 3
start local 3 2: iconst_0
istore 4
start local 4 3: new java.util.ArrayList
dup
invokespecial java.util.ArrayList.<init>:()V
astore 5
start local 5 4: iload 3
anewarray java.lang.String
astore 6
start local 6 5: iconst_0
istore 7
start local 7 6: goto 12
7: StackMap locals: org.h2.tools.Shell java.sql.ResultSet java.sql.ResultSetMetaData int int java.util.ArrayList java.lang.String[] int
StackMap stack:
aload 2
iload 7
iconst_1
iadd
invokeinterface java.sql.ResultSetMetaData.getColumnLabel:(I)Ljava/lang/String;
astore 8
start local 8 8: aload 6
iload 7
aload 8
ifnonnull 9
ldc ""
goto 10
StackMap locals: org.h2.tools.Shell java.sql.ResultSet java.sql.ResultSetMetaData int int java.util.ArrayList java.lang.String[] int java.lang.String
StackMap stack: java.lang.String[] int
9: aload 8
StackMap locals: org.h2.tools.Shell java.sql.ResultSet java.sql.ResultSetMetaData int int java.util.ArrayList java.lang.String[] int java.lang.String
StackMap stack: java.lang.String[] int java.lang.String
10: aastore
end local 8 11: iinc 7 1
StackMap locals:
StackMap stack:
12: iload 7
iload 3
if_icmplt 7
end local 7 13: aload 5
aload 6
invokevirtual java.util.ArrayList.add:(Ljava/lang/Object;)Z
pop
14: iconst_0
istore 7
start local 7 15: goto 21
16: StackMap locals:
StackMap stack:
iinc 7 1
17: iload 4
aload 0
aload 1
iload 3
aload 5
invokevirtual org.h2.tools.Shell.loadRow:(Ljava/sql/ResultSet;ILjava/util/ArrayList;)Z
ior
istore 4
18: iload 7
sipush 5000
if_icmple 21
19: aload 0
aload 5
iload 3
invokevirtual org.h2.tools.Shell.printRows:(Ljava/util/ArrayList;I)[I
pop
20: aload 5
invokevirtual java.util.ArrayList.clear:()V
21: StackMap locals:
StackMap stack:
aload 1
invokeinterface java.sql.ResultSet.next:()Z
ifne 16
22: aload 0
aload 5
iload 3
invokevirtual org.h2.tools.Shell.printRows:(Ljava/util/ArrayList;I)[I
pop
23: aload 5
invokevirtual java.util.ArrayList.clear:()V
24: iload 4
ifeq 26
25: aload 0
ldc "(data is partially truncated)"
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
26: StackMap locals:
StackMap stack:
iload 7
ireturn
end local 7 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 27 0 this Lorg/h2/tools/Shell;
0 27 1 rs Ljava/sql/ResultSet;
1 27 2 meta Ljava/sql/ResultSetMetaData;
2 27 3 len I
3 27 4 truncated Z
4 27 5 rows Ljava/util/ArrayList<[Ljava/lang/String;>;
5 27 6 columns [Ljava/lang/String;
6 13 7 i I
8 11 8 s Ljava/lang/String;
15 27 7 rowCount I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
rs
private boolean loadRow(java.sql.ResultSet, int, java.util.ArrayList<java.lang.String[]>);
descriptor: (Ljava/sql/ResultSet;ILjava/util/ArrayList;)Z
flags: (0x0002) ACC_PRIVATE
Code:
stack=3, locals=8, args_size=4
start local 0 start local 1 start local 2 start local 3 0: iconst_0
istore 4
start local 4 1: iload 2
anewarray java.lang.String
astore 5
start local 5 2: iconst_0
istore 6
start local 6 3: goto 12
4: StackMap locals: int java.lang.String[] int
StackMap stack:
aload 1
iload 6
iconst_1
iadd
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
astore 7
start local 7 5: aload 7
ifnonnull 7
6: ldc "null"
astore 7
7: StackMap locals: java.lang.String
StackMap stack:
iload 2
iconst_1
if_icmple 10
aload 7
invokevirtual java.lang.String.length:()I
aload 0
getfield org.h2.tools.Shell.maxColumnSize:I
if_icmple 10
8: aload 7
iconst_0
aload 0
getfield org.h2.tools.Shell.maxColumnSize:I
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 7
9: iconst_1
istore 4
10: StackMap locals:
StackMap stack:
aload 5
iload 6
aload 7
aastore
end local 7 11: iinc 6 1
StackMap locals:
StackMap stack:
12: iload 6
iload 2
if_icmplt 4
end local 6 13: aload 3
aload 5
invokevirtual java.util.ArrayList.add:(Ljava/lang/Object;)Z
pop
14: iload 4
ireturn
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 15 0 this Lorg/h2/tools/Shell;
0 15 1 rs Ljava/sql/ResultSet;
0 15 2 len I
0 15 3 rows Ljava/util/ArrayList<[Ljava/lang/String;>;
1 15 4 truncated Z
2 15 5 row [Ljava/lang/String;
3 13 6 i I
5 11 7 s Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
Signature: (Ljava/sql/ResultSet;ILjava/util/ArrayList<[Ljava/lang/String;>;)Z
MethodParameters:
Name Flags
rs
len
rows
private int[] printRows(java.util.ArrayList<java.lang.String[]>, );
descriptor: (Ljava/util/ArrayList;I)[I
flags: (0x0002) ACC_PRIVATE
Code:
stack=3, locals=10, args_size=3
start local 0 start local 1 start local 2 0: iload 2
newarray 10
astore 3
start local 3 1: iconst_0
istore 4
start local 4 2: goto 12
3: StackMap locals: int[] int
StackMap stack:
iconst_0
istore 5
start local 5 4: aload 1
invokevirtual java.util.ArrayList.iterator:()Ljava/util/Iterator;
astore 7
goto 7
StackMap locals: org.h2.tools.Shell java.util.ArrayList int int[] int int top java.util.Iterator
StackMap stack:
5: aload 7
invokeinterface java.util.Iterator.next:()Ljava/lang/Object;
checkcast java.lang.String[]
astore 6
start local 6 6: iload 5
aload 6
iload 4
aaload
invokevirtual java.lang.String.length:()I
invokestatic java.lang.Math.max:(II)I
istore 5
end local 6 7: StackMap locals:
StackMap stack:
aload 7
invokeinterface java.util.Iterator.hasNext:()Z
ifne 5
8: iload 2
iconst_1
if_icmple 10
9: aload 0
getfield org.h2.tools.Shell.maxColumnSize:I
iload 5
invokestatic java.lang.Math.min:(II)I
pop
10: StackMap locals: org.h2.tools.Shell java.util.ArrayList int int[] int int
StackMap stack:
aload 3
iload 4
iload 5
iastore
end local 5 11: iinc 4 1
StackMap locals:
StackMap stack:
12: iload 4
iload 2
if_icmplt 3
end local 4 13: aload 1
invokevirtual java.util.ArrayList.iterator:()Ljava/util/Iterator;
astore 5
goto 31
StackMap locals: org.h2.tools.Shell java.util.ArrayList int int[] top java.util.Iterator
StackMap stack:
14: aload 5
invokeinterface java.util.Iterator.next:()Ljava/lang/Object;
checkcast java.lang.String[]
astore 4
start local 4 15: new java.lang.StringBuilder
dup
invokespecial java.lang.StringBuilder.<init>:()V
astore 6
start local 6 16: iconst_0
istore 7
start local 7 17: goto 29
18: StackMap locals: org.h2.tools.Shell java.util.ArrayList int int[] java.lang.String[] java.util.Iterator java.lang.StringBuilder int
StackMap stack:
iload 7
ifle 20
19: aload 6
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
bipush 124
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
20: StackMap locals:
StackMap stack:
aload 4
iload 7
aaload
astore 8
start local 8 21: aload 6
aload 8
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
22: iload 7
iload 2
iconst_1
isub
if_icmpge 28
23: aload 8
invokevirtual java.lang.String.length:()I
istore 9
start local 9 24: goto 27
25: StackMap locals: java.lang.String int
StackMap stack:
aload 6
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
26: iinc 9 1
StackMap locals:
StackMap stack:
27: iload 9
aload 3
iload 7
iaload
if_icmplt 25
end local 9 end local 8 28: StackMap locals:
StackMap stack:
iinc 7 1
StackMap locals:
StackMap stack:
29: iload 7
iload 2
if_icmplt 18
end local 7 30: aload 0
aload 6
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
end local 6 end local 4 31: StackMap locals: org.h2.tools.Shell java.util.ArrayList int int[] top java.util.Iterator
StackMap stack:
aload 5
invokeinterface java.util.Iterator.hasNext:()Z
ifne 14
32: aload 3
areturn
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 33 0 this Lorg/h2/tools/Shell;
0 33 1 rows Ljava/util/ArrayList<[Ljava/lang/String;>;
0 33 2 len I
1 33 3 columnSizes [I
2 13 4 i I
4 11 5 max I
6 7 6 row [Ljava/lang/String;
15 31 4 row [Ljava/lang/String;
16 31 6 buff Ljava/lang/StringBuilder;
17 30 7 i I
21 28 8 s Ljava/lang/String;
24 28 9 j I
Signature: (Ljava/util/ArrayList<[Ljava/lang/String;>;I)[I
MethodParameters:
Name Flags
rows
len
private int printResultAsList(java.sql.ResultSet);
descriptor: (Ljava/sql/ResultSet;)I
flags: (0x0002) ACC_PRIVATE
Code:
stack=4, locals=11, args_size=2
start local 0 start local 1 0: aload 1
invokeinterface java.sql.ResultSet.getMetaData:()Ljava/sql/ResultSetMetaData;
astore 2
start local 2 1: iconst_0
istore 3
start local 3 2: aload 2
invokeinterface java.sql.ResultSetMetaData.getColumnCount:()I
istore 4
start local 4 3: iload 4
anewarray java.lang.String
astore 5
start local 5 4: iconst_0
istore 6
start local 6 5: goto 10
6: StackMap locals: org.h2.tools.Shell java.sql.ResultSet java.sql.ResultSetMetaData int int java.lang.String[] int
StackMap stack:
aload 2
iload 6
iconst_1
iadd
invokeinterface java.sql.ResultSetMetaData.getColumnLabel:(I)Ljava/lang/String;
astore 7
start local 7 7: aload 5
iload 6
aload 7
aastore
8: iload 3
aload 7
invokevirtual java.lang.String.length:()I
invokestatic java.lang.Math.max:(II)I
istore 3
end local 7 9: iinc 6 1
StackMap locals:
StackMap stack:
10: iload 6
iload 4
if_icmplt 6
end local 6 11: new java.lang.StringBuilder
dup
invokespecial java.lang.StringBuilder.<init>:()V
astore 6
start local 6 12: iconst_0
istore 7
start local 7 13: goto 33
14: StackMap locals: org.h2.tools.Shell java.sql.ResultSet java.sql.ResultSetMetaData int int java.lang.String[] java.lang.StringBuilder int
StackMap stack:
iinc 7 1
15: aload 6
iconst_0
invokevirtual java.lang.StringBuilder.setLength:(I)V
16: iload 7
iconst_1
if_icmple 18
17: aload 0
ldc ""
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
18: StackMap locals:
StackMap stack:
iconst_0
istore 8
start local 8 19: goto 31
20: StackMap locals: int
StackMap stack:
iload 8
ifle 22
21: aload 6
bipush 10
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
22: StackMap locals:
StackMap stack:
aload 5
iload 8
aaload
astore 9
start local 9 23: aload 6
aload 9
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
24: aload 9
invokevirtual java.lang.String.length:()I
istore 10
start local 10 25: goto 28
26: StackMap locals: java.lang.String int
StackMap stack:
aload 6
bipush 32
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
27: iinc 10 1
StackMap locals:
StackMap stack:
28: iload 10
iload 3
if_icmplt 26
end local 10 29: aload 6
ldc ": "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 1
iload 8
iconst_1
iadd
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
end local 9 30: iinc 8 1
StackMap locals:
StackMap stack:
31: iload 8
iload 4
if_icmplt 20
end local 8 32: aload 0
aload 6
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
33: StackMap locals:
StackMap stack:
aload 1
invokeinterface java.sql.ResultSet.next:()Z
ifne 14
34: iload 7
ifne 44
35: iconst_0
istore 8
start local 8 36: goto 42
37: StackMap locals: int
StackMap stack:
iload 8
ifle 39
38: aload 6
bipush 10
invokevirtual java.lang.StringBuilder.append:(C)Ljava/lang/StringBuilder;
pop
39: StackMap locals:
StackMap stack:
aload 5
iload 8
aaload
astore 9
start local 9 40: aload 6
aload 9
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
pop
end local 9 41: iinc 8 1
StackMap locals:
StackMap stack:
42: iload 8
iload 4
if_icmplt 37
end local 8 43: aload 0
aload 6
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.h2.tools.Shell.println:(Ljava/lang/String;)V
44: StackMap locals:
StackMap stack:
iload 7
ireturn
end local 7 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 45 0 this Lorg/h2/tools/Shell;
0 45 1 rs Ljava/sql/ResultSet;
1 45 2 meta Ljava/sql/ResultSetMetaData;
2 45 3 longestLabel I
3 45 4 len I
4 45 5 columns [Ljava/lang/String;
5 11 6 i I
7 9 7 s Ljava/lang/String;
12 45 6 buff Ljava/lang/StringBuilder;
13 45 7 rowCount I
19 32 8 i I
23 30 9 label Ljava/lang/String;
25 29 10 j I
36 43 8 i I
40 41 9 label Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
rs
}
SourceFile: "Shell.java"