Spring+Hibrenate中findByCriteria(criteria, start, limit)查询重复的问题解决

最新推荐文章于 2020-05-04 18:45:40 发布

原创

最新推荐文章于 2020-05-04 18:45:40 发布 · 3.4k 阅读

0 ·

CC 4.0 BY-SA版权

在Spring+Hibernate集成应用中遇到使用findByCriteria(criteria, start, limit)进行分页查询时出现结果重复的问题。问题源于两个实体类MessageModel和CaseProcess之间的关联。通过修改MessageModelService中的getConditions方法，成功解决了查询重复的故障。" 125280906,10247357,Vue项目搭建与管理指南,"['前端开发', 'Vue', 'vue-cli', 'npm', 'node.js']

1、问题出现的场景：两个Entity互相关联，我这里有两个类MessageMedel和CaseProcess，代码如下：

MessageModel类：

public class MessageModel extends Model {
	@Id
	@GeneratedValue
	@OrderBy("id")
	private long id;

	@ManyToMany(fetch = FetchType.EAGER)
	private List<Dict> recivers = new ArrayList<Dict>();

	@ManyToOne
	private Dict messageType;

	// 关联多个CaseProcess对象
	@OneToMany(cascade = CascadeType.ALL)
	private List<CaseProcess> caseProcessList;

}

CaseProcess类：

@Entity
public class CaseProcess extends Model {

	@Id
	@GeneratedValue
	private long id;

	@ManyToOne
	private Dict timerType;
	@ManyToOne
	private Dict caseGrade;
	@ManyToOne
	private Dict caseStatus;

	// 关联一个MessageModel对象
	@ManyToOne
	private MessageModel messageModel;

}

其中MessageModel中caseProcessList关联多个CaseProcess，CaseProcess中关联一个MessageModel，当使用hibernateTemplate.findByCriteria(criteria, start