JPA - check if the user exists in the database by name?

user_15690479 0
Viewed 1475

i'm triying user this code

public interface UserRepository extends CrudRepository<Usuario, Long> {

    @Query("select p from User p where name = ?1")
    public boolean findExistByname(String name);
    
    @Query("select p from User p where email = ?1")
    public boolean findExistByEmail(String email);
}

to check if the user in the database exists, but when not, it returns null and an error, I just don't know how to do this

spring-data-jpa jpa spring java
2 Answers

You need to select a boolean value.

@Query("select count(p) = 1 from User p where name = ?1")
public boolean findExistByname(String name);
user_52280650

Try following code:

@Repository
public interface UserRepository extends CrudRepository<UserEntity, Long> {

    Optional<UserEntity> findByName(final String name);
}

and then check whether user exists:

userRepository.findByName("username goes here")
                .orElseThrow(() -> new SecurityException("User not found in database"));

or:

userRepository.findByName("username goes here").isPresent()
user_133099180
Related