MySQL - Parameter index out of range!?

Hi all,

Today i started to make a global exp points system that I can use on my server so I don't have to write it in every plugin that needs an exp points shop. But now I'm facing some problems, and I can't figure it out :l So Now I come here to ask for help

This is my server log:

This is my MySQL class:

Code:java

package MySQL;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
import org.bukkit.Bukkit;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerLoginEvent;
import org.bukkit.plugin.Plugin;
 
public class MySQL implements Listener {
 
    //By dutch_kids/GonnaKillYou2 Aka bennie3211
 
    public static String databaseName;
    public static String dbTableName;
    public static String Ip;
    public static String Port;
    public static String userName;
    public static String password;
    public static Connection connection;
 
    public MySQL(String ip, String port, String user, String pass, String dbName, String tableName) {
        userName = user;
        password = pass;
        Port = port;
        Ip = ip;
        databaseName = dbName;
        dbTableName = tableName;
 
        connect();
 
        if (connection == null) {
 
            System.out.println("[ExpPoints] No connection could be made to the MySQL database. Plugin disabled!");
 
            Plugin plugin = Bukkit.getServer().getPluginManager().getPlugin("ExpPoints");
 
            if (plugin != null) {
                plugin.getServer().getPluginManager().disablePlugin(plugin);
            }
 
            return;
        }
 
        disconnect();
        System.out.println("[ExpPoints] Could successfully connect to database while testing the connection!");
    }
 
    public MySQL() {
    }
 
