sql：mysql：limit分页

1.前端接收不同参数过来

2.根据不同条件拼sql

3.使用limit分页（前端要传一个pageNum和pageSize，即第几页，每页展示多少条）

4.返回结果（封装对象StringData返回前端即json格式）

如下代码参考：

controller：

/**
     * 客户服务统计接口
     * @param json
     * @return
     */
    @CrossOrigin
    @PostMapping(value = "/customerServerSearch", produces = {"application/json;charset=UTF-8"})
    public StringData customerServerSearch(@RequestBody String json) {
        StringData data = new StringData();
        Map<EnumCustomerServerQuryParam, String> quryParamMap = new HashMap();
        try {
            LogUtil.print("接收消息:   "+json);
            //解析json消息
            JSONObject jsonobj =  JSONObject.parseObject(json);
            String pageNo = jsonobj.getString("pageNo");
            String pageSize = jsonobj.getString("pageSize");
            String companyName = jsonobj.getString("companyName");
            String brand = jsonobj.getString("brand");
            String serverType = jsonobj.getString("serverType");
            String clientFrom = jsonobj.getString("clientFrom");
            String contractInto = jsonobj.getString("contractInto");
            String moneyCount = jsonobj.getString("moneyCount");
            String startTime = jsonobj.getString("startTime");
            String endTime  = jsonobj.getString("endTime");

            if (StringUtils.isNotBlank(pageNo)) {
                quryParamMap.put(EnumCustomerServerQuryParam.pageNo, pageNo);
            }
            if (StringUtils.isNotBlank(pageSize)) {
                quryParamMap.put(EnumCustomerServerQuryParam.pageSize, pageSize);
            }
            if (StringUtils.isNotBlank(companyName)) {
                quryParamMap.put(EnumCustomerServerQuryParam.companyName, companyName);
            }
            if (StringUtils.isNotBlank(brand)) {
                quryParamMap.put(EnumCustomerServerQuryParam.brand, brand);
            }
            if (StringUtils.isNotBlank(serverType)) {
                quryParamMap.put(EnumCustomerServerQuryParam.serverType, serverType);
            }
            if (StringUtils.isNotBlank(clientFrom)) {
                quryParamMap.put(EnumCustomerServerQuryParam.clientFrom, clientFrom);
            }
            if (StringUtils.isNotBlank(contractInto)) {
                quryParamMap.put(EnumCustomerServerQuryParam.contractInto, contractInto);
            }
            if (StringUtils.isNotBlank(moneyCount)) {
                quryParamMap.put(EnumCustomerServerQuryParam.moneyCount, moneyCount);
            }
            if (StringUtils.isNotBlank(startTime)) {
                quryParamMap.put(EnumCustomerServerQuryParam.startTime, startTime);
            }
            if (StringUtils.isNotBlank(endTime)) {
                quryParamMap.put(EnumCustomerServerQuryParam.endTime, endTime);
            }

            Page results = iCalCustomerServerService.searchResult(quryParamMap);
            if(null!=results.getData() && results.getData().size()>0){
                data.success();
                data.setData(results);
            }else {
                data.dataNull();
            }
        } catch (Exception e) {
            // e.printStackTrace();
            LogUtil.error(DateUtil.fmtDateToStr(new Date(),"yyyy-MM-dd HH:mm:ss")+"http接口异常",e.getMessage(),e);
            data.error();
        }
        return data;
    }

 

service：

@Override
    public Page searchResult(Map<EnumCustomerServerQuryParam, String> quryParamMap) {

            String sql = "";
            //计算start、rows
            int start = 0;
            int pageNo = 1;
            int pageSize = 10;
            String companyName="";
            String