public int updateParticipant(Participant participant) {
// 1. get reference to writable DB
SQLiteDatabase db = this.getWritableDatabase();
// 2. create ContentValues to add key "column"/value
ContentValues values = new ContentValues();
// get nom
values.put(PARTICIPANT_NOM, participant.getNom());
// get prenom
values.put(PARTICIPANT_PRENOM, participant.getPrenom());
// 3. updating row
int i =
db.update(
TABLE_PARTICIPANT,
values,
PARTICIPANT_ID + " = ?",
new String[] {String.valueOf(participant.getId())});
// 4. close
db.close();
return i;
}
public void addParticipant(Participant p) {
// 1- get reference to writable DB
SQLiteDatabase db = this.getWritableDatabase();
// 2. create ContentValues to add key "column"/value
ContentValues values = new ContentValues();
// Preparation des valeurs a inserer
values.put(PARTICIPANT_NOM, p.getNom());
values.put(PARTICIPANT_PRENOM, p.getPrenom());
// 3. insertion dans la base de donnees
db.insert(
TABLE_PARTICIPANT,
null,
values); // key/value -> keys = column names/ values = column values
// 4. close
db.close();
}