前后端遇到的分页那些坑
1)后端pagehelper的jar包,竟可以排序PageHelper.startPage(pageNum, pageSize);
2)请求路径中的入参pageSize(常取10)
3)请求路径中的入参pageNum(常取1)
4)前端用户体验,决定了功能切换时入参pageNum要归1
5)排序另外也可以在sql里进行拼接实现
附1:service
import com.github.pagehelper.PageHelper;
@Service
public class AppsystemService {
@Autowired
private AppsystemMapper appsystemMapper;
public PageInfo<AppsystemEntity> getAppsystemList(int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<AppsystemEntity> list = appsystemMapper.getSystemList();
PageInfo<AppsystemEntity> pageInfo =new PageInfo<>(list);
return pageInfo;
}
}
附2:controller
@RestController
@RequestMapping("/api")
public class AppsystemController {
@Autowired
private AppsystemService appsystemService;
@LogAnnotation(type = Constants.LOG_TYPE_SELECT,value = "获取子系统信息列表")
@GetMapping(value = "/appsystem")
@ApiOperation(value="获取子系统信息列表", notes="获取所有数据")
public ResponseEntity<Object> getAppsystemAll
(@RequestParam(value="pageNum", defaultValue="1") int pageNum,
@RequestParam(value="pageSize", defaultValue="10") int pageSize) {
PageInfo<AppsystemEntity> list = appsystemService.getAppsystemList(pageNum,pageSize);
return new ResponseEntity<>(list, HttpStatus.OK);
}
}