表person對應(yīng)的model類:
@Entity
@Table(name = "person")
public class Person {
@Id
@GeneratedValue
private Long id;
private Integer age;
private String name;
@Column(name = "nick_name")
private String nickName;
private String company;
private Date birthday;
// getter and setter
}
數(shù)據(jù)庫訪問PersonRepository類:public interface PersonRepository extends JpaRepository<Person, Long>, JpaSpecificationExecutor<Person> {
}
查詢年齡大于等于20的人。public List<Person> findAll(SearchRequest request) { Specification<Person> specification = new Specifications<Person>() .ge(Object.nonNull(request.getAge()), "age", 20) .build(); return personRepository.findAll(specification); }
更多建議: