Mybatis实现分页查询

使用limit分页

接口类

//分页查询
    List<User> selectLimit(Map<String,Object> map);

Mapper.xml文件

<select id="selectLimit" parameterType="map" resultType="user">
        select * from t_user limit #{startIndex},#{pageSize}
    </select>

测试类：

public class Test {
   
    @org.junit.Test
    public void test(){
   
        //通过封装好的工具类获取SqlSession会话
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        //通过接口类型class获取接口对象实例(动态代理)
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("startIndex"<