Solved MySQL Error

Discussion in 'Plugin Development' started by CactusComboPvP, Mar 8, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    CactusComboPvP

    So I did this command:

    Code:
     @Override
        public boolean onCommand(CommandSender sender, Command cmd, String str, String[] args) {
            if(cmd.getName().equalsIgnoreCase("stats")) {
                Player p = (Player)sender;
                int amountofLogins = 0;
                try {
                    PreparedStatement statement = connection.prepareStatement("SELECT playerKills FROM `player_data` WHERE playerName='" + p.getName() + "'");
                    ResultSet result = statement.executeQuery();
                  
                    if (result.next()) {
                         amountofLogins = result.getInt("playerKills");
                    }
            } catch (Exception e) {
                    e.printStackTrace();
            }
                p.sendMessage("You got " + amountofLogins);
               
            }
            return false;
        }
    but it gives me this error:

    Code:
    [18:32:32 INFO]: MineplexMOD issued server command: /stats
    [18:32:32 WARN]: java.lang.NullPointerException
    [18:32:32 WARN]:        at io.github.cactuscombo.Main.onCommand(Main.java:109)
    [18:32:32 WARN]:        at org.bukkit.command.PluginCommand.execute(PluginComman
    d.java:44)
    [18:32:32 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
    mmandMap.java:181)
    [18:32:32 WARN]:        at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCo
    mmand(CraftServer.java:767)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.PlayerConnection.handleC
    ommand(PlayerConnection.java:1043)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.PlayerConnection.a(Playe
    rConnection.java:880)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.PacketPlayInChat.a(Packe
    tPlayInChat.java:28)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.PacketPlayInChat.handle(
    PacketPlayInChat.java:65)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.NetworkManager.a(Network
    Manager.java:186)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.ServerConnection.c(Serve
    rConnection.java:81)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.v(Minecr
    aftServer.java:734)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.DedicatedServer.v(Dedica
    tedServer.java:289)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.u(Minecr
    aftServer.java:584)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.run(Mine
    craftServer.java:490)
    [18:32:32 WARN]:        at net.minecraft.server.v1_7_R4.ThreadServerApplication.
    run(SourceFile:628)
    Line Main:109:

    Code:
    PreparedStatement statement = connection.prepareStatement("SELECT playerKills FROM `player_data` WHERE playerName='" + p.getName() + "'");
    and everytime i do /stats and says 0 with that error, however I have more than 0.

    [​IMG]

    Solved - I forgot to open the actual connection :p

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 10, 2016
Thread Status:
Not open for further replies.

Share This Page