if(geReqMain.getInputDate()!=null){
list.add(cb.equal(root.<Date> get("inputDate"), geReqMain.getInputDate()));
}
public Page<GeReqMain> findGeReqMainDtoList(final GeReqMain geReqMain, Pager pager) {
Page<GeReqMain> pages = null;
Pageable pr = new PageRequest(pager.getPageNum() - 1,pager.getNumPerPage());
pages = geReqMainDao.findAll(new Specification<GeReqMain>() {
public Predicate toPredicate(Root<GeReqMain> root,
CriteriaQuery<?> query, CriteriaBuilder cb) {
if (null == geReqMain) {
return null;
}
List<Predicate> list = new ArrayList<Predicate>();
// 加入查询条件
if (!StringUtils.isEmpty(geReqMain.getReqId())) {
list.add(cb.like(root.get("reqId").as(String.class), "%"+ geReqMain.getReqId().trim() + "%"));
}
if (!StringUtils.isEmpty(geReqMain.getReqName())) {
list.add(cb.l
springJpa中分页语句里拼接orderBy
最新推荐文章于 2024-04-14 18:06:43 发布