排序-Pageable

最新推荐文章于 2024-11-01 09:27:55 发布

jupiter_888

最新推荐文章于 2024-11-01 09:27:55 发布

阅读量842

点赞数

本文链接：https://blog.youkuaiyun.com/jupiter_888/article/details/103853147

版权

    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后面。