Limit实现分页

Dao层接口

    List<User> getUserByLimit(HashMap<String,Object> map);

UserMapper.xml

<!--    分页-->
   <select id="getUserByLimit" parameterType="map" resultType="User">
       select * from mybatis.user limit #{startIndex},#{pageSize}
   </select>

Main

    public void selectByLimit(){
       HashMap<String, Object> map = new HashMap<>();
       map.put("startIndex",0);
       map.put("pageSize",2);

       SqlSession sqlSession = myBatisUtil.getSqlSession();

       UserDao mapper = sqlSession.getMapper(UserDao.class);
       List<User> users = mapper.getUserByLimit(map);
       for (User user : users) {
           System.out.println(user);
       }

       sqlSession.close();
   }

<!--    分页-->
    <select id="getUserByLimit" parameterType="map" resultMap="userByLimit">
        select * from mybatis.user limit #{startIndex},#{pageSize}
    </select>
    <resultMap id="userByLimit" type="User">
        <result column="pwd" property="password"></result>
    </resultMap>