用 Apache Derby 進行開發 —— 取得節節勝利: 使用 Apache Derby 進行數據庫開發，第 1 部分

rb$ echo $CLASSPATH
            /opt/Apache/db-derby-10.1.2.1-bin/lib/derby.jar:
            /opt/Apache/db-derby-10.1.2.1-bin/lib/derbytools.jar:.
            rb$ mkdir derbyWork
            rb$ cd derbyWork
            rb$ java org.apache.derby.tools.ij
            ij version 10.1
            ij> connect 'jdbc:derby:test;create=true' ;
            ij> exit ;
            rb$ ls -CF
            derby.log       test/
            

rb$ ls -CF test/
            log/                    seg0/                   service.properties
            rb$ ls -CF test/log/
            log.ctrl        log1.dat        logmirror.ctrl
            rb$ ls -CF test/seg0/
            c10.dat         c191.dat        c221.dat        c2c1.dat       c90.dat
            c101.dat        c1a1.dat        c230.dat        c2d0.dat       ca1.dat
            c111.dat        c1b1.dat        c241.dat        c2e1.dat       cb1.dat
            c121.dat        c1c0.dat        c251.dat        c2f0.dat       cc0.dat
            c130.dat        c1d1.dat        c260.dat        c31.dat        cd1.dat
            c141.dat        c1e0.dat        c271.dat        c41.dat        ce1.dat
            c150.dat        c1f1.dat        c281.dat        c51.dat        cf0.dat
            c161.dat        c20.dat         c290.dat        c60.dat
            c171.dat        c200.dat        c2a1.dat        c71.dat
            c180.dat        c211.dat        c2b1.dat        c81.dat
            

rb$ java org.apache.derby.tools.ij
            ij version 10.1
            ij> help ;
            Supported commands include:
            PROTOCOL 'JDBC protocol' [ AS ident ];
            -- sets a default or named protocol
            DRIVER 'class for driver';   -- loads the named class
            CONNECT 'url for database' [ PROTOCOL namedProtocol ]
            [ AS connectionName ];
            -- connects to database URL
            -- and may assign identifier
            SET CONNECTION connectionName; -- switches to the specified
            connection
            SHOW CONNECTIONS;            -- lists all connections
            AUTOCOMMIT [ ON | OFF ];     -- sets autocommit mode for the
            -- connection
            DISCONNECT [ CURRENT | connectionName | ALL ];
            -- drop current, named, or all
            -- connections; the default is CURRENT
            COMMIT;                      -- commits the current transaction
            ROLLBACK;                    -- rolls back the current transaction
            PREPARE name AS 'SQL-J text'; -- prepares the SQL-J text
            EXECUTE { name | 'SQL-J text' } [ USING { name | 'SQL-J text' } ] ;
            -- executes the statement with
            -- parameter values from the USING
            -- result set row
            REMOVE name;                 -- removes the named previously
            -- prepared statement
            RUN 'filename';              -- run commands from the named file
            ELAPSEDTIME [ ON | OFF ];    -- sets elapsed time mode for ij
            MAXIMUMDISPLAYWIDTH integerValue;
            -- sets the maximum display width for
            -- each column to integerValue
            ASYNC name 'SQL-J text';     -- run the command in another thread
            WAIT FOR name;               -- wait for result of ASYNC'd command
            GET [SCROLL INSENSITIVE] CURSOR name AS 'SQL-J query';
            -- gets a cursor (JDBC result set)
            -- on the query
            -- SCROLL cursors are only available
            -- in JDBC 2.0 and higher.
            -- (Cursor scroll type is ignored in
            -- JDBC 1.X.)
            NEXT name;                   -- gets the next row from the
            -- named cursor
            FIRST name;                  -- gets the first row from the
            -- named scroll cursor
            LAST name;                   -- gets the last row from the
            -- named scroll cursor
            PREVIOUS name;               -- gets the previous row from the
            -- named scroll cursor
            ABSOLUTE integer name;       -- positions the named scroll cursor
            -- at the absolute row number
            -- (A negative number denotes
            -- position from the last row.)
            RELATIVE integer name;       -- positions the named scroll cursor
            -- relative to the current row
            -- (integer is number of rows)
            AFTER LAST name;             -- positions the named scroll cursor
            -- after the last row
            BEFORE FIRST name;           -- positions the named scroll cursor
            -- before the first row
            GETCURRENTROWNUMBER name;    -- returns the row number for the
            -- current position of the named
            -- scroll cursor (0 is returned when
            -- the cursor isn't positioned
            -- on a row.)
            CLOSE name;                  -- closes the named cursor
            LOCALIZEDDISPLAY [ ON | OFF ];
            -- controls locale sensitive data
            -- representation
            EXIT;                        -- exits ij
            HELP;                        -- shows this message
            Any unrecognized commands are treated as potential SQL-J commands
            and executed directly.
            ij>
            

ij> connect 'jdbc:derby:test;create=true' ;
            WARNING 01J01: Database 'test' not created,
            connection made to existing database instead.
            ij> connect 'jdbc:derby:test' ;
            ij(CONNECTION1)> show connections ;
            CONNECTION0 -   jdbc:derby:test
            CONNECTION1* -  jdbc:derby:test
            * = current connection
            ij(CONNECTION1)> disconnect ;
            ij> show connections ;
            CONNECTION0 -   jdbc:derby:test
            No current connection
            ij> set connection CONNECTION0 ;
            ij> show connections ;
            CONNECTION0* -  jdbc:derby:test
            * = current connection
            ij> exit ;