Alternatives to finder methods for every property in Spring JpaRepository

Question

I use Spring Data JPA for my repository layer. I need to query entities by every possible property and combinations of its properties. So my typical repository looks like this.

public interface UserRepository extends JpaRepository<User, Long> {

    User findByLogin(String login);
    User findByEmail(String email);
    User findByName(String name);
    User findByLoginAndEmail(String login, String email);
    User findByLoginAndName(String login, String name);
    User findByLoginAndEmailAndName(String login, String email, String name);
    //and so on
}

Even with three properties it looks ugly enough. Are there any more flexible alternatives to this approach? Or this design is OK(at least I do not have to implements all of these methods)?

You can try something from here https://spring.io/blog/2011/04/26/advanced-spring-data-jpa-specifications-and-querydsl/ — Orest, Mar 18 '17 at 09:59
Possible duplicate of [Spring Data dynamic query](http://stackoverflow.com/questions/23017419/spring-data-dynamic-query) — ltsallas, Mar 18 '17 at 11:15

score 1 · Accepted Answer · answered Mar 18 '17 at 15:09

1

Found query by example. Seems it is what I was looking for.

answered Mar 18 '17 at 15:09

Vitalii Vitrenko

9,763
4
43
62

Alternatives to finder methods for every property in Spring JpaRepository

1 Answers1