查询示例是否允许您对整数类型执行小于(lessThan())和大于(greaterThan())的操作?
查询示例是否允许您对整数类型执行小于(lessThan())和大于(greaterThan())的操作?
是的,Spring JPA为整数类型的列提供了lessThan()
、greaterThan()
方法,如下所示。(例如:UserProfile findByAgeGreaterThan(Integer age))
@Transactional
@Repository
public interface UserRepository extends CrudRepository<UserProfile, String> {
List<UserProfile> findByUsername(String username);
UserProfile findByUserid(Integer user_id);
UserProfile findByDevicesimno(String devicesimno);
**UserProfile findByAgeGreaterThan(Integer age);**
}
请参考此链接https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.query-creation