大家好，又见面了，我是你们的朋友全栈君。
Javadb学习
环境变量设置:
DERBY_HOME=D:ProgramFilesEnvironmentjavadb
path=.;%JAVA_HOME%/bin;%path%;�TALINA_HOME%/bin;%ANT_HOME%/bin;%ANT_HOME%/bin;C:Program FilesIDM Computer SolutionsUltraEdit;%JAVA_HOME%jrelib;%DERBY_HOME%bin
classpath=.;%JAVA_HOME%libtools.jar;%JAVA_HOME%libdt.jar;%JAVA_HOME%bin;%JAVA_HOME%jrelib;�RBY_HOME%libderby.jar;�RBY_HOME%libderbyclient.jar;�RBY_HOME%libderbynet.jar;�RBY_HOME%libderbyrun.jar
开启Javadb服务:
java -jar �rby_home%libderbyrun.jar server start
关闭javadb服务
java -jar �rby_home%libderbyrun.jar server shutdown
ij
ij> exit; 退出
Email server : derby-user@db.apache.org
用ij连接数据库javadb
Creating a Derby database and running SQL statements Now, you will use the Derby ij tool to load the Derby database engine. You will use the Derby embedded driver to create and connect to the firstdb database. You will also use a few basic SQL statements to create and populate a table. 1. Run the Derby ij tool. If you included the DERBY_HOME/bin directory in your PATH environment variable, type: ij Otherwise, you can use the java command to start the ij tool. Operating System Command UNIX (Korn Shell) java -jar $DERBY_HOME/lib/derbyrun.jar ij ij version 10.5 Windows java -jar �RBY_HOME%libderbyrun.jar ij ij version 10.5 2. Create the database and open a connection to the database using the embedded driver. CONNECT ‘jdbc:derby:firstdb;create=true’; Description of connection command: connect The ij command to establish a connection to a database. The Derby connection URL is enclosed in single quotation marks. An ij command can be in either uppercase or lowercase. jdbc:derby: The JDBC protocol specification for the Derby driver. firstdb The name of the database. The name can be any string. Because no filepath is specified, the database is created in the default working directory (DERBYTUTOR). ;create=true The Derby URL attribute that is used to create a database. Derby does not have an SQL create database command. ; Getting Started with Java DB 23 The semicolon is the ij command terminator. 3. Create a table with two columns using standard SQL. CREATE TABLE FIRSTTABLE (ID INT PRIMARY KEY, NAME VARCHAR(12)); 0 rows inserted/updated/deleted 4. Insert three records. INSERT INTO FIRSTTABLE VALUES (10,’TEN’),(20,’TWENTY’),(30,’THIRTY’); 3 rows inserted/updated/deleted 5. Perform a simple select of all records in the table. SELECT * FROM FIRSTTABLE; ID |NAME ———————— 10 |TEN 20 |TWENTY 30 |THIRTY 3 rows selected 6. Perform a qualified select of the record with column ID=20. SELECT * FROM FIRSTTABLE WHERE ID=20; ID |NAME ———————— 20 |TWENTY 1 row selected 7. Optional: Create and populate additional tables and other schema objects. a. Load the SQL script ToursDB_schema.sql. run ‘ToursDB_schema.sql’; ij> … CREATE TABLE AIRLINES ( AIRLINE CHAR(2) NOT NULL , AIRLINE_FULL VARCHAR(24), BASIC_RATE DOUBLE PRECISION, … 0 rows inserted/updated/deleted … Other output messages not shown … b. Populate the tables with data by running the script loadTables.sql. run ‘loadTables.sql’; ij> run ‘loadCOUNTRIES.sql’; ij> insert into COUNTRIES values ( ‘Afghanistan’,’AF’,’Asia’); 1 row inserted/updated/deleted ij> insert into COUNTRIES values ( ‘Albania’,’AL’,’Europe’); 1 row inserted/updated/deleted … Other output messages not shown … 8. Exit the ij tool. exit; You should be returned to the DERBYTUTOR directory. 9. Browse the most
Activity 2: Run SQL using the client driver
java -jar �RBY_HOME%libderbyrun.jar server start
换一个dos窗口
java -jar �RBY_HOME%libderbyrun.jar ij
CONNECT ‘jdbc:derby://localhost:1527/seconddb;create=true’;
备注区别:CONNECT ‘jdbc:derby:firstdb;create=true’;
CREATE TABLE SECONDTABLE (ID INT PRIMARY KEY, NAME VARCHAR(14)); 0 rows inserted/updated/deleted
INSERT INTO SECONDTABLE VALUES (100,’ONE HUNDRED’),(200,’TWO HUNDRED’),(300,’THREE HUNDRED’); 3 rows inserted/updated/deleted
SELECT * FROM SECONDTABLE; ID |NAME ———————— 100 |ONE HUNDRED 200 |TWO HUNDRED 300 |THREE HUNDRED 3 rows selected
Exit ij.
java -jar �RBY_HOME%libderbyrun.jar server shutdown
发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/156994.html原文链接：https://javaforall.cn
