Iterating the names of a MySQL database

Hey guys,
I've a MySQL database with a lot of information of the players of my server. I'd like to iterate the name of all those players, but I'm not sure about how to do it. I've writen this piece of code:

Code:java

    public static synchronized Array getNames(){
        try{
            PreparedStatement sql = connection
                    .prepareStatement("SELECT name FROM `bukkit`.`user_data`;");
 
            ResultSet result = sql.executeQuery();
            result.next();
            Array names = result.getArray("name");
            sql.close();
            result.close();
            return names;
        }catch (Exception e) {
            e.printStackTrace();
        }
 
        return null;
 
 
    }

ERROR: "get cannot be resolved or is not a field"

And then...

Code:java

public void anemiaCheck(){
        for(String player : MySQL.getNames()){
 
        }
    }

ERROR: "Can only iterate over an array or an instance of java.lang.Iterable"

Any idea?

Thanks in advance

 

Pitazzo This should work, not 100% sure.

Code:java

public static synchronized Array getNames(){
        try{
            PreparedStatement sql = connection
                    .prepareStatement("SELECT name FROM `bukkit`.`user_data`;");
 
            ResultSet result = sql.executeQuery();
            while(result.next()){
            Array names = result.getArray("name");
}
            sql.close();
            result.close();
            return names;
        }catch (Exception e) {
            e.printStackTrace();
        }
 
 
 
    }