package com.finalelite.testes;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.logging.Level;
import java.util.logging.Logger;

// create a users class
class Users {
	private int Id;
	private String Fname;
	private String Lname;
	private int Age;

	public Users() {
	}

	public Users(int id, String fname, String lname, int age) {
		this.Id = id;
		this.Fname = fname;
		this.Lname = lname;
		this.Age = age;
	}

	public int getId() {
		return this.Id;
	}

	public String getFname() {
		return this.Fname;
	}

	public String getLname() {
		return this.Lname;
	}

	public int getAge() {
		return this.Age;
	}

	// create a tostring method to diplay data
	public String ToString() {
		return this.Id + " " + this.Fname + " " + this.Lname + " " + this.Age;
	}
}

public class Work {

	// create a method to get the connection
	public static Connection getConnection() {

		Connection con = null;

		try {
			con = DriverManager.getConnection("jdbc:mysql://localhost/batt_356?autoReconnect=true", "batt_356",
						"ddb38916fd");
		} catch (SQLException ex) {
			Logger.getLogger(Work.class.getName()).log(Level.SEVERE, null, ex);
		}

		return con;
	}

	public static void main(String[] args) {

		// create the hashmap
		HashMap<Integer, Users> map = new HashMap<Integer, Users>();

		Statement st = null;
		ResultSet rs = null;
		Connection con = getConnection();
		Users u;

		try {
			st = con.createStatement();
			rs = st.executeQuery("SELECT * FROM users");
			while (rs.next()) {
				Integer id = rs.getInt("id");
				String fname = rs.getString("fname");
				String lname = rs.getString("lname");
				int age = rs.getInt("age");

				u = new Users(id, fname, lname, age);

				// set data in the hashmap
				map.put(id, u);
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}

		// display data from the hashmap
		for (Integer i : map.keySet()) {
			Users us = map.get(i);
			System.out.println(us.getId() + " " + us.getFname() + " " + us.getLname() + " " + us.getAge());
		}

		// show data from hashmap using our ToString Method
		System.out.println("______With ToString______");
		for (Integer i : map.keySet()) {
			Users us = map.get(i);
			System.out.println(us.ToString());
		}

		// now your data are displayed from mysql database using hashmap
	}
}