java分页类

package com.cloud.serviceexamine.util.pages;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

@Component
public class PageHelp {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    public PageList findAllbyPager(String sql,String sqlcount,int pagenum, int pagerow) {
        PageList pageList = new PageList();
        if (pagenum == 0) {
            pagenum = 1;
        }
        if (pagerow == 0) {
            pagerow = 30;
        }
        sql = sql + " LIMIT " + ((pagenum -1)* pagerow) + "," + pagerow;
        System.out.println(sql);
        List list = jdbcTemplate.queryForList(sql);
        Map map = jdbcTemplate.queryForMap(sqlcount);

        int TotalRows = Integer.parseInt(map.get("count").toString());
        pageList.setPage(pagenum);
        pageList.setTotalRows(TotalRows);
        int pages = 0;

        if (TotalRows % pagerow == 0) {
            pages = TotalRows / pagerow;
        } else {
            pages = TotalRows / pagerow + 1;
        }
        System.out.println("目前分页的总页数是" + pages);
        pageList.setPages(pages);

        pageList.setList(list);
        return pageList;
    }
}

package com.cloud.serviceexamine.util.pages;

import java.util.ArrayList;
import java.util.List;

public class PageList {
    private int page;   //当前页
    private int totalRows;   //总行数
    private int pages;    //总页数
    private List list=new ArrayList();

    public int getPage() {
        return page;
    }

    public void setPage(int page) {
        this.page = page;
    }

    public int getPages() {
        return pages;
    }

    public void setPages(int pages) {
        this.pages = pages;
    }

    public List getList() {
        if(list==null){
            list=new ArrayList();
        }
        return list;
    }

    public void setList(List list) {
        this.list = list;
    }

    public int getTotalRows() {
        return totalRows;
    }

    public void setTotalRows(int totalRows) {
        this.totalRows = totalRows;
    }
}