// 设置排序(默认按ID顺序)
String orderBy = "ID ASC";
String orderByElementCode = dto.getOrderBy();
if (StringUtils.isNotBlank(orderByElementCode)) {
String orderByElementName = NutrientElementsEnum.getValue(orderByElementCode);
String orderByElementField = NutrientElementsFieldEnum.getValue(orderByElementName);
String orderStr = String.format("(CASE %s WHEN -1 THEN 2147483647 ELSE %s END)", orderByElementField, orderByElementField);
String ifDesc = dto.getIsAsc() ? " ASC" : " DESC";
orderBy = orderStr + ifDesc + "," + orderBy;
}
Page page = PageHelper.startPage(pageNo, pageSize, orderBy);
OrderQueryDTO baseDTO = getOrderQueryDTO (dto, elementField)
List<orderDTO> vos = orderMapper.selectList(baseDTO);
结果:
select * from where order_code = ? order by (CASE age WHEN -1 THEN 2147483647 ELSE age END) ASC,ID ASC LIMIT ?