[Java] JDBC Test (ORACLE DB, tnsnames.ora)

// Instant Client 설치 및 TNS_ADMIN 환경변수 세팅 후 tnsnames.ora의 TNS_IDENTIFIER 참고하여 Oracle DB에 접근하는 예제

import java.sql.*;

public class JDBCTest {
    public static void main(String[] args) throws Exception {
        System.setProperty("oracle.net.tns_admin", System.getenv("TNS_ADMIN"));

        String dbURL = "jdbc:oracle:thin:@MYDB";
        Class.forName ("oracle.jdbc.OracleDriver");

        Connection conn = null;
        Statement stmt = null;

        try {
            conn = DriverManager.getConnection(dbURL, "system", "password");
            System.out.println("DB 접속 성공");

            stmt = conn.createStatement();

            String sql = "SELECT username, user_id, account_status FROM dba_users";
            ResultSet rs = stmt.executeQuery(sql);

            ResultSetMetaData metaInfo = rs.getMetaData();

            int count = metaInfo.getColumnCount();
            for (int i=0; i<count; i++) {
                System.out.printf("%s\t", metaInfo.getColumnName(i+1));
            }

            System.out.println();

            while (rs.next()) {
                System.out.println(rs.getString(1) + "\t" + rs.getString(2) + "\t" + rs.getString(3));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        finally {
            if (stmt != null) try { stmt.close(); } catch (Exception e) {}
            if (conn != null) try { conn.close(); } catch (Exception e) {}
        }
    }
}

 

 

Instant Client 설치 참고: https://testtube.tistory.com/27

[Oracle] Instant Client(11.2.0.4) 설치 및 설정(Windows 10 x64 기준)

https://testtube.tistory.com/entry/Oracle-JDBC-releases-Vs-JDK-versions?category=772690

[Java] Oracle JDBC releases Vs JDK versions