Springboot中MyBatisplus使用IPage和Page分頁的實例代碼
一、需求:實現(xiàn)Springboot中MyBatisplus使用IPage和Page分頁
二、技術(shù):MyBatisplus的IPage和Page
三、實現(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)前頁數(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@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)實體類
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、運行結(jié)果
以上用到的 lombok 注解:
@Data:注解在類上;提供類所有屬性的 getting 和 setting 方法,此外還提供了equals、canEqual、hashCode、toString 方法@Slf4j:注解在類上;為類提供一個 屬性名為log 的 log4j 日志對象
到此這篇關(guān)于Springboot中MyBatisplus使用IPage和Page分頁的文章就介紹到這了,更多相關(guān)MyBatisplus使用IPage和Page分頁內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章:
1. 用css截取字符的幾種方法詳解(css排版隱藏溢出文本)2. ASP.NET MVC遍歷驗證ModelState的錯誤信息3. jsp網(wǎng)頁實現(xiàn)貪吃蛇小游戲4. ASP 信息提示函數(shù)并作返回或者轉(zhuǎn)向5. CSS hack用法案例詳解6. asp中response.write("中文")或者js中文亂碼問題7. 將properties文件的配置設(shè)置為整個Web應(yīng)用的全局變量實現(xiàn)方法8. PHP設(shè)計模式中工廠模式深入詳解9. 刪除docker里建立容器的操作方法10. asp(vbs)Rs.Open和Conn.Execute的詳解和區(qū)別及&H0001的說明
