Mysql的分页limit (startNum从0开始,pageSize) limit 1即查询最新的一条(相当于limit（0,1）)

//private Integer startNum;//开始记录号private Integer pageNo;//当前页码private Integer pageSize = 20;//默认每页显示20条记录private Integer totalCount;//是从数据库差的总记录数private Integer totalPages;//总页数(totalCount - 1) / pageSize +1;private List<User> result = Lists.newArrayList();

public Resp getAccountList(HttpServletRequest request) {    String customerId = param(request, "customerId");    int pageNo = Integer.valueOf(param(request, "pageNo"));    int pageSize = 20;    //根据pageNo计算startNum    int startNum = (pageNo - 1) * pageSize;    //调用会客partal提供的查询总记录数的接口(入参userId)    //调用会客partal提供的查询list的接口(入参startNum, pageSize, customerId)    String url1 = portalUrl + "huike_getAccount?customerId=" + customerId;    String url2 = portalUrl + "huike_getAccountList?customerId=" + customerId + "&pageSize=" + pageSize + "&startNum=" + startNum;    int totalCount = 0;    String res = null;    try {        String result1 = HttpUtils.get(url1);        String result2 = HttpUtils.get(url2);        HashMap hashMap1 = JSON.parseObject(result1, HashMap.class);        HashMap hashMap2 = JSON.parseObject(result2, HashMap.class);        if (Integer.valueOf(hashMap1.get("code").toString()) == 2) {            totalCount = Integer.valueOf(hashMap1.get("result").toString());        }        if (Integer.valueOf(hashMap2.get("code").toString()) == 2) {            res = hashMap2.get("result").toString();        }    } catch (Exception e) {        logger.error("接口调用异常", e);    }    int totalPages = (totalCount - 1) / pageSize + 1;    List<User> list = JSON.parseArray(res, User.class);