/** * Return List of All records of WeatherData from DB * * @return List<WeatherData> */ public List<WeatherData> getAllWeather() { List<WeatherData> weatherList = new ArrayList<WeatherData>(); // Select All Query String selectQuery = "SELECT * FROM " + TABLE_WEATHER; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { WeatherData weatherData = new WeatherData(); weatherData.setID(cursor.getString(0)); weatherData.setCity(cursor.getString(1)); weatherData.setCoordLon(Double.parseDouble(cursor.getString(2))); weatherData.setCoordLat(Double.parseDouble(cursor.getString(3))); weatherList.add(weatherData); } while (cursor.moveToNext()); } // return weather list return weatherList; }