}
}
iSortCol = mDataProp.get(iSortCol_0);
String sql = null;
if(sSearch.equals(""))
sql = "select * from(select id,name,age,rownum rn from dtdemo_xxx)"
+"where rn between " + iDisplayStart + " and " + (iDisplayStart+iDisplayLength)
+" order by " + iSortCol + " " + sSortDir_0;
else
sql = "select * from(select id,name,to_char(age,999) age,rownum rn from dtdemo_xxx where id like '%"
+ sSearch +"%' or name like '%"+ sSearch +"%' or age like '%"+ sSearch +"%')"
+"where rn between " + iDisplayStart + " and " + (iDisplayStart+iDisplayLength)
+" order by " + iSortCol + " " + sSortDir_0;
System.out.println(sql);
// 从数据库获取数据
List<User> listUser = Service.getInstance().getAll(sql);
//获取记录数
int size = Service.getInstance().getAll().size();
// 数据封装并返回给客户端
DataTableJSONResponse dtjs = new DataTableJSONResponse(sEcho,size,size,listUser);
JSONObject jsonObject = JSONObject.fromObject(dtjs);
response.getWriter().print(jsonObject.toString());
}
}
至此，服务端分页完成~
精彩专题分享：jquery分页功能操作 JavaScript分页功能操作
