mybatis 实现分页的几种方法

SELECT * FROM table LIMIT stratIndex，pageSize
#列子#<1>检索记录为1到10行数据，下标是从0开始的select * from user limit 0,10;#<2>limit 只给一个参数表示从0开始到参数值的记录数，下面的语句相当于limit 0,5select * from user limit 5;

//实现分页操作List<User> getUserList1(Map<String,Object> map);

<select id="getUserList1" parameterType="map" resultMap="resultmap">        select * from user limit #{startindex},#{pagesize}</select>

 @Test    public void testGetUserList(){        SqlSession sqlSession = MysqlUtil.getSqlSession();        UserMapper mapper = sqlSession.getMapper(UserMapper.class);        Map<String, Object> map = new HashMap<String, Object>();        map.put("startindex",0);        map.put("pagesize",2);        List<User> userList1 = mapper.getUserList1(map);        for(User user:userList1){            System.out.println(user);        }    }

User{id=1, name='张三', password='322334'}User{id=2, name='李四', password='123456'}

//通过RowBounds 方法实现分页    List<User> getUserListByRowBounds();

 <select id="getUserListByRowBounds" resultType="user" resultMap="resultmap">        select * from user;    </select>

  @Test    public void getUserByRowBounds(){        SqlSession sqlSession = MysqlUtil.getSqlSession();                int currPage =1; //当前页        int pageSize = 2; //每页大小        RowBounds rowBounds = new RowBounds((currPage-1)*pageSize,pageSize);        ////通过session.**方法进行传递rowBounds，[此种方式现在已经不推荐使用了]        List<User> userList = sqlSession.selectList("com.xiezhr.dao.UserMapper.getUserListByRowBounds", null, rowBounds);        for(User user:userList){            System.out.println(user);        }        sqlSession.close();
    }

User{id=1, name='张三', password='322334'}User{id=2, name='李四', password='123456'}