mybatis：分页（逻辑、物理）

以下知识来源说明：http://www.java1234.com/

mapping

<select id="findStudents" resultMap="StudentResult" flushCache="false" useCache="true">
    select * from t_student
</select>

<select id="findStudents2" parameterType="Map" resultMap="StudentResult">
    select * from t_student
    <if test="start!=null and size!=null">
        limit #{start},#{size}
    </if>
</select>

junit测试

@Test
public void testFindStudent(){
    logger.info("查询学生");
    int offset=0,limit=3;
    RowBounds rowBounds=new RowBounds(offset,limit);
    List<Student> studentList=studentMapper.findStudents(rowBounds);
    for(Student student:studentList){
        System.out.println(student);
    }
}

@Test
public void testFindStudent2(){
    logger.info("查询学生");
    Map<String,Object> map=new HashMap<String,Object>();
    map.put("start", 3);
    map.put("size", 3);
    List<Student> studentList=studentMapper.findStudents2(map);
    for(Student student:studentList){
        System.out.println(student);
    }
}