使用IDEASpringBoot和JPA整合分页

最新推荐文章于 2024-06-28 16:28:01 发布

隔壁村委

最新推荐文章于 2024-06-28 16:28:01 发布

阅读量426

点赞数 2

本文链接：https://blog.csdn.net/weixin_43711303/article/details/84189305

版权

使用IDEASpringBoot和JPA整合分页

效果展示：

在这里插入图片描述

步骤一：工程搭建

备注：（web–thymeleaf–JPA–JDBC–MySql）
在这里插入图片描述

步骤二：创建全局配置文件application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost/jpa_onetomany
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: update
      naming:
      #表中字段命名策略,这里要引入hibernate的核心包，不然这个命名策略会报错
        implicit-strategy: org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyJpaImpl
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
        strategy: org.hibernate.cfg.ImprovedNamingStrategy
    show-sql: true
  thymeleaf:
    mode: LEGACYHTML5
    cache: false
  mvc:
    date-format: yyyy-MM-dd

server:
  port: 9090

步骤三：pom.xml文件需要引入两个依赖

<dependency>
   <groupId>net.sourceforge.nekohtml</groupId>
   <artifactId>nekohtml</artifactId>
   <version>1.9.22</version>
</dependency>
<!—通过webjars导入依赖-->
<dependency>
   <groupId>org.webjars</groupId>
   <artifactId>jquery</artifactId>
   <version>3.3.1-1</version>
</dependency>

步骤四：创建实体类

@Entity
public class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer eid;
    @Column
    private String  ename;
    @Column
    private String  gender;
    @Column
    private Integer age;
    @Column
    private  Date    birth;

    public Employee(){
        super();
    }

    public Employee(String ename, String gender, Integer age, Date birth) {
        this.ename = ename;
        this.gender = gender;
        this.age = age;
        this.birth = birth;
    }

    public Integer getEid() {
        return eid;
    }

    public void setEid(Integer eid) {
        this.eid = eid;
    }

    public String getEname() {
        return ename;
    }

    public void setEname(String ename) {
        this.ename = ename;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public Date getBirth() {
        return birth;
    }

    public void setBirth(Date birth) {
        this.birth = birth;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "eid=" + eid +
                ", ename='" + ename + '\'' +
                ", gender='" + gender + '\'' +
                ", age=" + age +
                ", birth=" + birth +
                '}';
    }
}

步骤五：编写EmployeeRepository接口

@Repository
public interface EmployeeRepository extends JpaRepository<Employee,Integer> {
}

步骤六：编写EmployeeController

分页实现：
JpaRepository ------Pageable------PageRequest

@Controller
public class EmployeeController {

     @Autowired
     EmployeeRepository employeeRepository;

      @RequestMapping("/user/findAll")
      public String findAll(@RequestParam(value="start",defaultValue = "0") Integer start,
                            @RequestParam(value="limit",defaultValue = "2") Integer limit, Model model){
          //分页
          start=start<0?0:start;
          Pageable pageable=new PageRequest(start,limit);
          Page<Employee> page = employeeRepository.findAll(pageable);
          model.addAttribute("page",page);
          return "list";
      }

}

步骤七：在template中编写list.html

引入thymeleaf的命名空间：xmlns:th="http://www.thymeleaf.org"

<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<table border="1">
    <tr>
        <td>编号</td>
        <td>姓名</td>
        <td>性别</td>
        <td>年龄</td>
        <td>生日</td>
        <td>操作</td>
    </tr>
    <tr th:each="emp:${page}">
        <td th:text="${emp.eid}"></td>
        <td th:text="${emp.ename}"></td>
        <td th:text="${emp.gender}"></td>
        <td th:text="${emp.age}"></td>
        <td th:text="${#dates.format(emp.birth,'yyyy-MM-dd')}"></td>
        <td>修改 删除</td>
    </tr>
</table>
<a th:href="@{/user/findAll(start=0)}">首页</a>
<a th:if="${not page.isFirst()}" th:href="@{/user/findAll(start=${page.number-1})}">上一页</a>
<a th:if="${not page.isLast()}" th:href="@{/user/findAll(start=${page.number+1})}">下一页</a>
<a th:href="@{/user/findAll(start=${page.totalPages-1})}">尾页</a>
第<span th:text="${page.number+1}"></span>页/共<span th:text="${page.totalPages}" ></span>页
共<span th:text="${page.totalElements}" ></span>条
</body>

隔壁村委

关注

2
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
使用IDEASpringBoot和JPA整合分页

使用IDEASpringBoot和JPA整合分页效果展示：步骤一：工程搭建备注：（web–thymeleaf–JPA–JDBC–MySql）步骤二：创建全局配置文件application.ymlspring: datasource: url: jdbc:mysql://localhost/jpa_onetomany username: root pass...
复制链接

扫一扫