1 package com.example.groom;
3 import android.content.ContentValues;
4 import android.content.Context;
5 import android.database.Cursor;
6 import android.database.sqlite.SQLiteDatabase;
11 private SQLiteDatabase
bdd;
23 Cursor cursor = bdd.query(
"preferences",
new String[] {
"idPreferences",
"groom",
"idPrecedentOccupant"},
24 null, null, null, null, null, null);
33 public long inserer(String appareilGroom,
int idPrecedentOccupant)
35 ContentValues values =
new ContentValues();
36 values.put(
"groom", appareilGroom);
37 values.put(
"idPrecedentOccupant", idPrecedentOccupant);
39 return bdd.insert(
"preferences", null, values);
42 public int modifier(
int id, String appareilGroom,
int idPrecedentOccupant)
44 ContentValues values =
new ContentValues();
45 values.put(
"groom", appareilGroom);
46 values.put(
"idPrecedentOccupant", idPrecedentOccupant);
48 return bdd.update(
"preferences", values,
"idPreferences = " +
id, null);
53 return bdd.delete(
"preferences",
"idOccupant = " +
id, null);
58 Cursor c = bdd.rawQuery(
"SELECT * FROM preferences", null);
72 if (c.getCount() == 0)
void setIdPreferences(int idPreferences)
long inserer(String appareilGroom, int idPrecedentOccupant)
Preference cursorToServeur(Cursor c, boolean one)
int modifier(int id, String appareilGroom, int idPrecedentOccupant)
void setIdPrecedentOccupant(int idPrecedentOccupant)
Preferences(Context context)
void setAppareilGroom(String appareilGroom)
Preference getPreference()