JAVA-springboot 集成 pagehelper分页插件多个字段排序

springboot 集成 pagehelper分页插件

pom

		<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.5</version>
        </dependency>

yml

#mysql
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql
#sqlserver
pagehelper:
  helperDialect: sqlserver
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

		//只需要在查询的方法前 插入PageHelper.startPage() 就会自动分页
		public Result getDraftEntry(int page,int size, int userId){

		//下面的第三个参数为固定写法，"要排序的属性 正序还是倒叙"
        //如果多个字段排序，逗号隔开，注意字段必须是数据库中的字段
        PageHelper.startPage(page,size,"approve_state desc , id desc");
        List<DictionaryEntry> list = dictionaryEntryService.findEntryByCreatorId(userId);

        return list.size()>0?Result.success("查询成功",list):Result.success("查询到0条",list);

    }