Hibernate的QBC查询语句问题

Scorpio_ya Scorpio_ya 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
有三张表分别关系如下:
Member表(会员表,属性:id主键,等等)
Product表(产品表,属性:id主键,等等)
MemberFavoriteProduct表:(会员关注产品表)

create table MemberFavoriteProduct(
favorite_members int references Member(id) not null,
favorite_products int references Products(id) not null,
primary key(favorite_members, favorite_products)
)


实体:
Member实体:

private Set<Product> favoriteProducts = new HashSet<Product>();
.........
@ManyToMany(fetch = FetchType.LAZY)
@JoinTable(name = "MemberFavoriteProduct", joinColumns = @JoinColumn(name = "favorite_members"), inverseJoinColumns = @JoinColumn(name = "favorite_products"))
public Set<Product> getFavoriteProducts() {
return this.favoriteProducts;
}

public void setFavoriteProducts(Set<Product> favoriteProducts) {
this.favoriteProducts = favoriteProducts;
}


Product实体:

private Set<Member> favoriteMembers = new HashSet<Member>();
..........
@ManyToMany(mappedBy = "favoriteProducts", fetch = FetchType.LAZY)
public Set<Member> getFavoriteMembers() {
return this.favoriteMembers;
}

public void setFavoriteMembers(Set<Member> favoriteMembers) {
this.favoriteMembers = favoriteMembers;
}

根据以上实体映射,所以没有建立MemberFavoriteProduct实体

需求:想根据会员去查它关注的有哪些产品,dao方法:

Criteria criteria = this.getSession().createCriteria(Product.class);
criteria.createAlias("favoriteMembers","x", JoinType.INNER_JOIN);
criteria.add(Restrictions.eq("x.favoriteMembers", member));//member为参数对象
.........


x为别名,但是打印出的语句是
select count(*) as y0_ from Product this_ inner join MemberFavoriteProduct favoriteme3_ on this_.id=favoriteme3_.favorite_products inner join Member x1_ on favoriteme3_.favorite_members=x1_.id where favoriteme3_.favorite_members.id = ?


问题:它把member对象给取别名为x了,不是MemberFavoriteProduct对象取名为x,如何才能得到MemberFavoriteProduct的别名,或者怎么去设置它的别名,求出结果??(还是用QBC) 求大神支招,感激不尽!!


...全文

相关推荐

评论 4
收藏 已收藏
分享
返回顶部
Scorpio_ya
Web 开发 81,107 成员 341,720 内容