mybatis的分页
接口
public interface UserMapper { //分页 List<User> getUserByLimit(Map<String,Integer> map); }
对应一个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.rzk.dao.UserMapper"> <!--分页--> <select id="getUserByLimit" parameterType="map" resultMap="UserMap"> select * from mybatis.user limit #{starIndex},#{pageSize} </select> <!--因为实体和数据库的字段不一致做了结果集映射--> <resultMap id="UserMap" type="user"> <id column="pwd" property="password"></id> </resultMap> </mapper>
测试 /*分页*/ @Test public void getUserByLimit(){ SqlSession sqlSession = MybatisUtils.getSqlSessionFactory(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); Map<String, Integer> map = new HashMap<>(); map.put("starIndex",1); map.put("pageSize",2); List<User> userList = mapper.getUserByLimit(map); for (User user : userList) { System.out.println(user); } sqlSession.close(); }