dhtmlxGrid分页与排序

1、服务端处理的Conntllor

 

package com.snailteam.reporting.web;

import java.util.ArrayList;
import java.util.List;

import javax.annotation.Resource;
import javax.validation.Validator;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.snailteam.reporting.domain.DataSource;
import com.snailteam.reporting.domain.json.JsonRow;
import com.snailteam.reporting.domain.json.JsonTable;
import com.snailteam.reporting.service.DataSourceService;
import com.snailteam.reporting.util.PojoMapper;


/**
 * @Description:异步请求，dhtmlGrid数据的处理
 * 
 * @Author: xiaofancn
 * @Date: 2011-7-20 上午10:51:01
 * 
 */
@Controller
@RequestMapping("/ajax")
public class Ajax {
	private Logger logger = LoggerFactory.getLogger(Ajax.class);
	private Validator validator;
	@Resource
	private transient DataSourceService dataSourceService;

	@Autowired
	public Ajax(Validator validator) {
		this.validator = validator;
	}

	
	
	/**
	 * 根据页面请求的起始页和数量参数 返回json对象，spring负责将对象序列化成json
	 * 
	 * @param posStart
	 * @param count
	 * @return
	 */
	@RequestMapping(value = "/ds", method = RequestMethod.GET)
	@ResponseBody
	// JsonTable是我封装好的对象，页面dhtmlxGrid脚本能够识别的Json格式
	public JsonTable loadDataSources(Integer posStart, Integer count,
			@RequestParam(required = false) String orderby,
			@RequestParam(required = false) String dire