[Oracle] JDBC Connection

오라클 JDBC 접속 테스트용 Java Program

 

-- ###########################################################################
-- Oracle JDBC Connection 테스트
-- ###########################################################################
 
-- 1) CLASSPATH 등록
export CLASSPATH=.:/oracle/db/12.1/jdbc/lib/ojdbc6.jar
 
-- 2) OraTest.java Compile
/oracle/db/12.1/jdk/bin/javac OraTest.java
 
-- 3) OraTest.java Exec
/oracle/db/12.1/jdk/bin/java OraTest
 
-------------------
-- OraTest.java
-------------------
import java.sql.*;
 
public class oratest {
 
    public static void main(string[] args) {
    
        string jdbc_driver = "oracle.jdbc.driver.oracledriver";
        string jdbc_url    = "jdbc:oracle:thin:@10.11.12.13:1521/testdb";
        string dbuser      = "orakim";
        string dbuser_pass = "orakim1234";
        connection conn    = null;
        statement st       = null;
        resultset rs       = null;
 
        try {
        
            class.forname(jdbc_driver);
            system.out.println("driver ok");
 
            conn = drivermanager.getconnection(jdbc_url, dbuser, dbuser_pass);
            system.out.println("connection ok");
 
            st = conn.createstatement();
            system.out.println("statement ok");
 
            string sql = "select * from dba_objects where rownum <=5";
 
            rs = st.executequery(sql);
            system.out.println("rs ok");
            
            while (rs.next()) {
 
                string objnm = rs.getstring("object_name");
                system.out.println("object_name=" + objnm );
            }
            
        } catch (exception e) {
            e.printstacktrace();
        } finally {
            if (rs != null)
            try {
                rs.close();
            } catch (sqlexception e) {
                e.printstacktrace();
            }
            if (st != null)
            try {
                st.close();
            } catch (sqlexception e) {
                e.printstacktrace();
            }
            if (conn != null)
            try {
                conn.close();
            } catch (sqlexception e) {
                e.printstacktrace();
            }
        }
    }