JavaWeb中关于easyui-datagrid分页

1、创建一个easyui-datagrid的数据网格，其中formatter依次是格式化文件、日期和销售状态

<table id="dg" class="easyui-datagrid" 
        data-options="url:'showGoods',fitColumns:true,singleSelect:true,fit:true,toolbar:'#tb',pagination:true">
        <thead>
            <tr>
                <th data-options="field:'gurl',formatter:function(value,row,index){
                    return tupian(value,row,index);
                }">图片</th>
                <th data-options="field:'gid',checkbox:'true'">商品编号</th>
                <th data-options="field:'agname'">商品名称</th>
                <th data-options="field:'gprice'">商品价格</th>
                <th data-options="field:'gnum'">商品数量</th>
                <th data-options="field:'prodate',formatter: function(value,row,index){
                var prodate=new Date(value);
                    return prodate.toLocaleString();
                }">生产日期</th>
                <th data-options="field:'bzdate'">保质期</th>
                <th data-options="field:'gaddr'">生产地</th>
                <th data-options="field:'gtel'">联系电话</th>
                <th data-options="field:'gstatus',formatter: function(value,row,index){
                    return value==1?'在售中':'已下架';
                }">销售状态</th>
            </tr>
        </thead>
    </table>

2、创建Servlet用来交互代码如下

        int page = Integer.parseInt(request.getParameter("page"));//当前第几页
        int rows = Integer.parseInt(request.getParameter("rows"));//每页多少行
        PrintWriter out = response.getWriter();
        GoodsDao dao=new GoodsDaoImpl();
        try {
            PageBean pb = dao.showGoods(page,rows);
            ObjectMapper om = new ObjectMapper();//创建jackjson的对象
            om.setDateFormat(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"));//格式化日期
            String json = om.writeValueAsString(pb);//把集合转为json数据发送给页面
            out.print(json);
        } catch (Exception e) {
            e.printStackTrace();
        }
        out.close();

3、JDBC查询语句的编写

String sql = "Select * from goods where 1=1";
String pagesql="select count(1) from ("+sql+") a";
        sql += " order by gid desc limit "+(page-1)*rows+","+rows;
        ResultSet rs = MysqlJDBC.select(pagesql);
        //获取总共多少条数据
        int total=0;
        if(rs.next()){
            total = rs.getInt(1);
        }
        //利用commons返回数据
        List<Goods> gs = new BeanListHandler<Goods>(Goods.class).handle( MysqlJDBC.select(sql));
        PageBean pb = new PageBean();
        pb.setTotal(total);
        pb.setRows(gs);
        MysqlJDBC.close();
        return pb;