package Cas3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Scanner;

public class MetaTest {

    private final static String CONN_STRING = "jdbc:oracle:thin:@nastava.is.pmf.uns.ac.rs:1521:xe";

    public static void main(String[] args) {

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

            Scanner sc = new Scanner(System.in);
            System.out.println("SQL upit:");
            String query = sc.nextLine();

            try (Connection conn = DriverManager.getConnection(CONN_STRING, "baze2", "baze2")){

                Statement stmt = conn.createStatement();

                ResultSet rs = stmt.executeQuery(query);

                ResultSetMetaData meta = rs.getMetaData();

                System.out.println("Broj kolona je: " + meta.getColumnCount());
                for(int i = 0; i < meta.getColumnCount(); i++) {
                    System.out.print(meta.getColumnName(i+1) + "["+meta.getColumnTypeName(i+1)+"] ");
                }

                while(rs.next()) {
                    for(int i = 0; i < meta.getColumnCount(); i++) {
                        if(meta.getColumnTypeName(i+1).equals("NUMBER")) {
                            System.out.print(rs.getInt(i+1)+" | ");
                        } else if(meta.getColumnTypeName(i+1).equals("VARCHAR2")) {
                            System.out.print(rs.getString(i+1)+" | ");
                        } else if(meta.getColumnTypeName(i+1).equals("DATE")) {
                            System.out.print(rs.getDate(i+1)+" | ");
                        }
                    }
                    System.out.println();
                }

            } catch (Exception e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
        }

    }

}