关于Hibernate的多表查询
关于Hibernate的2个表查询,请问各位大大该怎么弄。。我查了一下午了没整出来首先是2张个表,两个类
public class UserInterest {
private UserInterestPK userInterestPK;
public UserInterestPK getUserInterestPK() {
return userInterestPK;
}
public void setUserInterestPK(UserInterestPK userInterestPK) {
this.userInterestPK = userInterestPK;
}
}
public class UserInterestPK implements Serializable{
private static final long serialVersionUID = -490067277835330954L;
private String uid;
private String listenedId;
public String getUid() {
return uid;
}
public void setUid(String uid) {
this.uid = uid;
}
public String getListenedId() {
return listenedId;
}
public void setListenedId(String listenedId) {
this.listenedId = listenedId;
}
}
public class UserInfo extends CommonSuper{
private String uid ;
private String userName;
private String nickName;
private String age;
private String sex;
private String birthday;
private String hoby;
private String companyId;
private String headImgPath;
public String getUid() {
return uid;
}
public void setUid(String uid) {
this.uid = uid;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getNickName() {
return nickName;
}
public void setNickName(String nickName) {
this.nickName = nickName;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getBirthday() {
return birthday;
}
public void setBirthday(String birthday) {
this.birthday = birthday;
}
public String getHoby() {
return hoby;
}
public void setHoby(String hoby) {
this.hoby = hoby;
}
public String getCompanyId() {
return companyId;
}
public void setCompanyId(String companyId) {
this.companyId = companyId;
}
public String getHeadImgPath() {
return headImgPath;
}
public void setHeadImgPath(String headImgPath) {
this.headImgPath = headImgPath;
}
}
主要是中间关于UserInterest那个表,是联合主键,所以主键又是一个类
现在我想实现的查询如下sql语句,请问下用hql语句怎么写
select distinct
t.nuid,
t.susername,
t.snickname,
t.nage,
t.nsex,
t.sbirthday,
t.shoby,
t.ncompanyid,
t.sheadimgpath
from
t_user_info t
where
t.nuid not in (
select
ti.nlistenedid
from
t_user_interest ti
where
nuid = :uid
)
and t.nuid != :uid
多表查询 sql语句 hql hibernate --------------------编程问答-------------------- 肿么没人。。。。 --------------------编程问答-------------------- 是要显示在jsp页面吗
如果是的话 就直接查distinct表啊 最后用 集合.t_user_info.[某个属性] 但是在外键表中lazy=false --------------------编程问答-------------------- 直接用SQL语句,返回一个List<Object[]>
补充:Java , Java EE