通过方法名进行Spring Data Jpa查询不能与LocalDate的BETWEEN一起正常工作

@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
    @Query("SELECT e FROM YourEntity e WHERE e.date BETWEEN :startDate AND :endDate")
    List<YourEntity> findByDateRange(@Param("startDate") LocalDate startDate, @Param("endDate") LocalDate endDate);
}

@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
    List<YourEntity> findByDateRange(LocalDate startDate, LocalDate endDate);
}

@Service
public class YourService {
    @Autowired
    private YourRepository yourRepository;

    public List<YourEntity> findByDateRange(LocalDate startDate, LocalDate endDate) {
        CriteriaBuilder cb = yourRepository.getEntityManager().getCriteriaBuilder();
        CriteriaQuery<YourEntity> query = cb.createQuery(YourEntity.class);
        Root<YourEntity> root = query.from(YourEntity.class);
        query.select(root).where(cb.between(root.get("date"), startDate, endDate));
        return yourRepository.getEntityManager().createQuery(query).getResultList();
    }
}