使用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.