Slide 14
Slide 14 text
Retrieve
Cursor c = db.query("inventory_items",
{ "name", "quantity", "categoryId" },
"name = ?", { "Drilling machine" },
null, null, null, 1);
c.moveToFirst();
String name = c.getString(c.getColumnIndexOrThrow("name"));
Int quantity = c.getInt(c.getColumnIndexOrThrow("quantity"));
Long categoryId = c.getLong(c.getColumnIndexOrThrow("categoryId"));
Category category = getCategoryById(categoryId);
InventoryItem item = InventoryItem(name, quantity, category);
14