在StoredProcedureQuery循环中使用JPA for执行过程的最佳方法

@Entity
@NamedStoredProcedureQuery(
    name = "MyStoredProcedure",
    procedureName = "my_stored_procedure",
    parameters = {
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "param1", type = String.class),
        @StoredProcedureParameter(mode = ParameterMode.IN, name = "param2", type = Integer.class),
        // 添加其他参数
    }
)
public class MyStoredProcedureEntity {
    // 实体类的属性和对应的getter/setter
}

EntityManager entityManager = // 获取EntityManager的方法
StoredProcedureQuery storedProcedureQuery = entityManager.createStoredProcedureQuery("MyStoredProcedure");

storedProcedureQuery.setParameter("param1", "value1");
storedProcedureQuery.setParameter("param2", 2);
// 设置其他参数的值

boolean hasMoreResults = storedProcedureQuery.execute();
while (hasMoreResults) {
    List<Object[]> result = storedProcedureQuery.getResultList();
    // 处理查询结果
    hasMoreResults = storedProcedureQuery.hasMoreResults();
}