Ejemplo n.º 1
0
  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;
  }
Ejemplo n.º 2
0
  public void delateParticipant(Participant p) {

    // 1. get reference to writable DB
    SQLiteDatabase db = this.getWritableDatabase();

    // 2. delete
    db.delete(TABLE_PARTICIPANT, PARTICIPANT_ID + " = ?", new String[] {String.valueOf(p.getId())});

    // 3. close
    db.close();
  }