Java DBに挑戦 - Let's get started with Java DB - (Unix Ver) Volume3

<script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script>

次は組み込みドライバーを使ったJDBCプログラムを試してみます。
例の如くDERBYTUTORへ移動します。

> /var/tmp/DERBYTUTOR

ここでDERBYのデモプログラムを使ってみます。

> mkdir src
> cp $DERBY_HOME/demo/programs/workingwithderby/* src/
> ls src

WwdClientExample.class	WwdEmbedded.class	WwdUtils.class	readme.html
WwdClientExample.java	WwdEmbedded.java	WwdUtils.java

.classファイルは邪魔なので削除してください。

DERBYTUTOR直下で以下のようなbuild.xmlを作成しました。

■build-db.xml

<?xml version="1.0" encoding="EUC-JP"?>

<project name="derby-demo" default="build" basedir=".">
    <property name="src.dir" value="src" />
    <property name="dest.dir" value="classes" />
    <property environment="env" />

    <path id="cp">
        <pathelement location="${dest.dir}" />
        <fileset dir="${env.DERBY_HOME}/lib">
            <include name="**/*.jar" />
        </fileset>
    </path>

    <target name="echo">
        <property name="echo.path" refid="cp" />
        <echo message="${echo.path}" />
    </target>

    <target name="init">
        <tstamp />
    </target>

    <target name="build" depends="init">
        <mkdir dir="${dest.dir}" />
        <javac srcdir="${src.dir}" destdir="${dest.dir}" debug="yes">
            <classpath refid="cp" />
            <include name="*.java" />
        </javac>
    </target>

    <target name="emb" depends="build">
        <java classname="WwdEmbedded" fork="yes">
            <classpath refid="cp" />
        </java>
    </target>

</project>

■プログラムのコンパイルおよび起動の確認

> ant -f build-db.xml build
> ant -f build-db.xml emb
emb:
     [java] org.apache.derby.jdbc.EmbeddedDriver loaded.
     [java] Connected to database jdbcDemoDB
     [java]  . . . . creating table WISH_LIST
     [java] Enter wish-list item (enter exit to end):
a peppermint stick
     [java]   __________________________________________________
     [java] On 2010-06-24 00:49:04.977 I wished for a peppermint stick
     [java]   __________________________________________________
     [java] Enter wish-list item (enter exit to end):
a long vacation
     [java]   __________________________________________________
     [java] On 2010-06-24 00:49:04.977 I wished for a peppermint stick
     [java] On 2010-06-24 00:49:12.258 I wished for a long vacation
     [java]   __________________________________________________
     [java] Enter wish-list item (enter exit to end):
exit
     [java] Closed connection
     [java] Database shut down normally
     [java] Getting Started With Derby JDBC program ending.

<form id="cse-search-box" action="">http://www.google.co.jp/cse">  

    <input type="hidden" value="partner-pub-3407383286528802:x1hdk1ewp2s" name="cx" />     <input type="hidden" value="UTF-8" name="ie" />     <input type="text" size="31" name="q" />     <input type="submit" value="検索" name="sa" />  

</form>

<script src="http://www.google.co.jp/cse/brand?form=cse-search-box&lang=ja" type="text/javascript"></script>