As of Spring Data 1.7.1.RELEASE you can do it with two different ways,
- The new way, using query derivation for both count and delete queries. Read this, (Example 5).
Example,
public interface UserRepository extends CrudRepository<User, Integer> {
long countByName(String name);
}
- The old way, Using
@Query
annotation.
Example,
public interface UserRepository extends CrudRepository<User, Integer> {
@Query("SELECT COUNT(u) FROM User u WHERE u.name=?1")
long aMethodNameOrSomething(String name);
}
or using @Param
annotation also,
public interface UserRepository extends CrudRepository<User, Integer> {
@Query("SELECT COUNT(u) FROM User u WHERE u.name=:name")
long aMethodNameOrSomething(@Param("name") String name);
}
Check also this so answer.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…