Spring Data JPA本机查询中的变量

我爱您中国

使用Spring Dat
JPA，我需要查询我的数据库，OrderEntity基于数量的astartAmt和a返回一个s范围endAmt。我不确定是否应该映射这两个变量entity
OrderEntity，作为某种类型的单独类/实体/模型中的字段，或直接在本机查询中说明。也许我应该使用实现的服务EntityManager.createNativeQuery()？
想做类似的事：
@Repositorypublic interface OrderRangeRepository extends JpaRepository @Query(value = "SELECT * FROM Orders WHERE Amount BETWEEN startAmt AND endAmt;" ,nativeQuery=true) List findOrdersBy(int startAmt,int endAmt);}如果要EntityManager.createNativeQuery()在服务中使用可能与以下内容相似:
@Servicepublic class OrderRangeService @Autowired EntityManager entityManager; public List findAmountsBetween() List amountsBetween = entityManager.createNativeQuery("SELECT * FROM Orders WHERE Amount BETWEEN ?1 AND 2?;") .setParameter(1,"startAmt") .setParameter(2,"endAmt") .getResultList()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；return amountsBetween;
解决方案:

Spring Data JPA本机查询中的变量

我爱您中国 LV1