Mybatis分页插件PageHelper的配置和简单使用方法(推荐)

LIMIT [offset,] rows

# 每页10条记录，取第一页，返回的是前10条记录
select * from tableA limit 0,10;
# 每页10条记录，取第二页，返回的是第11条记录，到第20条记录，
select * from tableA limit 10,10;

      com.github.pagehelper
      pagehelper
      4.1.4
    

<?xml version="1.0" encoding="UTF-8"?>




  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  


  
    
    
    
    
    
    
    
  

　　

@Bean(name = "moonlightSqlSessionFactory")
  @Primary
  public SqlSessionFactory moonlightSqlSessionFactory(@Qualifier("moonlightData") DataSource dataSource) throws Exception {
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis-mapper/*.xml"));
    bean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
    return bean.getObject();
  }  

<?xml version="1.0" encoding="UTF-8"?>


 
  
   
   
   
   
   
   
   
  
 
 id, name, type, `group`, geo, createTime, updateTime 
 
  select  from geoFence where 1=1
  
   and type = #{type}
  
  
   and name like concat('%', #{name},'%')
  
  
   and `group` like concat('%', #{group},'%')
  
  
   and createTime >= #{startTime}
  
  
   and createTime <= #{endTime}
  
 

List queryGeoFence(GeoFenceQueryParam geoFenceQueryParam);

@RequestMapping(value = "/fence/query", method = RequestMethod.POST)
  @ResponseBody
  public Response queryFence(@RequestBody GeoFenceQueryParam geoFenceQueryParam) {
    try {
      Integer pageNum = geoFenceQueryParam.getPageNum()!=null?geoFenceQueryParam.getPageNum():1;
      Integer pageSize = geoFenceQueryParam.getPageSize()!=null?geoFenceQueryParam.getPageSize():10;
      PageHelper.startPage(pageNum, pageSize);
      List list = moonlightMapper.queryGeoFence(geoFenceQueryParam);
      return new Response(ResultCode.SUCCESS, "查询geoFence成功", list);
    } catch (Exception e) {
      logger.error("查询geoFence失败", e);
      return new Response(ResultCode.EXCEPTION, "查询geoFence失败", null);
    }
  }

PageHelper.startPage(1, 10);
List list;
if(param1 != null){
  list = countryMapper.selectIf(param1);
} else {
  list = new ArrayList();
}

List list;
if(param1 != null){
  PageHelper.startPage(1, 10);
  list = countryMapper.selectIf(param1);
} else {
  list = new ArrayList();
}

List list;
if(param1 != null){
  PageHelper.startPage(1, 10);
  try{
    list = countryMapper.selectAll();
  } finally {
    PageHelper.clearPage();
  }
} else {
  list = new ArrayList();
}