WBkLmVb8

1final 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	
9ratingbar.setOnRatingBarChangeListener(new RatingBar.OnRatingBarChangeListener() {
10        @Override
11        public void onRatingChanged(RatingBar ratingBar, float rating, boolean fromUser) {
12            db.addRating(id, rating);
13}
14	
15public void addRating(int id, float rating) {
16    String SET_RATING =
17            "UPDATE " + TABLE_RECIPES +
18                    " SET " + RECIPE_RATING + " = " + rating +
19                    " WHERE " + RECIPE_ID + " = " + id;
20
21    SQLiteDatabase db = this.getWritableDatabase();
22    db.rawQuery(SET_RATING, null);
23    db.close();
24}
25	
26public float getRating(int id) {
27    String GET_RATING =
28            "SELECT " + RECIPE_RATING +
29                    " FROM " + TABLE_RECIPES +
30                    " WHERE " + RECIPE_ID + " = "  + id;
31    SQLiteDatabase db = this.getReadableDatabase();
32    Cursor c = db.rawQuery(GET_RATING, null);
33    c.moveToFirst();
34    float rating =  c.getFloat(0);
35    Log.i("getRating", "gotRating: " + rating);
36    return rating;
37}