pagehelper oracle用法,SpringBoot集成PageHelper（Oracle数据库）

参考网页

集成步骤

Pom

com.github.pagehelper

pagehelper-spring-boot-starter

1.2.5

application.properties配置文件

########################################## pagehelper分页插件配置

pagehelper.helperDialect=oracle

pagehelper.reasonable=true

pagehelper.supportMethodsArguments=true

pagehelper.params=count=countSql

Controller

@Autowired

private UserService userService;

@RequestMapping(value = "/getUsers", method = RequestMethod.GET)

@ApiOperation(value = "查询", notes = "分页查询用户", produces = "application/json")

public PageInfo getUsers(@RequestParam(value = "jsonString") String jsonString,

HttpServletRequest request) throws Exception{

//整理参数

UserQuery query = null;

try {