Derby使用ij工具操作数据库

最新推荐文章于 2025-02-09 22:38:50 发布

J2EE_WQS

最新推荐文章于 2025-02-09 22:38:50 发布

阅读量955

点赞数

分类专栏： Sql/derby 文章标签： derby ij jdbc ij工具 apache

Sql/derby 专栏收录该内容

17 篇文章

订阅专栏

本文详细介绍了如何使用Derby数据库的ij工具进行数据库创建、表结构定义及数据增删查改等基本操作，并通过实例演示了整个过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

解压apache的derby数据库:D:\Program Files\derby\db-derby-10.7.1.1-bin

在home下找到/derby_home/bin/ij工具

启动ij工具

ij> connect 'jdbc:derby:ij_cmd_test_db;create=true';
WARNING 01J01: Database 'ij_cmd_test_db' not created, connection made to existing database instead.
ij(CONNECTION1)>select * from table;
ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 19.
Issue the 'help' command for general information on IJ command syntax.
Any unrecognized commands are treated as potential SQL commands and executed directly.
Consult your DBMS server reference documentation for details of the SQL syntax supported by your server.
ij(CONNECTION1)> create table ijtest(num int);
0 rows inserted/updated/deleted
ij(CONNECTION1)> select * from ijtest;
NUM
-----------

0 rows selected
ij(CONNECTION1)> insert into ijtest values (19890521);
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into ijtest values (19890520);
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into ijtest values (19890519);
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into ijtest values (19890518);
1 row inserted/updated/deleted
ij(CONNECTION1)> select * from ijtest;
NUM
-----------
19890521
19890520
19890519
19890518

4 rows selected
ij(CONNECTION1)>

按照上面步骤,建立数据库"ij_cmd_test_db",建立数据库表"ijtest",最后查询数据库表"select * from ijtest",查询得到刚刚插入的数据.

ij工具命令可以通过进入ij命令行后敲入"help"

退出 "exit".

后面贴上derby的jdbc的访问方式.

附件附上一个比较好的derby文档.