CreditsAPI.java

package me.WingedMLGPro.API;

import java.sql.ResultSet;
import org.bukkit.Bukkit;
import org.bukkit.entity.Player;

public class CreditsAPI
{
    public Integer getCredits(Player p)
    {
        ResultSet rs = MySQL.getResult("SELECT Credits FROM SwiftyCreditsTest WHERE UUID='" + p.getDisplayName() + "'");
        try {
            if (rs.next()) {
                return rs.getInt("Credits");
            }
            return null;
        } catch (Exception e) {
            Bukkit.getLogger().severe("Could not load Credits!");
        }
        return 0;
    }
    public void setCredits(Player p, int credits) {
        if (getCredits(p) == null) {
            MySQL.update("INSERT INTO `SwiftyCreditsTest`(`UUID`, `PlayerName`, `Credits`) VALUES ('" + p.getUniqueId() + "','" + p.getName() + "','" + credits + "')");
        }
        else if (getCredits(p) != null) {
            MySQL.update("UPDATE `SwiftyCreditsTest` SET `UUID`='" + p.getUniqueId() + "',`PlayerName`='" + p.getName() + "',`Credits`='" + credits + "' WHERE uuid='" + p.getUniqueId() + "'");
        }
    }

    public void addCredits(Player p, int amount) {
        if (getCredits(p) == null) {
            setCredits(p, amount);
        }
        else {
            int num = getCredits(p) + amount;
            MySQL.update("UPDATE `SwiftyCredits` SET `UUID`='" + p.getUniqueId() + "',`PlayerName`='" + p.getName() + "',`Credits`='" + num + "' WHERE uuid='" + p.getUniqueId() + "'");
        }
    }
}