软件编程
位置:首页>> 软件编程>> java编程>> SpringBoot如何集成PageHelper分页功能

SpringBoot如何集成PageHelper分页功能

作者:玉天恒  发布时间:2022-10-22 03:18:34 

标签:Spring,Boot,Page,Helper,分页

添加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=天恒

来源:https://www.cnblogs.com/tianhengblogs/p/9539269.html

0
投稿

猜你喜欢

手机版 软件编程 asp之家 www.aspxhome.com