081114 分页显示json数据

客户端使用jquery，设置了上一页和下一页作为分页并显示总页数和当前页数，并把返回的json用div+span显示：

$.ajaxSetup({
beforeSend: function() {
$("#back").html('<img src="loading.gif">');
},
complete: function() {},
error:function(){$("#back").html('<font color="red">read data error..</font>');},
method: "post",
timeout:50000,
cache:false
});

function loaddatapage(page){
$("#detail").html('');
$.ajax({
dataType:'json',
url:"<%=request.getContextPath()%>/jiner/jiner.action",
data:"pagenum=" + page,
success:function(data){
$("#detail").append('<p style="color:white;background-color:blue;font:bold;"><span style="color:white;">金额</span><span style="color:white;">时间</span><span style="color:white;">操作员</span><span style="color:white;">所在IP</span></span></p>');
$.each(data.list,function(i,n){
$("#detail").append('<p><span>'+ data.list[i][0] + '</span><span>' + data.list[i][2] + '</span><span>' + data.list[i][1] + '</span><span>' + data.list[i][3] + '</span></p>');
})
var prepage=page-1;
var nextpage=page+1;
if(prepage<=0){prepage=1;}
if(nextpage>data.amountPage){nextpage=data.amountPage;}
$("#detail").append('<p style="background-color:#CAD7F7;"><span style="font:blod;margin-top:20px;">当前页：'+ page + '/'+ data.amountPage + '</span><span><button   style="font:12px; width:60px; height:19px;  FONT-SIZE: 12px; " onclick="loaddatapage('+ prepage +')">上一页</button><button style="font:12px; width:60px; height:19px;  FONT-SIZE: 12px; " onclick="loaddatapage('+ nextpage +')">下一页</button></span></p>');
$("#back").html('')
}
});
}

服务器端使用比较普遍的分页方式，使用hibernate+struts2：

ACTION中部分代码：

 private List list;
 private int PageSize=10,amountPage;
 private String pagenum; 

 public String list() throws Exception {
  int s = JinerManager.CountCreditDetail();
  int a = s%PageSize;
  if(a!=0){
   amountPage = s/PageSize+1;
      }else{
   amountPage = s/PageSize;
      }
  this.setAmountPage(amountPage);
  this.setPagenum(pagenum);
  this.setList(JinerManager.Find(pagenum,PageSize));
  return SUCCESS;
 }

JinerManager.Find(pagenum,PageSize)调用了service，使用hibernate的数据库分页查找数据：

 public List FindCreditDetail(String pagenum,int pagesize){
  Query queryObject = getSession().createSQLQuery("select i_add_money ,s_user_id,to_char(d_date,'yyyy-mm-dd hh24:mi:ss' ),s_ip from jiner t order by i_id desc");
  if (pagenum == null|pagenum == ""){
   queryObject.setFirstResult(0);
   queryObject.setMaxResults(pagesize);
         }else{
          try{
          Integer p = (Integer.valueOf(pagenum)-1) * pagesize;
          queryObject.setFirstResult(p);
          queryObject.setMaxResults(pagesize);
          }catch (Exception e){
           queryObject.setFirstResult(0);
           queryObject.setMaxResults(pagesize);  
          }
         }
  List result = queryObject.list();
  return result;
 }

struts2配置，使用了jsonplugin：

 <package name="jiner"  extends="json-default"  namespace="/jiner">
      <action name="jiner" class="com.pixel.websino.admin.web.action.CreditdetailAction">
        <result type="json"/>
      </action>
  </package>