学步园

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 ;