Springboot中MyBatisplus使用IPage和Page分頁的實例代碼

更新時間：2020年12月29日 09:49:50 作者：super_.

這篇文章主要介紹了Springboot中MyBatisplus使用IPage和Page分頁,本文通過實例代碼給大家介紹的非常詳細，對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下

一、需求：實現(xiàn)Springboot中MyBatisplus使用IPage和Page分頁

二、技術：MyBatisplus的IPage和Page

三、實現(xiàn)

1、代碼結構

2、代碼詳情

（1）Controller

package com.xkcoding.rbac.security.controller;
 
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.Map;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xkcoding.rbac.security.service.InterService;
 
@Slf4j
@RestController
@RequestMapping("/inter")
public class InterController {
	@Autowired
	private InterService interService;
 
	@GetMapping("/test")
	public IPage<Map> test() {
		Integer currentPage = 1; //當前頁數(shù)：顯示第一頁數(shù)據(jù)
		Integer pageSize = 2;  //每頁顯示多少：每頁顯示2條數(shù)據(jù)
		Page<Map> page = new Page<Map>(currentPage, pageSize);
		IPage<Map> findList = interService.findlistpage(page);
		return findList;
	}
}

（2）Service

package com.xkcoding.rbac.security.service;
 
import java.util.Map;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xkcoding.rbac.security.dao.InterDao;
import org.springframework.beans.factory.annotation.Autowired;
import lombok.extern.slf4j.Slf4j;
 
@Slf4j
@Service
public class InterService {
	@Autowired
	private InterDao interDao;
 
	public IPage<Map> findlistpage(Page<Map> page) {
		return interDao.selectMapsPage(page, null);
	}
}

（3）Dao

package com.xkcoding.rbac.security.dao;
 
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xkcoding.rbac.security.entity.Permission;
 
public interface InterDao extends BaseMapper<Permission> {
	IPage<Map> selectMapsPage(Page<Map> page, QueryWrapper<List<Map<String, Object>>> wrapper);
}

（4）XML

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http#{//mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xkcoding.rbac.security.dao.InterDao">
 
	<select id="selectMapsPage" resultType="java.util.Map" parameterType="java.util.Map">
		SELECT * FROM INTER_COLLECTION
	</select>
	
</mapper>

（5）實體類

package com.xkcoding.rbac.security.entity;
 
import lombok.Data;
 
@Data
public class Inter {
  private String id;
 
  private String interName;
  
  private String mode;
 
  private String selectStatement;
 
  private String insertStatement;
  
  private String updateStatement;
 
  private String interEnable;
 
  private String interParam;
 
  private String interType;
  
  private String tableName;
}