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

public class Coneccion {
    //database URL
    static final String DATABASE_URL= "jdbc:mysql://localhost/books";
    //launch the application

    public static void main(String[] args) {
    Connection connection = null;
    Statement statement= null;
    ResultSet resultSet= null;

    //conectar a la base de datos books y query
    try{
    connection = DriverManager.getConnection(DATABASE_URL,"deitel","deitel");
    statement= connection.createStatement();
    resultSet=statement.executeQuery("SELECT AuthorID, FirstName,LastName FROM Authors");
    ResultSetMetaData metaData= resultSet.getMetaData();
    int numerOfColumns = metaData.getColumnCount();
        System.out.println("Authors Table of Books Database: \n");
        for(int i=1; i<=numerOfColumns;i++)
            System.out.printf("%-8s\t", metaData.getColumnName(i));
        System.out.println();
        while(resultSet.next()){
            for(int i=1; i<=numerOfColumns;i++)
                System.out.printf("%-8s\t",resultSet.getObject(i));
            System.out.println();

        }

    }
    catch (SQLException sqlException){
    sqlException.printStackTrace();
    }
    finally {
    try{
    resultSet.close();
    statement.close();
    connection.close();
    }
    catch(Exception exception){
    exception.printStackTrace();
    }//fin catch
    }//end finally
    }

}