Guest User

Untitled

a guest
Apr 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. final String CREATE_TABLE_RECIPES = "CREATE TABLE IF NOT EXISTS " +
  2. TABLE_RECIPES + "(" +
  3. RECIPE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
  4. RECIPE_NAME + " TEXT, " +
  5. RECIPE_INSTRUCTIONS + " TEXT, " +
  6. RECIPE_RATING + " FLOAT " +
  7. ")";
  8.  
  9. ratingbar.setOnRatingBarChangeListener(new RatingBar.OnRatingBarChangeListener() {
  10. @Override
  11. public void onRatingChanged(RatingBar ratingBar, float rating, boolean fromUser) {
  12. db.addRating(id, rating);
  13. }
  14. });
  15.  
  16. public void addRating(int id, float rating) {
  17. String SET_RATING =
  18. "UPDATE " + TABLE_RECIPES +
  19. " SET " + RECIPE_RATING + " = " + rating +
  20. " WHERE " + RECIPE_ID + " = " + id;
  21.  
  22. SQLiteDatabase db = this.getWritableDatabase();
  23. db.rawQuery(SET_RATING, null);
  24. db.close();
  25. }
  26.  
  27. public float getRating(int id) {
  28. String GET_RATING =
  29. "SELECT " + RECIPE_RATING +
  30. " FROM " + TABLE_RECIPES +
  31. " WHERE " + RECIPE_ID + " = " + id;
  32. SQLiteDatabase db = this.getReadableDatabase();
  33. Cursor c = db.rawQuery(GET_RATING, null);
  34. c.moveToFirst();
  35. float rating = c.getFloat(0);
  36. Log.i("getRating", "gotRating: " + rating);
  37. return rating;
  38. }
Add Comment
Please, Sign In to add comment