在Hibernate中选择2个表

Question

`@实体公共类影片{

private Long id;
private String title;
private String summary;
private long duration;
private LocalDateTime startDate;
private LocalDateTime endDate;
private Set<Session> sessions = new HashSet<>();


public Movie() {
}


public Movie(Long id, String title, String summary, long duration, LocalDateTime startDate, LocalDateTime endDate) {
    super();
    this.id = id;
    this.title = title;
    this.summary = summary;
    this.duration = duration;
    this.startDate = startDate;
    this.endDate = endDate;
}


public Movie(String title, String summary, long duration, LocalDateTime startDate, LocalDateTime endDate) {
    super();
    this.title = title;
    this.summary = summary;
    this.duration = duration;
    this.startDate = startDate;
    this.endDate = endDate;
}


@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
public Long getId() {
    return id;
}


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

@OneToMany(mappedBy="movie")
public Set<Session> getSessions() {
    return sessions;
}


public void setSessions(Set<Session> sessions) {
    this.sessions = sessions;
}


public String getTitle() {
    return title;
}


public void setTitle(String title) {
    this.title = title;
}


public String getSummary() {
    return summary;
}


public void setSummary(String summary) {
    this.summary = summary;
}


public long getDuration() {
    return duration;
}


public void setDuration(long duration) {
    this.duration = duration;
}


public LocalDateTime getStartDate() {
    return startDate;
}


public void setStartDate(LocalDateTime startDate) {
    this.startDate = startDate;
}


public LocalDateTime getEndDate() {
    return endDate;
}


public void setEndDate(LocalDateTime endDate) {
    this.endDate = endDate;
}

}'

@Entity

公开课课时{

private Long id;
private BigDecimal prize;
private LocalDateTime sessionDate;
private Movie movie;
private MovieCinema movieCinema;

public Session() {
}

public Session(Long id, BigDecimal prize, LocalDateTime sessionDate, Movie movie, MovieCinema movieCinema) {
    super();
    this.id = id;
    this.prize = prize;
    this.sessionDate = sessionDate;
    this.movie = movie;
    this.movieCinema = movieCinema;
}

public Session(BigDecimal prize, LocalDateTime sessionDate, Movie movie, MovieCinema movieCinema) {
    this.prize = prize;
    this.sessionDate = sessionDate;
    this.movie = movie;
    this.movieCinema = movieCinema;
}

public Session(BigDecimal prize, LocalDateTime sessionDate, Movie movie) {

    this.prize = prize;
    this.sessionDate = sessionDate;
    this.movie = movie;
}

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
public Long getId() {
    return id;
}

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

public BigDecimal getPrize() {
    return prize;
}

public void setPrize(BigDecimal prize) {
    this.prize = prize;
}

public LocalDateTime getSessionDate() {
    return sessionDate;
}

public void setSessionDate(LocalDateTime sessionDate) {
    this.sessionDate = sessionDate;
}

@ManyToOne(optional = false, fetch = FetchType.LAZY)
@JoinColumn(name = "movieId")
public Movie getMovie() {
    return movie;
}

public void setMovie(Movie movie) {
    this.movie = movie;
}

@ManyToOne(optional = false, fetch = FetchType.LAZY)
@JoinColumn(name = "movieCinemaId")
public MovieCinema getMovieCinema() {
    return movieCinema;
}

public void setMovieCinema(MovieCinema movieCinema) {
    this.movieCinema = movieCinema;
}

}

我有两张桌子

表A

Id | name | date | Set

表B Id |日期|表A

我想选择TableB. date所在的所有tableA

我想从表格A，表格B中选择*表格B。日期

我想要一个TableA元素列表和一个TableB的少数元素列表

在此输入图像描述

在此输入图像描述

Answer 1

我解决了，但没有使用我做了这个“公共切片查找SessionsByDate（Long moviId， int page， int size）{

    LocalDateTime date = LocalDateTime.now();
    //Esto devuelve la lista de sesiones validas de una pelicula
    String queryString = "SELECT s  from Session s WHERE s.sessionDate >= :date AND s.movie.id = :movieId";

    queryString += " ORDER BY s.sessionDate";

    Query query = entityManager.createQuery(queryString).setFirstResult(page * size).setMaxResults(size + 1);

    if (date != null) {
        query.setParameter("date", date);
    }

    if (movieId != null) {
        query.setParameter("movieId", movieId);
    }


    List<Session> sessions = query.getResultList();

    boolean hasNext = sessions.size() == (size + 1);

    if (hasNext) {
        sessions.remove(sessions.size() - 1);
    }

    return new SliceImpl<>(sessions, PageRequest.of(page, size), hasNext);

}`

我想问的问题是，我想按电影筛选，在电影列表中，我想筛选这些电影的会话