分页:
<%
String strPageNo = request.getParameter("pageNo");
int pageNo;
if (strPageNo == null || strPageNo.trim().equals("")){
pageNo = 1;
}else{
pageNo = Integer.parseInt(strPageNo);
if(pageNo<=0) pageNo = 1;
}
int pageSize = 3;
int startPos = (pageNo-1)*pageSize;
%>
ResultSet rsCount = stmt.executeQuery("select count(*) from article where pid = 0");
rsCount.next();
int totalRecords = rsCount.getInt(1);
int totalPages = totalRecords%pageSize==0 ? totalRecords/pageSize : totalRecords/pageSize+1;
if(pageNo>totalPages){
pageNo = totalPages;
}
String sql = "select * from article where pid = 0 order by pdate desc limit " + startPos + "," + pageSize;
<%
String strPageNo = request.getParameter("pageNo");
int pageNo;
if (strPageNo == null || strPageNo.trim().equals("")){
pageNo = 1;
}else{
pageNo = Integer.parseInt(strPageNo);
if(pageNo<=0) pageNo = 1;
}
int pageSize = 3;
int startPos = (pageNo-1)*pageSize;
%>
ResultSet rsCount = stmt.executeQuery("select count(*) from article where pid = 0");
rsCount.next();
int totalRecords = rsCount.getInt(1);
int totalPages = totalRecords%pageSize==0 ? totalRecords/pageSize : totalRecords/pageSize+1;
if(pageNo>totalPages){
pageNo = totalPages;
}
String sql = "select * from article where pid = 0 order by pdate desc limit " + startPos + "," + pageSize;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货