趁着还没忘,在这里记下来。当用spring data jpa进行多条件与的时候会用到 and。and()里面是这样描述的
有...表示为可变参数。凡是可变参数就可以用一个数组表示。所以我们根据条件查询代码可以写成如下所示:
default Page<T> findByCondition(final Map<String, Object> map, int page,// 根据条件查找
int size) {
Set set = map.keySet();
Iterator itr = set.iterator();
List list = new ArrayList();
while (itr.hasNext()) {
list.add(itr.next());
}
Specification<T> specification = new Specification<T>() {
@Override
public Predicate toPredicate(Root<T> root, CriteriaQuery<?> query,
CriteriaBuilder cb) {
Predicate[] pre = new Predicate[map.size()];
for (int i = 0; i < map.size(); i++) {
Predicate predicate = cb.equal(
root.get(list.get(i).toString()),
map.get(list.get(i).toString()));
pre[i] = predicate;
}
return cb.and(pre);cb.an
}
};
Pageable pageable = new PageRequest(page - 1, size);
Page<T> p_page = findAll(specification, pageable);
return p_page;
}