假设这是您的过程:
CREATE OR REPLACe PROCEDURE get_users(data out SYS_REFCURSOR)ASBEGINOPEN data FOR SELECT * FROM USERS;END;
您定义一个
@NamedStoredProcedureQuery:
@NamedStoredProcedureQuery( name="getUsers", procedureName="get_users", resultClass=User.class, parameters={ @StoredProcedureParameter(queryParameter="data", name="data", direction=Direction.OUT_CURSOR) })@Entitypublic class User { ...}然后您可以像这样调用过程:
public UserRepository extends JpaRepository<User, Long>{ @Procedure('User.getUsers') List<User> getUsers();}您也可以使用EntityManager进行检查,如下所示:
Query query = entitymanager.createNamedQuery("getUsers");List users = query.getResultList();


