Springboot整合分页插件pagehelper

首先需要有一定的springboot+mybatis的基础，才能使用顺畅

---

项目结构如下

---

---

引入依赖，springboot版本选的是2.7.16版本，jdk选的17，

---

    com.github.pagehelper
    pagehelper-spring-boot-starter
    1.4.6

---

 mapper层

---

 

@Mapper
public interface InsectDao {

   List selectAll();

}

---

 service接口层

---

public interface InsectService {

    List selectAll();

}

---

service实现类

---

@Service
public class InsectServiceImpl implements InsectService {
    @Resource
    private InsectDao insectDao;


    @Override
    public List selectAll() {
        return insectDao.selectAll();
    }
}

 

---

 controller层

---

@RestController
public class InsectController {
    /**
     * 服务对象
     */
    @Resource
    private InsectService insectService;

   @GetMapping("/insect")//分页ok了
    public PageInfo selectAll(){

       System.out.println("进来了首页");

       PageHelper.startPage(1,2);

       List list =insectService.selectAll();

       PageInfo pageInfo = new PageInfo<>(list);

       pageInfo.setList(list);

       System.out.println("看看分页"+list);

       System.out.println("看看分页1"+pageInfo);

       return pageInfo;
   }


}

---

 mapper层xml，对应mapper层的接口方法

---

    
        
        
        
        
        
        
    

    
        select  * from insect
    

---

 application核心配置文件如下

---

server:
  port: 8045

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/t155
    username: root
    password: root

  thymeleaf:
    suffix: .html
    prefix: classpath:/templates/

mybatis:
  mapper-locations: classpath:mapper/*.xml

 接下来就可以进行测试了

---

测试效果如下，输入地址进行测试，参数可以自行去了解一下，希望可以帮助各位小伙伴

---

---

 到这里就已经ok了！！