Interface UserRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<User,Long>, org.springframework.data.repository.Repository<User,Long>
@Repository public interface UserRepository extends org.springframework.data.repository.CrudRepository<User,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    org.springframework.data.domain.Page<User>
    findAll(org.springframework.data.domain.Pageable pageable)
     
    Optional<User>
    findByEmail(String email)
     
    List<User>
    searchUsers(String query, org.springframework.data.domain.Pageable pageable)
     

    Methods inherited from interface org.springframework.data.repository.CrudRepository

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

  • Method Details

    • findByEmail

      Optional<User> findByEmail(String email)

    • findAll

      org.springframework.data.domain.Page<User> findAll(org.springframework.data.domain.Pageable pageable)

    • searchUsers

      @Query("SELECT u FROM users u\nWHERE LOWER(u.fullName) LIKE LOWER(CONCAT('%', :query, '%'))\n OR LOWER(u.givenName) LIKE LOWER(CONCAT('%', :query, '%'))\n OR LOWER(u.familyName) LIKE LOWER(CONCAT('%', :query, '%'))\n OR LOWER(u.email) LIKE LOWER(CONCAT('%', :query, '%'))\n") List<User> searchUsers(@Param("query") String query, org.springframework.data.domain.Pageable pageable)