一、使用limit来分页（sql语句）

select * from user limit startIndex,pageSize
select * from user limit 0,2//从0开始查，一页显示2个数据（不包括0）
select * from user limit 3; //表示从0开始查，查到第3个数据

二、在mybits中使用（实质是sql）

1、定义接口

package dao;
import pojo.User;
import java.util.List;
import java.util.Map;
public interface UserMapper {
    List getUserList();
    List getUserBylimit(Map map);
}

2、mapper配置

<?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">



    
        
        
        
        
    

    
    
    select * from mybatis.user
  

    
        select * from mybatis.user limit #{startIndex},#{pageSize};
    

3、test测试

import dao.UserMapper;
import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.Logger;
import org.junit.Test;
import pojo.User;
import utiles.MybatisUtiles;

import java.util.HashMap;
import java.util.List;

public class Mytest {
    static Logger logger=Logger.getLogger(Mytest.class);

    public void test(){
        logger.info("进入getLogger方法成功！");
        SqlSession sqlSession= MybatisUtiles.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List list=mapper.getUserList();
        for (User user : list) {
            System.out.println(user);
        }
        sqlSession.close();
    }
    @Test
    public void test2(){
        SqlSession sqlSession=MybatisUtiles.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        HashMap map=new HashMap();
        map.put("startIndex",0);
        map.put("pageSize",2);
        List users = mapper.getUserBylimit(map);
        for (User user : users) {
            System.out.println(user);
        }
        sqlSession.close();
    }
}

三、RowBounds分页