package GymApp.ClientManagementScreen;

import java.sql.*;

public class dbGetClients
{
    private static String url = "jdbc:mysql://192.185.**.***:3306/randybro_gymapp";
    private static String driverName = "com.mysql.jdbc.Driver";
    private static String username = "randybro_admin";
    private static String password = "******!";
    private static Connection con;


    public static Client[] DBClients()
    {
        Connection con;
        Statement stmt;
        ResultSet result;
        Client[] members = new Client[10];
        int memberCounter = 0;

        try
        {
            Class.forName(driverName);
            try
            {
                con = DriverManager.getConnection(url, username, password);
                stmt = con.createStatement();
                result = stmt.executeQuery("SELECT + FROM Client");


                while(result.next())
                {
                    Client member = new Client();
                    member.setClientID(result.getInt("ClientID"));
                    member.setFirstName(result.getString("FirstName"));
                    member.setLastName(result.getString("LastName"));
                    member.setPhone(result.getString("Phone"));
                    members[memberCounter] = member;
                    memberCounter++;
                }
                con.close();

            }
            catch (SQLException ex)
            {
                System.out.println("Failed to create the database connection.");
            }
        }
        catch (ClassNotFoundException ex)
        {
            System.out.println("Driver not found.");
        }
            return members;
    }
}