SpringBoot2 实现JPA分页和排序分页的案例

2023-07-06 03:36:02 323

分页

application.yml

spring:
datasource:
url:jdbc:mysql://127.0.0.1/jpa?useUnicode=true&characterEncoding=utf-8&useSSL=false
username:root
password:123456
driver-class-name:com.mysql.jdbc.Driver
jpa:
hibernate:
#更新或者创建数据表结构
ddl-auto:update
#控制台显示SQL
show-sql:true
properties:
hibernate.format_sql:true

实体类

@Entity
@Table(name="employee")
publicclassEmployee{
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
privateIntegerempId;
privateStringlastName;
privateStringemail;
@Temporal(TemporalType.DATE)
privateDatebirth;
@Temporal(TemporalType.TIMESTAMP)
privateDatecreateTime;
@ManyToOne
@JoinColumn(name="dept_id")
privateDepartmentdepartment;
//省去setget方法
}
@Entity
@Table(name="department")
publicclassDepartment{
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
privateIntegerdeptId;
privateStringdeptName;
//省去setget方法
}

Repository接口类

importcom.springboot.jpa.entity.Employee;
importorg.springframework.data.jpa.repository.JpaRepository;
publicinterfaceEmployeeRepositoryextendsJpaRepository{
}

service接口类

importcom.springboot.jpa.entity.Employee;
importorg.springframework.data.domain.Page;
publicinterfaceEmployeeService{
//普通分页
PagegetPage(IntegerpageNum,IntegerpageLimit);
//排序分页
PagegetPageSort(IntegerpageNum,IntegerpageLimit);
}

Service实现类

importcom.springboot.jpa.dao.EmployeeRepository;
importcom.springboot.jpa.entity.Employee;
importcom.springboot.jpa.service.EmployeeService;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.data.domain.Page;
importorg.springframework.data.domain.PageRequest;
importorg.springframework.data.domain.Pageable;
importorg.springframework.data.domain.Sort;
importorg.springframework.stereotype.Service;
importorg.springframework.transaction.annotation.Transactional;
@Service
publicclassEmployeeServiceImplimplementsEmployeeService{
@Autowired
privateEmployeeRepositoryemployeeRepository;
//普通分页
@Override
@Transactional(readOnly=true)//只读事务
publicPagegetPage(IntegerpageNum,IntegerpageLimit){
Pageablepageable=newPageRequest(pageNum-1,pageLimit);
returnemployeeRepository.findAll(pageable);
}
//分页排序
@Override
@Transactional(readOnly=true)
publicPagegetPageSort(IntegerpageNum,IntegerpageLimit){
Sortsort=newSort(Sort.Direction.DESC,"createTime");
Pageablepageable=newPageRequest(pageNum-1,pageLimit,sort);
returnemployeeRepository.findAll(pageable);
}
}

Controller控制器类

importcom.springboot.jpa.entity.Employee;
importcom.springboot.jpa.service.EmployeeService;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.data.domain.Page;
importorg.springframework.web.bind.annotation.GetMapping;
importorg.springframework.web.bind.annotation.RequestParam;
importorg.springframework.web.bind.annotation.RestController;
@RestController
publicclassEmployeeController{
@Autowired
privateEmployeeServiceemployeeService;
//分页显示数据
@GetMapping("/emp")
publicPageshowPage(@RequestParam(value="page")Integerpage,@RequestParam(value="size")Integersize){
System.out.println("分页：page:"+page+";size:"+size);
returnemployeeService.getPage(page,size);
}
//排序分页显示数据
@GetMapping("/emp_sort")
publicPageshowSortPage(@RequestParam(value="page")Integerpage,@RequestParam(value="size")Integersize){
System.out.println("排序分页：page:"+page+";size:"+size);
returnemployeeService.getPageSort(page,size);
}
}

分页显示的json格式串

http://localhost:8080/emp_sort?page=1&size=10url格式

{
"content":[{
"lastName":"7QW",
"email":"453@qq.com",
"birth":"2018-08-06",
"createTime":"2018-08-30T07:40:34.000+0000",
"id":5,
"dempartment":{
"deptName":"BBB",
"id":2
}
},{
"lastName":"qax",
"email":"1223@qq.com",
"birth":"2018-08-06",
"createTime":"2018-08-24T07:40:56.000+0000",
"id":6,
"dempartment":{
"deptName":"AAA",
"id":1
}
}
}],
"pageable":{
"sort":{
"sorted":true,
"unsorted":false
},
"offset":0,
"pageNumber":0,
"pageSize":10,
"unpaged":false,
"paged":true
},
"last":true,
"totalElements":6,
"totalPages":1,
"number":0,
"size":10,
"sort":{
"sorted":true,
"unsorted":false
},
"numberOfElements":6,
"first":true
}

补充：SpringDataJpa普通分页+排序分页

SpringBoot2使用jpa分页问题

一、jap的普通分页：

pojo

@Entity
@Table(name="user")
publicclassUser{
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
privateIntegerid;
@Column
privateStringuserName;
@Column
privateStringpassword;
@Column
privateStringage；
//省略get、set
｝

IUserService

//jpa简单分页
PagegetPage(IntegerpageNum,IntegerpageSize);

UserService

@Override
publicPagegetPage(IntegerpageNum,IntegerpageSize){
/**
*之前看到别的博主直接newPageRequest(pageNum-1，pageSize)
*自己实践后报错，可能是因为版本不一致吧
*查看PageRequest的底层构造方法并没有对应的只有of方法对应
*后经实验成功！
*/
//创建一个pageable，调用它的实现类PageRequest的of()方法
Pageablepageable=PageRequest.of(pageNum-1,pageSize);

PageuserPage=userDao.findAll(pageable);
returnuserPage;
}

Test

@Test
voidtestGetPage(){
//调用service层的getPage()方法
PageuserPage=userService.getPage(1,5);
/**
*userPage.getContent()
*getContent();获取查询的结果集
*Page

SpringBoot2 实现JPA分页和排序分页的案例

分页

实体类

Repository接口类

service接口类

Service实现类

Controller控制器类

分页显示的json格式串

一、jap的普通分页：

二、jap的普通分页：

随机推荐

SpringBoot2 实现JPA分页和排序分页的案例

分页

实体类

Repository接口类

service接口类

Service实现类

Controller控制器类

分页显示的json格式串

一、jap的普通分页：

二、jap的普通分页：

热门推荐

随机推荐