How can I create a list Array with the cursor data in Android

android, android-cursor, android-sqlite, arraylist

Solution

Go through every element in the `Cursor`, and add them one by one to the `ArrayList`.

ArrayList<WhateverTypeYouWant> mArrayList = new ArrayList<WhateverTypeYouWant>();
for(mCursor.moveToFirst(); !mCursor.isAfterLast(); mCursor.moveToNext()) {
    // The Cursor is now set to the right position
    mArrayList.add(mCursor.getWhateverTypeYouWant(WHATEVER_COLUMN_INDEX_YOU_WANT));
}

(replace `WhateverTypeYouWant` with whatever type you want to make a `ArrayList` of, and `WHATEVER_COLUMN_INDEX_YOU_WANT` with the column index of the value you want to get from the cursor.)

Problem

Original source