springboot分页且本表或引用其他表的多字段排序查询

 1、本表多字段排序分页

ybsjlgsszRepository.findAllByQjId(qjId, PageRequest.of(page - 1, size, Sort.Direction.ASC, "bylc", "sylc"))

 2、引用其他表的多字段排序分页，用hql来实现

首先通过navicat来测试原生态的sql语句

SELECT a.* FROM "PUNISHER_GZMBNRGL" a INNER JOIN "PUNISHER_GZMBGL" b on a.ZT_ID=9 AND a.GZMBGL_ID=b.id ORDER BY  b.CODE ASC,a.XH asc;

最后把原生态的sql语句写成hql语句

@Query("select a from punisher.Gzmbnrgl a inner join punisher.Gzmbgl b on a.ztId=:ztId and a.gzmbglId=b.id order by b.code asc,a.xh asc")
List<Gzmbnrgl> findAllByZtId(@Param("ztId") int ztId, Pageable pageable);

在Controller调用即可

 

 

参考链接：https://blog.csdn.net/zyp1376308302/article/details/81213595?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param