使用DetachedCriteria分离查询条件

最新推荐文章于 2018-09-03 06:28:00 发布

lvw1105

最新推荐文章于 2018-09-03 06:28:00 发布

阅读量145

点赞数

分类专栏： hibernate 文章标签： DetachedCriteria 动态条件查询

hibernate 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

Service


		Criterion c1 = Restrictions.eq("diprojectId", projectId);
		Criterion c2 = Restrictions.in("digroupId", groupId);
		Criterion c3 = Restrictions.eq("divalid", Const_val.C_INT_VALID);
		List<TbDeviceInfo> deviceInfoList = deviceInfoDao.findAvlByProIdAndGroupId(projectId, groupId, c1, c2, c3);

Dao


public List<TbDeviceInfo> findAvlByProIdAndGroupId(Integer projectId, Collection<Integer> groupId, Criterion... c)

		DetachedCriteria criteria = DetachedCriteria.forClass(TbDeviceInfo.class);

		for (Criterion criterion : c) {
			criteria.add(criterion);
		}
		List<TbDeviceInfo> results = getHibernateTemplate().findByCriteria(criteria);