服务器之家

服务器之家 > 正文

Java实现分页的前台页面和后台代码

时间:2020-08-29 14:50     来源/作者:dKnightL

本文实例为大家分享了Java分页展示的具体代码,供大家参考,具体内容如下

先上图吧,大致如图,也就提供个思路(ps:使用了SSH框架)

Java实现分页的前台页面和后台代码

前台JSP页面

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
<%@ page language="java" contentType="text/html; charset=utf-8"
 pageEncoding="utf-8"%>
<%@taglib prefix="s" uri="/struts-tags"%> 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
 <title>数据交易猫</title>
 <script type="text/javascript">
 
 //1分页下,动态添加disable给分页按钮
 /*
 $(function(){
  var myPageId="#"+$("#hidCurrentPage").val();
  var myPageAId="#"+$("#hidCurrentPage").val()+" a";
  $(myPageAId).addClass('main-bgcolor');
  $(myPageAId).attr('href','javascript:void(0)')
  $(myPageId).addClass('disabled');
  $(myPageId).addClass('disabledControl');
 
 })
 */
 //
 $(function(){
 
 })
 //根据页数查询数据列表
 function queryRequirListByPage(i) {
  var pageNo=i;
  var sortValue=$('#hidSortValue').val();
  $.ajax({
   url:'${pageContext.request.contextPath}/bid/reAction_queryRequirListByPage.action',
   type:'POST',
   data:{
    sortValue:sortValue,
    pageNo:pageNo
   },
   success:function(datas){
    $('#requireContentDiv').html(datas);         
   },
   error:function(){
    alert("失败");
   },
   });
 }
 
 //根据下拉查询数据列表
 function selectPage(obj){
  var pageNo=obj.options[obj.selectedIndex].value;
  var sortValue=$('#hidSortValue').val();
  $.ajax({
   url:'${pageContext.request.contextPath}/bid/reAction_queryRequirListByPage.action',
   type:'POST',
   data:{
    sortValue:sortValue,
    pageNo:pageNo
   },
   success:function(datas){
    $('#requireContentDiv').html(datas);         
   },
   error:function(){
    alert("失败");
   },
   });
  }
 //根据下拉选择排序方式
 function selectSort(obj){
  var sortValue = obj.options[obj.selectedIndex].value;
  var pageNo =1;
  $.ajax({
   url:'${pageContext.request.contextPath}/bid/reAction_queryRequirListByPage.action',
   type:'POST',
   data:{sortValue:sortValue,
     pageNo:pageNo
    },
   success:function(datas){
    $('#requireContentDiv').html(datas);
 
 
   },
   error:function(){
    alert("失败");
   },
   });
  }
 
  $(document).ready(function(){
   var backSortValue=$('#backSortValue').val();
   console.log("backSortValue"+backSortValue)
   $("#category option").each(function(){
    var thisId='#'+this.id;
    var thisValue=this.value;
    if(backSortValue==thisValue){
     $(thisId).attr('selected','selected');
    }
   });
  })
 </script>
