方式一:采用map映射的方式进行分页
接口方法:
//limit查询用户 List<User> getUserByLimit(Map<String,Object> map);
xml文件:
<!--limit查询--> <select id="getUserByLimit" resultMap="UserMap" parameterType="map"> select * from mybatis.user limit #{startIndex},#{pageSize}; </select>
使用parameterType="map",在测试时用map传入对应的key:startIndex、pageSize所对应的value,实现分页查询。
测试:
public void testGetUserByLimit(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); HashMap<String, Object> map = new HashMap<String, Object>(); map.put("startIndex",1); map.put("pageSize",3); List<User> userList = mapper.getUserByLimit(map); for (User user : userList) { System.out.prin