分页
1.使用Limit分页
select * from database limit startIndex, pageSize;
select * from database limit 3; #[0,3]
使用mybatis实现分页:
1.接口
List<DataBase> getDataBaseByLimit(Map<String,Integer> map);
2.mapper
<select id="getDataBaseByLimit" parameterType="map" resultMap="DataBase">
select * from DataBase limit #{startIndex}, #{pageSize}
</select>
3.测试
@Test
public void SubjectByLimit(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Integer> map = new HashMap<String, Integer>();
map.put("startIndex", 0);
map.put("pageSize", 2);
List<Subject> subjectList = userMapper.getSubjectByLimit(map);
for(Subject subject : subjectList){
System.out.println(subject);
}
sqlSession.close();
}