Chinaunix首页 | 论坛 | 博客

天空从何开始hzm.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

tkchks

  • 博客访问： 2575870
  • 博文数量： 245
  • 博客积分： 4125
  • 博客等级： 上校
  • 技术积分： 3113
  • 用 户 组： 普通用户
  • 注册时间： 2009-03-25 23:56
文章分类

全部博文（245）

文章存档

2015年（2）

2014年（26）

2013年（41）

2012年（40）

2011年（134）

2010年（2）

我的朋友
最近访客
推荐博文
相关博文
spring mvc实现ajax 分页

分类： Java

2011-11-16 10:44:45

参考链接：http://www.cnblogs.com/chenping-987123/archive/2011/02/14/1954640.html

使用到的技术：
·spring 3 mvc
·json
·jquery
·java
·mysql

首先，要了解如何在spring mvc中使用json。

以下主要从Dao和View及Controller来分析：

Dao层：
  1. public List<Position> getPagePosition(int pageNum,int pageSize){        
  2.   //select * from t_position order by id desc limit (pageNum-1)*pagesize , pagesize    
  3.         List<Position> list = jdbc.query("select * from position order by id desc limit ?,? ", new Object[]{(pageNum-1)*pageSize>=0?(pageNum-1)*pageSize:0,pageSize},
  4.                 new RowMapper<Position>() {
  5.                     public Position mapRow(ResultSet rs, int rowNum)
  6.                             throws SQLException {
  7.                         return populate(rs);
  8.                     }
  9.                 }
  10.         );
  11.         return list;    
  12.     }

Controller中代码：
  1. @RequestMapping("/positionlist")
  2.     public String listPosition(Model model,
  3.             @RequestParam(value = "pagesize", required = false, defaultValue = "5") int pagesize,
  4.             @RequestParam(value = "pagenum", required = false, defaultValue = "1") int pagenum){
  5.         int recordCount = positionMgr.getAll().size();
  6.         int pageCount = (recordCount+pagesize-1)/pagesize ;
  7.         model.addAttribute("pageTitle", "Position List");
  8.         return "positionlist";
  9.     }
  10.     
  11.     @RequestMapping("/positionlistajax")
  12.     public @ResponseBody List<Position> listPositionDo(Model model,
  13.             @RequestParam(value = "pagesize", required = false, defaultValue = "5") int pagesize,
  14.             @RequestParam(value = "pagenum", required = false, defaultValue = "1") int pagenum){        
  15.         List<Position> ret = positionMgr.getPagePosition(pagenum, pagesize);
  16.         return ret;
  17.     }

View层：
  1. <script type="text/javascript">
  2.         var pageIndex = 0;
  3.         var pageSize = 5;
  4.         $(function () {
  5.            
  6.                 pageIndex = 1;
  7.                 AjaxGetData(pageIndex, pageSize);
  8.           
  9.         });

  11.         function AjaxGetData( index, size) {
  12.             $.ajax({
  13.                 url: "${pageContext.request.contextPath}/positionlistajax",
  14.                 type: "Get",
  15.                 data: "pagenum=" + index + "&pagesize=" + size,
  16.                 dataType: "json",
  17.                 success: function (json) {
  18.                     
  19.                      var html = "";
  20.                      html += "";
  21.                      html += "
    22. ";
  22.                      html += "
    23. ";
  23.                      html += "
    24. ";
  24.                 
  25.                      html += "
    26. ";
  26.                      html += "
    27. ";     
  27.                    for(position in json){
  28.                    html += "
    29. ";
  29.                    html += "
    30. ";
  30.                        html += "
    31. ";
  31.                        html += "
    32. ";
  32.                        html += "
    33. ";
  33.                        html += "
    34. ";
  34.                        html += "
    35. ";
  35.                        html += "
    36. ";
  36.                        html += "
    37. ";
  37.                
  38.                    }
  39.                    html += "
    40. ";
  40.                   
  41.                   html += "
    42. ";
  42.                   html += "
    43. ";
  43.                   html += "
    44. ";
  44.                   html += "
    45. ";
  45.                   html += "
    46. ";
  46.                   html += "
    47. Position List
    IDNameLocationNatureNumberEnd DateOperation
    "+json[position].id+""+json[position].name+""+json[position].location+""+json[position].nature+""+json[position].number+""+json[position].endDate+" Edit View
    ";
  47.                   html += "Total Records:" + ${recordCount} + "; Total Page:" +${pageCount} + "" + "";
  48.                   html += "First   ";
  49.                   html += "Pre   ";
  50.                   html += "Next   ";
  51.                   html += "Last   ";
  52.                   html += " ";
  53.                   html += "
    54. "    ;
  54.                   //alert(html);
  55.                    $('#divResult').html("");
  56.                    $('#divResult').html(html);
  57.                   
  58.                 
  59.                 },
  60.                 error: function (XMLHttpRequest, textStatus, errorThrown) {
  61.                     alert(XMLHttpRequest);
  62.                     alert(textStatus);
  63.                     alert(errorThrown);
  64.                 }
  65.             });
  66.         }
  67.         
  68.         function GoToFirstPage() {
  69.             pageIndex = 1;
  70.             AjaxGetData( pageIndex, pageSize);
  71.         }
  72.         
  73.         function GoToPrePage() {
  74.             pageIndex -= 1;
  75.             pageIndex = pageIndex >= 1 ? pageIndex : 1;
  76.             AjaxGetData( pageIndex, pageSize);
  77.         }
  78.        
  79.         function GoToNextPage() {
  80.             if (pageIndex < parseInt($("#count").text())) {
  81.                 pageIndex += 1;
  82.             }
  83.                 AjaxGetData( pageIndex, pageSize);
  84.         }
  85.        
  86.         function GoToEndPage() {
  87.             pageIndex = parseInt($("#count").text()) ;
  88.             AjaxGetData( pageIndex, pageSize);
  89.         }
  90.        
  91.         function GoToAppointPage(e) {
  92.             var page = $(e).prev().val();
  93.             if (isNaN(page)) {
  94.                 alert("Page should be a valid number");
  95.             }
  96.             else {
  97.                 var tempPageIndex = pageIndex;
  98.                 pageIndex = parseInt($(e).prev().val());
  99.                 if (pageIndex <= 0 || pageIndex > parseInt($("#count").text())) {
  100.                     pageIndex = tempPageIndex;
  101.                     alert("Please input valid page scope!");
  102.                 }
  103.                 else {
  104.                     AjaxGetData(pageIndex, pageSize);
  105.                 }
  106.             }
  107.         }
  108.     </script>

  1. <div id="divResult" ></div>







 

谢谢访问！

阅读(6919) | 评论(0) | 转发(0) |
0

上一篇：REST Web Services

下一篇：Java Overriding and Overloading

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6