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;

 posted on 2017-02-06 14:59  丶汤女  阅读(2098)  评论(0编辑  收藏  举报