'디렉토리 구조'에 해당되는 글 1

  1. 2010.08.16 Eclipse에서 Ant로 HSQLDB 사용하기

Eclipse에서 Ant로 HSQLDB 사용하기

간단한 테스트 데이터베이스로 사용하기에 이놈보다 좋은게 어디있겠냐.
예전 Tutorial에서 가져옴.
원출처는 여기
<project name="sample.pantarei" default="usage" basedir=".">
<property file="build.properties"/>

<path id="master.classpath">
    <!-- &lt;pathelement location="res/devlib/hsqldb.jar"/&gt; -->
    <fileset dir="${devlib.dir}">
        <include name="**/*.jar" />
    </fileset>
</path>
	
<target name="usage"></target>
    
<target name="hsql.startup">
    <java classname="org.hsqldb.Server" classpathref="master.classpath" fork="true">
        <arg value="-database.0" />
        <arg value="res/db/data/${db.name}" />
        <arg value="-dbname.0" />
        <arg value="${db.name}" />
    </java>
</target>

<target name="hsql.shutdown">
    <sql driver="${db.driver}" classpathref="master.classpath" 
        url="${db.url}/${db.name}" 
    	userid="${db.username}" password="${db.password}">
        SHUTDOWN;
    </sql>
</target>

<target name="hsql.manager">
    <java classname="org.hsqldb.util.DatabaseManager" classpathref="master.classpath" fork="true"/>
</target>
	
<target name="printData">
    <echo message="PRINT DATA : ${db.url}/${db.name}"/>
    <sql driver="${db.driver}" classpathref="master.classpath" 
         url="${db.url}/${db.name}"
         userid="${db.username}" password="${db.password}"         
         onerror="continue" print="true">  
    SELECT * FROM products;
    </sql> 
</target>

</project>	
devlib.dir=res/devlib

db.driver=org.hsqldb.jdbcDriver
db.url=jdbc:hsqldb:hsql://localhost
db.name=baseball
db.username=sa
db.password=