Save SQLite returned data to an object list
public void fillDataToArray() { ArrayList<BeanClass> arrayList = new ArrayList<BeanClass>(); DatabaseHandler db = new DatabaseHandler(getActivity()); db.open(); try { Cursor c = db.getImageNameForList(); if (c != null && c.getCount() > 0) { c.moveToFirst(); for (int count = 0; count < c.getCount(); count++) { Beanclass detail = new Beanclass (); detail.setName(c.getString(c .getColumnIndex(DatabaseHandler._ID))); detail.setPath(c.getString(c .getColumnIndexOrThrow(DatabaseHandler._PATH))); arrayList.add(detail); c.moveToNext(); } } } catch(Exception e) { e.printStackTrace(); } c.close(); db.close(); }
Source: stackoverflow.com