springboot+jpa+thymeleaf 按条件分页

1.添加依赖，pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.3.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.qikan</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.5</version>
        </dependency>


    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2.配置application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/qikan
    username: root
    password: 123456

  jpa:
    open-in-view: false
    hibernate:
      ddl-auto: update
    show-sql: true
  thymeleaf:
    mode: HTML
    encoding: UTF-8
    servlet:
      content-type: text/html
    cache: false
    suffix: .html
    check-template: false
    check-template-location: false
    prefix: classpath:/templates/
    enabled: true

3.entity实体类，Article，QkInfo

package com.qikan.demo.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class Article {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    private String title;
    private String authorName;
    private String zhaiyao;
    private String keywords;
    private String pdf;
    private String startPage;
    private String endPage;

    public Integer getQkID() {
        return qkID;
    }

    public void setQkID(Integer qkID) {
        this.qkID = qkID;
    }

    private Integer qkID;//所属的第几期

    public String getStartPage() {
        return startPage;
    }

    public void setStartPage(String startPage) {
        this.startPage = startPage;
    }

    public String getEndPage() {
        return endPage;
    }

    public void setEndPage(String endPage) {
        this.endPage = endPage;
    }

    public Article() {
    }

    public Integer getId() {
        return id;
    }

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

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getAuthorName() {
        return authorName;
    }

    public void setAuthorName(String authorName) {
        this.authorName = authorName;
    }

    public String getZhaiyao() {
        return zhaiyao;
    }

    public void setZhaiyao(String zhaiyao) {
        this.zhaiyao = zhaiyao;
    }

    public String getKeywords() {
        return keywords;
    }

    public void setKeywords(String keywords) {
        this.keywords = keywords;
    }

    public String getPdf() {
        return pdf;
    }

    public void setPdf(String pdf) {
        this.pdf = pdf;
    }

    @Override
    public String toString() {
        return "Article{" +
                "id=" + id +
                ", title='" + title + '\'' +
                ", authorName='" + authorName + '\'' +
                ", zhaiyao='" + zhaiyao + '\'' +
                ", keywords='" + keywords + '\'' +
                ", pdf='" + pdf + '\'' +
                ", startPage='" + startPage + '\'' +
                ", endPage='" + endPage + '\'' +
                ", qkID=" + qkID +
                '}';
    }
}

package com.qikan.demo.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import java.util.Date;


/*期刊信息*/
@Entity
public class QkInfo {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    private Date date;//出刊日期
    private Integer year;
    private Integer djq;//第几期

    public QkInfo() {
    }

    public Integer getId() {
        return id;
    }

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

    public Date getDate() {
        return date;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public Integer getYear() {
        return year;
    }

    public void setYear(Integer year) {
        this.year = year;
    }

    public Integer getDjq() {
        return djq;
    }

    public void setDjq(Integer djq) {
        this.djq = djq;
    }
}

 

4.dao(repository)层

package com.qikan.demo.repository;

import org.springframework.data.domain.Page;
import com.qikan.demo.entity.Article;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface ArticleRepository extends JpaRepository<Article,Integer> {
    public Page<Article> findAllByQkID(Integer qkId, Pageable pageable);
}

package com.qikan.demo.repository;

import com.qikan.demo.entity.QkInfo;
import org.springframework.data.jpa.repository.JpaRepository;

public interface QkInfoRepository extends JpaRepository<QkInfo,Integer> {
    public QkInfo findByYearAndDjq(Integer year,Integer djq);
}

 

5.controller层

package com.qikan.demo.controller;


import com.qikan.demo.entity.Article;
import com.qikan.demo.entity.Author;
import com.qikan.demo.entity.QkInfo;
import com.qikan.demo.repository.ArticleRepository;
import com.qikan.demo.repository.AuthorRepositoy;
import com.qikan.demo.repository.QkInfoRepository;
import com.qikan.demo.service.ArticleService;
import com.qikan.demo.service.AuthorService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

@Controller
@RequestMapping
public class  AuthorController {
 
    @Autowired
    private ArticleRepository articleRepository;
    @Autowired
    private HttpServletRequest request;
    @Autowired
    private QkInfoRepository qkInfoRepository;


    @RequestMapping(value = "/index")
    public ModelAndView index(@RequestParam(value = "start", defaultValue = "0") Integer start,
                        @RequestParam(value = "limit", defaultValue = "12") Integer limit){

        Integer year = Calendar.getInstance().get(Calendar.YEAR);
        Integer djq = Calendar.getInstance().get(Calendar.MONTH)+1;

        QkInfo qkInfo = qkInfoRepository.findByYearAndDjq(year,djq);
    //    List<Article> list = articleService.findAllArticles(year,month);
        start = start < 0 ? 0 : start;

        Sort sort = new Sort(Sort.DEFAULT_DIRECTION, "id");
        Pageable pageable = PageRequest.of(start, limit, sort);
        Page<Article> page= articleRepository.findAllByQkID(qkInfo.getId(),pageable);
/*
        System.out.println(list.getNumber());
       System.out.println(list.getNumberOfElements());
       System.out.println(list.getSize());
       System.out.println(list.getTotalElements());
        System.out.println(list.getTotalPages());
       System.out.println(list.isFirst());
      System.out.println(list.isLast());*/

        ModelAndView mav = new ModelAndView("index");
        mav.addObject("page", page);
        mav.addObject("year",year);
        mav.addObject("djq",djq);
        Date date = qkInfo.getDate();
        DateFormat dateFormat = DateFormat.getDateInstance();
        mav.addObject("date",dateFormat.format(date));
        mav.addObject("shang","上一期");
        mav.addObject("xia","");
        return mav;
    }

}

6.界面

 <div style="border-bottom: 1px dotted darkgray;margin-top: 10px">
                                    <dl th:each="article:${page}" th:object="${article}">
                                        <dd th:text="*{title}" style="font-weight: bold">云计算中任务调度研究的调查</dd>
                                        <dd th:text="*{authorName}" style="margin-top:5px; ">马小晋,饶国宾,许华虎</dd>
                                        <dd style="margin-top:5px; ">计算机科学. 2019, 46 (3): 1-8.  doi:10.11896/j.issn.1002-137X.2019.03.001</dd>
                                        <dd style="margin-top:5px; margin-bottom: -10px" >
                                        <span class="glyphicon glyphicon-edit" style="color: orange"></span><a href="#" style="" onclick="zyClick()">摘要</a>
                                        <span class="glyphicon glyphicon-floppy-save" style="color: orange"></span><a>PDF</a> <span>(1583k)</span>
                                       </dd>
                                       <div th:text="*{zhaiyao}" id="zhaiyaodiv" style="margin-top:10px; margin-bottom: -10px;display:none">
                                           摘要               
                                       </div>
                                    </dl>
                                </div>
                                <div>
                                        <a th:href="@{/index(start=0)}">[首页]</a>&nbsp;&nbsp;
                                        <a th:if="${not page.isFirst()}" th:href="@{/index(start=${page.number-1})}">[上页]</a>&nbsp;&nbsp;
                                        <a th:if="${not page.isLast()}" th:href="@{/index(start=${page.number+1})}">[下页]</a>&nbsp;&nbsp;
                                        <a th:href="@{/index(start=${page.totalPages-1})}">[末页]</a>
                                 </div>