And自定义查询的用法
表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; @ManyToMany(cascade = ALL, fetch = FetchType.LAZY) private Set<Address> addresses = new HashSet<>();
// getter and setter
}
表address对应的model类:
@Entity @Table(name = "address") public class Address { @Id @GeneratedValue private Long id; private String street; private Integer number; @ManyToMany(mappedBy = "addresses") private Set<Person> owners = new HashSet<>();
// getter and setter
}
数据库访问PersonRepository类:
public interface PersonRepository extends JpaRepository<Person, Long>, JpaSpecificationExecutor<Person> {
}
查询年龄在10到35之间住在"Chengdu"的人。
public List<Person> findAll(SearchRequest request) {
Specification<Person> specification = new Specifications<Person>()
.between("age", new Range<>(10, 35))
.and(StringUtils.isNotBlank(jack.getName()), ((root, query, cb) -> {
Join address = root.join("addresses", JoinType.LEFT);
return cb.equal(address.get("street"), "Chengdu");
}))
.build();
return phoneRepository.findAll(specification);
}