GrOOm  0.2
BTS SNIR LaSalle Avignon 2020
Preferences.java
Aller à la documentation de ce fichier.
1 package com.example.groom;
2 
3 import android.content.ContentValues;
4 import android.content.Context;
5 import android.database.Cursor;
6 import android.database.sqlite.SQLiteDatabase;
7 
8 public class Preferences
9 {
10  private GroomBDD groomBDD;
11  private SQLiteDatabase bdd;
12 
13  public Preferences(Context context)
14  {
15  groomBDD = new GroomBDD(context);
16  groomBDD.open();
17  bdd = groomBDD.getBDD();
18  }
19 
21  {
22  Preference preference;
23  Cursor cursor = bdd.query("preferences", new String[] {"idPreferences", "groom", "idPrecedentOccupant"},
24  null, null, null, null, null, null);
25 
26  cursor.moveToFirst();
27  preference = cursorToServeur(cursor, false);
28 
29  cursor.close();
30  return preference;
31  }
32 
33  public long inserer(String appareilGroom, int idPrecedentOccupant)
34  {
35  ContentValues values = new ContentValues();
36  values.put("groom", appareilGroom);
37  values.put("idPrecedentOccupant", idPrecedentOccupant);
38 
39  return bdd.insert("preferences", null, values);
40  }
41 
42  public int modifier(int id, String appareilGroom, int idPrecedentOccupant)
43  {
44  ContentValues values = new ContentValues();
45  values.put("groom", appareilGroom);
46  values.put("idPrecedentOccupant", idPrecedentOccupant);
47 
48  return bdd.update("preferences", values, "idPreferences = " + id, null);
49  }
50 
51  public int supprimer(int id)
52  {
53  return bdd.delete("preferences", "idOccupant = " + id, null);
54  }
55 
56  public boolean estVide()
57  {
58  Cursor c = bdd.rawQuery("SELECT * FROM preferences", null);
59 
60  if(c.getCount() == 0)
61  {
62  return true;
63  }
64  else
65  {
66  return false;
67  }
68  }
69 
70  private Preference cursorToServeur(Cursor c, boolean one)
71  {
72  if (c.getCount() == 0)
73  return null;
74 
75  if(one)
76  c.moveToFirst();
77 
78  Preference preference = new Preference();
79  preference.setIdPreferences(c.getInt(0));
80  preference.setAppareilGroom(c.getString(1));
81  preference.setIdPrecedentOccupant(c.getInt(2));
82 
83  if (one)
84  c.close();
85  return preference;
86  }
87 }
void setIdPreferences(int idPreferences)
Definition: Preference.java:20
long inserer(String appareilGroom, int idPrecedentOccupant)
Preference cursorToServeur(Cursor c, boolean one)
int modifier(int id, String appareilGroom, int idPrecedentOccupant)
void setIdPrecedentOccupant(int idPrecedentOccupant)
Definition: Preference.java:40
Preferences(Context context)
void setAppareilGroom(String appareilGroom)
Definition: Preference.java:30
SQLiteDatabase getBDD()
Definition: GroomBDD.java:29