Between的用法
2018-10-28 13:14 更新
表person对应的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
}
数据库访问PersonRepository类:public interface PersonRepository extends JpaRepository<Person, Long>, JpaSpecificationExecutor<Person> {
}
查询年龄在18到25之间,生日日期在某个区间的人。
public List<Person> findAll(SearchRequest request) {
Specification<Person> specification = new Specifications<Person>()
.between(Objects.nonNull(request.getAge(), "age", new Range<>(18, 25))
.between("birthday", new Range<>(new Date(), new Date()))
.build();
return personRepository.findAll(specification);
}
以上内容是否对您有帮助:
← NotIn的用法
更多建议: