Trying to assign an array a value

I'm trying to create a list of announcements loaded from my SQL database and I have loaded them successfully without SQLExceptions, but I can't seem to add them to the String array announcements that I created. Here's my code:

Code:java

 
package me.dev.mct.Announcer;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
 
import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.plugin.java.JavaPlugin;
 
public class Announcer extends JavaPlugin {
 
public String prefix = ChatColor.GRAY + "[" + ChatColor.BLUE + "MC-Tron" + ChatColor.GRAY + "] " + ChatColor.BLUE + "";
public String[] announcements;
 
public void onEnable() {
getLogger().info("Announcer has been enabled and will connect shortly!");
try {
Database.start();
Database.query("CREATE TABLE IF NOT EXISTS announcements (string varchar(255))");
getLogger().info("Starting database... creating necessary tables...");
Bukkit.getScheduler().scheduleSyncRepeatingTask(this, new Runnable() {
public void run() {
loadAnnouncements();
}
}, 0L, 12000L);
} catch (SQLException e) {
e.printStackTrace();
}
Bukkit.getScheduler().scheduleSyncDelayedTask(this, new Runnable() {
public void run() {
startSpeaking();
}
},350L);
}
 
public void onDisable() {
getLogger().info("Announcer has been disabled!");
try {
Database.stop();
} catch (SQLException e) {
e.printStackTrace();
}
}
 
public void loadAnnouncements() {
if (Database.openConnection()) {
ResultSet rs;
int loaded = 0;
int queue = 1;
try {
rs = Database.query("SELECT * FROM announcements");
while (rs.next()) {
announcements[queue] = rs.getString("string");
queue++;
loaded++;
}
getLogger().info(loaded + " announcements were loaded from the database!");
} catch (SQLException e) {
e.printStackTrace();
}
 
}
else {
getLogger().info("Announcer could not load MC-Tron's announcements because it couldn't connect to the database!");
Bukkit.broadcast(ChatColor.RED + "Announcements failed to be loaded. No database connection.", "mct.admin");
}
}
 
public void startSpeaking() {
if (announcements.length > 0) {
 
Bukkit.getScheduler().scheduleSyncRepeatingTask(this, new Runnable() {
public void run() {
int queue = 1;
if (!(announcements.length < queue)) {
Bukkit.broadcastMessage(prefix + announcements[queue]);
queue+=1;
}
}
}, 0L, 120L);
}
else {
getLogger().info("Why are there no announcements to be read!");
Bukkit.broadcast(ChatColor.RED + "There aren't any announcements to be read! Check the list to be sure.", "mct.admin");
}
}
 
 
 
 
}
 

And there's a NullPointerException on lines 54 and 24. And another one on 71 and 32. I'm in a bit of a rush today so I may have forgotten the most silliest thing.

Bump

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

 

chris4315

Well... your result statement is null.. how can you expect to load the messages correctly from the database, then?

 

The messages are being loaded properly from the database. I debugged that and checked to be sure. I think the lines are messed up.