Java Query.asc方法代码示例

import org.activiti.engine.query.Query; //导入方法依赖的package包/类
private static void applySortSpec(Query activitiQuery, QuerySpec querySpec)
		throws InvocationTargetException, IllegalAccessException, NoSuchMethodException {
	for (SortSpec orderSpec : querySpec.getSort()) {
		List<String> attributePath = orderSpec.getAttributePath();
		PreconditionUtil.assertTrue("nested attribute paths not supported", attributePath.size() == 1);
		String attributeName = attributePath.get(0);

		String orderbyMethodName = "orderBy" + firstToUpper(addTypePrefix(querySpec.getResourceClass(), attributeName));
		Method method = activitiQuery.getClass().getMethod(orderbyMethodName);
		method.invoke(activitiQuery);

		if (orderSpec.getDirection() == Direction.DESC) {
			activitiQuery.desc();
		}
		else {
			activitiQuery.asc();
		}
	}
}
 

import org.activiti.engine.query.Query; //导入方法依赖的package包/类
/**
 * uses the pagination parameters form the request and makes sure to order the result and set all pagination
 * attributes for the response to render
 *
 * @param req The request containing the pagination parameters
 * @param query The query to get the paged list from
 * @param listName The name model attribute name to use for the result list
 * @param model The model to put the list and the pagination attributes in
 * @param defaultSort THe default sort column (the rest attribute) that later will be mapped to an internal engine name
 */
@SuppressWarnings("rawtypes")
public DataResponse paginateList(Form form, Query query,
    String defaultSort, Map<String, QueryProperty> properties) {
  
  // Collect parameters
  int start = RequestUtil.getInteger(form, "start", 0);
  int size = RequestUtil.getInteger(form, "size", 10);
  String sort = form.getValues("sort");
  if(sort == null) {
    sort = defaultSort;
  }
  String order = form.getValues("order");
  if(order == null) {
    order = "asc";
  }

  // Sort order
  if (sort != null && properties.size() > 0) {
    QueryProperty qp = properties.get(sort);
    if (qp == null) {
      throw new ActivitiException("Value for param 'sort' is not valid, '" + sort + "' is not a valid property");
    }
    ((AbstractQuery) query).orderBy(qp);
    if (order.equals("asc")) {
      query.asc();
    }
    else if (order.equals("desc")) {
      query.desc();
    }
    else {
      throw new ActivitiException("Value for param 'order' is not valid : '" + order + "', must be 'asc' or 'desc'");
    }
  }

  // Get result and set pagination parameters
  List list = processList(query.listPage(start, size));
  DataResponse response = new DataResponse();
  response.setStart(start);
  response.setSize(list.size()); 
  response.setSort(sort);
  response.setOrder(order);
  response.setTotal(query.count());
  response.setData(list);
  return response;
}
 

import org.activiti.engine.query.Query; //导入方法依赖的package包/类
public DataResponse paginateList(Map<String, String> requestParams, PaginateRequest paginateRequest, Query query,
                                 String defaultSort, Map<String, QueryProperty> properties) {

    if (paginateRequest == null) {
        paginateRequest = new PaginateRequest();
    }

    // In case pagination request is incomplete, fill with values found in URL if possible
    if (paginateRequest.getStart() == null) {
        paginateRequest.setStart(RequestUtil.getInteger(requestParams, "start", 0));
    }

    if (paginateRequest.getSize() == null) {
        paginateRequest.setSize(RequestUtil.getInteger(requestParams, "size", 10));
    }

    if (paginateRequest.getOrder() == null) {
        paginateRequest.setOrder(requestParams.get("order"));
    }

    if (paginateRequest.getSort() == null) {
        paginateRequest.setSort(requestParams.get("sort"));
    }

    // Use defaults for paging, if not set in the PaginationRequest, nor in the URL
    Integer start = paginateRequest.getStart();
    if(start == null || start < 0) {
        start = 0;
    }

    Integer size = paginateRequest.getSize();
    if(size == null || size < 0) {
        size = 10;
    }

    String sort = paginateRequest.getSort();
    if(sort == null) {
        sort = defaultSort;//id
    }
    String order = paginateRequest.getOrder();
    if(order == null) {
        order = "asc";
    }

    // Sort order
    if (sort != null && !properties.isEmpty()) {
        QueryProperty qp = properties.get(sort);
        if (qp == null) {
            throw new ActivitiIllegalArgumentException("Value for param 'sort' is not valid, '" + sort + "' is not a valid property");
        }
        ((AbstractQuery) query).orderBy(qp);
        if (order.equals("asc")) {
            query.asc();
        }
        else if (order.equals("desc")) {
            query.desc();
        }
        else {
            throw new ActivitiIllegalArgumentException("Value for param 'order' is not valid : '" + order + "', must be 'asc' or 'desc'");
        }
    }

    // Get result and set pagination parameters
    List list = processList(query.listPage(start, size));
    DataResponse response = new DataResponse();
    response.setStart(start);
    response.setSize(list.size());
    response.setSort(sort);
    response.setOrder(order);
    response.setTotal(query.count());
    response.setData(list);
    return response;
}