在Spring中创建带日期的JPA查询

@Repository
public interface UserRepository extends JpaRepository<User, Long> {

    @Query("SELECT u FROM User u WHERE u.createDate >= :startDate AND u.createDate <= :endDate")
    List<User> findByCreateDateBetween(@Param("startDate") LocalDate startDate, @Param("endDate") LocalDate endDate);

}

@Service
public class UserService {

    @Autowired
    private UserRepository userRepository;

    public List<User> getUsersByCreateDate(LocalDate startDate, LocalDate endDate) {
        return userRepository.findByCreateDateBetween(startDate, endDate);
    }

}