import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class EmployeeDetails{
    public static void main(String[] args) {

        System.out.println("Getting Employee Details Using resultset metadata: ");
        Connection con = null;
        String url = "jdbc:oracle:thin:@172.24.137.30:1521:ORA10G";;

        String driver = "oracle.jdbc.driver.OracleDriver";
        String user = "e206227";
        String pass = "VeuFmodax";
        try{
            Class.forName(driver);
            con = DriverManager.getConnection(url, user, pass);
            try{
                Statement st = con.createStatement();
                ResultSet rs = st.executeQuery("SELECT * FROM employee");
                ResultSetMetaData md = rs.getMetaData();
                while(rs.next())
                {
                    System.out.print("\t"+rs.getString(1));
                    System.out.print("\t"+rs.getString(2));
                    System.out.print("\t"+rs.getString(3));
                    System.out.print("\t"+rs.getString(4));
                    System.out.println("\t"+rs.getString(5));
                }


//              String tableName= md.getTableName(1);
                System.out.println("Table name: "+md.getTableName(5));


                int col = md.getColumnCount();
                System.out.println("Number of Column : "+ col);
                System.out.println("Columns Name: ");
                for (int i = 1; i <= col; i++){
                    String col_name = md.getColumnName(i);

                    System.out.println("\n'"+col_name+"' column properties ");
                    System.out.println("\t max column size: "+md.getColumnDisplaySize(i));
                    System.out.println("\t column type name: "+md.getColumnTypeName(i));
//                  System.out.println("\t catalog name: "+md.getCatalogName(i));
//                  System.out.println("\t Schema name: "+md.getSchemaName(i));
//                  System.out.println("\t Table name: "+md.getTableName(i));
//                  System.out.println("\t catalog name: "+md.getClass());
                    System.out.println("\t is Nullable: "+md.isNullable(i));
                    System.out.println("\t is Currency: "+md.isCurrency(i));
                    System.out.println("\t is Auto increment: "+md.isAutoIncrement(i));
                    System.out.println("\t is case sensitive: "+md.isCaseSensitive(i));
                    System.out.println("\t is Searchable: "+md.isSearchable(i));
                    System.out.println("\t is Writable: "+md.isWritable(i));
                    System.out.println("\t is Signed: "+md.isSigned(i));
                    System.out.println("\t is Read only: "+md.isReadOnly(i));

                }
            }
            catch (SQLException s){
                System.out.println("SQL statement is not executed!");
            }
        }
        catch (Exception e){
            e.printStackTrace();
        }
    }
}