java-使用MySQL和PreparedStatement的NullPointerException和参数索引超出范围异常

使用MySQL时出现此错误,无法弄清楚如何解决.自从我从Connection.execute [whatever]()切换到PreparedStatement以来,我一直在收到此错误,但似乎无法修复.

空指针异常:

guild info space
[09:51:56 WARN]: java.lang.NullPointerException
[09:51:56 WARN]:    at net.aspace.guilds.Guild.getGuild(Guild.java:56)
[09:51:56 WARN]:    at net.aspace.guilds.command.GuildsInfoCommand.execute(GuildsInfoCommand.java:28)
[09:51:56 WARN]:    at net.aspace.command.CommandNode.onCommand(CommandNode.java:64)
[09:51:56 WARN]:    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[09:51:56 WARN]:    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:140)
[09:51:56 WARN]:    at org.bukkit.craftbukkit.v1_10_R1.CraftServer.dispatchCommand(CraftServer.java:646)
[09:51:56 WARN]:    at org.bukkit.craftbukkit.v1_10_R1.CraftServer.dispatchServerCommand(CraftServer.java:632)
[09:51:56 WARN]:    at net.minecraft.server.v1_10_R1.DedicatedServer.aL(DedicatedServer.java:438)
[09:51:56 WARN]:    at net.minecraft.server.v1_10_R1.DedicatedServer.D(DedicatedServer.java:401)
[09:51:56 WARN]:    at net.minecraft.server.v1_10_R1.MinecraftServer.C(MinecraftServer.java:668)
[09:51:56 WARN]:    at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:567)
[09:51:56 WARN]:    at java.lang.Thread.run(Thread.java:745)
[09:51:56 INFO]: Guild space does not exist!

