Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- final String CREATE_TABLE_RECIPES = "CREATE TABLE IF NOT EXISTS " +
- TABLE_RECIPES + "(" +
- RECIPE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
- RECIPE_NAME + " TEXT, " +
- RECIPE_INSTRUCTIONS + " TEXT, " +
- RECIPE_RATING + " FLOAT " +
- ")";
- ratingbar.setOnRatingBarChangeListener(new RatingBar.OnRatingBarChangeListener() {
- @Override
- public void onRatingChanged(RatingBar ratingBar, float rating, boolean fromUser) {
- db.addRating(id, rating);
- }
- });
- public void addRating(int id, float rating) {
- String SET_RATING =
- "UPDATE " + TABLE_RECIPES +
- " SET " + RECIPE_RATING + " = " + rating +
- " WHERE " + RECIPE_ID + " = " + id;
- SQLiteDatabase db = this.getWritableDatabase();
- db.rawQuery(SET_RATING, null);
- db.close();
- }
- public float getRating(int id) {
- String GET_RATING =
- "SELECT " + RECIPE_RATING +
- " FROM " + TABLE_RECIPES +
- " WHERE " + RECIPE_ID + " = " + id;
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor c = db.rawQuery(GET_RATING, null);
- c.moveToFirst();
- float rating = c.getFloat(0);
- Log.i("getRating", "gotRating: " + rating);
- return rating;
- }
Add Comment
Please, Sign In to add comment