import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Database {
    private Connection connection;
    private String url;
    private static Database instance;

    // Database gegevens
    private static String HOST = "localhost";
    private static String PORT = "3306"; // standaard 3306
    private static String DB = "maffiato_db";
    private static String USER = "maffiato";
    private static String PASSWORD = "dDpRamaS^e(N";

    private Database() {
        connection = null;

        // url = "jdbc:mysql://145.76.18.71/s147614?user=s147614&password=avrx";
        url = "jdbc:mysql://" + HOST + ":" + PORT + "/" + DB;

    }

    public static Database getInstance() {
        if (instance == null) {
            return instance = new Database();
        }
        return instance;
    }

    public void setPlayerTime(String player, double time, int circuitNr) {
        maakVerbinding();

        PreparedStatement stmt = null;
        String query = "INSERT INTO straatrace (naam, tijd, circuit) VALUES (?,?,?)";

        try {
            if (connection != null) {
                stmt = connection.prepareStatement(query);

                stmt.setString(1, player);
                stmt.setDouble(2, time);
                stmt.setInt(3, circuitNr);

                stmt.executeUpdate();
            }
        } catch (SQLException e) {
            System.out.println("Er gaat iets niet helemaal goed..");
            e.printStackTrace();
        }

        close(stmt);
        close(connection);

    }

    public void maakVerbinding() {

        // Laad eerst de driver.
        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Laden van de driver is gelukt.");
        } catch (ClassNotFoundException e) {
            System.err.println("Kan de driver niet in de classpath vinden.");
            return;
        }

        try {
            // Verkrijg de connectie.
            connection = DriverManager.getConnection(url, USER, PASSWORD);
            System.out.println("Verbinding gemaakt!");

        } catch (SQLException e) {
            System.out.println(connection);
            System.err
                    .println("Kan geen verbinding maken met de database! Controleer alles nog eens!");
        }

    }

    public Connection getConnection() {
        return connection;
    }

    public void close(Connection connection) {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                // Niks aan te doen.
                System.err.println("Kan de connectie niet sluiten.");
                e.printStackTrace();
            }
        }
    }

    public void close(Statement statement) {
        if (statement != null) {
            try {
                statement.close();
            } catch (SQLException e) {
                // Niks aan te doen.
                System.err.println("Kan de statement niet sluiten.");
                e.printStackTrace();
            }
        }
    }

    public void close(ResultSet resultSet) {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
                // Niks aan te doen.
                System.err.println("Kan de resultset niet sluiten.");
                e.printStackTrace();
            }
        }
    }
}