SpringBoot+jpa+hibernate

Question

有一个查询语句
select * from 表1
WHERE name = #{request.name}
<![CDATA[ AND age >= #{minAge} AND age <= #{maxAge} ]]>
<![CDATA[ AND weight >= #{minWeight} AND latitude <= #{maxWeight} ]]>
这样一个查询语句，如何转换成使用SpringBoot+jpa+Hibernate方式的查询呢？

Answer 1

jpa有规范比如说这个 findByNameAndAgeBetweenAndWeigthBetween(name,minAge,maxAge,minWeight,maxWeight) 你可以查下jpa规范，

或者使用注解的方式
@Select("from Entity where name=?1 and age between ?2 and ?3 and weight between ?4 and 5")
findByNameAndAgeBetweenAndWeigthBetween(name,minAge,maxAge,minWeight,maxWeight)