Spring Boot分页操作

    com.baomidou
    mybatis-plus-boot-starter
    3.4.1

@Configuration
public class MyBatisPageConfig {

    @Bean
    public MybatisPlusInterceptor paginationInterceptor(){
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();

        //这是分页拦截器
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        paginationInnerInterceptor.setOverflow(true);
        paginationInnerInterceptor.setMaxLimit(500L);

        mybatisPlusInterceptor.addInnerInterceptor(paginationInnerInterceptor);
        return mybatisPlusInterceptor;


    }
}

UserMapper

package com.baidu.admin.mapper;

import com.baidu.admin.bean.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper extends BaseMapper {


}

这里用到userService；需要创建UserService接口和实现类

注意：由于是mybatis-plus需要继承 IService
UserService

package com.baidu.admin.service;

import com.baidu.admin.bean.User;
import com.baomidou.mybatisplus.extension.service.IService;

public interface UserService extends IService {

}

UserServiceImpl

package com.baidu.admin.service.impl;

import com.baidu.admin.bean.User;
import com.baidu.admin.mapper.UserMapper;
import com.baidu.admin.service.UserService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl extends ServiceImpl implements UserService {

}

Controller层

@Controller
public class TableController {

    @Autowired
    UserService userService;
    
    @GetMapping("/dynamic_table")
    public String dynamic_table(@RequestParam(value = "pn",defaultValue = "1")Integer pn, Model model){
    
		//这里查询全部数据
	    List list = userService.list();

        //分页查询数据
        Page userPage = new Page<>(pn,2);

        //分页查询的结果
        Page page = userService.page(userPage, null);

        long current = page.getCurrent();
        long pages = page.getPages();
        long total = page.getTotal();
        List records = page.getRecords();

        model.addAttribute("page",page);


        return "table/dynamic_table";
    }
}

这里自己找一些前端的前端的样式；大概效果就这样

   

       

           当前第 [[${page.current}]] 页 总计 [[${page.pages}]] 页 共 [[${page.total}]] 条记录
       
   

   

       

           

               
前一页
               

                   [[${num}]]
               
               
下一页