Spring Data JPA - finding number of rows from the database

Question

I am a noob in Spring framework. I know there is the findAll method to query all the data in a database. Is there a way to count the number of rows in a database using the Spring framework and doesn't require to write a SQL query?

Solution

There is method count() in CrudRepository. You can check oficial documentation.

Comments

[aswzen]

how to add condition to that count

[Woodchuck]

You could just add something like this to your repository: long countBySomeField(String someField);