Database.java

package com.slprojects.slcraftplugin.utils;

import com.slprojects.slcraftplugin.models.UserSetting;
import com.slprojects.slcraftplugin.utils.database.Configuration;
import net.luckperms.api.model.user.User;
import org.bjloquent.Connector;
import org.bjloquent.Model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

@SuppressWarnings("UnusedReturnValue")
public class Database {
    static final private String userSettingsTabName = "site_userSetting";
    static Connection connection = null;
    static Connector jLoquentConnector = null;

    /**
     * Récupère une valeur dans la table site_userSetting
     *
     * @param uuid UUID du joueur
     * @param key  Nom de la clé
     * @return Valeur de la clé
     */
    public static String getUserSetting(String uuid, String key) {
        List<UserSetting> settings = Model.where(
                UserSetting.class,
                new String[]{"uuid", "name"},
                new String[]{"=", "="},
                new String[]{uuid, key}
        );

        if (settings.size() != 1) {
            return null;
        }

        return (settings.get(0)).getValue();
    }

    /**
     * Ajoute ou modifie une valeur dans la table site_userSetting
     *
     * @param uuid  UUID du joueur
     * @param key   Nom de la clé
     * @param value Valeur de la clé
     */
    public static void setUserSetting(String uuid, String key, String value) {
        List<UserSetting> userSettingExists = Model.where(
                UserSetting.class,
                new String[]{"uuid", "name"},
                new String[]{"=", "="},
                new String[]{uuid, key}
        );

        if (userSettingExists.size() == 0) {
            UserSetting userSetting = new UserSetting();
            userSetting.setUuid(uuid);
            userSetting.setName(key);
            userSetting.setValue(value);
            userSetting.create();
        } else {
            UserSetting userSetting = userSettingExists.get(0);
            userSetting.setValue(value);
            userSetting.save();
        }
    }

    /**