MyBatis中三种分页查询方式

文章目录

• 通过limit分页查询
• 通过Rowbounds
• 通过分页插件pagehelper

通过limit分页查询

mapper接口

List<User> getUserByLimit(Map<String,Integer> map);

mapper.xml

<select id="getUserByLimit" parameterType="map" resultType="com.hzy.pojo.User">
    select * from user limit #{offset},#{pageSize}
</select>

test

Map<String,Integer> map = new HashMap<String, Integer>();
map.put("offset",1);
map.put("pageSize",2);
List<User> userByLimit = userMapper.getUserByLimit(map);

通过Rowbounds

mapper接口

List<User> getUserByRowBounds(RowBounds rowBounds);

mapper.xml

<select id="getUserByRowBounds" resultType="com.hzy.pojo.User">
    select * from user
</select>

test

RowBounds rowBounds = new RowBounds(1,2);
List<User> userByRowBounds = userMapper.getUserByRowBounds(rowBounds);

通过分页插件pagehelper

pom.xml

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>4.1.6</version>
</dependency>

配置mybatis-config.xml

<plugins>
    <plugin interceptor="com.github.pagehelper.PageHelper">
        <property name="dialect" value="mysql"/>
    </plugin>
</plugins>

mapper接口

List<User> getUserByPageHelper();

mapper.xml

<select id="getUserByPageHelper()" resultType="com.hzy.pojo.User">
    select * from user
</select>

test

PageHelper.offsetPage(1,2);
List<User> userList = userMapper.getUserByPageHelper();