18jqGrid - 表格数据SET类方法

这儿例子展示了grid的set方法。在多数情况下，这些方法应该与.trigger（‘relodGrid’）方法结合使用。

HTML代码举例

  
    jqGrid 实例
  
  
    ···代码省略···
    
    

    
    Set new url
    
    Set Sort to amount column
    
    Set Sort new Order
    
    Set to view second Page
    
    Set new Number of Rows(15)
    
    Set Data Type from json to xml
    ···代码省略···
  

		

javascript代码举例

$(function(){
  pageInit();
});
function pageInit(){
  jQuery("#list7").jqGrid(
      {
        url : ctx+'/JSONData',
        datatype : "json",
        colNames : [ 'Inv No', 'Date', 'Client', 'Amount', 'Tax','Total', 'Notes' ],
        colModel : [ 
                     {name : 'id',index : 'id',width : 55}, 
                     {name : 'invdate',index : 'invdate',width : 90}, 
                     {name : 'name',index : 'name',width : 100}, 
                     {name : 'amount',index : 'amount',width : 80,align : "right"}, 
                     {name : 'tax',index : 'tax',width : 80,align : "right"}, 
                     {name : 'total',index : 'total',width : 80,align : "right"}, 
                     {name : 'note',index : 'note',width : 150,sortable : false} 
                   ],
        rowNum : 10,
        rowList : [ 10, 20, 30 ],
        pager : '#pager7',
        sortname : 'id',
        viewrecords : true,
        sortorder : "desc",
        caption : "Set Methods Example",
        hidegrid : false,
        height : 210
      });
  jQuery("#list7").jqGrid('navGrid', '#pager7', {
    edit : false,
    add : false,
    del : false,
    refresh : false,
    searchtext : "Find"
  });
  jQuery("#s1").click(function() {
    jQuery("#list7").jqGrid('setGridParam', {
      url : ctx+"/JSONData?q=2"
    }).trigger("reloadGrid");
  });
  jQuery("#s2").click(function() {
    jQuery("#list7").jqGrid('setGridParam', {
      sortname : "amount",
      sortorder : "asc"
    }).trigger("reloadGrid");
  });
  jQuery("#s3").click(function() {
    var so = jQuery("#list7").jqGrid('getGridParam', 'sortorder');
    so = so == "asc" ? "desc" : "asc";
    jQuery("#list7").jqGrid('setGridParam', {
      sortorder : so
    }).trigger("reloadGrid");
  });
  jQuery("#s4").click(function() {
    jQuery("#list7").jqGrid('setGridParam', {
      page : 2
    }).trigger("reloadGrid");
  });
  jQuery("#s5").click(function() {
    jQuery("#list7").jqGrid('setGridParam', {
      rowNum : 15
    }).trigger("reloadGrid");
  });
  jQuery("#s6").click(function() {
    jQuery("#list7").jqGrid('setGridParam', {
      url : "server.php?q=1",
      datatype : "xml"
    }).trigger("reloadGrid");
  });
  jQuery("#s7").click(function() {
    jQuery("#list7").jqGrid('setCaption', "New Caption");
  });
  jQuery("#s8").click(function() {
    jQuery("#list7").jqGrid('sortGrid', "name", false);
  });
}
			

java servlet代码举例

public class JSONData extends HttpServlet {
  private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public JSONData() {
        super();
        // TODO Auto-generated constructor stub
    }

  @Override
  protected void doGet(HttpServletRequest req, HttpServletResponse resp)
      throws ServletException, IOException {
    // TODO Auto-generated method stub
    doPost(req,resp);
  }

  /**
   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
   */
  protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    String jsondata = "{\"page\":\"1\"," +
        "      \"total\":2," +
        "      \"records\":\"13\"," +
        "      \"rows\":" +
        "          [" +
        "            {" +
        "              \"id\":\"13\"," +
        "              \"cell\":" +
        "                  [\"13\",\"2007-10-06\",\"Client 3\",\"1000.00\",\"0.00\",\"1000.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"12\"," +
        "              \"cell\":" +
        "                  [\"12\",\"2007-10-06\",\"Client 2\",\"700.00\",\"140.00\",\"840.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"11\"," +
        "              \"cell\":" +
        "                  [\"11\",\"2007-10-06\",\"Client 1\",\"600.00\",\"120.00\",\"720.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"10\"," +
        "              \"cell\":" +
        "                  [\"10\",\"2007-10-06\",\"Client 2\",\"100.00\",\"20.00\",\"120.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"9\"," +
        "              \"cell\":" +
        "                  [\"9\",\"2007-10-06\",\"Client 1\",\"200.00\",\"40.00\",\"240.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"8\"," +
        "              \"cell\":" +
        "                  [\"8\",\"2007-10-06\",\"Client 3\",\"200.00\",\"0.00\",\"200.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"7\"," +
        "              \"cell\":" +
        "                  [\"7\",\"2007-10-05\",\"Client 2\",\"120.00\",\"12.00\",\"134.00\",null]" +
        "            }," +
        "            {" +
        "              \"id\":\"6\"," +
        "              \"cell\":" +
        "                  [\"6\",\"2007-10-05\",\"Client 1\",\"50.00\",\"10.00\",\"60.00\",\"\"]" +
        "            }," +
        "            {" +
        "              \"id\":\"5\"," +
        "              \"cell\":" +
        "                  [\"5\",\"2007-10-05\",\"Client 3\",\"100.00\",\"0.00\",\"100.00\",\"no tax at all\"]" +
        "            }," +
        "            {" +
        "              \"id\":\"4\"," +
        "              \"cell\":" +
        "                  [\"4\",\"2007-10-04\",\"Client 3\",\"150.00\",\"0.00\",\"150.00\",\"no tax\"]" +
        "            }" +
        "          ]," +
        "      \"userdata\":{\"amount\":3220,\"tax\":342,\"total\":3564,\"name\":\"Totals:\"}" +
        "    }";
    response.getWriter().write(jsondata);
  }

}