Html
<div region= "center" border= "false" style= "padding:0px 3px 0px 3px;margin:0px;" >
<table id= "test" ></table>
</div>
Initial gird of the first place
$ (function () {
Loadgrid ();
Loadcombobox (null);
});
function Loadgrid () {
$ (' #test '). DataGrid ({
Title: ' Appointment and dismissal Information List ',
fit:true,
nowrap:false,
striped:false,
Url: ' Rm.json ',
Url: ' Http://127.0.0.1:8080/web/AppAndRemoveServer.server ',
queryparams:{},
Sortname: ' appandremove_id ',
SortOrder: ' ASC ',
remotesort:false,
Idfield: ' appandremove_id ',
frozencolumns:[[
{field: ' ck ', checkbox:true}
]],
Columns:[[{field: ' appandremove_id ', title: ' Batch number ', width:200,sortable:true},
{field: ' batch_name ', title: ' Batch name ', width:240,sortable:true},
{field: ' batch_no ', title: ' Batch number ', width:100,sortable:true},
{field: ' recorder_date ', title: ' Registration time ', width:120,sortable:true},
{field: ' recorder_id ', title: ' registrant ', width:100,sortable:true},
{field: ' state ', title: ' status ', width:100,sortable:true},
{field: ' Memo ', title: ' remarks ', width:300}
]],
pagination:true,
pagenumber:1,
pagesize:5,
pagelist:[5,10],
singleselect:true,
Rownumbers:true
});
}
server receives rows, page, order, sort Parameters
The parameter name is easyui, and the value is automatically bound
Can be passed Request.getparameternames () on the service side; see what parameters
Receive parameter values
If (null!=request.getparameter ("rows")) {pagerows=integer.parseint (request.getparameter ("rows"). toString ());
}
If (null!=request.getparameter ("page")) {
Page=integer.parseint (request.getparameter ("page"). toString ());
}
If (null!=request.getparameter ("order")) {
Order=request.getparameter ("order"). toString ();
}
If (null!=request.getparameter ("sort")) {
Order=request.getparameter ("sort"). toString ();
}
Then assemble the SQL statement to implement the Paging.
Add Query parameters, Reload table
function Reloadgrid (stateval) {
Query parameters are added directly in the URL
/* var url =$ (' #test '). datagrid (' Options '). url;
url = "http://127.0.0.1:8080/web/AppAndRemoveServer.server?state=" +stateval;
Reassign URL Properties
$ (' #test '). DataGrid (' Options '). url=url;
$ ("#test"). DataGrid (' Reload ');
*/
Query parameters are added directly in Queryparams
var queryparams = $ (' #test '). DataGrid (' Options '). queryparams;
Queryparams.state = stateval;
$ (' #test '). DataGrid (' Options '). queryparams=queryparams;
$ ("#test"). DataGrid (' Reload ');
}
Queryparams of Jquery-easyui-datagrid parameters