ResultSet Format

I have a MySQL table that looks like this:

Code:

playername :: permission
random    :: essentials.perm
random    :: essentials.perme
random    :: essentials.perm4
dude    :: essentials.perm2 

I was to get all the perms random has so i used this:

Code:java

ResultSet res = plugin.statement.executeQuery("SELECT playername FROM playerperms WHERE playername='" + player.getName() + "'");

My Question is how would I go through all the the Permissions as a result set and add them with:

Code:java

                player.addAttachment(plugin, ("next Perm looped through here"), true);

Thanks

I can provide more code if needed.

 

From what you are saying, I think you want to iterate the ResultSet, correct?
If so, you will need to use ResultSet#next(), as can be seen in this code example

Code:java

while (res.next()) {
String permission = res.getString("YOUR FIELD NAME");
player.addAttachment(plugin, permission, true);
}

 

What do you mean your field name?
Would this work?

Code:java

    public void loadPerms(Player player){
        try {
            ResultSet res = plugin.statement.executeQuery("SELECT playername FROM playerperms WHERE playername='" + player.getName() + "'");
            while(res.next()){
                player.addAttachment(plugin, res.toString(), true);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

jackwilsdon

Bumped back to first page

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

 

I don't think just toString() would work. You would use res.getString("playername"), seeing as "playername" is the name of the field you are selecting in your query

 

jackwilsdon
Thanks, Ill try that.