方法一: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);
}
}