Players.java

package fr.revivemc.data.wrapper;

import fr.revivemc.Main;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.UUID;

public class Players {

    /**
     * This function allows the player to be initialized in the table
     * @param uuid Player uuid
     */
    public static void addPlayer(UUID uuid) {
        try {
            Connection connection = Main.sql.getConnection();

            String query = "INSERT INTO players (uuid, kill, death) VALUES (?, 0, 0)";
            PreparedStatement ps = connection.prepareStatement(query);
            ps.setString(1, uuid.toString());

            ps.executeUpdate();

        } catch (SQLException e) {
            System.err.println("Error while executing SQL statement " + e.getMessage());
        }
    }

    /**
     * This function allows you to add n to the player's kills
     * @param uuid Player uuid
     * @param n Number to add
     */
    public static void setKillByUuid(UUID uuid, int n) {
        try {
            Connection connection = Main.sql.getConnection();

            String query = "UPDATE players SET kill = ? WHERE uuid = ?";
            PreparedStatement ps = connection.prepareStatement(query);
            ps.setString(1, String.valueOf(n));
            ps.setString(2, uuid.toString());

            ps.executeUpdate();

        } catch (SQLException e) {
            System.err.println("Error while executing SQL statement " + e.getMessage());
        }
    }

    /**
     * This function allows you to add n to the player's deaths
     * @param uuid Player uuid
     * @param n Number to add
     */
    public static void setDeathByUuid(UUID uuid, int n) {
        try {
            Connection connection = Main.sql.getConnection();

            String query = "UPDATE players SET death = ? WHERE uuid = ?";
            PreparedStatement ps = connection.prepareStatement(query);
            ps.setString(1, String.valueOf(n));
            ps.setString(2, uuid.toString());

            ps.executeUpdate();

        } catch (SQLException e) {
            System.err.println("Error while executing SQL statement " + e.getMessage());
        }
    }

    /**
     * Function that allows you to retrieve the number of kills in relation to the player's UUID
     * @param uuid Player uuid
     * @return Returns the correct value or 0
     */
    public static int getKillByUuid(UUID uuid) {
        int kills = 0;

        try {
            Connection connection = Main.sql.getConnection();

            String query = "SELECT kill FROM players WHERE uuid=?";
            PreparedStatement ps = connection.prepareStatement(query);
            ps.setString(1, uuid.toString());

            ResultSet row = ps.executeQuery();

            if (row.next())
                kills = row.getInt("kill");

        } catch (SQLException e) {
            System.err.println("Error while executing SQL statement " + e.getMessage());
        }

        return (kills);
    }

    /**
     * Function that allows you to retrieve the number of deaths in relation to the player's UUID
     * @param uuid Player uuid
     * @return Returns the correct value or 0
     */
    public static int getDeathByUuid(UUID uuid) {
        int deaths = 0;

        try {
            Connection connection = Main.sql.getConnection();

            String query = "SELECT death FROM players WHERE uuid=?";
            PreparedStatement ps = connection.prepareStatement(query);
            ps.setString(1, uuid.toString());

            ResultSet row = ps.executeQuery();

            if (row.next())
                deaths = row.getInt("death");

        } catch (SQLException e) {
            System.err.println("Error while executing SQL statement " + e.getMessage());
        }

        return (deaths);
    }

}