mybatis分页查询

 

方法一：1.petMapper.xml

<select id="selectAll" parameterType="Map" resultType="Pet">
		select * from pet limit #{startIndex},#{pageSize}
</select>

2.PetDao.java

public List<Pet> selectAll(int currentPage,int pageSize) throws IOException{
		SqlSession sqlSession = MyBatisUtil.getSqlSession();
		Map<String,Integer> map=new HashMap<String, Integer>();
		map.put("startIndex", (currentPage-1)*pageSize);
		map.put("pageSize",pageSize);
		List<Pet> pets=sqlSession.selectList("com.mybatis.entity.PetMapper.selectAll",map);
		return pets;
	}

3.测试类

public static List<Pet> selectAll(int currentPage,int pageSize) throws IOException {
		PetDao petDao=new PetDao();
		List<Pet> pets=petDao.selectAll(currentPage,pageSize);
		return pets;
	}

public static void main(String[] args) throws IOException, ParseException {
		PetDao petDao=new PetDao();
		List<Pet> pets=petDao.selectAll(1, 2);
		for(Pet pet:pets) {
			System.out.println(pet);
		}
	}

方法二  1.PetMapper.xml

<select id="getAll" resultType="Pet">
		select * from pet
</select>

2.PetDao.java 

public List<Pet> getAll(int currentPage,int pageSize) throws IOException{
		SqlSession sqlSession = MyBatisUtil.getSqlSession();
		RowBounds rowBounds=new RowBounds((currentPage-1)*pageSize,pageSize);
		List<Pet> pets=sqlSession.selectList("com.mybatis.entity.PetMapper.getAll",null,rowBounds);
		return pets;
	}

3.测试类

public static List<Pet> getAll(int currentPage,int pageSize) throws IOException {
		PetDao petDao=new PetDao();
		List<Pet> pets=petDao.getAll(currentPage, pageSize);
		return pets;
	}

public static void main(String[] args) throws IOException, ParseException {
		PetDao petDao=new PetDao();
		List<Pet> pets=petDao.getAll(1, 2);
		for(Pet pet:pets) {
			System.out.println(pet);
		}
	}