mysql jsp分页
int pg=1;if(request.getParameter("pg")!=null){
pg=Integer.parseInt(request.getParameter("pg"));
}
int size=20;//每页显示条数
ResultSet rs=db.executeQuery("select * from p_web where Title like'%"+keyword+"%' and State='finished' order by SortID limit "+(pg-1)*size+","+size);
// 计算总的记录条数
ResultSet rs3 = db.executeQuery("select count(*) from p_web where Title like'%"+keyword+"%' and State='finished' order by SortID");
int total =0;
if (rs3.next()) {
total = rs3.getInt(1);
}
// out.print(total+"<br>");
//总页数
int pgsize=0;
pgsize=(total/size)+((total%size)>0?1:0);
// out.print(pgsize);
%><br>
<%if(pg!=1){ %>
<A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=1">首页</A>
<A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pg>1?pg-1:1%>">上页</A>
<%}else{out.print("首页 上页");} %>
<%if(pg!=pgsize){ %>
<A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pg<pgsize?pg+1:pgsize%>">下页</A>
<A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pgsize%>">尾页</A>
<%}else{out.print("下页 尾页");} %>
第<%=pg%>页/共<%=pgsize%>页</A>
页:
[1]