/**
* 分页列出所有产品,并返回总页数
* @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;
}