Springboot集成pagehelper-spring-boot-starter
1.添加依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.3</version>
</dependency>
2.application.yml配置
# pagehelper配置
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
3.使用
import com.cs.myops.conmon.R;
import com.cs.myops.pojo.Secret;
import com.cs.myops.service.SecretService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
@RestController
@RequestMapping("/secret")
@Slf4j
public class SecretController {
@Autowired
private SecretService secretService;
@GetMapping
public R<PageInfo<Secret>> getList(HttpServletRequest request,
@RequestParam(value = "query") String title, Integer pageNum, Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
int uid = (Integer) request.getSession().getAttribute("uid");
List<Secret> secrets = secretService.findByIdAndTitle(uid, title);
return R.success(new PageInfo<Secret>(secrets));
}
}
4.版本说明
springboot:2.7.2
pagehelper-spring-boot-starter:1.4.3