android how to check Database Table Is empty or not?

Question

i want code for following concept If Data_Base_Table is empty insert the data to Data_Base_Table.Its only one time .If already data in Data_Base_Table means do nothing.I Wrote like this Here am checking DataBase Table data is empty or not is it correct or not public boolean checkDataBaseTable() { SQLiteDatabase dataBase = this.getReadableDatabase();

    String s = "SELECT * FROM"+Data_Base_Table;
    Cursor cursor = dataBase.rawQuery(s, null);
    if (cursor.moveToFirst()) {
        do {
            //int i=cursor.getColumnCount();
        }while(cursor.moveToNext());

    }
    return cursor!= null ? true : false;
}

see this http://stackoverflow.com/questions/5202269/sqlite-query-in-android-to-count-rows — Syed Raza Mehdi, Jun 08 '15 at 05:54

score 4 · Answer 1 · answered Jun 08 '15 at 06:06

4

Try with this code.

Cursor cursor = database.query(TABLE_NAME, null, null, null, null, null,null);
if(cursor.getCount()>0)
{
     // database not empty
} else {
    // database empty
}

answered Jun 08 '15 at 06:06

Jigar Shekh

2,800
6
29
54

Hi Jigar Shekh,every time calling database not empty even after uninstall and install it wil call database not empty.please reply me – Thej Jun 08 '15 at 07:17
@Thej, your database store in sdcard? – Jigar Shekh Jun 09 '15 at 03:55
Hi Jigar,Thanks for Reply.My Problem solved.I didn't get ur point. – Thej Jun 09 '15 at 04:46

score 1 · Answer 2 · edited Jun 08 '15 at 06:00

1

I use something like this:

Cursor cursor = db.query(your-table-name, columns, null, null, null);
if(cursor.getCount() > 0) {
    //do some stuff when there is data in the table
} else {
   //do some stuff when there is no data
}

edited Jun 08 '15 at 06:00

Xaver Kapeller

49,491
11
98
86

answered Jun 08 '15 at 05:57

muhammad waqas

742
1
5
20

if(cursor!=null && cursor.getCount() > 0) { //just in case your cursor is null.check if it is not equal to null }else{ } – khubaib Jun 08 '15 at 06:30

android how to check Database Table Is empty or not?

2 Answers2