简单的JDBC应用程序for Java DB

下面是如何运行这个程序：
一、怎样在内嵌式环境（集成到桌面应用）中运行这个例子

我的工作目录是c:\java,先将derby.jar复制到c:\java\jar下。再写一个批处理文件run.bat，内容如下：

set CLASSPATH=c:\java\jar\derby.jar;%CLASSPATH%

打开windows XP的命令行窗口，转入工作目录。运行：

C:\java>run.bat
C:\java>set CLASSPATH=c:\java\jar\derby.jar;
C:\java>javac SimpleApp.java

C:\java>java SimpleApp
SimpleApp starting in embedded mode.
Loaded the appropriate driver.
Connected to and created database derbyDB
Created table derbyDB
Inserted 1956 Webster
Inserted 1910 Union
Updated 1956 Webster to 180 Grand
Updated 180 Grand to 300 Lakeshore
Verified the rows
Dropped table derbyDB
Closed result set and statement
Committed transaction and closed connection
Database shut down normally
SimpleApp finished

程序运行后将在当前目录下生成

• derbyDB (目录)
  这个目录构成了 derbyDB 数据库目录. 你不能修改这个目录中的任何文件。
• derbyDB\log (目录)
  这个目录保存了数据库的事务日志.
• derbyDB\seg0 (目录)
  这个目录保存了数据库derbyDB的数据
• derbyDB\service.properties
  一个内部文件，保存了一些配置参数
• derby.LOG
  日志文件

二、 怎样在服务器环境中运行这个例子

(1)启动Derby Network Server

将derbynet.jar复制到c:\java\jar中,run.bat文件改为:
set CLASSPATH=c:\java\jar\derby.jar;c:\java\jar\derbynet.jar;%CLASSPATH%

新开一个DOS命令行窗口,在这个窗口中启动 Derby Network Server,如:

C:\java>run.bat

C:\java>set CLASSPATH=c:\java\jar\derby.jar;c:\java\jar\derbynet.jar;

C:\java>java org.apache.derby.drda.NetworkServerControl start
服务器准备在端口 1527 上接受连接。

(2)用 Derby 客户端模式运行这个程序:

将 derbyclient.jar 复制到c:\java\jar中,run.bat文件改为:
set CLASSPATH=c:\java\jar\derbyclient.jar;%CLASSPATH%

新开一个DOS命令行窗口,然后以Derby 客户端模式启动SimpleApp

C:\java>run.bat
C:\java>set CLASSPATH=c:\java\jar\derbyclient.jar;

C:\java>java SimpleApp derbyclient
SimpleApp starting in derbyclient mode.
Loaded the appropriate driver.
Connected to and created database derbyDB
Created table derbyDB
Inserted 1956 Webster
Inserted 1910 Union
Updated 1956 Webster to 180 Grand
Updated 180 Grand to 300 Lakeshore
Verified the rows
Dropped table derbyDB
Closed result set and statement
Committed transaction and closed connection
SimpleApp finished

(3)使用 IBM DB2 JDBC Universal Driver运行这个例子

      在Derby的10.0版本, IBM DB2 JDBC Universal Driver 是Derby Network Server唯一的客户端驱动.驱动程序需要从 IBM的站点下载 (IBM DB2 JDBC Universal Driver, for Apache Derby Network Server). 从10.1开始, Derby网络客户端驱动程序与Derby一起分发,并且是被推荐的客户端驱动程序,但 DB2 Universal Driver还被支持并且可以象下面一样被使用:

下载 db2jcc.jar和 db2jcc_license_c.jar,放到c:\java\jar目录下,run.bat的内容改为:
set CLASSPATH=c:\java\jar\db2jcc.jar;c:\java\jar\db2jcc_license_c.jar;%CLASSPATH%

C:\java>run.bat

C:\java>set CLASSPATH=c:\java\jar\db2jcc.jar;c:\java\jar\db2jcc_license_c.jarr;

c:\java>java SimpleApp jccjdbcclient

A successful run produces the following output:
SimpleApp starting in jccjdbc mode.
Loaded the appropriate driver.
Connected to and created database derbyDB
Created table derbyDB
Inserted 1956 Webster
Inserted 1910 Union
Updated 1956 Webster to 180 Grand
Updated 180 Grand to 300 Lakeshore
Verified the rows
Dropped table derbyDB
Closed result set and statement
Committed transaction and closed connection
SimpleApp finished

上一页  [1] [2]