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();