- Баллы
- 76
- Имя в Minecraft
- Solomka
При попытке отправить сообщения с вопросом вылезает вот это
Код:
Получение листа:
Отправка вопроса:
Код:
Caused by: java.sql.SQLException: ResultSet closed
at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:69) ~[spigot-1.12.2.jar:git-Spigot-dcd1643-e60fc34]
at org.sqlite.jdbc3.JDBC3ResultSet.findColumn(JDBC3ResultSet.java:38) ~[spigot-1.12.2.jar:git-Spigot-dcd1643-e60fc34]
at ru.solomka.helper.database.tables.utils.HandlerRequests.getAllValue(HandlerRequests.java:69) ~[?:?]
at ru.solomka.helper.database.tables.Users.getHelpersOnline(Users.java:113) ~[?:?]
at ru.solomka.helper.commands.util.methods.Question.sendQuestion(Question.java:23) ~[?:?]
at ru.solomka.helper.commands.QuestionCommand.onCommand(QuestionCommand.java:50) ~[?:?]
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) ~[spigot-1.12.2.jar:git-Spigot-dcd1643-e60fc34]
Код:
Код:
public void getAllValue(Connection connection, String compare, String target,
String dbName, String selected) throws SQLException {
String get = "SELECT " + selected + " FROM " + dbName + " WHERE " + target + " = '" + compare + "'";
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(get);
for (int i = 0; i < rs.findColumn(target); i++) {
rsList.add(rs.getString("name"));
}
}
Получение листа:
Код:
@Override
public List<String> getHelpers() throws SQLException {
rq.getAllValue(db.getConnection(), "true", "helper", db.DB_FILE, "*");
return rq.getRsList();
}
Отправка вопроса:
Код:
private final Users users = new Users(Main.getInstance());
private final ConfigManager config = new ConfigManager();
private final MessageHandler msg = new MessageHandler();
public Question() throws SQLException, ClassNotFoundException {}
public void sendQuestion(Player p, String message) throws SQLException, ClassNotFoundException {
if(users.getHelpers().size() == 0) {
p.sendMessage(translateAlternateColorCodes('&', msg.sHelpersNull()));
return;
}
if(users.isActiveQuestion(p.getName())) {
p.sendMessage(translateAlternateColorCodes('&', msg.haveActiveQuestion()));
return;
}
for(String name : users.getHelpers()) {
Bukkit.getPlayer(name).sendMessage(msg.sSendQuestionFormat(message, p));
}
users.setActiveQuestion(p.getName(), true);
new RunnableDB().start(p, config.getInt("Question.Cooldown"), RunnableType.COOLDOWN);
}