一个java的分页实现类

public List PageUsers(int pageSize, int currentPage) throws Exception {

  List PageUsers = new ArrayList();
  int start = (currentPage - 1)*pageSize;
  try{
  
   //sql语句一定要严密，空格不能多也不能少注意每隔单词之间，和limit后面
   String sql = "SELECT * FROM loginuser limit "+ start+","+pageSize;
  
   System.out.println(sql);
   conn = db.getConnection();
   ps = conn.prepareStatement(sql);
   rs = ps.executeQuery();
   while(rs.next())
   {
    LoginUser luser = new LoginUser(); //这个实例化一定要放在这里，开始我放到了while循环外，结果只能取得最后一条数据
    luser.setId(rs.getInt(1));
    luser.setUsername(rs.getString(2));
    luser.setPassword(rs.getString(3));
    luser.setEmail(rs.getString(4));
    luser.setSex(rs.getString(5));
    luser.setLogintime(rs.getDate(6));
    PageUsers.add(luser);//这里也是要注意，不要放到while外
   }
  }catch(Exception e)
  {
   e.printStackTrace();
  }finally{
   db.close();
  }
  return PageUsers;
 }