Springboot中MyBatisplus使用IPage和Page分頁的實(shí)例代碼
一、需求:實(shí)現(xiàn)Springboot中MyBatisplus使用IPage和Page分頁
二、技術(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)前頁數(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)實(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分頁的文章就介紹到這了,更多相關(guān)MyBatisplus使用IPage和Page分頁內(nèi)容請(qǐng)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章:
1. 利用CSS3新特性創(chuàng)建透明邊框三角2. ASP.NET Core實(shí)現(xiàn)中間件的幾種方式3. AJAX實(shí)現(xiàn)數(shù)據(jù)的增刪改查操作詳解【java后臺(tái)】4. React優(yōu)雅的封裝SvgIcon組件示例5. 使用css實(shí)現(xiàn)全兼容tooltip提示框6. el-table表格動(dòng)態(tài)合并相同數(shù)據(jù)單元格(可指定列+自定義合并)7. .NET 中配置從xml轉(zhuǎn)向json方法示例詳解8. WML語言的基本情況9. ASP中解決“對(duì)象關(guān)閉時(shí),不允許操作。”的詭異問題……10. Python使用socket_TCP實(shí)現(xiàn)小文件下載功能
