limit (pageSize-1)*每页显示的个数,每页显示的个数
SELECT id,NAME,typename,health,love,birthday FROM pet
WHERE owner_id=(SELECT id FROM petowner WHERE NAME=?)
ORDER BY id ASC LIMIT ? ,?";
DaoImpl层
1 public class PetDaoImpl extends BaseDao implements IPetDao { 2 3 /** 4 * 根据宠物主人查询其拥有的宠物信息 5 * @param name 宠物主人姓名 6 * @return List<Pet> 7 */ 8 @Override 9 public List<Pet> getPetByPoname(String poname,int startCount, int pageSize) { 10 // TODO Auto-generated method stub 11 List<Pet> petList = new ArrayList<Pet>(); 12 Pet pet = null; 13 14 String sql="SELECT id,NAME,typename,health,love,birthday FROM pet WHERE owner_id=(SELECT id FROM petowner WHERE NAME=?) ORDER BY id ASC LIMIT ? ,?"; 15 Object[] params= {poname,startCount,pageSize}; 16 res=super.excuteSelect(sql, params); 17 try { 18 while(res.next()){ 19 pet=new Pet(); 20 pet.setId(res.getInt("id")); 21 pet.setName(res.getString("name")); 22 pet.setTypename(res.getString("typename")); 23 pet.setHealth(res.getInt("health"