/**
     * 分頁(yè)查詢 -- 順序傳參
     * @param startIndex 開始索引
     * @param pageSize 每頁(yè)條數(shù)
     * @return
     */
    List<User> findPage(int startIndex,int pageSize);

<!-- 分頁(yè)查詢-順序傳參 -->
    <select id="findPage" resultType="com.mybatisstudy.pojo.User">
        select * from user limit #{param1},#{param2}
    </select>

// 測(cè)試分頁(yè)查詢方法 -- 順序傳參
    @Test
    public void testFindPage(){
        List<User> users = userMapper.findPage(0,3);
        users.forEach(System.out::println);
    }

/**
     * 分頁(yè)查詢 -- @param傳參
     * @param startIndex 開始索引
     * @param pageSize 每頁(yè)條數(shù)
     * @return
     */
    List<User> findPage1(@Param("startIndex")int startIndex,@Param("pageSize")int pageSize);

<!-- 分頁(yè)查詢-@param傳參 -->
    <select id="findPage1" resultType="com.mybatisstudy.pojo.User">
        select * from user limit #{startIndex},#{pageSize}
    </select>

// 測(cè)試分頁(yè)查詢方法 -- @param傳參
    @Test
    public void testFindPage1(){
        List<User> users = userMapper.findPage1(3,3);
        users.forEach(System.out::println);
    }

package com.mybatisstudy.pojo;
 
public class PageQuery {
    private int startIndex;
    private int pageSize;
 
    public PageQuery(int i, int i1) {
        this.startIndex = i;
        this.pageSize = i1;
    }
 
    public int getStartIndex() {
        return startIndex;
    }
 
    public void setStartIndex(int startIndex) {
        this.startIndex = startIndex;
    }
 
    public int getPageSize() {
        return pageSize;
    }
 
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
}

/**
     * 分頁(yè)查詢 -- POJO傳參
     * @param PageQuery
     * @return
     */
    List<User> findPage2(PageQuery pageQuery);

<!-- 分頁(yè)查詢-POJO傳參 -->
    <select id="findPage2" resultType="com.mybatisstudy.pojo.User" parameterType="com.mybatisstudy.pojo.PageQuery">
        select * from user limit #{startIndex},#{pageSize}
    </select>

// 測(cè)試分頁(yè)查詢方法 -- POJO傳參
    @Test
    public void testFindPage2(){
        PageQuery pageQuery = new PageQuery(2,3);
        List<User> users = userMapper.findPage2(pageQuery);
        users.forEach(System.out::println);
    }

/**
     * 分頁(yè)查詢 -- Map傳參
     * @param Map
     * @return
     */
    List<User> findPage3(Map<String,Object> params);

<!-- 分頁(yè)查詢-Map傳參 -->
    <select id="findPage3" resultType="com.mybatisstudy.pojo.User" parameterType="map">
        select * from user limit #{startIndex},#{pageSize}
    </select>

// 測(cè)試分頁(yè)查詢方法 -- Map傳參
    @Test
    public void testFindPage3(){
        Map<String,Object> params = new HashMap<>();
        params.put("startIndex",0);
        params.put("pageSize",4);
        List<User> users = userMapper.findPage3(params);
        users.forEach(System.out::println);
    }