我在 Spring Boot 項目中使用存儲過程并嘗試獲取輸出值，但在我的項目中它總是返回 null。但是，如果我通過 HeidiSQL 調用該過程，它會起作用并為我提供正確的值。所以它必須用我的java代碼做一些事情。我調試了受影響的方法，但找不到返回 null 的原因。我已經(jīng)嘗試查找其他帖子，但找不到與我的特定問題相匹配的內容。這是我嘗試使用存儲過程的方法：公司資源服務實現(xiàn)@Servicepublic class CompanyResourceServiceImpl implements CompanyResourceService {@PersistenceContext private EntityManager entityManager;...private int getMetalResourceByPlayerId(int theId) { StoredProcedureQuery theQuery = entityManager.createStoredProcedureQuery("getAllMetalFromCompaniesByPlayerId"); theQuery.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN); theQuery.registerStoredProcedureParameter(2, BigDecimal.class, ParameterMode.OUT); theQuery.setParameter(1, theId); theQuery.execute(); BigDecimal outAmount = (BigDecimal) theQuery.getOutputParameterValue(2); return outAmount.intValue(); }...}以下是存儲過程：getAllMetalFromCompaniesByPlayerIdCREATE DEFINER=`root`@`localhost` PROCEDURE `getAllMetalFromCompaniesByPlayerId`( IN `playerId` INT, OUT `metalSum` DECIMAL(19,2))LANGUAGE SQLNOT DETERMINISTICCONTAINS SQLSQL SECURITY DEFINERCOMMENT ''BEGINSELECT sum(cr.amount) as metalSumFROM company_resource crJOIN company c ON (c.id = cr.company_id) WHERE c.player_id = playerId and cr.resource_id = 1;END我的目標是獲取輸出值并在@Scheduled方法中使用它。正如我所說，在 HeidiSQL 中，存儲過程有效。
1 回答
躍然一笑
TA貢獻1826條經(jīng)驗 獲得超6個贊
經(jīng)過幾個小時的嘗試，我找到了一種讓它工作的方法。
首先我添加@NamedStoredProcedureQuery到我的CompanyResource實體類：
CompanyResource.java
@Entity
@Table(name = "company_resource")
@NamedStoredProcedureQueries({
@NamedStoredProcedureQuery(name = "getAllMetalFromCompaniesByPlayerId",
procedureName = "getAllMetalFromCompaniesByPlayerId",
parameters = {
@StoredProcedureParameter(mode = ParameterMode.IN, name = "playerId", type = Integer.class),
@StoredProcedureParameter(mode = ParameterMode.OUT, name = "metalSum", type = BigDecimal.class)
})
})
@IdClass(CompanyResourcePK.class)
public class CompanyResource {
...
}
然后我改變了我的getMetalResourceByPlayerId()方法CompanyResourceServiceImpl如下：
CompanyResourceServiceImpl.java
@Service
public class CompanyResourceServiceImpl implements CompanyResourceService {
@PersistenceContext
private EntityManager entityManager;
...
private int getMetalResourceByPlayerId(int theId) {
StoredProcedureQuery theQuery = entityManager.createNamedStoredProcedureQuery("getAllMetalFromCompaniesByPlayerId");
theQuery.setParameter("Param1", theId);
BigDecimal outAmount = (BigDecimal) theQuery.getSingleResult();
return outAmount.intValue();
}
...
}
添加回答
舉報
0/150
提交
取消