Oracleへのjdbc thin 接続

JAVAによる、OracleへのJDCB(thin)接続の方法

実行用スクリプト(JAVAコンパイル兼用)

#!/bin/sh

CLASS=test_jdbc_oracle_thin

javac -classpath $HOME/jdbc/lib/jars/ojdbc14.jar $CLASS.java
echo "*** finished build."

SQL="select table_name from all_tables"

java -classpath $HOME/jdbc/lib/jars/ojdbc14.jar:./ -client $CLASS "$SQL"
echo "*** finished process."

JAVAソース

import java.sql.*;

//気が向いたら下記のも試してみたい
//import oracle.jdbc.*;
//import oracle.jdbc.pool.OracleConnectionCacheManager;
//import oracle.jdbc.pool.OracleDataSource;


public class test_jdbc_oracle_thin {

    public static void main (String args[]) throws SQLException, ClassNotFoundException {

        String sql = args[0];
        System.out.println ("*** SQL=["+ sql +"]");

        // driver load
        Class.forName("oracle.jdbc.driver.OracleDriver");

        Connection conn = DriverManager.getConnection (
                              "jdbc:oracle:thin:@host-name.com1521:oracle-sid"
                            , "CHANGE_USER"
                            , "CNAHGE_PASS"
                          );

        Statement stmt = conn.createStatement(); 
        ResultSet rset = stmt.executeQuery(sql);

        int i = 0;
        while ( rset.next() ) {
            i++;
            //System.out.println (rset.getString(1));
            //System.out.println(rset.getInt(1) + "\t" + rset.getString(2));
            System.out.println(rset.getInt(1));
            if (i > 10) break;
        } 

        // close
        rset.close(); 

        // close
        stmt.close(); 
  
        // close
        conn.close();
    }
}