//méthode pour création BDD et Table public class SQLiteDataBaseHelper extends SQLiteOpenHelper { public static final String DATABASE_NAME = "Book.db"; public static final String TABLE_NAME = "book_table"; public static final String COL_1 = "ID"; public static final String COL_2 = "NOM"; public static final String COL_3 = "AUTEUR"; public static final String COL_4 = "CATEGORY";
public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion){ db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); onCreate(db); }
public boolean insertData(String nom, String auteur, String categorie ) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL_2, nom); contentValues.put(COL_3,auteur); contentValues.put(COL_4,categorie); long result=db.insert(TABLE_NAME, null, contentValues); if (result == -1) return false; else return true; }
public Cursor getAllData(){ SQLiteDatabase db = this.getWritableDatabase(); Cursor result = db.rawQuery("select * from " + TABLE_NAME, null); return result;
public void AddData(){ buttonAddData.setOnClickListener( new View.OnClickListener(){ public void onClick (View view){ // insert the new rav data on click of the button boolean isInserted = db.insertData(nomInput.getText().toString(), auteurInput.getText() .toString(), categorieInput.getText().toString()); if (isInserted==true) { Toast.makeText(MainActivity.this, "Les données sont insérer avec succès", Toast.LENGTH_LONG).show(); } else Toast.makeText(MainActivity.this, "Les données ne sont pas insérées", Toast.LENGTH_LONG).show(); } }
); }
private void ViewAll(){ buttonViewAllData.setOnClickListener( new View.OnClickListener(){ public void onClick(View view){ Cursor data = db.getAllData(); if (data.getCount()== 0) { //show message showMessage("Error","No Data Found !"); return; } StringBuffer buffer = new StringBuffer(); while (data.moveToNext()){ buffer.append("ID : " + data.getString(0) + "\n"); buffer.append("Nom :" + data.getString(1) + "\n"); buffer.append("Auteur :" + data.getString(2) + "\n"); buffer.append("Catégorie :" + data.getString(3) + "\n"); } showMessage("Data", buffer.toString()); } }
); }
public void showMessage(String titel, String message){ AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.setCancelable(true); builder.setTitle(titel); builder.setMessage(message); builder.show(); }