public Page findPageBySearch( Map< String, String> search, Integer page, Integer pageSize) {
PageHelper.startPage( page,pageSize) ;
//创建查询条件封装对象
Example example = new Example( Brand.class) ;
//创建where条件
Example.Criteria criteria = example.createCriteria( ) ;
if ( search != null) {
//名称不为null,则根据名称模糊查询
if( ! StringUtils.isEmpty( search.get( "name" )) ) {
criteria.andLike( "name" ,"%" +search.get( "name" ) +"%" ) ;
}
//andEqualTo等于letter
if ( StringUtils.isEmpty( search.get( "letter" )) ) {
criteria.andEqualTo( "letter" ,search.get( "letter" )) ;
}
}
Page< Brand> brands = ( Page< Brand> ) brandMapper.selectByExample( example) ;
return brands;
/**
* 复杂查询, 并且带分页
* @param search 搜索的数据
* @param page 当前页
* @param pageSize 每页显示条数
* @return
*/
@GetMapping( "/search/{page}/{pageSize}" )
public PageResult< Brand> findPageBySearch( @RequestParam Map< String,String> search,
@PathVariable( "page" ) Integer page,
@PathVariable( "pageSize" ) Integer pageSize) {
Page pageBySearch = brandService.findPageBySearch( search, page, pageSize) ;
System.out.println( "+++++++++" +pageBySearch) ;
PageResult< Brand> pageResult = new PageResult<> ( pageBySearch.getTotal( ) ,pageBySearch.getResult( )) ;
return pageResult;
}