使用Mybatis如何对Mysql进行分页功能？

电玩女神 2023-10-03 15:51 55阅读 0赞

## 使用Mybatis如何对Mysql进行分页功能 ##

### 1、Limit实现分页 ###

接口

//分页
        List<User> getUserByLimit(HashMap<String, Integer> map);

Mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    
    <mapper namespace="com.kk.dao.UserMapper">
    
    
        <resultMap id="UserMap" type="User">
    
    
    
            <result column="pwd" property="password"></result>
        </resultMap>
        
        
        <select id="getUserById" parameterType="int" resultMap="UserMap" >
            select * from mybatis.user where id = #{id};
        </select>
    
    
    
        <select id="getUserByLimit" parameterType="map" resultMap="UserMap">
                select * from mybatis.user limit #{startIndex},#{pageSize};
        </select>
    
    
    </mapper>

测试

//分页
        @Test
        public void getUserByLimit() {
        
            SqlSession sqlSession = MybatisUtil.getSqlSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            HashMap<String, Integer> map = new HashMap<String,Integer>();
            map.put("startIndex",0);
            map.put("pageSize",2);
    
          List<User> userList= mapper.getUserByLimit(map);
    
            for (User user : userList) {
        
                System.out.println(user);
            }
    
            sqlSession.close();
        }

### 2、RowBounds实现分页 ###

不使用SQL实现分页

接口

//分页2
    List<User> getUserByRowBounds();

Mapper.xml

<select id="getUserByRowBounds" resultMap="UserMap">
        select * from mybatis.user
    </select>

测试

//分页2
    @Test
    public void getUserByRowBounds(){
        
        SqlSession sqlSession = MybatisUtil.getSqlSession();
    
        //RowBound实现
        RowBounds rowBounds = new RowBounds(1, 2);
    
        //通过Java层面实现分页
        List<User> userList = sqlSession.selectList("com.kk.dao.UserMapper.getUserByRowBounds",null,rowBounds);
    
        for (User user : userList) {
        
            System.out.println(user);
        }
    
        sqlSession.close();
    }

### 3.分页插件 （mybatis pagehelper） ###

了解即可