    public static void connect() {
 
        try {
            connection = DriverManager.getConnection("jdbc:mysql://" + Ip
                    + ":" + Port + "/" + databaseName, userName, password);           
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 
    public static void disconnect() {
 
        try {
            if (connection != null) {
                connection.close();
                connection = null;
            }
 
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    public synchronized static boolean databaseContainsPlayer(Player pl) {
        try {
 
            if (connection == null || connection.isClosed()) {
                connect();
            }
 
            PreparedStatement ps = connection.prepareStatement("Select * FROM `data` WHERE UUID = ?;");
 
            ps.setString(1, pl.getUniqueId().toString());
 
            ResultSet result = ps.executeQuery();
            Boolean bool = result.next();
 
            ps.close();
            result.close();
 
            System.out.println("[ExpPoints] Database contains player " + pl.getName() + ".");
 
            return bool;
 
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        } finally {
            disconnect();
        }
    }
 
    public synchronized static void addPlayerToDatabase(Player pl) {
 
        try {
 
            if (connection == null || connection.isClosed()) {
                connect();
            }
 
            PreparedStatement ps = connection.prepareStatement("INSERT INTO `" + dbTableName + "` values(?, ?);");
 
            ps.setString(1, pl.getUniqueId().toString());
            ps.setInt(2, 0);
 
            ps.execute();
            ps.close();
 
            System.out.println("[ExpPoints] Adding player " + pl.getName() + " to the database.");
 
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            disconnect();
        }
    }
 
    public synchronized static void giveExpPoints(Player pl, Integer i) {
 
        try {
 
            if (!databaseContainsPlayer(pl)) {
                addPlayerToDatabase(pl);
            }
 
            if (connection == null || connection.isClosed()) {
                connect();
            }
 
            int previousExp = 0;
 
            PreparedStatement ps = connection.prepareStatement("SELECT Exp FROM '" + dbTableName + "` WHERE UUID = ?;");
 
            ps.setString(1, pl.getUniqueId().toString());
 
            ResultSet result = ps.executeQuery();
            result.next();
 
            previousExp = result.getInt("Exp");
 
            PreparedStatement update = connection.prepareStatement("UPDATE `" + dbTableName + "` SET Exp = ? WHERE UUID = ?;");
 
            update.setInt(1, Integer.valueOf(previousExp + i));
            update.setString(2, pl.getUniqueId().toString());
            update.executeUpdate();
 
            ps.close();
            result.close();
            update.close();
 
            System.out.println("[ExpPoints] Adding " + i + " ExpPoints to player " + pl.getName() + ".");
 
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            disconnect();
        }
    }
 
    public synchronized static int getExpPoints(Player pl) {
 
        try {
 
            if (!databaseContainsPlayer(pl)) {
                addPlayerToDatabase(pl);
            }
 
            if (connection == null || connection.isClosed()) {
                connect();
            }
 
            PreparedStatement ps = connection.prepareStatement("SELECT Exp FROM `" + dbTableName + "` WHERE UUID = ?;");
 
            ps.setString(1, pl.getUniqueId().toString());
 
            ResultSet result = ps.executeQuery();
            result.next();
            Integer total = result.getInt("Exp");
 
            ps.close();
            result.close();
 
            System.out.println("[ExpPoints] Player " + pl.getName() + " has an amount of " + total + " ExpPoints.");
 
            return total;
 
        } catch (Exception e) {
            e.printStackTrace();
            return -1;
        } finally {
            disconnect();
        }
    }
 
    public synchronized static boolean checkExp(Player pl, Integer i) {
 
        Integer exp = getExpPoints(pl);
 
        if (exp >= i) {
            return true;
        }
 
        return false;
    }
 
    public synchronized static void takeExp(Player pl, Integer i) {
 
        try {
 
            if (!databaseContainsPlayer(pl)) {
                addPlayerToDatabase(pl);
            }
 
            if (connection == null || connection.isClosed()) {
                connect();
            }
 
            Integer totalExp = 0;
 
            PreparedStatement ps = connection.prepareStatement("SELECT Exp FROM `" + dbTableName + "` WHERE UUID = ?;");
 
            ps.setString(1, pl.getUniqueId().toString());
            ResultSet result = ps.executeQuery();
 
            result.next();
 
            totalExp = result.getInt("Exp");
 
            totalExp -= i;
 
            if (totalExp < 0) {
                totalExp = 0;
            }
 
            PreparedStatement update = connection.prepareStatement("UPDATE `" + dbTableName + "` SET Exp = ? WHERE UUID = ?;");
 
            update.setInt(1, Integer.valueOf(totalExp));
            update.setString(2, pl.getUniqueId().toString());
            update.executeQuery();
 
            ps.close();
            result.close();
            update.close();
 
            System.out.println("[ExpPoints] Player " + pl.getName() + " was taken " + i + " ExpPoints.");
 
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            disconnect();
        }
    }
 
    public static synchronized boolean transferExpFromP2P(Player p1, Player p2, Integer i) {
 
        if (p1 == null || p2 == null || i == 0) {
            return false;
        }
 
        if (!checkExp(p1, i)) {
            return false;
        }
 
        try {
            takeExp(p1, i);
            giveExpPoints(p2, i);
            return true;
 
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
    }
 
    @EventHandler
    public void onRegisterPlayerInDatabase(PlayerLoginEvent event) {
 
        Player pl = event.getPlayer();
 
        if (!databaseContainsPlayer(pl)) {
            addPlayerToDatabase(pl);
        }
    }
}

And this is how I'm calling the methods (on command):

Code:java

package Commands;
 
import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
 
import MySQL.MySQL;
 
public class GiveExpCommand implements CommandExecutor {
 
    @SuppressWarnings("deprecation")
    @Override
    public boolean onCommand(CommandSender sender, Command command, String Label, String[] args) {
 
 
        if (args.length == 2) {
 
            Player pl = Bukkit.getPlayer(args[0]);
 
            if (pl == null) {
 
                sender.sendMessage(ChatColor.GREEN + "[Exp] " + ChatColor.RED + " Player is offline or doesn't exists!");
                return false;
            }
 
            try {
 
                Integer.parseInt(args[1]);
            } catch (NumberFormatException e) {
 
                sender.sendMessage(ChatColor.GREEN + "[Exp] " + ChatColor.RED + " No integer given.");
                return false;
            }
 
            Integer ExpPointsToGive = Integer.parseInt(args[1]);
 
            MySQL.giveExpPoints(pl, ExpPointsToGive);
            return true;
        }
 
        sender.sendMessage(ChatColor.GREEN + "[Exp] " + ChatColor.RED + "No arguments given!");
        return false;
    }
}

So does anyone see what I'm doing wrong? I don't see it anyways xD I've looked at it for couple of hours. So if anyone can tell me whats wrong please tell me

PS: I don't know if you need to know this, but the first time I executed the command, it was done in game, the second time through console.

PSS: Yes, The database and tables and other kind of stuff are working 100%, because adding the player and checking if the player is inside the database works

Up

EDIT by Moderator: merged posts, please use the edit button instead of double posting.