public void createBooster(String player, int booster){

        try {
            PreparedStatement rs = connection.prepareStatement("INSERT INTO boosters_players(player,booster) VALUES (?,?)");
            rs.setString(1, player);
            rs.setInt(2, booster);
            rs.execute();
            rs.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public void addBooster(String player, int booster){


        try {

            int balance = (getBooster(player) + booster);

            PreparedStatement rs = connection.prepareStatement("UPDATE boosters_players SET booster = ? WHERE player = ?");
            rs.setInt(1, balance);
            rs.setString(2, player);
            rs.executeUpdate();
            rs.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public void removeBooster(String player, int booster){


        try {

            int balance = (getBooster(player) - booster);

            PreparedStatement rs = connection.prepareStatement("UPDATE boosters_players SET booster = ? WHERE player = ?");
            rs.setInt(1, balance);
            rs.setString(2, player);
            rs.executeUpdate();
            rs.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public int getBooster(String player){
        //SELECT

        try {
            PreparedStatement q = connection.prepareStatement("SELECT booster FROM boosters_players WHERE player = ?");
            q.setString(1, player);
            ResultSet resultat = q.executeQuery();

            int coins = 0;
            while(resultat.next()){
                coins = resultat.getInt("booster");

            }


            q.close();
            return coins;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return 0;
    }

    public boolean hasBooster(String player){

        try {
            PreparedStatement q = connection.prepareStatement("SELECT player FROM boosters_players WHERE player = ?");
            q.setString(1, player);
            ResultSet resultat = q.executeQuery();
            boolean hasCoins = resultat.next();
            q.close();
            return hasCoins;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return false;

    }