Springboot中MyBatisplus使用IPage和Page分頁(yè)的實(shí)例代碼
一、需求:實(shí)現(xiàn)Springboot中MyBatisplus使用IPage和Page分頁(yè)
二、技術(shù):MyBatisplus的IPage和Page
三、實(shí)現(xiàn)
1、代碼結(jié)構(gòu)

(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 {@Autowiredprivate InterService interService; @GetMapping('/test')public IPage<Map> test() {Integer currentPage = 1; //當(dāng)前頁(yè)數(shù):顯示第一頁(yè)數(shù)據(jù)Integer pageSize = 2; //每頁(yè)顯示多少:每頁(yè)顯示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@Servicepublic class InterService {@Autowiredprivate 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 resultType='java.util.Map' parameterType='java.util.Map'>SELECT * FROM INTER_COLLECTION</select></mapper>
(5)實(shí)體類
package com.xkcoding.rbac.security.entity; import lombok.Data; @Datapublic 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;}3、運(yùn)行結(jié)果

以上用到的 lombok 注解:
@Data:注解在類上;提供類所有屬性的 getting 和 setting 方法,此外還提供了equals、canEqual、hashCode、toString 方法@Slf4j:注解在類上;為類提供一個(gè) 屬性名為log 的 log4j 日志對(duì)象
到此這篇關(guān)于Springboot中MyBatisplus使用IPage和Page分頁(yè)的文章就介紹到這了,更多相關(guān)MyBatisplus使用IPage和Page分頁(yè)內(nèi)容請(qǐng)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章:
1. 編程語(yǔ)言PHP在Web開發(fā)領(lǐng)域的優(yōu)勢(shì)在哪?2. 詳解Android studio 動(dòng)態(tài)fragment的用法3. 圖文詳解vue中proto文件的函數(shù)調(diào)用4. 什么是python的自省5. 基于android studio的layout的xml文件的創(chuàng)建方式6. Spring Boot和Thymeleaf整合結(jié)合JPA實(shí)現(xiàn)分頁(yè)效果(實(shí)例代碼)7. 解決Android studio xml界面無(wú)法預(yù)覽問題8. Android如何加載Base64編碼格式圖片9. Vue封裝一個(gè)TodoList的案例與瀏覽器本地緩存的應(yīng)用實(shí)現(xiàn)10. Springboot Druid 自定義加密數(shù)據(jù)庫(kù)密碼的幾種方案

網(wǎng)公網(wǎng)安備