69jqGrid层级加载时展开所有行

当行被加载时&＃xff0c;我们可以自动的展开所有的行。这样做是通过一个参数实现的。具体请查看代码。

HTML代码举例

···代码省略···

Javascript代码举例

$(function(){pageInit();
});
function pageInit(){jQuery("#sg2").jqGrid({url:ctx&＃43;&＃39;/JSONData&＃39;,datatype: "json",height: 190,colNames:[&＃39;Inv No&＃39;,&＃39;Date&＃39;, &＃39;Client&＃39;, &＃39;Amount&＃39;,&＃39;Tax&＃39;,&＃39;Total&＃39;,&＃39;Notes&＃39;],colModel:[{name:&＃39;id&＃39;,index:&＃39;id&＃39;, width:55},{name:&＃39;invdate&＃39;,index:&＃39;invdate&＃39;, width:90},{name:&＃39;name&＃39;,index:&＃39;name&＃39;, width:100},{name:&＃39;amount&＃39;,index:&＃39;amount&＃39;, width:80, align:"right"},{name:&＃39;tax&＃39;,index:&＃39;tax&＃39;, width:80, align:"right"},{name:&＃39;total&＃39;,index:&＃39;total&＃39;, width:80,align:"right"},{name:&＃39;note&＃39;,index:&＃39;note&＃39;, width:150, sortable:false}],rowNum:8,rowList:[8,10,20,30],pager: &＃39;#psg2&＃39;,sortname: &＃39;id&＃39;,viewrecords: true,sortorder: "desc",multiselect: false,subGrid: true,caption: "Custom Icons in Subgrid",// define the icons in subgridsubGridOptions: {"plusicon" : "ui-icon-triangle-1-e","minusicon" : "ui-icon-triangle-1-s","openicon" : "ui-icon-arrowreturn-1-e",//expand all rows on load"expandOnLoad" : true},subGridRowExpanded: function(subgrid_id, row_id) {var subgrid_table_id, pager_id;subgrid_table_id &＃61; subgrid_id&＃43;"_t";pager_id &＃61; "p_"&＃43;subgrid_table_id;$("#"&＃43;subgrid_id).html("

Master java servlet代码举例

package net.mn886.blog.jqgrid.loadding_data;import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;/*** Servlet implementation class JSONData*/
public class JSONData extends HttpServlet {private static final long serialVersionUID &＃61; 1L;/*** &＃64;see HttpServlet#HttpServlet()*/public JSONData() {super();// TODO Auto-generated constructor stub}&＃64;Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {// TODO Auto-generated method stubdoPost(req,resp);}/*** &＃64;see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubString jsondata &＃61; "{\"page\":\"1\"," &＃43;" \"total\":2," &＃43;" \"records\":\"13\"," &＃43;" \"rows\":" &＃43;" [" &＃43;" {" &＃43;" \"id\":\"13\"," &＃43;" \"cell\":" &＃43;" [\"13\",\"2007-10-06\",\"Client 3\",\"1000.00\",\"0.00\",\"1000.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"12\"," &＃43;" \"cell\":" &＃43;" [\"12\",\"2007-10-06\",\"Client 2\",\"700.00\",\"140.00\",\"840.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"11\"," &＃43;" \"cell\":" &＃43;" [\"11\",\"2007-10-06\",\"Client 1\",\"600.00\",\"120.00\",\"720.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"10\"," &＃43;" \"cell\":" &＃43;" [\"10\",\"2007-10-06\",\"Client 2\",\"100.00\",\"20.00\",\"120.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"9\"," &＃43;" \"cell\":" &＃43;" [\"9\",\"2007-10-06\",\"Client 1\",\"200.00\",\"40.00\",\"240.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"8\"," &＃43;" \"cell\":" &＃43;" [\"8\",\"2007-10-06\",\"Client 3\",\"200.00\",\"0.00\",\"200.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"7\"," &＃43;" \"cell\":" &＃43;" [\"7\",\"2007-10-05\",\"Client 2\",\"120.00\",\"12.00\",\"134.00\",null]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"6\"," &＃43;" \"cell\":" &＃43;" [\"6\",\"2007-10-05\",\"Client 1\",\"50.00\",\"10.00\",\"60.00\",\"\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"5\"," &＃43;" \"cell\":" &＃43;" [\"5\",\"2007-10-05\",\"Client 3\",\"100.00\",\"0.00\",\"100.00\",\"no tax at all\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"4\"," &＃43;" \"cell\":" &＃43;" [\"4\",\"2007-10-04\",\"Client 3\",\"150.00\",\"0.00\",\"150.00\",\"no tax\"]" &＃43;" }" &＃43;" ]," &＃43;" \"userdata\":{\"amount\":3220,\"tax\":342,\"total\":3564,\"name\":\"Totals:\"}" &＃43;" }";response.getWriter().write(jsondata);}}


Subgrid java servlet代码举例

package net.mn886.blog.jqgrid.advanced;import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;/*** Servlet implementation class SubGrid*/
public class SubGrid extends HttpServlet {private static final long serialVersionUID &＃61; 1L;/*** &＃64;see HttpServlet#HttpServlet()*/public SubGrid() {super();// TODO Auto-generated constructor stub}/*** &＃64;see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoPost(request,response);}/*** &＃64;see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubString id &＃61; request.getParameter("id");int iId &＃61; Integer.parseInt(id);String jsondata &＃61; "{}";switch (iId) {case 13:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"1\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 13\",\"1.00\",\"1000.00\",\"1 000.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 12:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"1.00\",\"400.00\",\"400.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 4\",\"1.00\",\"300.00\",\"300.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 11:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"4\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 1\",\"2.00\",\"100.00\",\"200.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"3.00\",\"50.00\",\"150.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"3\"," &＃43;" \"cell\":[\"3\",\"item 3\",\"1.00\",\"50.00\",\"50.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"4\"," &＃43;" \"cell\":[\"4\",\"item 4\",\"1.00\",\"200.00\",\"200.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 10:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 4\",\"1.00\",\"70.00\",\"70.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 5\",\"3.00\",\"10.00\",\"30.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 9:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 3\",\"1.00\",\"60.00\",\"60.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 6\",\"1.00\",\"140.00\",\"140.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 8:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"3\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"1.00\",\"120.00\",\"120.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 3\",\"1.00\",\"50.00\",\"50.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"3\"," &＃43;" \"cell\":[\"3\",\"item 3\",\"1.00\",\"30.00\",\"30.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 7:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 1\",\"1.00\",\"100.00\",\"100.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 5\",\"2.00\",\"10.00\",\"20.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 6:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"1\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 4\",\"1.00\",\"50.00\",\"50.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 5:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"1\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 3\",\"1.00\",\"100.00\",\"100.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 4:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 1\",\"1.00\",\"100.00\",\"100.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"1.00\",\"50.00\",\"50.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 3:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 3\",\"1.00\",\"100.00\",\"100.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 4\",\"1.00\",\"200.00\",\"200.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 2:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 1\",\"2.00\",\"20.00\",\"40.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"4.00\",\"40.00\",\"160.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;case 1:jsondata &＃61; "{" &＃43;" \"page\":\"1\"," &＃43;" \"total\":1," &＃43;" \"records\":\"2\"," &＃43;" \"rows\":[" &＃43;" {" &＃43;" \"id\":\"1\"," &＃43;" \"cell\":[\"1\",\"item 1\",\"1.00\",\"20.00\",\"20.00\"]" &＃43;" }," &＃43;" {" &＃43;" \"id\":\"2\"," &＃43;" \"cell\":[\"2\",\"item 2\",\"2.00\",\"40.00\",\"80.00\"]" &＃43;" }" &＃43;" ]" &＃43;" }";break;default:break;}response.getWriter().write(jsondata);}}