[Updated Thread] SQL Help

Right. So the SQL execute method from a statement is a boolean type.

So if I execute:

"SELECT " + name + " FROM Players";

Then how do I actually get the thing I selected? This might be a bit of a noob question.

 

while(resultsetvariable.next()) {
//stuff
}

That'll loop through every entry, even if you have just one.

 

Thanks, but I kinda worked out a slightly different way before you posted that. Would this work:

Code:

public PlayerData playerFetch(String playerName) {
    ResultSet result = sql.executeQuery("SELECT " + playerName + " FROM Players");
    PlayerData pd;
    try {
        pd = (PlayerData) result.getObject(playerName);
        return pd;
     } catch (SQLException ex) {
         return null;
     }
}

 

You should check if result is empty before end. A thrown error is much slower to process than IF check.