Write a row query in Sqllite room

Question

I need to write this query by using sqllite room query with Dao Class. I.getItemID() is a dynamic variable.

"SELECT item_quantity FROM item WHERE item_id ='"+I.getItemID()+"'"

Answer 1

If it is what you meant, you almost got it then:

"SELECT item_quantity FROM item WHERE item_id = :I.getItemID()"

Answer 2

Check out this link for more information regarding accessing-data using room.

@Dao
public interface MyDao {

    @Query("SELECT item_quantity FROM item WHERE item_id = :itemId")
    public int getItemQuantity(String itemId);

}