public Page<Task> getUserTask(Long userId, Map<String, Object> searchParams, int pageNumber, int pageSize, String sortType) { PageRequest pageRequest = buildPageRequest(pageNumber, pageSize, sortType); Specification<Task> spec = buildSpecification(userId, searchParams); return taskDao.findAll(spec, pageRequest); } /** * 创建分页请求. */ private PageRequest buildPageRequest(int pageNumber, int pagzSize, String sortType) { Sort sort = null; if ("auto".equals(sortType)) { sort = new Sort(Direction.DESC, "id"); } else if ("title".equals(sortType)) { sort = new Sort(Direction.ASC, "title"); } return new PageRequest(pageNumber - 1, pagzSize, sort); } /** * 创建动态查询条件组合. */ private Specification<Task> buildSpecification(Long userId, Map<String, Object> searchParams) { Map<String, SearchFilter> filters = SearchFilter.parse(searchParams); filters.put("user.id", new SearchFilter("user.id", Operator.EQ, userId)); Specification<Task> spec = DynamicSpecifications.bySearchFilter(filters.values(), Task.class); return spec; }
步骤1:创建分页请求
使用org.springframework.data.domain.PageRequest.PageRequest(int page, int size, Sort sort)创建分页请求
page:当前页数-1;
size:每页记录数;
sort:springframework封装的排序类,new Sort(Direction.DESC/ASC,"filed");
步骤2:创建动态查询条件组合
SearchFilter.parse(searchParams)中searchParams是一个Map集合,集合中数据的格式为
searchParams.put(name,value):
name: LIKE_fieldname; EQ__fieldname; GT_....; LT_....; GTE_....; LTE_....;
value: fieldvalue
返回一个Map<String,SearchFilter>的集合,也可以自己往集合中添加查询条件:filters.put(fieldname,new SearchFilter(fieldname,Operator.LIKE/EQ/GT......,fieldvalue));
然后生成查询器:Specification<Task> spec = DynamicSpecifications.bySearchFilter(filters.values(), Task.class);
步骤3:组合返回Page集合对象
taskDao.findAll(spec, pageRequest);
除了jpa data的包外还需要springisde的以下包
import org.springside.modules.persistence.DynamicSpecifications;
import org.springside.modules.persistence.SearchFilter;
import org.springside.modules.persistence.SearchFilter.Operator;