从Java spring启动存储库获取方法值

Question

我的查询返回一个INT，这将是受影响的行数。

我想知道，如何在控制器或服务中检索这个值，或者在存储库本身

@Modifying(clearAutomatically = true)
@Transactional
@Query(nativeQuery = true, value = "UPDATE tb_pessoal_funcionarios SET salario = CAST(salario+(salario * :percentualAumento)/100 AS NUMERIC(18,2)) "
+ "WHERE id IN (:funcionarioId) "
+ "AND (:alterarFuncionariosDemitidos IS true OR condicao <> 'Inativo')")
void AlterarSalarioSelecionadosPorPercentual(Double percentualAumento, Long funcionarioId, Boolean alterarFuncionariosDemitidos);

i need get method value from Java spring boot repository

Answer 1

直接添加int作为返回值

@Modifying(clearAutomatically = true)
@Transactional
@Query(nativeQuery = true, value = "UPDATE tb_pessoal_funcionarios SET salario = CAST(salario+(salario * :percentualAumento)/100 AS NUMERIC(18,2)) "
+ "WHERE id IN (:funcionarioId) "
+ "AND (:alterarFuncionariosDemitidos IS true OR condicao <> 'Inativo')")
int AlterarSalarioSelecionadosPorPercentual(Double percentualAumento, Long funcionarioId, Boolean alterarFuncionariosDemitidos);