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 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
| package bdradio.com;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class OperateurBDD {
private static final int VERSION_BDD = 1;
private static final String NOM_BDD = "Operateur.db";
private static final String TABLE_OPERATEURS = "table_operateurs";
private static final String COL_ID = "ID";
private static final int NUM_COL_ID = 0;
private static final String COL_CODOP = "Codop";
private static final int NUM_COL_CODOP = 1;
private static final String COL_NOMOP = "Nomop";
private static final int NUM_COL_NOMOP= 2;
private SQLiteDatabase bdd;
private MaBaseSQLite maBaseSQLite;
public OperateurBDD(Context context){
maBaseSQLite = new MaBaseSQLite(context, NOM_BDD, null, VERSION_BDD);
}
public void open(){
bdd = maBaseSQLite.getWritableDatabase();
}
public void close(){
bdd.close();
}
public SQLiteDatabase getBDD(){
return bdd;
}
public long insertOperateur(Operateur table_operateurs){
ContentValues values = new ContentValues();
values.put(COL_CODOP, table_operateurs.getCodop());
values.put(COL_NOMOP, table_operateurs.getNomop());
return bdd.insert(TABLE_OPERATEURS, null, values);
}
public int updateIdOperateur(int id, Operateur table_operateurs){
ContentValues values = new ContentValues();
values.put(COL_ID, table_operateurs.getId());
return bdd.update(TABLE_OPERATEURS, values, COL_ID + " > " + id , null);
}
public int removeOperateurWithId(int id){
return bdd.delete(TABLE_OPERATEURS, COL_ID + " = " +id, null);
}
public Operateur getOperateurWithNomop(String nomop){
contenu dans la BDD (ici on sélectionne le livre grâce à son titre)
Cursor c = bdd.query(TABLE_OPERATEURS, new String[] {COL_ID, COL_CODOP, COL_NOMOP}, COL_NOMOP + " LIKE \"" + nomop +"\"", null, null, null, null);
return cursorToOperateur(c);
}
private Operateur cursorToOperateur(Cursor c){
if (c.getCount() == 0)
return null;
c.moveToFirst();
Operateur table_operateurs = new Operateur();
table_operateurs.setId(c.getInt(NUM_COL_ID));
table_operateurs.setCodop(c.getString(NUM_COL_CODOP));
table_operateurs.setNomop(c.getString(NUM_COL_NOMOP));
c.close();
return table_operateurs;
}
public int countrecords (){
Cursor c = bdd.query(TABLE_OPERATEURS, null, null, null, null, null, null);
return c.getCount();
}
public String getnomopWithId(int i){
(ici on sélectionne le livre grâce à son titre)
Cursor c = bdd.query(TABLE_OPERATEURS, null, COL_ID + " = " +i, null, null, null, null);
if (c.moveToFirst()){
String name;
int nameColumn = c.getColumnIndex(COL_NOMOP);
do{
name = c.getString(nameColumn);
return name;
}while(c.moveToNext());
}
return null;
}
} |
Partager