分页

摘要：配置无当前页总页数每页记录大小总记录查询结果集当前页总记录数每页记录数设置值查询结果当前共条记录首页上一页总页不超过头溢出尾溢出循环遍历页码列表下一页尾页运行结果为去写我要显示页总记录数总页数首页头溢出尾溢出尾页

ssm配置无

StudentMapper.java

public interface StudentMapper {
    int queryCount();
    List queryAll(HashMap map);
}

StudentMapper.xml

    
        select id,name,birthday from student
        limit #{start},#{size}
    
    
        select count(*) from student
    

Student.java

public class Student {
    package cn.scitc.pojo;

import java.util.Date;

public class Student {
    private Integer id;
    private  String name;
    private Date birthday;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }
}

}

PageBean.java

package cn.scitc.pojo;

import java.util.List;

public class PageBean {
    private int currPage; //当前页
    //    private int totalPage;//总页数
    private int pageSize;//每页记录大小
    private int totalCount;//总记录
    private List pageBean;//查询结果集

    public int getCurrPage() {
        return currPage;
    }

    public void setCurrPage(int currPage) {
        this.currPage = currPage;
    }

    public int getTotalPage() {
        int totalPage = totalCount / pageSize;
        return totalCount % pageSize == 0 ? totalPage : totalPage + 1;
    }

//    public void setTotalPage(int totalPage) {
//        this.totalPage = totalPage;
//    }

    public int getPageSize() {
        return pageSize;
    }

    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public List getPageBean() {
        return pageBean;
    }

    public void setPageBean(List pageBean) {
        this.pageBean = pageBean;
    }
}

StudentService.java

public interface StudentService {
    PageBean queryAll(Integer currPage);
}

StudentServiceImpl.java

@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentMapper studentMapper;
    @Override
    public PageBean queryAll(Integer currPage) {
        HashMap map = new HashMap<>();
       PageBean pageBean = new PageBean<>();
       //当前页
        pageBean.setCurrPage(currPage);
        //总记录数
        int totalCount = studentMapper.queryCount();
        pageBean.setTotalCount(totalCount);
        //每页记录数
        int pageSize = 5;
        pageBean.setPageSize(pageSize);

        //map设置值
        map.put("start",(currPage -1) * pageSize );
        map.put("size",pageBean.getPageSize());
        //查询结果
        List studentList = studentMapper.queryAll(map);
        pageBean.setPageBean(studentList);
        return pageBean;
    }
}

StudentController.java

@Controller
public class StudentController {
    @Autowired
    private StudentService studentService;
    @RequestMapping("/query")
    public String query(@RequestParam(value = "currPage",defaultValue = "1") Integer currpage, Model model){
        model.addAttribute("pageBean",studentService.queryAll(currpage));
        return "student";
    }
}

student.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    



        

    

        
id:
        
name:
        
birthday:
    
    

            

            

            
 
        
    
    


    

        当前${pageBean.currPage}/${pageBean.totalPage}
        共${pageBean.totalCount}条记录
        
            
                ">[首页]
                ">上一页
            

            
                <%--总页不超过10--%>
                
                    
                    
                
                
                    
                    
                    <%--头溢出--%>
                    
                        
                        
                    
                    <%--尾溢出--%>
                    
                        
                        
                    
                
            

            <%-- 循环遍历页码列表 --%>
            
                
                    
                        [${i}]
                    
                    
                        ">${i}
                    
                
            

             
                 ">下一页
                 ">[尾页]

             
        

    

运行结果为：

js去写

         //我要显示5页
            // 1 2 [3] 4 5
            //总记录数
            var recordCount = data.data.articleCount;
            //总页数
            var pageCount = Math.ceil(recordCount / pageSize);
            if (pageIndex != 1) {
                var indexPageHtml =
                    ``
                    + ``
                    + ``
                    + `首页`;
                $(".nav-links").append(indexPageHtml);
            }
            if (pageCount < 5) {
                var begin = 1;
                var end = pageCount;
            } else {
                var begin = (pageIndex - 3);
                var end = (pageIndex + 1);
                //头溢出
                if (begin < 1) {
                    begin = 1;
                    end = 5;
                }
                //尾溢出
                if (end > pageCount) {
                    begin = pageCount - 4;
                    end = pageCount;
                }
            }
            console.log("begin:" + begin);
            console.log("end:" + end);
            for (var i = begin; i <= end; i++) {
                if (i == pageIndex) {
                    $(".nav-links").append(`${i}`);
                } else {
                    $(".nav-links").append(`${i}`);
                }
            }

            if (pageIndex != pageCount) {
                var lastPageHtml =
                    `尾页`
                    + ``
                    + ``
                    + ``
                $(".nav-links").append(lastPageHtml);
            }
        }