MySQL JAVA 分页

/**
  * 分页列出所有产品,并返回总页数
  * @param pageNo 页码
  * @param pageSize 每页记录条数

  * @return
  */
 public int getPageCount(List<Pojo> pojos, int pageNo, int pageSize) {
  Connection conn = null;
  ResultSet rs = null;
  ResultSet rsCount = null ;      
  int pageCount = 0 ;                   //总页数
  
  //得到总页数
  try {
  conn = DB.getConn();
  rsCount = DB.executeQuery(conn, "select count(id) from tableName");
  rsCount.next();
  pageCount = (rsCount.getInt(1)+pageSize-1)/pageSize ;
  
  String sql = "select * from tableName limit "+ (pageNo-1)*pageSize + "," + pageSize;
   rs = DB.executeQuery(conn, sql);
   while(rs.next()){
    Pojo p = new Pojo();
    p.setId(rs.getInt("id"));
    p.setName(rs.getString("name"));   
    pojos.add(p);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   DB.close(rsCount);
   DB.close(rs);
   DB.close(conn);
  }
  return pageCount;  
 }