build.xml

JAVA用jdbc联接ORACLE的例子。

<project name="oracle" default="all" basedir=".">

  <property environment="env"/>
  <property file="../../../examples.properties"/>
  <property name="build.compiler" value="${compiler}"/>

  <!-- set global properties for this build -->
  <property name="source" value="${basedir}"/>
  <property name="db.url" value="${db.host}:${db.port}:${sid}"/>

  <target name="all" depends="build"/>

  <!-- Compile the java code from ${source} into ${client.classes.dir} -->
  <target name="build">
    <javac srcdir="${source}"
      destdir="${client.classes.dir}"
      includes="*.java"
    />
  </target>

  <target name="run.all" depends="run.batchUpdate,
                                  run.exsql,
                                  run.login,
                                  run.longvarchar,
                                  run.OracleBlobClob,
                                  run.records,
                                  run.spcursors,
                                  run.storedprocs,
                                  run.simple.sql,
                                  run.simple.select"/>

  <target name="run.batchUpdate">
    <java classname="examples.jdbc.oracle.batchUpdate"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
    </java>
  </target>

  <target name="run.exsql">
    <java classname="examples.jdbc.oracle.exsql"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${sid}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
    </java>
  </target>

  <target name="run.login">
    <java classname="examples.jdbc.oracle.login"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <arg line="-url jdbc:oracle:thin:@${db.host}:${db.port}:${sid}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
    </java>
  </target>

  <target name="run.longvarchar">
    <java classname="examples.jdbc.oracle.longvarchar"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <arg line="-file longvarchar.html"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
    </java>
  </target>

  <target name="run.OracleBlobClob">
    <java classname="examples.jdbc.oracle.OracleBlobClob"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
    </java>
  </target>

  <target name="run.records">
    <java classname="examples.jdbc.oracle.records"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
     </java>
  </target>

  <target name="run.spcursors">
    <exec dir="${source}" executable="${env.ORACLE_HOME}/bin/sqlplus" output="spcursors.out">
      <arg line="scott/tiger@${sid} @spcursors.ddl"/>
    </exec>
    <java classname="examples.jdbc.oracle.spcursors"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${sid}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
     </java>
  </target>

  <target name="run.storedprocs">
    <java classname="examples.jdbc.oracle.storedprocs"
      fork="yes" failonerror="yes">
      <arg line="-user ${db.user}"/>
      <arg line="-password ${db.password}"/>
      <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
     </java>
  </target>
  
  <target name="run.simple.select" depends="run.simple.sql">
    <java classname="examples.jdbc.oracle.SimpleSelectClient"
      fork="yes" failonerror="yes">
            <arg line="-user ${db.user}"/>
            <arg line="-password ${db.password}"/>
            <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
     </java>
  </target>

  <target name="run.simple.sql">
    <java classname="examples.jdbc.oracle.SimpleSqlClient"
      fork="yes" failonerror="yes">
            <arg line="-user ${db.user}"/>
            <arg line="-password ${db.password}"/>
            <arg line="-server ${db.url}"/>
      <classpath>
        <pathelement path="${ex.classpath}"/>
       </classpath>
     </java>
  </target>
</project>