How to delete all items from databese and base adapter

Question

I have a database to saving all data. There are 3 different activities. First activity has only one word. Second activity has many words and All data go to my database. Third activity All data are being compiled. But I have a problem. I cannot delete all data. There is a little button in 3rd activity. But when I use, My application does nothing. All data are still in my database. I want to delete all data. How can I fix?

My database query:

 public void deleteAllName(int id, String name ) {
    SQLiteDatabase db = this.getWritableDatabase();
    String query = "DELETE FROM " + TABLE_NAME + " WHERE "
            + COL1 + " = '" + id + "' AND "
            + COL2 + " = '" + name + "'";
    Log.d(TAG, "deleteName: query: " + query);
    Log.d(TAG, "deleteName: Deleting " + name + " from database.");
    db.execSQL(query);
}

How to get all data :

     Cursor data = mDatabaseHelper.getData();

    while(data.moveToNext()){

        listDataId.add(data.getString(0)); //all ıds
        analiste.add(data.getString(1));  // all datas


    }

My little button :

 sil.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

              for (int i = 0 ; i< listDataId.size()  ; i++ ) {

              int all_id = Integer.parseInt(listDataId.get(i));
                String all_names = analiste.get(i);

               mDatabaseHelper.deleteAllName(all_id , all_names);
            }
            isleme.notifyDataSetChanged();


        }
    });

}

My purpose is generate too many items from these worlds.There is different logic in this project.So I have to erase all datas at first time. — Hatay Berkay Işıkoğlu, Jan 10 '18 at 12:35
@BerkayIşıkoğlu I have edited answer. This method will clear all your data.. — coder_baba, Jan 10 '18 at 12:38

score 1 · Accepted Answer · answered Jan 10 '18 at 12:38

1

Hi As per my understanding You can Delete from this code

 public void deleteBackGroundTable() {
    String deleteQuery = "DELETE  FROM " + YOUR_TABLE_NAME;
    SQLiteDatabase db = this.getWritableDatabase();
    db.execSQL(deleteQuery);
    Log.e("Offline Table", "deleteBackGroundTable: DELETED !! ");
}

answered Jan 10 '18 at 12:38

coder_baba

447
3
21

Thanks for your helping. – Hatay Berkay Işıkoğlu Jan 10 '18 at 12:41
@BerkayIşıkoğlu Welcome ... Great to hear, I could help you :-) – coder_baba Jan 10 '18 at 12:42

score 0 · Answer 2 · edited Jan 12 '18 at 09:32

0

Very first time you can use in your SqliteDatabaseHelper

db.execSQL("delete from "+ TABLE_NAME);

edited Jan 12 '18 at 09:32

Pang

9,564
146
81
122

answered Jan 10 '18 at 12:39

Swapnil Kshirsagar

660
6
20

How to delete all items from databese and base adapter

2 Answers2