1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| package org.ae.dragon.poker.Db;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
/**
* Created by Vincent on 21/07/2014.
*/
public class ReferentielLongDAO extends DAOBase {
public ReferentielLongDAO(Context pContext) {
super(pContext);
}
public static final String TABLE_NAME = "referentiel_long";
public static final String KEY = "CLE";
public static final String VALEUR = "valeur";
public static final String TABLE_CREATE = "CREATE TABLE " + TABLE_NAME + " (" + KEY + " STRING, " + KEY + " INTEGER);";
public static final String TABLE_DROP = "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
/**
* @param m le métier à ajouter à la base
*/
public void ajouter(ReferentielLong m) {
ContentValues value = new ContentValues();
value.put(KEY, m.getCle());
value.put(VALEUR, m.getValeur());
mDb.insert(TABLE_NAME, null, value);
}
public void supprimer(String cle) {
mDb.delete(TABLE_NAME, KEY + " = ?", new String[]{cle});
}
public void modifier(ReferentielLong m) {
ContentValues value = new ContentValues();
value.put(VALEUR, m.getValeur());
mDb.update(TABLE_NAME, value, KEY + " = ?", new String[]{m.getCle()});
}
public ReferentielLong selectionner(String cle) {
Cursor c = mDb.rawQuery("select " + KEY + "," + VALEUR + " from " + TABLE_NAME + " where valeur = ?", new String[]{cle});
if (c.getCount() > 0) {
c.moveToFirst();
return new ReferentielLong(c.getString(1), c.getLong(2));
} else
return null;
}
} |
Partager