Pageable pageable = PageRequest.of(page, pageSize, new Sort(Sort.Direction.DESC, "shieldTime", "createTime"));
Pageable排序规则:
和MySQL的排序一样。
http://www.mysqltutorial.org/mysql-order-by/
SELECT
contactLastname,
contactFirstname
FROM
customers
ORDER BY
contactLastname DESC;
Young Jeff
Young Julie
Young Mary
Young Dorothy
Yoshido Juri
Walker Brydey
Victorino Wendy
Urs Braun
SELECT
contactLastname,
contactFirstname
FROM
customers
ORDER BY
contactLastname DESC,
contactFirstname ASC;
Young Dorothy
Young Jeff
Young Julie
Young Mary
Yoshido Juri
Walker Brydey
Victorino Wendy
Urs Braun
⚠️ Young和Yoshido
单词是按照字母一个一个比较的,
u在s后面。
多字段排序
只有第一个字段相同,且存在多条记录, 第二个排序字段才会起作用。
例如
Young Jeff
Young Julie
Young Mary
Young Dorothy
第二个字段起作用
Young Dorothy
Young Jeff
Young Julie
Young Mary
、