执行具有多个参数的存储过程，并使用spring data jpa将ResultSet映射到非实体类

// 定义非实体类
public class MyResult {
    private String column1;
    private String column2;
    // getter和setter方法
}

// Repository接口
public interface MyRepository extends JpaRepository<MyEntity, Long> {
    @Procedure(name = "my_stored_procedure")
    List<MyResult> executeMyStoredProcedure(@Param("param1") String param1, @Param("param2") String param2);
}

// Repository接口实现类
@Repository
public class MyRepositoryImpl implements MyRepository {
    @PersistenceContext
    private EntityManager entityManager;

    @Override
    public List<MyResult> executeMyStoredProcedure(String param1, String param2) {
        StoredProcedureQuery query = entityManager.createStoredProcedureQuery("my_stored_procedure");
        query.registerStoredProcedureParameter("param1", String.class, ParameterMode.IN);
        query.registerStoredProcedureParameter("param2", String.class, ParameterMode.IN);
        query.setParameter("param1", param1);
        query.setParameter("param2", param2);
        query.execute();

        List<Object[]> resultList = query.getResultList();
        List<MyResult> myResults = new ArrayList<>();
        for (Object[] result : resultList) {
            MyResult myResult = new MyResult();
            myResult.setColumn1((String) result[0]);
            myResult.setColumn2((String) result[1]);
            myResults.add(myResult);
        }
        return myResults;
    }
}