Solved NullPointer Help

im getting this error

Code:

01:11:08 [INFO] IcyRelic issued server command: /unban test
01:11:08 [SEVERE] null
org.bukkit.command.CommandException: Unhandled exception executing command 'unba
n' in plugin LegendaryBans v1.0
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:46)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:18
9)
        at org.bukkit.craftbukkit.v1_6_R2.CraftServer.dispatchCommand(CraftServe
r.java:523)
        at net.minecraft.server.v1_6_R2.PlayerConnection.handleCommand(PlayerCon
nection.java:964)
        at net.minecraft.server.v1_6_R2.PlayerConnection.chat(PlayerConnection.j
ava:882)
        at net.minecraft.server.v1_6_R2.PlayerConnection.a(PlayerConnection.java
:839)
        at net.minecraft.server.v1_6_R2.Packet3Chat.handle(SourceFile:49)
        at net.minecraft.server.v1_6_R2.NetworkManager.b(NetworkManager.java:296
)
        at net.minecraft.server.v1_6_R2.PlayerConnection.e(PlayerConnection.java
:118)
        at net.minecraft.server.v1_6_R2.ServerConnection.b(SourceFile:37)
        at net.minecraft.server.v1_6_R2.DedicatedServerConnection.b(SourceFile:3
0)
        at net.minecraft.server.v1_6_R2.MinecraftServer.t(MinecraftServer.java:5
90)
        at net.minecraft.server.v1_6_R2.DedicatedServer.t(DedicatedServer.java:2
26)
        at net.minecraft.server.v1_6_R2.MinecraftServer.s(MinecraftServer.java:4
86)
        at net.minecraft.server.v1_6_R2.MinecraftServer.run(MinecraftServer.java
:419)
        at net.minecraft.server.v1_6_R2.ThreadServerApplication.run(SourceFile:5
82)
Caused by: java.lang.NullPointerException
        at me.icyrelic.com.Data.LBMySQL.checkBan(LBMySQL.java:170)
        at me.icyrelic.com.Commands.unban.onCommand(unban.java:34)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
        ... 15 more
>

LBMySQL.java:170

Code:java

 rs = st.executeQuery("SELECT * FROM banlist WHERE username = '"+name+"'");

unban.java:34

Code:java

if(mysql.checkBan(player)){

mysql variable in unban

Code:java

private LBMySQL mysql = new LBMySQL();

checkban method in LBMySQL

Code:java

 public boolean checkBan(String name){
 
 
try {
 
rs = st.executeQuery("SELECT * FROM banlist WHERE username = '"+name+"'");
 
if (rs.next()) {
return true;
}else{
return false;
}
 
 
} catch (SQLException ex) {
return false;
 
}
 
}

 

Full code please. What is rs? What is st?

 

the code is about 700 lines long anyway those are

Statement and ResultSet the class worked fine when i had it like this

i had this in the main class

Code:java

public LBMySQL mysql = new LBMySQL(this);

and had this in the mysql class at the top

Code:java

LegendaryBans plugin;
public LBMySQL(LegendaryBans instance) {
    plugin = instance;
}

i removed both of those and made the variable private and added it to every class that needed myql and now it wont work

and in the classes to access the mysql i used plugin.mysql and that worked fine

fixed it!

i made the connection to the database, resultset, and statement static

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