参数索引超出范围异常:

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
[11:11:37 WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
[11:11:37 WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
[11:11:37 WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
[11:11:37 WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
[11:11:37 WARN]:    at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3321)
[11:11:37 WARN]:    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3306)
[11:11:37 WARN]:    at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4021)
[11:11:37 WARN]:    at net.aspace.guilds.Guild.getGuild(Guild.java:57)
[11:11:37 WARN]:    at net.aspace.guilds.command.GuildsInfoCommand.execute(GuildsInfoCommand.java:28)

这是公会类:

package net.aspace.guilds;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Logger;

import net.aspace.chat.Message;
import net.aspace.guilds.GuildsPlugin;
import net.aspace.guilds.util.MySQL;
import net.aspace.util.SimpleCallback;

import org.bukkit.entity.Player;
import org.bukkit.plugin.Plugin;
import org.bukkit.scheduler.BukkitRunnable;
import org.bukkit.scheduler.BukkitTask;

public class Guild {

    public String name;
    public List<String> members;
    public int maxPlayers = 3;

    public Guild(String name) {
    }

    public Guild(String name, List<String> members, int maxPlayers) {
        this.name = name;
        this.members = members;
        this.maxPlayers = maxPlayers;
    }

    public void addPlayer(final Player p) {
        final String gName = this.name;
        new BukkitRunnable() {

            public void run() {
                try {
                    PreparedStatement ps = MySQL.getConnection()
                            .prepareStatement("UPDATE PlayerData SET GUILD='?' WHERE PLAYERNAME='?'");
                    ps.setString(1, gName);
                    ps.setString(2, p.getName());
                    ps.executeUpdate();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }.runTaskAsynchronously((Plugin) GuildsPlugin.getInstance());
    }

    public static void getGuild(final String name, final SimpleCallback<Guild> callback) {
        try {
            PreparedStatement ps = MySQL.getConnection().prepareStatement("SELECT * FROM Guilds WHERE GUILD_NAME='?'");
            ps.setString(1, name);
            ArrayList<String> players = new ArrayList<String>();

            ResultSet set = ps.executeQuery();
            if (set.next()) {
                String gName = set.getString("GUILD_NAME");
                int maxMembers = set.getInt("MAX_MEMBERS");
                try {
                    PreparedStatement ps2 = MySQL.getConnection()
                            .prepareStatement("SELECT * FROM PlayerData WHERE GUILD = '?'");
                    ps2.setString(1, name);
                    ResultSet result = ps2.executeQuery();
                    GuildsPlugin.getInstance().getLogger().info("select");
                    while (result.next()) {
                        players.add(result.getString("PLAYERNAME"));
                    }
                    result.close();
                    callback.execute(new Guild(gName, players, maxMembers));
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                set.close();

            }
        } catch (SQLException e) {
            e.printStackTrace();
            callback.execute(null);
        } catch (NullPointerException e) {
            e.printStackTrace();
            callback.execute(null);
        }
    }

    public static void createGuild(final Player p, final String name) {
        new BukkitRunnable() {

            @Override
            public void run() {
                try {
                PreparedStatement ps = MySQL.getConnection().prepareStatement("SELECT * FROM PlayerData WHERE PLAYER_NAME = '?'");
                ps.setString(1,p.getName());



                    //Get player data
                    ResultSet result = ps.executeQuery();
                    if (result.first()) {
                        //Check if player is in a guild
                        if (result.getString("GUILD") == null) {
                            // TODO Check if guild exists
                            try {
                                //Add guild
                                PreparedStatement ps2 = MySQL.getConnection().prepareStatement("INSERT INTO Guilds (GUILD_NAME,MAX_MEMBERS) VALUES ('?',10)");
                                ps2.setString(1,name);
                                ps2.executeUpdate();
                                //Add player to guild
                                PreparedStatement ps3 = MySQL.getConnection().prepareStatement("UPDATE PlayerData SET GUILD='?'"
                                        + "WHERE PLAYER_NAME='?'");
                                ps3.setString(1,name);
                                ps3.setString(2,p.getName());
                                p.sendMessage(Message.fromString(String.format("&eYou have created and joined the guild &b%s&e!",name)));
                            } catch (SQLException e) {
                                e.printStackTrace();
                            }
                        } else {
                            //Player is in a guild
                            p.sendMessage(Message.fromString("&cYou are already in a guild!"));
                        }
                    }
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        }.runTaskAsynchronously(GuildsPlugin.getInstance());
    }

}

这是GuildInfoCommand类:

package net.aspace.guilds.command;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.plugin.Plugin;

import net.aspace.chat.Message;
import net.aspace.command.CommandNode;
import net.aspace.guilds.Guild;
import net.aspace.guilds.GuildsPlugin;
import net.aspace.guilds.util.GuildsPlayer;
import net.aspace.util.SimpleCallback;

public class GuildsInfoCommand<E extends Plugin> extends CommandNode<E> {

    public GuildsInfoCommand(E plugin) {
        super(plugin);
        // TODO Auto-generated constructor stub
    }

    @Override
    public boolean execute(CommandSender sender, String... args) {
        if (args.length >= 1) {
            Guild.getGuild(args[0], new SimpleCallback<Guild>() {

                @Override
                public void execute(Guild guild) {
                    if (guild != null) {

                        sender.sendMessage(Message.fromString("&b&lGUILD INFO"));
                        sender.sendMessage(Message.fromString("&eGuild name: " + guild.name));
                        sender.sendMessage(Message.fromString("&eGuild maxmembers: " + guild.maxPlayers));
                        sender.sendMessage(
                                Message.fromString("&eGuild members &7(" + Integer.toString(guild.members.size()) + "/"
                                        + Integer.toString(guild.maxPlayers) + ")&e: "));
                        guild.members.forEach(s -> {
                            sender.sendMessage(Message.fromString("&7- " + s));
                        });
                        sender.sendMessage(Message.fromString("&b&lGUILD INFO"));

                    } else {
                        sender.sendMessage(Message.fromString(String.format("&cGuild &e%s&c does not exist!", args[0])));
                    }

                }
            });

        } else {
            if (sender instanceof Player) {
                Player player = (Player) sender;
                GuildsPlayer player2 = GuildsPlayer.getPlayer(player);
                player2.inGuild(new SimpleCallback<Boolean>() {

                    @Override
                    public void execute(Boolean response) {
                        if (response) {
                            Guild.getGuild(args[0], new SimpleCallback<Guild>() {

                                @Override
                                public void execute(Guild guild) {
                                    if (guild != null) {
                                        sender.sendMessage(Message.fromString("&b&lGUILD INFO"));
                                        sender.sendMessage(Message.fromString("&eGuild name: &b" + guild.name));
                                        sender.sendMessage(Message.fromString("&eMember Limit: &b" + guild.maxPlayers));
                                        sender.sendMessage(Message.fromString(
                                                "&eGuild members &7(" + Integer.toString(guild.members.size()) + "/"
                                                        + Integer.toString(guild.maxPlayers) + ")&e: "));
                                        guild.members.forEach(s -> {
                                            sender.sendMessage(Message.fromString("&7- " + s));
                                        });
                                        sender.sendMessage(Message.fromString("&b&lGUILD INFO"));

                                    } else {
                                        sender.sendMessage(Message.fromString("&cYou are not in a guild!"));
                                    }
                                }

                            });
                        } else {

                        }
                    }
                });
            } else {
                sender.sendMessage(Message.fromString("&cYou must specify a guild name!"));
            }
        }

        return true;
    }

    @Override
    public String getName() {
        // TODO Auto-generated method stub
        return "info";
    }

}

MySQL类的代码:

package net.aspace.guilds.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.bukkit.Bukkit;
import org.bukkit.command.ConsoleCommandSender;

public class MySQL {

    public static String host = "****";
    public static String port = "****";
    public static String database = "****";
    public static String username = "****";
    public static String password = "****";
    public static Connection con;

    static ConsoleCommandSender console = Bukkit.getConsoleSender();

    // connect
    public static void connect() {
        if (!isConnected()) {
            try {
                con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
                console.sendMessage("\247c[\2476Minepedia-System\247c] \247bMySQL-Verbindung wurde aufgebaut!");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    // disconnect
    public static void disconnect() {
        if (isConnected()) {
            try {
                con.close();
                console.sendMessage("\247c[\2476Minepedia-System\247c]\247bMySQL-Verbindung wurde geschlossen!");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    // isConnected
    public static boolean isConnected() {
        return (con == null ? false : true);
    }

    // getConnection
    public static Connection getConnection() {
        return con;
    }
}

解决方法:

在尝试调用MySQL.getConnection()之前,需要调用MySQL.connect()方法.

当您在不使用MySQL.connect()方法的情况下调用MySQL.getConnection()方法时,您不会创建连接,因此尝试调用MySQL.getConnection().prepareStatement时会得到NullPointerException …

您需要删除’字符,因为SQL解析器会像字符串值一样解释它们并忽略占位符?.

例如:

PreparedStatement ps = 
    MySQL.getConnection().prepareStatement("SELECT * FROM Guilds WHERE GUILD_NAME=?");
上一篇:Java-Bukkit ConfigurationSection getKeys


下一篇:java-我在第一次运行中创建的属性文件在第二次运行中被屏蔽