database Derby initial

surf the site http://db.apache.org/derby/derby_downloads.html.
you'll get more, but first is download the lastest Derby: derby-10.5.1.1-bin
http://labs.xiaonei.com/apache-mirror/db/derby/db-derby-10.5.1.1/db-derby-10.5.1.1-bin.zip

make a folder:

e:/database/
and unzip it.

E:/database/db-derby-10.5.1.1-bin



Set the system environment:
I set it in WindowsXP:


set Path=
set JAVA_HOME=D:/JAVA
set Path=%JAVA_HOME%/bin;.
set CLASSPATH=%JAVA_HOME%/lib/dt.jar;%JAVA_HOME%/tools.jar;.
set DERBY_INSTALL=E:/database/db-derby-10.5.1.1-bin
set DERBY_HOME=E:/database/db-derby-10.5.1.1-bin
set CLASSPATH=%DERBY_INSTALL%/lib/derby.jar;%DERBY_INSTALL%/lib/derbytools.jar;.
e:
cd E:/database/db-derby-10.5.1.1-bin/bin/
E:/database/db-derby-10.5.1.1-bin/bin/ij.bat

It works:

start the Derby network service

E:/database/db-derby-10.5.1.1-bin/bin>startNetworkServer.bat
2009-07-10 06:53:26.445 GMT : 已使用基本服务器安全策略安装了安全管理程序。
2009-07-10 06:53:28.429 GMT : Apache Derby Network Server － 10.5.1.1 - (764942)
 已启动并且已准备好 {3} 时在端口 1527 上接受连接
 
 OK!
 
 create database:
 
 cd E:/database/db-derby-10.5.1.1-bin/bin/
E:/database/db-derby-10.5.1.1-bin/bin/ij.bat

ij> connect 'jdbc:derby:DerbyTestDB;create=true';
ij>create table zipcodes(zipcode varchar(5), city varchar(20), state varchar(2));
message...
ij>insert int zipcodes values('0755', 'shenzhen', 'GD');
ij>insert int zipcodes values('020', 'guanzhou', 'GD');
ij>insert int zipcodes values('0668', 'dianbai', 'GD');

ij> select 8 from zipcodes;