我已经将数据封装到list里了,如果直接显示:
<%
for(int i=0;i<list.size();i++){
out.println(list.get(i));
}但是我想分页显示,请问,代码应该如何写呢?请高手提供一个做参考,多谢
<%
for(int i=0;i<list.size();i++){
out.println(list.get(i));
}但是我想分页显示,请问,代码应该如何写呢?请高手提供一个做参考,多谢
解决方案 »
- 用jquery 写的增加行,怎么将增加的行中的数据传到后台,ssh架构
- 关于树形的实现代码,求助
- jsp跳转,如何获得URL
- HQL内连接
- (有正确答案就结帐)catch抛出的异常是在Jbuilder的控制台中显示出来吗?
- 全动态树~jsp+js+javabean+xml~ 代码<200行。
- 现在的腾讯微博模拟登录上了之后会话为什么会失效?
- 急!! jsp删除文件
- struts1.1+oracle,哪里有完整的例子,哥们刚学
- 关于numeric数据类型的问题!!急急。
- 如何测试服务器http性能和数据库MYSQL的性能,谢谢学哥们!
- 请问测试linux下某个jsp站点cpu和内存占用率代码怎么写?
* 做分页操作的工具类
* @author Administrator
*
*/
public class Page {
private int pageidid;//页数
private int prepage;//上一页
private int nextpage;//下一页
private String next;
private String pre;
private int pagesize;
private int totalRecord;
public int getTotalRecord() {
return totalRecord;
}
public void setTotalRecord(int totalRecord) {
this.totalRecord = totalRecord;
}
public int getPagesize() {
return pagesize;
}
public void setPagesize(int pagesize) {
this.pagesize = pagesize;
}
private int totalpage;
public int getTotalpage() {
return totalpage;
}
public void setTotalpage(int totalpage) {
this.totalpage = totalpage;
}
public int getPageidid() {
return pageidid;
}
public void setPageidid(int pageidid) {
this.pageidid = pageidid;
}
public int getPrepage() {
return prepage;
}
public void setPrepage(int prepage) {
this.prepage = prepage;
}
public int getNextpage() {
return nextpage;
}
public void setNextpage(int nextpage) {
this.nextpage = nextpage;
}
public String getNext() {
return next;
}
public void setNext(String next) {
this.next = next;
}
public String getPre() {
return pre;
}
public void setPre(String pre) {
this.pre = pre;
} public Page(String next, int nextpage, int pageidid,
String pre, int prepage,int totalpage) {
super();
this.next = next;
this.nextpage = nextpage;
this.pageidid = pageidid;
this.pre = pre;
this.prepage = prepage;
this.totalpage=totalpage;
}
public Page() {
super();
}
//pageid当前页,all总记录数,num为每页显示大小
public void apartPage(int pageid,int all,int num){
this.totalpage=this.computeTotal(all, num);//首先计算总页数
this.totalRecord=all;
this.setPagesize(num);
this.setPageidid(pageid);
this.setNextpage(pageid);
this.setPrepage(pageid);
this.setNext("下一页");
this.setPre("上一页");
if(pageid>1){//表示有上一页
this.setPrepage(pageid-1);
}else{
this.setPre("首页");
}
int rest=all-pageid*num;
if(rest>0){//表示有下一页
this.setNextpage(pageid+1);
}else{this.setNext("尾页");}
if(this.pre.equals("首页")&&this.next.equals("尾页")){
this.setNext("");
}
}
//计算总页数
private int computeTotal(int all,int num){
int page=all/num;
page=all/num>0?page+1:page;
setTotalpage(page);
return this.totalpage;
}
}
private static final int PAGE_SIZE = 2;
%><%
String strPageNo = request.getParameter("pageno");
int pageNo = 1;
if(strPageNo != null) {
pageNo = Integer.parseInt(strPageNo);
}
if(pageNo < 1) pageNo = 1;
%><%
//get all the users
List<SalesOrder> orders = new ArrayList<SalesOrder>();
int totalRecords = OrderMgr.getInstance().getOrders(orders, pageNo, PAGE_SIZE);int totalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
if(pageNo > totalPages) pageNo = totalPages;
%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>Insert title here</title>
</head>
<body>
<table border="1" align="center">
<tr>
<td>ID</td>
<td>username</td>
<td>addr</td>
<td>odate</td>
<td>status</td> <td></td>
</tr>
<%
for(Iterator<SalesOrder> it = orders.iterator(); it.hasNext(); ) {
SalesOrder so = it.next();
%>
<tr>
<td><%=so.getId() %></td>
<td><%=so.getUser().getUsername() %></td>
<td><%=so.getAddr() %></td>
<td><%=so.getODate() %></td>
<td><%=so.getStatus() %></td>
<td>
<a href="OrderDetailShow.jsp?id=<%=so.getId()%>" target="detail">订单明细</a>
<a href="OrderModify.jsp?id=<%=so.getId()%>" target="detail">订单修改</a>
</td>
</tr>
<%
}
%>
</table>
<center>
第<%=pageNo %>页
共<%=totalPages %>页
<a href="OrderList.jsp?pageno=<%=pageNo-1 %>">上一页</a>
<a href="OrderList.jsp?pageno=<%=pageNo+1 %>">下一页</a>
<a href="OrderList.jsp?pageno=<%=totalPages %>">最后一页</a>
</center>
servlet>
<servlet-name>InitServlet</servlet-name>
<servlet-class>servlet.InitServlet</servlet-class>
<init-param>
<param-name>dbUrl</param-name>
<param-value>/WEB-INF/db.mdb</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet> <servlet-mapping>
<servlet-name>InitServlet</servlet-name>
<url-pattern>/InitServlet</url-pattern>
</servlet-mapping>
class page{
int currentPage;//当前页
int maxResults;//本页记录数
}找个数据库分页算法
参数点击分页时搞个form提交过去分页算法晚上一大堆
不过还是建议你把对数据库的操作不要写到jsp中,这样耦合性太强了