package JDBC;

import java.sql.*;
import static java.lang.System.*;

public class AplicacionJDBC {

    final static String PORT = "5432";
    final static String URL = "jdbc:postgresql://localhost:" + PORT + "/";
    final static String DBNAME = "Ramiro";
    final static String DRIVER = "org.postgresql.Driver";
    final static String USERNAME = "postgres";
    final static String PASSWORD = "furer";

    static java.util.Scanner input = new java.util.Scanner(in);

    public static void main(String[] args) {
        char resp;
        do {
            try {
                Class.forName(DRIVER);
                Connection conn;
                conn = DriverManager.getConnection(URL + DBNAME, USERNAME, PASSWORD);
                if (!conn.isClosed()) {
                    out.println("Conexion con la base de datos sobre TCP/IP");
                    out.println();
                }

                Statement stmt;
                stmt = conn.createStatement();
                // String sql = "select cod,veloc,ram,pantalla,precio from Laptop";
                out.print("Ingrese consulta: ");
                String sql = input.nextLine();

                ResultSet rs;
                rs = stmt.executeQuery(sql);
                ResultSetMetaData rsmd = rs.getMetaData();

                out.println();
                out.println("Resultados:");
                out.println("-------------------------------------------------------");

                for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                // Reemplaza out.println("Cod3456\t\tVelocidad\tRam\t\tPantalla\tPrecio\t\tHD");
                    // Cabecera de la tabla
                    out.print(
                            rsmd.getColumnName(i)
                            + ((rsmd.getColumnName(i).length() > 6) ? "\t" : "\t\t")
                    );
                }
                out.println();

                // (String) getObject(i)
                while (rs.next()) {
                    String temp = "";
                    for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                        temp += rs.getObject(i).toString()
                                + ((("" + rs.getObject(i)).length() > 6) ? "\t" : "\t\t");
                    }
                    out.println(temp);
                }
//          while (rs.next()) {
//              int cod = rs.getInt("cod");
//              int veloc = rs.getInt("veloc");
//              int ram = rs.getInt("ram");
//              int pantalla = rs.getInt("pantalla");
//              int precio = rs.getInt("precio");
//              BigDecimal hd =rs.getBigDecimal("hd");
//              out.println(""+cod+"\t\t"+veloc+"\t\t"+ram+"\t\t"+pantalla+"\t\t"+precio+"\t\t"+hd);
//          }
                rs.close();
                stmt.close();
                conn.close();
            } catch (SQLException e) {
                System.err.println("Excepcion SQL: " + e.getMessage());
            } catch (ClassNotFoundException e) {
                System.err.println("Excepcion ClassNF: " + e.getMessage());
            }
            out.print("Desea realizar otra consulta? ");
            resp = (input.nextLine()).charAt(0);

        } while (Character.toUpperCase(resp) != 'N');
    }
}