GrOOm  0.2
BTS SNIR LaSalle Avignon 2020
Occupants.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 import java.util.ArrayList;
9 import java.util.List;
10 
11 public class Occupants
12 {
13  private GroomBDD groomBDD;
14  private SQLiteDatabase bdd;
15 
16  public Occupants(Context context)
17  {
18  groomBDD = new GroomBDD(context);
19  groomBDD.open();
20  bdd = groomBDD.getBDD();
21  }
22 
23  public List<Occupant> getListe()
24  {
25  List<Occupant> occupants = new ArrayList<Occupant>();
26  Cursor cursor = bdd.query("occupants", new String[] {"idOccupant", "nom", "prenom", "fonction"},
27  null, null, null, null, null, null);
28 
29  cursor.moveToFirst();
30  while (!cursor.isAfterLast())
31  {
32  Occupant occupant = cursorToServeur(cursor, false);
33  occupants.add(occupant);
34  cursor.moveToNext();
35  }
36 
37  cursor.close();
38  return occupants;
39  }
40 
41  public long inserer(String nom, String prenom, String fonction)
42  {
43  ContentValues values = new ContentValues();
44  values.put("nom", nom);
45  values.put("prenom", prenom);
46  values.put("fonction", fonction);
47 
48  return bdd.insert("occupants", null, values);
49  }
50 
51  public int modifier(int id, Occupant occupant)
52  {
53  ContentValues values = new ContentValues();
54  values.put("nom", occupant.getNom());
55  values.put("prenom", occupant.getPrenom());
56  values.put("fonction", occupant.getFonction());
57 
58  return bdd.update("occupants", values, "idOccupant = " + id, null);
59  }
60 
61  public int supprimer(int id)
62  {
63  return bdd.delete("occupants", "idOccupant = " + id, null);
64  }
65 
66  public Occupant getOccupant(String nom)
67  {
68  Cursor c = bdd.rawQuery("SELECT * FROM occupants WHERE nom = ?", new String[] {nom});
69 
70  return cursorToServeur(c, true);
71  }
72 
73  private Occupant cursorToServeur(Cursor c, boolean one)
74  {
75  if (c.getCount() == 0)
76  return null;
77 
78  if(one)
79  c.moveToFirst();
80 
81  Occupant occupant = new Occupant();
82  occupant.setId(c.getInt(0));
83  occupant.setNom(c.getString(1));
84  occupant.setPrenom(c.getString(2));
85  occupant.setFonction(c.getString(3));
86 
87  if (one)
88  c.close();
89  return occupant;
90  }
91 }
Occupant getOccupant(String nom)
Definition: Occupants.java:66
List< Occupant > getListe()
Definition: Occupants.java:23
Occupant cursorToServeur(Cursor c, boolean one)
Definition: Occupants.java:73
void setFonction(String fonction)
Definition: Occupant.java:97
Occupants(Context context)
Definition: Occupants.java:16
void setNom(String nom)
Definition: Occupant.java:53
int modifier(int id, Occupant occupant)
Definition: Occupants.java:51
long inserer(String nom, String prenom, String fonction)
Definition: Occupants.java:41
void setPrenom(String prenom)
Definition: Occupant.java:75
SQLiteDatabase getBDD()
Definition: GroomBDD.java:29