分页插件

 
        
  
   com.github.pagehelper
  
        
  
   pagehelper
  
        
  
   4.1.4
  
      
 

public List
 
   demo() throws Exception{
        //第一个参数为 第几页 第二个为每页大小
        PageHelper.startPage(20,2);
        //按什么排序
        PageHelper.orderBy("CREATE_TIME DESC");
        //分页 只分页第一个select
        List
  
    serviceProviderParameterList=serviceProviderFunctionMapper.selectAll(null); PageInfo
   
     pageInfo=new PageInfo
    
     (serviceProviderParameterList); System.out.println(serviceProviderParameterList.size()); System.out.println(JSON.toJSONString(pageInfo)); return serviceProviderParameterList; }
    
   
  
 

{"endRow":2,"firstPage":1,"hasNextPage":true,"hasPreviousPage":false,"isFirstPage":true,"isLastPage":false,"lastPage":3,"list":[{"createTime":1510376118000,"functionId":"201711031132506643378881501","hopeState":"审核中","serviceProviderFunctionId":"201711111255176254104118523","serviceProviderFunctionState":"未开启","serviceProviderId":"201710101543313668118756668"},{"createTime":1510364592000,"functionId":"201711031132506385623368425","hopeState":"审核中","serviceProviderFunctionId":"201711110943119732611472061","serviceProviderFunctionState":"未开启","serviceProviderId":"201710101543313668118756668"}],"navigatePages":8,"navigatepageNums":[1,2,3],"nextPage":2,"orderBy":"CREATE_TIME DESC","pageNum":1,"pageSize":2,"pages":3,"prePage":0,"size":2,"startRow":1,"total":6}


total是总条数
list放的是数据