JPQL EclipseLink分页

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
import java.util.List;

public class PaginationExample {
    public static void main(String[] args) {
        EntityManagerFactory emf = Persistence.createEntityManagerFactory("your-persistence-unit");
        EntityManager em = emf.createEntityManager();

        int pageSize = 10; // 每页的大小
        int pageNumber = 1; // 当前页码

        try {
            String jpql = "SELECT e FROM Entity e";
            Query query = em.createQuery(jpql);

            // 设置分页参数
            query.setFirstResult((pageNumber - 1) * pageSize);
            query.setMaxResults(pageSize);

            List<Entity> entities = query.getResultList();

            for (Entity entity : entities) {
                // 处理查询结果
            }
        } finally {
            em.close();
            emf.close();
        }
    }
}