包结构
mapper接口类
List<User> getBylimit(HashMap<String, Integer> map);
mapper映射
<mapper namespace="com.itheima.mappers.UserMapper">
<select id="getBylimit" parameterType="map" resultType="hello">
select * from mybatis.t_customer limit #{startIndex},#{pageSize}
</select>
</mapper>
测试方法
@Test
public void bylimit(){
SqlSession sqlSession = MybatisUtils.getSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Integer> map = new HashMap<String, Integer>();
map.put("startIndex",0);
map.put("pageSize",3);
List<User>userList = mapper.getBylimit(map);
for (User user:userList){
System.out.println(user);
}
}