public ArrayList<Group> getGroupList(Long facultetId) { ArrayList<Group> result = new ArrayList<Group>(); Cursor c = mDb.rawQuery( TextUtils.concat( "SELECT * FROM ", Group.TABLE_NAME, " WHERE ", Group.FACULTET_ID, "=?", " ORDER BY ", Group.LEVEL, ", ", Group.GROUP_TITLE) .toString(), new String[] {facultetId.toString()}); Group group = null; while (c.moveToNext()) { group = new Group(); group.setId(c.getLong(c.getColumnIndex(Group.ID))); group.setTitle(c.getString(c.getColumnIndex(Group.GROUP_TITLE))); group.setLevel(c.getInt(c.getColumnIndex(Group.LEVEL))); group.setFacultetId(c.getLong(c.getColumnIndex(Group.FACULTET_ID))); result.add(group); } return result; }