HQL查询中如何利用LocalTime范围过滤LocalDateTime属性

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import java.time.LocalDateTime;

@Entity
public class Work {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private LocalDateTime endTime; // 需要过滤的LocalDateTime字段

    // 构造函数
    public Work() {}

    public Work(LocalDateTime endTime) {
        this.endTime = endTime;
    }

    // Getter和Setter方法
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public LocalDateTime getEndTime() {
        return endTime;
    }

    public void setEndTime(LocalDateTime endTime) {
        this.endTime = endTime;
    }

    @Override
    public String toString() {
        return "Work{id=" + id + ", endTime=" + endTime + '}';
    }
}

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import java.time.LocalTime;
import java.util.List;

public interface WorkRepository extends JpaRepository<Work, Long> {

    /**
     * 根据endTime字段的时间部分是否在指定的LocalTime范围内进行过滤。
     * 使用CAST函数将LocalDateTime的时间部分转换为java.lang.Time进行比较。
     *
     * @param from 起始时间（LocalTime），包含在查询范围内
     * @param to 结束时间（LocalTime），包含在查询范围内
     * @return 符合条件的Work对象列表
     */
    @Query("SELECT w FROM Work w WHERE CAST(w.endTime AS java.lang.Time) BETWEEN :from AND :to")
    List<Work> findWorksByEndTimeBetweenLocalTime(@Param("from") LocalTime from, @Param("to") LocalTime to);
}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.stereotype.Component;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.List;

@Component
public class DataInitializer implements CommandLineRunner {

    @Autowired
    private WorkRepository workRepository;

    @Override
    public void run(String... args) throws Exception {
        // 插入一些测试数据
        workRepository.save(new Work(LocalDateTime.of(2023, 1, 1, 9, 30))); // 09:30
        workRepository.save(new Work(LocalDateTime.of(2023, 1, 2, 12, 0)));  // 12:00
        workRepository.save(new Work(LocalDateTime.of(2023, 1, 3, 14, 45))); // 14:45
        workRepository.save(new Work(LocalDateTime.of(2023, 1, 4, 18, 15))); // 18:15
        workRepository.save(new Work(LocalDateTime.of(2023, 1, 5, 20, 0)));  // 20:00

        // 定义查询的时间范围
        LocalTime fromTime = LocalTime.of(10, 0); // 10:00
        LocalTime toTime = LocalTime.of(17, 0);   // 17:00

        System.out.println("查询时间范围: " + fromTime + " - " + toTime);
        List<Work> works = workRepository.findWorksByEndTimeBetweenLocalTime(fromTime, toTime);
        works.forEach(System.out::println);
        // 预期输出: 12:00 和 14:45 的Work对象
    }
}