Solved Get more then one result out of mysql

Hey Guys,
i'm coding a little minigame at the moment and i want to save the locations, where an items spawn, in an database in mysql. But I get a NullPointerException in line 19.

Code:

public static ArrayList getBronze(){
        Integer x = 0;
        Integer y = 0;
        Integer z = 0;
        ArrayList<Location> locs = new ArrayList<Location>();
            try {
//next line is line 19
                ResultSet rs = Main.mysql.query("SELECT * FROM Locations WHERE TYPE = '1'");
                while(rs.next()){
                if(!(rs.next()) || (Integer.valueOf(rs.getInt("XWERT")) == null));
                x = rs.getInt("XWERT");   
                if(!(rs.next()) || (Integer.valueOf(rs.getInt("YWERT")) == null));
                y = rs.getInt("YWERT");
                if(!(rs.next()) || (Integer.valueOf(rs.getInt("ZWERT")) == null));
                z = rs.getInt("ZWERT");
                Location loc = new Location(Bukkit.getServer().getWorld("world-"), x, y, z);
                locs.add(loc);
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
           
       
       
       
        return locs;
    }

I hope somebody can help me i'm very new to mysql in Java.
Ole

 

On line 19, the only thing that could cause an NPE is that Main.mysql has not be instantiated yet.

 

Both together helped. thx