本文共 1414 字，大约阅读时间需要 4 分钟。

思考：为什么要分页？

7.1使用limit分页

语法：select * from mybatis.user limit startIndex,pageSize;select * from mybatis.user limit 0,2;从0-2select * from mybatis.user limit 3;从0-3

使用mybatis实现分页 核心Sq

//分页    List
   
     getUserByLimit(Map
    
     map);
    
   

Mapper.Xml:

    select * from mybatis.user limit #{startIndex},#{pageSize}

测试：

@Testpublic void getUserByLimit(){
          SqlSession sqlSession = Utils.getSqlSession();       UserMapper mapper = sqlSession.getMapper(UserMapper.class);       HashMap
   
     map = new HashMap
    
     ();       map.put("startIndex",1);       map.put("pageSize",2);       List
     
       userList = mapper.getUserByLimit(map);       for (User user : userList) {
              System.out.println(user);                  }       sqlSession.close();   }
     
    
   

7.2RowBounds分页

//分页2    List
   
     getUserByRowbounds(Map
    
     map);
    
   

Mapper.Xml:

        select * from mybatis.user    

测试：

@Test        public void getUserByRowbounds(){
               SqlSession sqlSession = Utils.getSqlSession();        //Rowbounds实现            RowBounds rowBounds = new RowBounds(1, 2);            //通过java代码来实现            List
   
     userList = sqlSession.selectList("com.Dao.UserMapper.getUserByRowbounds",null,rowBounds);            for (User user : userList) {
                   System.out.println(user);            }            sqlSession.close();        }
   

转载地址：https://blog.csdn.net/answero/article/details/107075794 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！