public Recipe get(int id) { Recipe recipe; db.open(); Cursor cursor = db.fetch(KEY_TABLE_NAME, id); if (cursor == null || cursor.getCount() < 1) return null; cursor.moveToFirst(); /*Get column IDs*/ int col_name = cursor.getColumnIndex(KEY_NAME); int col_category = cursor.getColumnIndex(KEY_CATEGORY); int col_ingredients = cursor.getColumnIndex(KEY_INGREDIENTS); int col_instructions = cursor.getColumnIndex(KEY_INSTRUCTIONS); int col__id = cursor.getColumnIndex(KEY__ID); do { recipe = new Recipe(); recipe.name = cursor.getString(col_name); recipe.category = cursor.getString(col_category); recipe.ingredients = cursor.getString(col_ingredients); recipe.instructions = cursor.getString(col_instructions); recipe._id = Integer.parseInt(cursor.getString(col__id)); } while (cursor.moveToNext()); db.close(); return recipe; }