关于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语句hqlhibernate
首先是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语句hqlhibernate
解决方案 »
- java如何调用c++编写的webservice接口
- spring 事务管理问题 当一个线程处地使用状态时,其它线程不能操作数据库
- 问一个hibernate里的,关于复合主键的问题
- 在tomcat部署web service
- struts2的例子配置问题
- 学习J2EE的一些问题~~恳请前辈们给小一辈的说两句~~
- 请教各位大虾:如何把中文转换成如下格式: 国家 转换成 %B9%FA%BC%D2 感谢!!
- 晕~strutsCS与Model2X的一个小问题~~是不是这样的A?
- WSAD内JDBC连接
- 如何通过EJB删除数据库中的一行记录? 请帮忙
- 关于进销存管理系统的一些问题请教
- HTTP Status 500 -
如果是的话 就直接查distinct表啊 最后用 集合.t_user_info.[某个属性] 但是在外键表中lazy=false