首页 > 编程语言 > SpringBoot如何集成PageHelper分页功能
2020
09-24

SpringBoot如何集成PageHelper分页功能

添加MyBatis的代码并修改以下部分:

1.添加MyBatisConfig

package myshop.config;

import java.util.Properties;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.github.pagehelper.PageHelper;

@Configuration
public class MyBatisConfig {
  @Bean
  public PageHelper pageHelper()
  {
    System.out.println("Use PageHelper");
    PageHelper pageHelper = new PageHelper();
    Properties p = new Properties();
    p.setProperty("offsetAsPageNum", "true");
    p.setProperty("rowBoundsWithCount", "true");
    p.setProperty("reasonable", "true");
    pageHelper.setProperties(p);
    return pageHelper;
  }
}

2.修改MyBatisController

package myshop.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.github.pagehelper.PageHelper;

import myshop.bean.UserInfo;
import myshop.service.MyBatisService;

@RestController
public class MyBatisController {
   @Autowired
   private MyBatisService myBatisService;
   
   @RequestMapping("likeName")
   public List<UserInfo> likeName(String username)
   {
     PageHelper.startPage(1,2);
     return myBatisService.likeName(username);
   }
}

3.访问地址

http://localhost:8080/likeName?username=天恒

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持自学编程网。

编程技巧