1、UserMapper.java
List<User> getUserByLimit(Map<String, Integer> map);
2、Usermapper.xml
<select id="getUserByLimit" parameterType="map" resultType="com.wjj.pojo.User">
select * from mybatis.user limit #{startIndex}, #{pageSize}
</select>
3、测试
public void testGetUserByLimit() {
SqlSession sqlSession = MybatisUtil.sqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Integer> map = new HashMap<>();
map.put("startIndex", 1);
map.put("pageSize", 5);
List<User> userList = userMapper.getUserByLimit(map);
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}