mFTBDSCJ

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});
15	
16public 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	
27public 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}