【Java】Mybatis框架学习 vol7分页与RowBounds

分页与RowBounds

视频参考:

https://www.bilibili.com/video/av69742084?p=13

为什么使用分页?
减少数据的查询量

sql语句:Limit

select * from table limit begin,size;

table -> 表名
begin -> 查询的起始位置 [从0到总记录数]
size  -> 要查询的记录个数 [大于0，超过总记录数也只能查询到总记录]

直接用Map传参

List<User> getUserByLimit(Map<String,Integer> map);
-------------------------------------------------------------------
<select id="getUserByLimit" resultMap="UserMap" parameterType="Map">
        select * from user limit #{begin},#{size};
</select>
-----------------------------------------------------------------------
@Test
public void getUserByLimit(){
    SqlSession sqlSession = MybatisUtil.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    HashMap<String,Integer> map = new HashMap<String,Integer>();
    map.put("begin",4);
    map.put("size",2);
    List<User> users = mapper.getUserByLimit(map);
    for (User user:users) {
        System.out.println(user);
    }
    sqlSession.close();
}
--------------------------------------------------------------------
User{id=5, name='老八', password='434567'}
User{id=6, name='巨魔', password='123321'}    

学了个小东西，直接记在这里吧

• 整体缩进:框住所有代码 按Tab键
• 整体缩退:框住所有代码 按左Shift+Tab键

---

使用RowBounds实现分页

在sqlSession有这样的一个方法
参数有RowBounds对象

List<User> getUserByRowBounds(); 接口方法可以不需要传参
--------------------------------------------------------------------
<select id="getUserByRowBounds" resultMap="UserMap">
    select * from user ;
</select>
--------------------------------------------------------------------
@Test
public void getUserByRowBounds(){
    SqlSession sqlSession = MybatisUtil.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    RowBounds rowBounds = new RowBounds(0,4);
    //通过代码层是实现分页，但这里也没有调用dao接口方法
    List<User> users = sqlSession.selectList("dao.UserMapper.getUserByRowBounds",null, rowBounds);
    for (User user:users) {
        System.out.println(user);
    }
    sqlSession.close();
}
--------------------------------------------------------------------
User{id=1, name='张三', password='123456'}
User{id=2, name='李四', password='234567'}
User{id=3, name='王五', password='345678'}
User{id=4, name='钱六', password='456789'}

最后是狂神提到的一个分页插件 PageHelper

https://pagehelper.github.io/