</head>
<body>
 
    <!-- 内容-->
    <div class="well">
    <!-- 标题-->
     <div class="box"><h3><span class="glyphicon glyphicon-list" ></span>需求列表</h3></div>
    <!-- 筛选条件-->
     <div class="box">
      <div class="row">
       <div class="col-xs-12">       
         <span>筛选:按</span>
         <select id="category" name="category" onchange="selectSort(this)">
          <option id="categoryTime" value="publishDatetime">最新</option>
          <option id="categoryPrice" value="price">价格降序</option>
          <input id="backSortValue" type="hidden" value="${sortValue}">
         </select>
         <hr class="mrgZero mrgTopSma"/>
       </div>
      </div>
     </div>    
    <!-- 内容-->
      <input type="hidden" name="hidCurrentPage2" id="hidCurrentPage" value="${currentPage}">
      <input type="hidden" id="hidAllPage" value="${allPage}">
      <input type="hidden" id="hidSortValue" value="${sortValue}">
      <s:iterator value="#requiList">
 
      <div class="data-down-box">
       <div class="row">
        <div class="col-xs-12">
         <h4 class="ellipsis"><a href="${pageContext.request.contextPath}/bid/bidAction_queryById?id=${id}" rel="external nofollow" onclick="reward()">${title}</a></h4>
        </div>                        
       </div>
       <div class="row mrgTopSma">
        <div class="col-xs-12 ">     
         <p class="data-provider padLeftBig sec-color ellipsis">悬赏积分:<span>${price}</span></p>
         <p class="data-intro padLeftBig ellipsis sec-color">需求描述:<span>${requirementDescription}</span></p>
        </div>   
       </div>
       <hr/> 
      </div>
 
      </s:iterator>
     <!-- 分页 -->
     <div id="rePagerDiv" class="rePagerDiv box">
      <nav>
       <ul class="pager">
 
        <!-- 判断当前页是否位1,如果不为1则显示上一页, -->
        <s:if test="1 == #currentPage"
        </s:if>
        <s:else>
        <li
         <a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" aria-label="Previous" onclick="queryRequirListByPage(${currentPage-1})">
         <span aria-hidden="true">&laquo;</span>
         </a>
        </li
        </s:else>
 
       <!-- 首页 -->       
       <li><a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="queryRequirListByPage(1)">首页</a></li>
 
       <li>
        <span><span class="main-color">${currentPage}</span>/&nbsp;${allPage}页</span>       
       </li>
 
       <!-- 尾页 -->       
       <li><a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="queryRequirListByPage(${allPage})">尾页</a></li>
 
       <!-- 判断当前页和总页数,小于则显示下一页, -->
       <s:if test="#currentPage < #allPage">
        <li>
         <a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" aria-label="Next" onclick="queryRequirListByPage(${currentPage+1})">
         <span aria-hidden="true">&raquo;</span>
         </a>
        </li>
       </s:if>
       <li>
        <span class="skipPageSpan">跳转到第&nbsp;
        <select onchange="selectPage(this)">
         <s:iterator var="lst" begin="1" end="#allPage" step="1">         
          <s:if test="%{#lst == #currentPage}">
           <option selected="selected" value="<s:property/>" ><s:property/></option
           </s:if>
           <s:else>
            <option value="<s:property/>" ><s:property/></option>
           </s:else>
         </s:iterator>                   
        </select>
        &nbsp;页
        </span>
        </li>
 
       </ul>
      </nav>
 
     </div>     
 
 
     </div>    
 
 
 
 
 <hr/>
 
</body>
</html>

action

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
//查询需求列表
public String queryRequirListByPage(){
 int pageSize=5;//每页记录
 String hql="select r from Requirement r where r.reStatus !=2 ";
 if(sortValue == null || sortValue.length() <= 0){
  hql=hql+"order by r.publishDatetime desc";
  ActionContext.getContext().put("sortValue", "publishDatetime"); //当前页码条件
  session.put("sessionReqSortValue","publishDatetime");
 }else{
 hql=hql+"order by r."+sortValue+" desc";
  ActionContext.getContext().put("sortValue", sortValue); //当前页码条件
  session.put("sessionReqSortValue",sortValue);
 }
 long icount=requirementService.countAllRe();//总记录数
 long allPage;//总页数
 //判断是否能整除,能则直接,不能则+1;
 if((icount%pageSize)==0){
  allPage=icount/pageSize;
 }
 else{
  allPage=(icount/pageSize)+1;
 }
 System.out.println("总记录:"+icount+";总页数:"+allPage+";当前页码:"+pageNo);
 List<Requirement> requiList=requirementService.queryByPage(hql, pageNo, pageSize);
 ActionContext.getContext().put("requiList", requiList);//需求列表
 ActionContext.getContext().put("icount", icount);//总记录数
 ActionContext.getContext().put("allPage", allPage);//总页数
 ActionContext.getContext().put("currentPage", pageNo); //当前页码
 session.put("sessionCurrentPage", pageNo);
 return "requireContent";
 
}

service

?
1
2
3
4
5
6
public long countAllRe() {
 return requirementDao.countAllRe();
}
 public List<T> queryByPage(String hql, int pageNo, int pageSize) {
 return requirementDao.queryByPage(hql, pageNo, pageSize);
}

dao

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
//这里可能会报错,就是直接查询数据列表(使用了SSH)
public long countAll() {
 List<?> l = getSession().createQuery("select count(*) from "
   + clazz.getSimpleName()).list();
 if (l != null && l.size() == 1 )
 {
  return (Long)l.get(0);
 }
 return 0;
}
public List<T> queryByPage(String hql, int pageNo, int pageSize) {
 return getSession()
   .createQuery(hql)
   .setFirstResult((pageNo - 1) * pageSize)
   .setMaxResults(pageSize)
   .list();
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。

标签:

相关文章

热门资讯

2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全
2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全 2019-12-26
Intellij idea2020永久破解,亲测可用!!!
Intellij idea2020永久破解,亲测可用!!! 2020-07-29
歪歪漫画vip账号共享2020_yy漫画免费账号密码共享
歪歪漫画vip账号共享2020_yy漫画免费账号密码共享 2020-04-07
最新idea2020注册码永久激活(激活到2100年)
最新idea2020注册码永久激活(激活到2100年) 2020-07-29
男生常说24816是什么意思?女生说13579是什么意思?
男生常说24816是什么意思?女生说13579是什么意思? 2019-09-17
返回顶部