[手把手实现]springboot+mybatis整合pagehelper全流程详解

1、pom引入jar包

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent

        2.5.6
         
    
    com.re
    r
    0.0.1-SNAPSHOT
    r
    Demo project for Spring Boot
    
        11
    
    
        
            org.springframework.boot
            spring-boot-starter-web
        


        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.0
        



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



        
            org.projectlombok
            lombok
            true
        

        
            mysql
            mysql-connector-java
            runtime
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

二、application.yml配置

# DataSource Config
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/ldzy?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
    username: root
    password: root
mybatis:
  mapper-locations: classpath*:/mapper
@Mapper
public interface TeacherMapper {


    public List queryByPage(Teacher userparm);
}

六、TeacherController.java 

首先准备一个TableResult类

package com.re.r.pojo;

import lombok.Data;

import java.io.Serializable;
import java.util.List;


@Data
public class TableResult implements Serializable {
    private List rows;

    private int totalCount;

    private int pageCount;

    public void setPageCount(Integer pageSize){
        if(pageSize==null){
            return;
        }

        if(totalCount % pageSize==0){
            this.pageCount=totalCount/pageSize;
        }
        else
        {
            this.pageCount=totalCount/pageSize+1;
        }

    }


}

 编写TeacherController 类

@RestController
public class TeacherController {
    @Autowired
    TeacherMapper teacherMapper;
    
    @RequestMapping(value = "/getSomePerson")
    public TableResult getSomePerson(@RequestParam(value = "pageNum",defaultValue="1") int pageNum,@RequestParam(value = "tname",defaultValue="") String tname ){
        Teacher teacher=new Teacher();
        teacher.setTeaName(tname);
        PageHelper.startPage(pageNum,4);
        List list=teacherMapper.queryByPage(teacher);

        //将查询到的数据封装到PageInfo对象
        PageInfo pageInfo=new PageInfo(list);

        TableResult tableResult=new TableResult<>();
        tableResult.setRows(pageInfo.getList());
        tableResult.setTotalCount( Integer.parseInt(String.valueOf(pageInfo.getTotal())));
        tableResult.setPageCount(pageInfo.getPageSize());

        

        return tableResult;
    }

    
    private int getaaa(Integer totalCount,Integer pageSize){
        if(totalCount % pageSize==0){
            return totalCount/pageSize;
        }
        else
        {
            return totalCount/pageSize+1;
        }
    }

}

七、测试

项目结构：