HQL查询：基于LocalTime范围筛选LocalDateTime字段

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

@Entity
public class Work {

  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;
  private LocalDateTime endTime;

  // 构造函数
  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 +
           '}';
  }
}

// 假设的HQL查询，可能无法直接工作或不是最佳实践
// @Query("SELECT new package.dto(w.id) FROM Work w WHERE TIME(w.endTime) BETWEEN :from AND :to")
// List<Dto> createDtoList(LocalTime from, LocalTime to);

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.time.LocalTime;
import java.util.List;

// 假设有一个简单的DTO用于返回结果，例如：
// public class WorkDto {
//     private Long id;
//     public WorkDto(Long id) { this.id = id; }
//     public Long getId() { return id; }
//     public void setId(Long id) { this.id = id; }
// }

@Repository
public interface WorkRepository extends JpaRepository<Work, Long> {

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

  // 如果需要返回DTO，可以这样写：
  // @Query("SELECT new your.package.WorkDto(w.id) FROM Work w WHERE CAST(w.endTime AS java.sql.Time) BETWEEN :from AND :to")
  // List<WorkDto> findWorkDtosByEndTimeBetweenLocalTime(
  //     @Param("from") LocalTime from,
  //     @Param("to") LocalTime to
  // );
}