easyui datagrid

1.Datagrid实现添加查询参数，翻页功能1.1.初始化表格Html<div region="center" border="false" style="padding:0px 3px 0px 3px;margin:0px;"><table id="test"></table></div>Script初置化gird$(function(){loadgrid();//loadcombobox(null);});function loadgrid(){$('#test').datagrid({title:'任免信息列表',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:'任免批次编号',width:200,sortable:true},{field:'batch_name',title:'任免批次名称',width:240,sortable:true},{field:'batch_no',title:'任免批次编号',width:100,sortable:true},{field:'recorder_date',title:'登记时间',width:120,sortable:true},{field:'recorder_id',title:'登记人',width:100,sortable:true},{field:'state',title:'状态',width:100,sortable:true},{field:'memo',title:'备注',width:300}]],pagination:true,pageNumber:1,pageSize:5,pageList:[5,10],//singleSelect:true,rownumbers:true});}1.2.效果图当点击分页控件的按钮时，会根据绑定的url，向服务器发送请求,1.3.服务端接收rows、page、order、sort参数参数名称是easyui起的，值也是自动绑定可以在服务端通过request.getParameterNames();查看有什么参数接收参数值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();}然后拼装sql语句实现分页。

1.4.增加查询参数，重新加载表格function reloadgrid (stateVal) {//查询参数直接添加在url中/* var url =$('#test').datagrid('options').url;url ="http://127.0.0.1:8080/web/AppAndRemoveServer.server?state="+stateVal;//重新赋值url 属性$('#test').datagrid('options').url=url;$("#test").datagrid('reload');*///查询参数直接添加在queryParams中var queryParams = $('#test').datagrid('options').queryParams; queryParams.state = stateVal;$('#test').datagrid('options').queryParams=queryParams; $("#test").datagrid('reload');}bobox实现google提示Hmtl<select id="appandremove_id" class="easyui-combobox"="appandremove_id" style="width:150px;" required="false" ></select>Script2.1.onChange事件中改变url，重新绑定数据function loadcombobox(inputString){var urlStr='http://127.0.0.1:8080/web/AppAndRemoveServer1.server?appandremove_i d=true&inputString=';var urlStr = null;if(inputString !=null){urlStr = urlStr +inputString；}$('#appandremove_id').combobox({//url:urlStr,valueField:'appandremove_id',textField:'appandremove_id',onChange:function (newValue, oldValue){var urlStr="http://127.0.0.1:8080/web/AppAndRemoveServer1.server?appandremove_i d=true&inputString=" + newValue;$("#appandremove_id").combobox("reload",urlStr);}});}inputString=request.getParameter("inputString").toString();2.2.服务端根据接收到的用户输入参数，模糊查询插入然后返回结果3.Datebox3.1.格式化日期格式gird 中字段{field:'appeffect_date',title:'任职生效日期',width:100,editor:'datebox',formatter :function(value,rec){return formatDate(value);}}/*将Date/String类型,解析为String类型.传入String类型,则先解析为Date类型不正确的Date,返回 ''如果时间部分为0,则忽略,只返回日期部分.*/function formatDate(v) {if (v instanceof Date) {var y = v.getFullYear();var m = v.getMonth() + 1;var d = v.getDate();var h = v.getHours();var i = v.getMinutes();var s = v.getSeconds();var ms = v.getMilliseconds();if (ms > 0)return y + '-' + m + '-' + d + ' ' + h + ':' + i + ':' + s + '.' + ms;if (h > 0 || i > 0 || s > 0)return y + '-' + m + '-' + d + ' ' + h + ':' + i + ':' + s;return y + '-' + m + '-' + d;}return '';}3.2.赋默认值、提示设置为中文//初始化指标登记时间function loaddatebox(){$('#recorder_date').datebox( {currentText : '今天',closeText : '关闭',disabled : false,required : true,missingMessage : '必填',formatter : function(value,rec){return formatDate(value);}});setdateboxDefaultValue();}function setdateboxDefaultValue(){var v = new Date();var y = v.getFullYear();var m = v.getMonth() + 1;var d = v.getDate();$("#recorder_date").val(y + '-' + m + '-' + d);}3.3.Dd。