@RequestMapping("datagrid")public void datagrid(Model model, @ModelAttribute BeanName bean, HttpServletRequest request, HttpServletResponse response) {    bean.setOffset(bean.getRows() * (bean.getPage()-1) );//limit:start        DataGrid dataGrid = new DataGrid();    dataGrid.setRows(service.selectList(bean));//list    dataGrid.setTotal(service.selectListCount(bean));//list total count    writeJson(response, dataGrid);//对象转换成json输出}public class DataGrid {    private Long total = 0L;    private List rows = new ArrayList();        //setter...    //getter...}/** * 将对象转换成JSON字符串，并响应回前台 *  * @param object * @throws IOException */public void writeJson(HttpServletResponse response,Object object) {    try {        String json =  com.alibaba.fastjson.JSON.toJSONStringWithDateFormat(object, "yyyy-MM-dd HH:mm:ss");        response.setContentType("text/html;charset=utf-8");        response.getWriter().write(json);        response.getWriter().flush();    } catch (IOException e) {        log.debug(e.getMessage());    }}//sql:select * from table_ where 1=1 order by ${sort} ${order}  limit ${offset},${rows}/***js**/$(function(){    dg2 = $('#dg2').datagrid({        url : '/datagrid.action',        //iconCls : 'icon-save',        pagination : true,        pagePosition : 'bottom',        rownumbers : true,        pageSize : 1,        pageList : [ 20, 50, 100],        fit : true,        fitColumns : true,        nowrap : true,        border : true,        idField : '',        sortName : 'f.name',        sortOrder : 'asc',        singleSelect : true,        columns : [ [              {field:'id',title:'详情',align:'center',width:30,                 formatter:function(value,row,index){                        return '详情';                 }             },                       {field:'xbr.real_name',title:'姓名',align:'center',sortable:true,width:50,                formatter:function(value,row,index){                    if(row.bean != null)                         return row.bean.realName;                }            }         ] ],         onDblClickRow: function(rowIndex, row){                      }    });});