jsp:
function loadData(param){
grid = $("#maingrid4").ligerGrid({
columns: [
{ display: 'ID', name: 'id', align: 'left', width:239 },
{ display: '用户名', name: 'uname', width: 100 },
{ display: '真实姓名', name: 'rlname', width: 100 },
{ display: '注册时间', name: 'addtime', width: 100,align:'left',format: 'yyyy年MM月dd', },
{ display: '是否启用', name: 'sfqy', width: 100},
{
display: '角色操作', isAllowHide: false,width: 100,
render: function (row) {
var html = '<a href="javascript:openUR(\''+row.id+'\')">修改角色</a>';
return html;
}
},
{
display: '编辑操作', isAllowHide: false,width: 100,
render: function (row) {
var html = '<a href="javascript:up(\''+row.id+'\')">编辑</a>';
return html;
}
},
{
display: '删除操作', isAllowHide: false,width: 100,
render: function (row) {
var html = '<a href="javascript:delDate(\''+row.id+'\')">删除</a>';
return html;
}
}
],
dataAction : 'server',
url:'<%=path%>/zw/queryDataLimit?param='+param,
width: '100%',
height:'90%',
sortName : 'id',
pageSize : 2,
usePager:true,
rownumbers : true,
heightDiff : -6,
pageSize:20,
pageSizeOptions:[20]
});
}
server:
setParam(request, response);
int page = Integer.parseInt(request.getParameter("page"));
int pagesize = Integer.parseInt(request.getParameter("pagesize"));
//进行排序
String sortname = request.getParameter("sortname");
String sortorder = request.getParameter("sortorder");
StringBuffer sql = new StringBuffer();
StringBuffer sqlCount = new StringBuffer();
sql.append("select * from zw_user where 1=1");
sqlCount.append("select count(*) num from zw_user where 1=1");
if(null != param){
if(param.containsKey("uname")){
if(!param.getString("uname").trim().equals("")){
sql.append(" and uname like '%"+param.getString("uname").trim()+"%'");
sqlCount.append(" and uname like '%"+param.getString("uname").trim()+"%'");}}
if(param.containsKey("rlname")){
if(!param.getString("rlname").trim().equals("")){
sql.append(" and rlname like '%"+param.getString("rlname").trim()+"%'");
sqlCount.append(" and rlname like '%"+param.getString("rlname").trim()+"%'");}}
}
sql.append(" order by "+sortname+" "+sortorder);
sql.append(" limit "+((page-1)*pagesize)+","+pagesize);
JSONArray jArray = null;
int total = 0;
jArray = jsonFace.getJsonArray(sql.toString());
total = jsonFace.getJson(sqlCount.toString()).getInt("num");
JSONObject jsonObject = new JSONObject();
jsonObject.accumulate("Rows", jArray);
jsonObject.accumulate("Total", total);
out.print(jsonObject);