How to get the number of query strings in Android using SQLite?

Question

How to get the number of query strings in Android using SQLite? It seems my next method is not working.

public int getFragmentCountByMixId(int mixId) { int count = 0; SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); Cursor cursor = db.rawQuery( "select count(*) from downloadedFragement where mixId=?", new String[]{String.valueOf(mixId)}); while(cursor.moveToFirst()){ count = cursor.getInt(0); } return count; } 

Answer 1

Cursor.getCount()

Answer 2

 cursor.moveToNext(); cursor.getCount(); 

If moveToNext () is not called, a cursorIndexOutOfBoundException may occur.

Answer 3

This would be more efficient because work for all versions:

 int numRows = DatabaseUtils.longForQuery(db, "SELECT COUNT(*) FROM table_name", null); 

or

 int numRows = DatabaseUtils.queryNumEntries(db, "table_name"); 

or , if you want to get the number of rows that have a specific selection , then you should go with (added in API 11)

 public static long queryNumEntries (SQLiteDatabase db, String table, String selection) 

Thank:)

Answer 4

Query for the _ID column in the table, and then call getCount on the cursor. Here is the link that I am making in one of my projects. Look at line number 110.

Answer 5

use string instead of int

 String strCount = ""; int count = 0; SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); Cursor cursor = db.rawQuery( "select count(*) from downloadedFragement where mixId=?", new String[]{String.valueOf(mixId)}); while(cursor.moveToFirst()){ strCount = cursor.getString(cursor.getColumnIndex("COUNT(*)")); } count = Integer.valueOf(strCount).intValue(); 

Answer 6

In DatabaseUtils

 public static long queryNumEntries(SQLiteDatabase db, String table) 

Answer 7

  public long getRecords() { return DatabaseUtils.longForQuery(db, "SELECT COUNT(*) FROM contacts", null); } 

You can use this as a method or use this if your database uses auto-increment

  public long getRecords() { return DatabaseUtils.longForQuery(db, "SELECT seq FROM sqlite_sequence", null); } 

Answer 8

 val query = "SELECT * FROM $TABLE_NAME ;" val result = db.rawQuery(query,null) Toast.makeText(ctx,result.count,Toast.LENGTH_SHORT).show()