jquery easyui datagrid 数据绑定java版本



前端设置datagrid代码

$("#invitation").datagrid({
  width:"auto",
  height:"auto",
  nowrap: false,
  striped: true,
  //url:"datagrid_data.json",
  url:loadInvitationBysectionId, //获取数据的url 返回值为json
  sortName: "id",
  sortOrder: "desc",
  loadMsg:"数据正在加载中，请稍后……",
  remoteSort: false,
  idField:"id",
  frozenColumns:[[
            {field:"ck",checkbox:true}
  ]],
  columns:[[
   {field:"id",title:"序         号",width:40, align:"center",},
   {field:"section",title:"所在版块",width:100, align:"center",},
   {field:"nuser",title:"发帖用户",width:100, align:"center"},
   {field:"recount",title:"回复数量",width:80, align:"center",},
   {field:"title",title:"发帖标题",width:180, align:"center",formatter:function(value,row,index){
    if(value.length>10)
     return value.substring(0,10)+"...";
    else
     return value;
   }},
   {field:"content",title:"发帖内容",width:320, align:"center",formatter:function(value,row,index){
    if(value.length>25)
     return value.substring(0,25)+"...";
    else
     return value;
   }},
   {field:"idate",title:"发帖时间",width:80, align:"center",formatter:function(value,row,index){
    if(value!=null)
    {
     return new Date(value.time).format("yyyy-MM-dd");
    }
    else
     return value;
    
   }},
   {field:"clkcount",title:"点击次数",width:80, align:"center",},
   {field:"isimport",title:"是否加精",width:80, align:"center", formatter:function(value,row,index){
    return value=="1"?"是":"否";
     
   }},
   {field:"istop",title:"是否置顶",width:80, align:"center", formatter:function(value,row,index){
    return value=="1"?"是":"否";
   }},
   {field:"luid",title:"最后回复用户",width:100, align:"center",},
   {field:"ldate",title:"最后回复时间",width:100, align:"center", formatter:function(value,row,index){
    if(value!=null)
    {
     return new Date(value.time).format("yyyy-MM-dd");
    }
    else
     return value;
   }},
  ]],
  pagination:true,
  //rownumbers:true,
  toolbar:[{
   id:"btndel",
   text:"删除帖子",
   iconCls:"icon-remove",
   handler:function(){
     var id="";
     var rows = $("#invitation").datagrid("getSelections");
     if(rows.length>0)
     {
      $.messager.confirm("删除提示", "你确定要删除他们?", function(r){
      if (r){
       for(var i=0;i<rows.length;i++){
       
        id+=rows[i].id;
        id+="-"; 
       
       }
       }
      $.post(delInvitation,{id:id},function(msg){
        $.messager.alert("提示信息","数据删除成功!");
        $("#invitation").datagrid("reload");
       });
      });
     }else
     {
       $.messager.alert("提示信息","请选择要删除的数据!");
     }
   
    }
  },"-",{
   id:"btntop",
   text:"帖子置顶",
   iconCls:"icon-edit",
   handler:function(){
    var rows = $("#invitation").datagrid("getSelections");
    alert(rows.length);
    if(rows.length>0)
    {
     var id="";
     for(var i=0;i<rows.length;i++)
     {
      id+=rows[i].id;
      id+="-";
     }
     $.post(opInvitation,{id:id,op:"top"},function(data){
      $.messager.alert("提示信息","帖子置顶成功！");
      $("#invitation").datagrid("reload");
     });
    }
    else
    {
     $.messager.alert("提示信息","请选择要修改的数据!");
    }
   }
  }
  ,"-",{
   id:"btnnotop",
   text:"取消置顶",
   iconCls:"icon-edit",
   handler:function(){
    var rows = $("#invitation").datagrid("getSelections");
    if(rows.length<1)
    {
     $.messager.alert("提示信息","请选择要修改的数据!");
    }
    else
    {
     var id="";
     for(var i=0;i<rows.length;i++)
     {
      id+=rows[i].id;
      id+="-";
     }
     $.post(opInvitation,{id:id,op:"notop"},function(msg){
      $.messager.alert("提示信息","帖子取消置顶成功！");
      $("#invitation").datagrid("reload");
     });
    }
   }
  },"-",{
   id:"btnimport",
   text:"帖子加精",
   iconCls:"icon-edit",
   handler:function(){
    var rows = $("#invitation").datagrid("getSelections");
    if(rows.length<1)
    {
     $.messager.alert("提示信息","请选择要修改的数据!");
    }
    else
    {
     var id="";
     for(var i=0;i<rows.length;i++){
      id+=rows[i].id;
      id+="-";
      }
     $.post(opInvitation,{id:id,op:"import"},function(data){
      $.messager.alert("提示信息","帖子加精成功！");
      $("#invitation").datagrid("reload");
     });
    }
   }
  },"-",{
   id:"btnnoimport",
   text:"取消加精",
   iconCls:"icon-edit",
   handler:function(){
    var rows = $("#invitation").datagrid("getSelections");
    if(rows.length<1)
    {
     $.messager.alert("提示信息","请选择要修改的数据!");
    }
    else
    {
     var id="";
     for(var i=0;i<rows.length;i++){
      id+=rows[i].id;
      id+="-";
      }
     $.post(opInvitation,{id:id,op:"noimport"},function(data){
      $.messager.alert("提示信息","帖子取消加精成功！");
      $("#invitation").datagrid("reload");
     });
    }
   }
  },"-",{
   id:"btninfo",
   text:"查看详情",
   //disabled:true,
   iconCls:"icon-save",
   handler:function(){
    var rows = $("#invitation").datagrid("getSelections");
    if(rows.length<1)
    {
     $.messager.alert("提示信息","请选择要查看的数据!");
    }
    else if(rows.length>1)
    {
     $.messager.alert("提示信息","只能对一条数据查看!");
     $("#invitation").datagrid("clearSelections");
    }
    else
    {
     $.get(infoInvitation,{id:rows[0].id},function(data){
      $("#title").html(data.title);
      $("#content").html(data.content);
      $("#infoinvitation").dialog("open");
     });
    }
   }
  }]
 });
 var p = $("#invitation").datagrid("getPager");
 $(p).pagination({
   beforePageText: "第",//页数文本框前显示的汉字
   pageList: [10,15,20,25,30],//可以设置每页记录条数的列表
   afterPageText: "页    共 {pages} 页",
   displayMsg: "当前显示 {from} - {to} 条记录   共 {total} 条记录",
  onBeforeRefresh:function(){
   $("#invitation").datagrid("reload");
  }
 });

