给ligerui分页。

来源：互联网发布：免费硬盘数据恢复软件编辑：程序博客网时间：2024/06/01 09:46

给ligerui分页。

使用到的知识：ligerui mybatis

页面代码如下：

$("#PUAdetailGrid").ligerGrid({
            columns: [
                      { display: '日期', name: 'first', align: 'left',width:'8%'} ,
                      { display: '来源产品', name: 'appNameFrom',width:'8%'},
                      { display: '目的产品', name: 'appName',width:'8%'},
                      { display: '漫游次数', name: 'roamcnt',width:'11%',render: datashow},
                      { display: '漫游用户数', name: 'roamuser',width:'11%',render: datashow}
                  ],
            url: "/admin/vapproam/pUAApproamGrid.do?bytype="+bytype+"&rd="+rd

+"&start_date="+start_date+"&end_date="+end_date+"&appKey="+prodid+"&appNameFrom="+prodid2,
            ajaxType:"post",
            width: '99.9%',
            height: '260',
            checkbox: false,
            usePager: true,//支持分页
            //newPage: ${pageNo}, pageSize: ${pageSize},
            pageSizeOptions:[5,10,20,40,60,80,100],
            pageParmName:'pageNo', pagesizeParmName:'pageSize',

sortnameParmName:'sortName',sortorderParmName:'sortOrder',
            dataAction:'server',dateFormat:'yyyy-MM-dd HH:mm:ss', usePager: true
        });

        }
    });

然后后台返回的是一个json字符串。
还要注意的是在mybatis中写的sql代码：
获取参数：
String bytype = request.getParameter("bytype") ;
        String start_date = request.getParameter("start_date") ;
        String end_date = request.getParameter("end_date") ;
        String appKey = request.getParameter("appKey") ;
        String appNameFrom = request.getParameter("appNameFrom") ;
        int pageSize = reqInfo.getIntParameter("pageSize");//每页显示多少
       int pageNo = reqInfo.getIntParameter("pageNo", Constants.DEFAULT_PAGE_NO);

        Map<String,Object> params = new HashMap<String,Object>();
        params.put("type", bytype);
        params.put("start_date", start_date);
        params.put("end_date", end_date);
        params.put("appKey", appKey);
        params.put("appNameFrom", appNameFrom);
        params.put("pageNo", pageNo);
        params.put("pageSize", pageSize);
        Map<String,Object> responseData = vapproamService.pUAApproamGrid(params);
        AjaxResponseUtil.returnData(response, "json", responseData);

mybatis sql语句：
<select id="getAccountTypes" resultMap="VAcctTypeResult" parameterClass="java.util.Map" >
    SELECT *
    FROM T_UMS_STAT_V_ACCTTYPE
    WHERE STAT_DATE <![CDATA[ >= ]]>#geStatDate:VARCHAR#
    ORDER BY STAT_DATE DESC
    LIMIT #start:INTEGER#,#end:INTEGER#
</select>

0 0