/**
* 测试 PagingAndSortingRepository 的分页能力
*/
@Test
public void testPaging(){
System.out.println(bookRepository.getClass().getName());
/**
* 前台传来的第几页(当前第几页)
*/
Integer pageNoFromWeb = 1;
/**
* 前台传来的每页几条数据(当前页面的记录数)
*/
Integer pageSizeFromWeb = 5;
Integer page = pageNoFromWeb - 1;
Integer size = pageSizeFromWeb;
PageRequest pageRequest = new PageRequest(page, size);
Page<Book> bookPage = bookRepository.findAll(pageRequest);
long totalElements = bookPage.getTotalElements();
System.out.println("总记录数(总数据条数) => " + totalElements);
int number = bookPage.getNumber();
System.out.println("当前第几页 => " + (number + 1));
int totalPages = bookPage.getTotalPages();
System.out.println("总页数 => " + totalPages);
List<Book> content = bookPage.getContent();
for(Book book:content){
System.out.println(book);
}
int numberOfElements = bookPage.getNumberOfElements();
System.out.println(numberOfElements);
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
控制台显示:
分页 + 排序
关键代码:
Order order1 = new Order(Direction.DESC,"id");
Order order2 = new Order(Direction.ASC,"name");
Sort sort = new Sort(order1,order2);
PageRequest pageRequest = new PageRequest(page, size,sort);
测试代码:
/**
* 测试分页和排序
*/
@Test
public void testPagingAndSorting(){
System.out.println(bookRepository.getClass().getName());
/**
* 前台传来的第几页(当前第几页)
*/
Integer pageNoFromWeb = 1;
/**
* 前台传来的每页几条数据(当前页面的记录数)
*/
Integer pageSizeFromWeb = 5;
Integer page = pageNoFromWeb - 1;
Integer size = pageSizeFromWeb;
Order order1 = new Order(Direction.DESC,"id");
Order order2 = new Order(Direction.ASC,"name");
Sort sort = new Sort(order1,order2);
PageRequest pageRequest = new PageRequest(page, size,sort);
Page<Book> bookPage = bookRepository.findAll(pageRequest);
long totalElements = bookPage.getTotalElements();
System.out.println("总记录数(总数据条数) => " + totalElements);
int number = bookPage.getNumber();
System.out.println("当前第几页 => " + (number + 1));
int totalPages = bookPage.getTotalPages();
System.out.println("总页数 => " + totalPages);
List<Book> content = bookPage.getContent();
for(Book book:content){
System.out.println(book);
}
int numberOfElements = bookPage.getNumberOfElements();
System.out.println("当前页面的记录数 => " + numberOfElements);
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
控制台显示: