org.hsqldb/hsqldb/2.5.0 : org/hsqldb/sample/FindFile.class

FindFile
http://hsqldb.org: HSQLDB - Lightweight 100% Java SQL Database Engine (The HSQL Development Group)
HSQLDB License, a BSD open source license
Blaine Simpson
class org.hsqldb.sample.FindFile
  minor version: 0
  major version: 59
  flags: flags: (0x0020) ACC_SUPER
  this_class: org.hsqldb.sample.FindFile
  super_class: java.lang.Object
{
  void <init>();
    descriptor: ()V
    flags: (0x0000) 
    Code:
      stack=1, locals=1, args_size=1
        start local 0 // org.hsqldb.sample.FindFile this
         0: .line 88
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
            return
        end local 0 // org.hsqldb.sample.FindFile this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    1     0  this  Lorg/hsqldb/sample/FindFile;

  public static void main(java.lang.String[]);
    descriptor: ([Ljava/lang/String;)V
    flags: (0x0009) ACC_PUBLIC, ACC_STATIC
    Code:
      stack=3, locals=2, args_size=1
        start local 0 // java.lang.String[] arg
         0: .line 108
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
         1: .line 115
            ldc "jdbc:hsqldb:testfiles"
            ldc "SA"
         2: .line 116
            ldc ""
         3: .line 115
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
         4: .line 114
            astore 1 /* conn */
        start local 1 // java.sql.Connection conn
         5: .line 119
            aload 0 /* arg */
            arraylength
            iconst_1
            if_icmpne 8
         6: .line 123
            aload 1 /* conn */
            aload 0 /* arg */
            iconst_0
            aaload
            invokestatic org.hsqldb.sample.FindFile.listFiles:(Ljava/sql/Connection;Ljava/lang/String;)V
         7: .line 124
            goto 16
      StackMap locals: java.sql.Connection
      StackMap stack:
         8: aload 0 /* arg */
            arraylength
            iconst_2
            if_icmpne 11
            aload 0 /* arg */
            iconst_0
            aaload
            ldc "-init"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 11
         9: .line 128
            aload 1 /* conn */
            aload 0 /* arg */
            iconst_1
            aaload
            invokestatic org.hsqldb.sample.FindFile.fillFileNames:(Ljava/sql/Connection;Ljava/lang/String;)V
        10: .line 129
            goto 16
        11: .line 132
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Usage:"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        12: .line 133
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "java FindFile -init ."
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        13: .line 134
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "  Re-create database from directory '.'"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        14: .line 135
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "java FindFile name"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        15: .line 136
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "  Find files like 'name'"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        16: .line 140
      StackMap locals:
      StackMap stack:
            aload 1 /* conn */
            invokeinterface java.sql.Connection.close:()V
        end local 1 // java.sql.Connection conn
        17: .line 141
            goto 21
      StackMap locals: java.lang.String[]
      StackMap stack: java.lang.Exception
        18: astore 1 /* e */
        start local 1 // java.lang.Exception e
        19: .line 144
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 1 /* e */
            invokevirtual java.io.PrintStream.println:(Ljava/lang/Object;)V
        20: .line 145
            aload 1 /* e */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 1 // java.lang.Exception e
        21: .line 147
      StackMap locals:
      StackMap stack:
            return
        end local 0 // java.lang.String[] arg
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   22     0   arg  [Ljava/lang/String;
            5   17     1  conn  Ljava/sql/Connection;
           19   21     1     e  Ljava/lang/Exception;
      Exception table:
        from    to  target  type
           0    17      18  Class java.lang.Exception
    MethodParameters:
      Name  Flags
      arg   

  static void listFiles(java.sql.Connection, java.lang.String);
    descriptor: (Ljava/sql/Connection;Ljava/lang/String;)V
    flags: (0x0008) ACC_STATIC
    Code:
      stack=4, locals=4, args_size=2
        start local 0 // java.sql.Connection conn
        start local 1 // java.lang.String name
         0: .line 156
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            ldc "Files like '"
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* name */
            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;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         1: .line 159
            aload 1 /* name */
            invokevirtual java.lang.String.toUpperCase:()Ljava/lang/String;
            astore 1 /* name */
         2: .line 162
            aload 0 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 2 /* stat */
        start local 2 // java.sql.Statement stat
         3: .line 167
            aload 2 /* stat */
            new java.lang.StringBuilder
            dup
            ldc "SELECT Path FROM Files WHERE UCASE(Path) LIKE '%"
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
         4: .line 168
            aload 1 /* name */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
         5: .line 169
            ldc "%' ESCAPE ':'"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         6: .line 167
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 3 /* result */
        start local 3 // java.sql.ResultSet result
         7: .line 172
            goto 9
         8: .line 176
      StackMap locals: java.sql.Statement java.sql.ResultSet
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 3 /* result */
            iconst_1
            invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         9: .line 172
      StackMap locals:
      StackMap stack:
            aload 3 /* result */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 8
        10: .line 180
            aload 3 /* result */
            invokeinterface java.sql.ResultSet.close:()V
        11: .line 181
            return
        end local 3 // java.sql.ResultSet result
        end local 2 // java.sql.Statement stat
        end local 1 // java.lang.String name
        end local 0 // java.sql.Connection conn
      LocalVariableTable:
        Start  End  Slot    Name  Signature
            0   12     0    conn  Ljava/sql/Connection;
            0   12     1    name  Ljava/lang/String;
            3   12     2    stat  Ljava/sql/Statement;
            7   12     3  result  Ljava/sql/ResultSet;
    Exceptions:
      throws java.sql.SQLException
    MethodParameters:
      Name  Flags
      conn  
      name  

  static void fillFileNames(java.sql.Connection, java.lang.String);
    descriptor: (Ljava/sql/Connection;Ljava/lang/String;)V
    flags: (0x0008) ACC_STATIC
    Code:
      stack=3, locals=4, args_size=2
        start local 0 // java.sql.Connection conn
        start local 1 // java.lang.String root
         0: .line 191
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Re-creating the database..."
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         1: .line 194
            aload 0 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 2 /* stat */
        start local 2 // java.sql.Statement stat
         2: .line 198
            aload 2 /* stat */
            ldc "DROP TABLE Files"
            invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
            pop
         3: .line 199
            goto 5
      StackMap locals: java.sql.Connection java.lang.String java.sql.Statement
      StackMap stack: java.sql.SQLException
         4: pop
         5: .line 204
      StackMap locals:
      StackMap stack:
            aload 2 /* stat */
            ldc "CREATE TABLE Files(Path varchar(255),Name varchar(255))"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
         6: .line 208
            aload 2 /* stat */
            invokeinterface java.sql.Statement.close:()V
         7: .line 212
            aload 0 /* conn */
            ldc "INSERT INTO Files (Path,Name) VALUES (?,?)"
            invokeinterface java.sql.Connection.prepareCall:(Ljava/lang/String;)Ljava/sql/CallableStatement;
         8: .line 211
            astore 3 /* prep */
        start local 3 // java.sql.PreparedStatement prep
         9: .line 215
            aload 1 /* root */
            ldc ""
            aload 3 /* prep */
            invokestatic org.hsqldb.sample.FindFile.fillPath:(Ljava/lang/String;Ljava/lang/String;Ljava/sql/PreparedStatement;)V
        10: .line 218
            aload 3 /* prep */
            invokeinterface java.sql.PreparedStatement.close:()V
        11: .line 219
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Finished"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        12: .line 220
            return
        end local 3 // java.sql.PreparedStatement prep
        end local 2 // java.sql.Statement stat
        end local 1 // java.lang.String root
        end local 0 // java.sql.Connection conn
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   13     0  conn  Ljava/sql/Connection;
            0   13     1  root  Ljava/lang/String;
            2   13     2  stat  Ljava/sql/Statement;
            9   13     3  prep  Ljava/sql/PreparedStatement;
      Exception table:
        from    to  target  type
           2     3       4  Class java.sql.SQLException
    Exceptions:
      throws java.sql.SQLException
    MethodParameters:
      Name  Flags
      conn  
      root  

  static void fillPath(java.lang.String, java.lang.String, java.sql.PreparedStatement);
    descriptor: (Ljava/lang/String;Ljava/lang/String;Ljava/sql/PreparedStatement;)V
    flags: (0x0008) ACC_STATIC
    Code:
      stack=3, locals=6, args_size=3
        start local 0 // java.lang.String path
        start local 1 // java.lang.String name
        start local 2 // java.sql.PreparedStatement prep
         0: .line 230
            new java.io.File
            dup
            aload 0 /* path */
            invokespecial java.io.File.<init>:(Ljava/lang/String;)V
            astore 3 /* f */
        start local 3 // java.io.File f
         1: .line 232
            aload 3 /* f */
            invokevirtual java.io.File.isFile:()Z
            ifeq 7
         2: .line 235
            aload 2 /* prep */
            invokeinterface java.sql.PreparedStatement.clearParameters:()V
         3: .line 238
            aload 2 /* prep */
            iconst_1
            aload 0 /* path */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         4: .line 241
            aload 2 /* prep */
            iconst_2
            aload 1 /* name */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         5: .line 244
            aload 2 /* prep */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
         6: .line 245
            goto 16
      StackMap locals: java.io.File
      StackMap stack:
         7: aload 3 /* f */
            invokevirtual java.io.File.isDirectory:()Z
            ifeq 16
         8: .line 246
            aload 0 /* path */
            getstatic java.io.File.separator:Ljava/lang/String;
            invokevirtual java.lang.String.endsWith:(Ljava/lang/String;)Z
            ifne 10
         9: .line 247
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            getstatic java.io.File.separator:Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 0 /* path */
        10: .line 250
      StackMap locals:
      StackMap stack:
            aload 3 /* f */
            invokevirtual java.io.File.list:()[Ljava/lang/String;
            astore 4 /* list */
        start local 4 // java.lang.String[] list
        11: .line 253
            iconst_0
            istore 5 /* i */
        start local 5 // int i
        12: goto 15
        13: .line 254
      StackMap locals: java.lang.String[] int
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 4 /* list */
            iload 5 /* i */
            aaload
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            aload 4 /* list */
            iload 5 /* i */
            aaload
            aload 2 /* prep */
            invokestatic org.hsqldb.sample.FindFile.fillPath:(Ljava/lang/String;Ljava/lang/String;Ljava/sql/PreparedStatement;)V
        14: .line 253
            iinc 5 /* i */ 1
      StackMap locals:
      StackMap stack:
        15: aload 4 /* list */
            ifnull 16
            iload 5 /* i */
            aload 4 /* list */
            arraylength
            if_icmplt 13
        end local 5 // int i
        end local 4 // java.lang.String[] list
        16: .line 257
      StackMap locals:
      StackMap stack:
            return
        end local 3 // java.io.File f
        end local 2 // java.sql.PreparedStatement prep
        end local 1 // java.lang.String name
        end local 0 // java.lang.String path
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   17     0  path  Ljava/lang/String;
            0   17     1  name  Ljava/lang/String;
            0   17     2  prep  Ljava/sql/PreparedStatement;
            1   17     3     f  Ljava/io/File;
           11   16     4  list  [Ljava/lang/String;
           12   16     5     i  I
    Exceptions:
      throws java.sql.SQLException
    MethodParameters:
      Name  Flags
      path  
      name  
      prep  
}
SourceFile: "FindFile.java"
/

org.hsqldb/ hsqldb/ 2.5.0/ org/hsqldb/sample/FindFile.class
