package com.company;

import java.sql.*;
import java.util.ArrayList;


public class Main {

    static final String DATABASE_URL = "jdbc:mysql://zutch.net/ai?autoReconnect=true&useSSL=false";

    public static void main(String[] args) {
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        String username="pi";
        String password="go";

        String sqlStatement = "select * from employees";
        ArrayList<Employee> employees=new ArrayList<Employee>();
        try {
            connection = DriverManager.getConnection(DATABASE_URL, username, password);

           statement = connection.prepareStatement(sqlStatement);
          // statement.setString(1, "M");
          // statement.setString(2, "X%");
          //  statement.setString(3, "Z%");

            resultSet =statement.executeQuery();

            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();

           for (int i = 1; i <= numberOfColumns; i++) {
               System.out.printf("%-12s\t", metaData.getColumnName(i));


           }

            System.out.println();

            while (resultSet.next()) {
                for (int i = 1; i <= numberOfColumns; i++) {
                    System.out.printf("%-12s\t", resultSet.getObject(i));

                }
                System.out.println();
            }
            while(resultSet.next())
                for(int i=1;i<=numberOfColumns/6;i++)
                    employees.add(new Employee(resultSet.getObject("first_name").toString(), resultSet.getObject("last_name").toString()));

            System.out.println("done printing now testing arraylist");
            for(int i=0;i<employees.size();i++)
                System.out.println(employees.get(i));
        } catch (SQLException SE) {
            SE.printStackTrace();
            System.out.println(SE.toString());
        } finally {
            try {
             resultSet.close();
              statement.close();
                connection.close();
            } catch (SQLException E) {
                E.printStackTrace();
            }
        }
    }
}