获取数据返回json 代码

public void execute()
 {
  HttpServletRequest request = ServletActionContext.getRequest();
  HttpServletResponse response = ServletActionContext.getResponse();
  String sectionid = request.getParameter("id");
  String page = request.getParameter("page");
  String pagecount = request.getParameter("rows");
  String type=request.getParameter("type");
  Page p=null;
  HttpSession session = request.getSession();
  User u = (User)session.getAttribute("user");
  Map map = new HashMap();
  if(page!=null&&pagecount!=null)
  {
   p =new Page();
   p.setPage(Integer.parseInt(page));
   p.setPageSize(Integer.parseInt(pagecount));
  }
  List<Invitation> invitationlist=null;
  Section section = null;
  if(sectionid==null)
  {
   if(type==null)
   {
    if(u.getUissectioner()!=null&&!u.getUissectioner().equals(""))
    {
     invitationlist = invitationManageService.loadAllInvitation(p,u.getUissectioner());
     map.put("total", invitationManageService.loadInvatationCountadmin(u.getUissectioner()));
    }
    else if(u.getSsid().length()==9 && (u.getUissectioner()==null||u.getUissectioner().equals("")))
    {
     invitationlist = invitationManageService.loadAllInvitation(p,"普通用户"+u.getId());
     map.put("total", invitationManageService.loadInvatationCountadmin("普通用户"+u.getId()));
    }
    else
    {
     invitationlist = invitationManageService.loadAllInvitation(p,null);
     map.put("total", invitationManageService.loadInvatationCountadmin(null));
    }
   }
   else if(type!=null&&type.equals("qian"))
   {
    invitationlist = invitationManageService.loadAllInvitation(p, null);
   }
   
  }
  else
  {
    if(type==null)
    {
    if(u.getUissectioner()!=null&&!u.getUissectioner().equals(""))
    {
     invitationlist = invitationManageService.loadInvitationBySectionId(Integer.parseInt(sectionid),p,null);
     map.put("total", invitationManageService.loadInvationCount(Integer.parseInt(sectionid),null));
    }
    else if(u.getSsid().length()==9&&(u.getUissectioner()==null||u.getUissectioner().equals("")))
    {
     invitationlist = invitationManageService.loadInvitationBySectionId(Integer.parseInt(sectionid),p,"普通用户"+u.getId());
     map.put("total", invitationManageService.loadInvationCount(Integer.parseInt(sectionid),"普通用户"+u.getId()));
    }
    else
    {
     invitationlist = invitationManageService.loadInvitationBySectionId(Integer.parseInt(sectionid),p,null);
     map.put("total", invitationManageService.loadInvationCount(Integer.parseInt(sectionid),null));
    }
   
    }else if(type!=null&&type.equals("qian"))
    {
  
     invitationlist = invitationManageService.loadAllInvitation(p, null);
    }
    section =sectionService.findSectionById(Integer.parseInt(sectionid));
  }
  List<Map> list = new ArrayList<Map>();
  if(invitationlist!=null)
  {
   for(int i=0;i<invitationlist.size();i++)
   {
    Map m = new HashMap();
    m.put("id", invitationlist.get(i).getId());
    if(sectionid!=null)
    {
     m.put("section", section.getName());
    }
    else
    {
     String str = sectionService.findSectionById(invitationlist.get(i).getSetion()).getName();
     m.put("section",str);
    }
    User user = new User();
    user = usermanageService.loadUserById(invitationlist.get(0).getNuser());
    m.put("nuser", user.getName());
    m.put("express", invitationlist.get(i).getExpress());
    m.put("recount", invitationlist.get(i).getRecount());
    m.put("title", invitationlist.get(i).getTitle());
    m.put("content", invitationlist.get(i).getContent());
    m.put("idate", invitationlist.get(i).getIdate());
    m.put("clkcount", invitationlist.get(i).getClkcount());
    m.put("isimport", invitationlist.get(i).getIsimport());
    m.put("istop", invitationlist.get(i).getIstop());
    User luser = usermanageService.loadUserById(invitationlist.get(i).getLuid());
    m.put("luid", luser.getName());
    m.put("ldate", invitationlist.get(i).getLdate());
    list.add(m);
   }
  }
  map.put("rows", list);
  JSONObject json = JSONObject.fromObject(map); 
  response.setContentType("text/json;charset=utf-8");
  
  try {
   PrintWriter out = response.getWriter();
   out.print(json);
   out.flush();
   out.close();
  } catch (IOException e) {
   e.printStackTrace();
  }
  
 }