Mattie

public void getUsersFromDB()
    {
        userList.clear();
        rs = db.getUsersFromDB();

        try
        {
            while (rs.next())
            {
                int id = rs.getInt("user_id");
                String nick = rs.getString("user_nick");
                String host = rs.getString("user_host");
                String realname = rs.getString("user_realname");
                String password = rs.getString("user_password");
                int level = rs.getInt("user_access");
                int away = rs.getInt("user_away_status");
                boolean awaystatus = false;
                if (away == 1)
                    awaystatus = true;
                String awayreason = rs.getString("user_away_reason");
                long awaytime = rs.getLong("user_away_time");
                boolean user_ignore = rs.getBoolean("user_ignore");

                Gebruiker user = new Gebruiker(id, nick, realname, host, password, level);
                user.setAway(awaystatus);
                user.setReden(awayreason);
                user.setTijd(awaytime);
                user.setIgnore(user_ignore);
                userList.add(user);
            }
            rs.close();
        } catch (SQLException e)
        {

            db.genereerError(e);
        }

    }