[img]http://dl.iteye.com/upload/attachment/601004/6652a741-baf1-30cb-a26e-9923d920b766.jpg[/img]
实体类(feeds):主要字段
后台分页代码:
实体类(feeds):主要字段
private int pageIndex;
private int maxIndex;
后台分页代码:
List list = new ArrayList();
// 设置分页默认页码(控制上一页不越值)
if (feeds.getPageIndex() <= 1) {
feeds.setPageIndex(1);
}
// 组合查询语句(必须有一个查询条件,分页条件为页码)
String querySql = "select username,snp(content,\""
+ feeds.getContent()
+ "\",\"span style='color:red'\"),`datetime`,website,is_original,reposts_num,"
+ "comments_num,score " + "from feeds where content=\""
+ feeds.getContent() + "\" " + condition + " limit "
+ ((feeds.getPageIndex() - 1) * 10 + 1) + ","
+ (feeds.getPageIndex() * 10) + ";";
// eql执行步骤并获取数据
Eql eql = new Eql();
eql.connect();
eql.select_db();
list = eql.query(querySql);
if (list.size() > 0) {
int total = Integer
.parseInt(((List) list.get(0)).get(0).toString());
feeds.setMaxIndex(total % 10 == 0 ? total / 10 : total / 10 + 1);
}
return list;
private INewsService newsService;
private List list;
private WeiboFeeds feeds = new WeiboFeeds();
public String execute() {
list = newsService.retrieve(feeds);
return SUCCESS;
}
<div
class="page_num"
style="width: 400px;"
>
<div class="page_bg">
<a
href="news.action?feeds.pageIndex=${feeds.pageIndex-1}"
class="page_font_link"
>上一页</a>
</div>
<s:iterator
var="pageIndex"
value="{0,1,2,3,4}"
>
<s:if test="feeds.pageIndex+#pageIndex <= feeds.maxIndex">
<div
class="${feeds.pageIndex != feeds.pageIndex+pageIndex ? 'page_bg2' : 'page_over_bg'}"
>
<a
href="news.action?feeds.pageIndex=${feeds.pageIndex+pageIndex}"
class="page_font_link"
>${feeds.pageIndex+pageIndex}</a>
</div>
</s:if>
</s:iterator>
<div class="page_text">
…
</div>
<div class="page_bg2">
<a
href="news.action?feeds.pageIndex=${feeds.maxIndex}"
class="page_font_link"
>${feeds.maxIndex}</a>
</div>
<%--<s:if test="feeds.pageIndex+4 < feeds.maxIndex"></s:if>
--%>
<div class="page_bg">
<a
href="news.action?feeds.pageIndex=${feeds.pageIndex >= feeds.maxIndex ? feeds.maxIndex : feeds.pageIndex+1}"
class="page_font_link"
>下一页</a>
</div>
<div class="page_text">
共${feeds.maxIndex}页
</div>
</div>
</div>