// Getting All Features public List<Feature> getAllFeatures() { List<Feature> featureList = new ArrayList<Feature>(); // Select All Query String selectQuery = "SELECT * FROM " + TABLE_FEATURES; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { Feature feature = new Feature(); feature.setID(Integer.parseInt(cursor.getString(0))); feature.setName(cursor.getString(1)); feature.setL1Norm(Double.parseDouble(cursor.getString(2))); feature.setL2Norm(Double.parseDouble(cursor.getString(3))); feature.setLinfNorm(Double.parseDouble(cursor.getString(4))); feature.setTimestamp(Double.parseDouble(cursor.getString(5))); feature.setDiffSecs(Double.parseDouble(cursor.getString(6))); feature.setMfccsAsString(cursor.getString(7)); feature.setPsdAcrossFrequencyBandsAsString(cursor.getString(8)); // Adding feature to list featureList.add(feature); } while (cursor.moveToNext()); } db.close(); // Closing database connection // return feature list return featureList; }