How can data pagination be implemented?

Pagination allows splitting a large dataset into pages for easier display and reduced load.

In Java, this can be implemented in several ways:

1. Using SQL with LIMIT and OFFSET (if data is from a database):

int page = 2; // page number
int pageSize = 10; // number of items per page
int offset = (page - 1) * pageSize;

String sql = "SELECT * FROM table LIMIT ? OFFSET ?";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setInt(1, pageSize);
ps.setInt(2, offset);
ResultSet rs = ps.executeQuery();

2. Using collections in Java: If data is already loaded into a list, you can get a sublist:

List<Data> allData = ...;
int page = 2;
int pageSize = 10;
int fromIndex = (page - 1) * pageSize;
int toIndex = Math.min(fromIndex + pageSize, allData.size());
List<Data> pageData = allData.subList(fromIndex, toIndex);

3. Frameworks: In Spring Data, for example, there is the Pageable interface, which simplifies working with pagination.

Thus, pagination is implemented by selecting the required data range using page parameters and page size.