spring-data

Here is sample of such Specification for User: public static Specification<User> containsTextInName(String text) { if (!text.contains(“%”)) { text = “%” + text + “%”; } String finalText = text; return (root, query, builder) -> builder.or( builder.like(root.get(“lastname”), finalText), builder.like(root.get(“firstname”), finalText) ); } or even more customizable implementation: public static Specification<User> containsTextInAttributes(String text, List<String> attributes) { if … Read more

Use below steps. Create jpa-named-queries.property file in src/main/resources–>META-INF Folder Defile your query in given properties file. Above screenshot look closely.Here Group is Entity name, while Method should match with method define in Repository interface. Query should have object name instead table name and instead of column name provide variable name given in entity for respective … Read more

This is now possible with Spring Data. Check out http://docs.spring.io/spring-data/jpa/docs/current/reference/html/#query-by-example Person person = new Person(); person.setLastname(“Smith”); Example<Person> example = Example.of(person); List<Person> results = personRepository.findAll(example); Note that this requires very recent 2016 versions <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-jpa</artifactId> <version>1.10.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-commons</artifactId> <version>1.12.1.RELEASE</version> </dependency> see https://github.com/paulvi/com.example.spring.findbyexample