JdbcTestSelectError

// Filename :  JdbcTestSelectError.java

import java.sql.*; 

import java.util.*; 

class JdbcTestSelectError { 

    public static void main (String args []) { 

  // JDBC 드라이버를 로드한다.

        try {

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

} catch(java.lang.ClassNotFoundException e) {

  System.err.print("오류 -> ClassNotFoundException: "); 

System.err.println(e.getMessage());

System.exit(1);

}

try {

// 데이터베이스에 접속한다. 적절한 JDBC URL 설정한다.

      Connection con = DriverManager.getConnection

("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "javatest", "javatest");

  // SQL문을 수행시킨다. 

      Statement stmt = con.createStatement (); 

ResultSet rset = stmt.executeQuery ("SELECT name FROM student");

  while (rset.next ()) {

  String s = OraCon.fromDB(rset.getString(1));

    System.out.println (s);

      }

  } catch (SQLException ex) {

        System.out.println ("SQLState: " + ex.getSQLState ());

              System.out.println ("Message:  " + ex.getMessage ());

              System.out.println ("ErrorCode:  " + ex.getErrorCode ());

          }catch (Exception e) {

  e.printStackTrace();

  }

}

}