How to use the ORMLite query builder to get the total records in a table

Question

Similar to

select count(*) from tablename;

what should be query in ORMLITE

i tried something like

int total = dao.queryBuilder().("select count(*)");

Pretext

Answer 1

How to use the ORMLite query builder to get the total records in a table

ORMLite has a Dao.countOf() method that returns the total number of rows in a table:

long numRows = dao.countOf();

You can also count the number of rows in a custom query by calling the countOf() method on the Where or QueryBuilder object.

// count the number of lines in this custom query
long numRows = dao.queryBuilder().where().eq("name", "Joe Smith").countOf();

Herstein

countOf() will return long value not int – Brigidbrigida

Thanks @KJEjava48. Fixed. – Herstein

Answer 2

for package 5: you can use countOf()

From the docs:

Returns the value returned from a SELECT COUNT(*) query which is the number of rows in the table. Depending on the database and the size of the table, this could be expensive.

Tajo

I'm not really familiar with ormlite. I just searched.What about: dao.queryBuilder().countOf(); – Tajo

Did it work ? if so, please help me,yourself and the community by accepting this as the right answer – Tajo