其中MobiUser和Rewards是多对多的关系,MobiuserRewardsR是连接它们的关联表。
@Override
public List<MobiuserRewardsR> findMyRewards(TableModel<MobiuserRewardsR> tableModel, Long mobiUserId) {
DetachedCriteria dc = DetachedCriteria.forClass(MobiuserRewardsR.class);
dc.setFetchMode("mobiUser", FetchMode.JOIN);
dc.setFetchMode("rewards", FetchMode.JOIN);
if (mobiUserId != null) {
dc.createAlias("mobiUser", "mobiUser");
dc.add(Restrictions.eq("mobiUser.id", mobiUserId));
}
dc.createAlias("rewards", "rewards");
dc.add(Restrictions.eq("rewards.deleted", Constant.NO));
dc.add(Restrictions.eq("rewards.enabled", Constant.ENABLED));
dc.add(Restrictions.gt("rewards.endTime", new Date()));
dc.addOrder(Order.asc("rewards.endTime"));
return findPageByCriteria(dc, tableModel);
}
/**
* MobiuserRewardsR generated by hbm2java
*/
@Entity
@Table(name = "mobiuser_rewards_r", schema = "public")
public class MobiuserRewardsR extends BaseBo {
private long id;
private Rewards rewards;
private MobiUser mobiUser;
private Boolean gift;
public MobiuserRewardsR() {
}
@SequenceGenerator(name = "seq_mobiuser_rewards_r", sequenceName = "seq_mobiuser_rewards_r", initialValue = 1, allocationSize = 1)
@GeneratedValue(strategy = GenerationType.AUTO, generator = "seq_mobiuser_rewards_r")
@Id
@Column(name = "id", unique = true, nullable = false)
public long getId() {
return this.id;
}
public void setId(long id) {
this.id = id;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "rew_id")
public Rewards getRewards() {
return this.rewards;
}
public void setRewards(Rewards rewards) {
this.rewards = rewards;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "mobiuser_id")
public MobiUser getMobiUser() {
return this.mobiUser;
}
public void setMobiUser(MobiUser mobiUser) {
this.mobiUser = mobiUser;
}
public Boolean getGift() {
return gift;
}
@Column(name = "gift", nullable = false)
public void setGift(Boolean gift) {
this.gift = gift;
}
}
分享到:
相关推荐
DetachedCriteria的查询方式汇总
NULL 博文链接:https://chaoyi.iteye.com/blog/2152094
DetachedCriteria
DetachedCriteria使用介绍
DetachedCriteria Criteria 使用方法 非常详细外加练习
Hibernate - DetachedCriteria 的完整用法文档描述
下面小编就为大家带来一篇浅谈DetachedCriteria和Criteria的使用方法(必看)。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
NULL 博文链接:https://rmn190.iteye.com/blog/379302
源文件 博文链接:https://kings008.iteye.com/blog/246773
().findByCriteria(detachedCriteria) 方法可以很方便地根据DetachedCriteria 来返回查询结 果。 DetachedCriteria 提供了 2 个静态方法 forClass(Class) 或 forEntityName(Name) 进行DetachedCriteria 实例的创建。
使用 Hibernate Criteria && DetachedCriteria Queries演示Exists Clause非常简单的项目 安装 git clone https://github.com/RameshRM/hibernate-sample.git 跑步 mvn install 这是一个maven项目,依赖项是 ...