ResultApp

import java.sql.*;

import java.util.*;

class ResultApp {

  public static void main(String args[]) {

  try {

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

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

      Connection con = DriverManager.getConnection

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

        Statement statement = con.createStatement();

      String sql = "SELECT * FROM student";

      ResultSet rs = statement.executeQuery(sql);

ResultSetMetaData rmeta = rs.getMetaData();

int su =  rmeta.getColumnCount();

  System.out.println("컬럼수 : "+ su);

System.out.println("======================================");

for (int i = 1; i <= su; i++) {

System.out.println("타입 : "+ rmeta.getColumnTypeName(i));

System.out.println("명칭 : "+ rmeta.getColumnName(i));

switch (rmeta.isNullable(i)) {

  case 0 : System.out.println("null 할당여부 :  columnNoNulls");

              break;

case 1 : System.out.println("null 할당여부 :  columnNullable");

              break;

case 2 : System.out.println("null 할당여부 :  columnNullableUnknown");

}                

System.out.println("======================================");

}

con.close();

  } catch(Exception ex) {

      System.out.println("오류발생 : " + ex);

        }

  }

}