java - JPA 不同的内部联接与联接表上的条件
问题描述
我在下面有两个表:
@Entity
@Table(name="COLLEGE")
public class College {
private Long collegeId;
private List<Student> students;
@Id
@Column(name = "COLLEGE_ID")
public Long getCollegeId() {
return this.collegeId;
}
public void setCollegeId(final Long collegeId) {
this.collegeId= collegeId;
}
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "college")
@Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)
public List<Student> getStudents() {
if (this.students== null) {
this.students= new ArrayList<>();
}
return this.students;
}
public void setStudents(List<Student> students){
this.students = students
}
}
@Entity
@Table(name="STUDENT")
public class Student {
private Long studentId;
private College college;
private String name;
private String department;
@Id
public Long getStudentId() {
return this.studentId;
}
public void setStudentId(Long studentId) {
this.studentId = studentId;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "COLLEGE_ID")
public getCollege() {
return this.college;
}
public setCollege(College college) {
this.college = college;
}
......
......
}
我想获取带有特定college
列表的对象。SQL查询如下:students
department
select *
from COLLEGE c
inner join STUDENT s on c.COLLEGE_ID= s.collegeId
where c.COLLEGE_ID=12345 and s.DEPARTMENT="ENGINEERING";
到目前为止,我已经尝试了下面的 JPA 查询,但它返回了多个College
对象。
SELECT DISTINCT c
FROM COLLEGE c
INNER JOIN c.students s
where c.collegeId= :collegeid and s.department = :department
如何返回带有过滤college
列表的单个对象?students
department
注意:我无法更改此处使用的实体对象。
解决方案
尝试使用此查询,JOIN FETCH
改为使用INNER JOIN
:
SELECT DISTINCT c FROM College c
JOIN FETCH c.students s
WHERE c.collegeId= :collegeid
AND s.department = :department
推荐阅读
- python - selenium.common.exceptions.WebDriverException:消息:未知错误:net::ERR_CONNECTION_RESET
- lua - 描述中的代码是什么意思,是roblox lua
- python - 如何使数据类实例属性非公开和 __init__ arg?
- android-studio - 为什么从 DrawerLayout 中选择项目会将 BottomNavigationView 的选择移动到第一个选项卡
- c# - 如何从 c# WPF 中的多个类调用接口方法?
- android - 如何在 RecyclerView 中设置所有项目的宽度相同?
- c - C中的视频出租
- node.js - 电子生成器和电子重建有什么区别?
- windows - 有没有办法从 Perforce 的默认更改列表中删除文件?
- html - 如何使框中的文本响应?