Hibernate查询2

最新推荐文章于 2024-09-16 21:37:07 发布

u010212202

最新推荐文章于 2024-09-16 21:37:07 发布

阅读量76

点赞数

分类专栏： Hibernate知识文章标签： java

本文链接：https://blog.csdn.net/u010212202/article/details/84233677

版权

Hibernate知识专栏收录该内容

3 篇文章 0 订阅

订阅专栏



//between  and

@Override
public PageInfo<T> queryInfoAndLikes(PageInfo<T> pageInfo,
			Map<String, String> map, String propertyName, Object minObject,
			Object maxObject) throws DataAccessException {
		if (pageInfo == null) {
			pageInfo = new PageInfo<T>();
		}
		DetachedCriteria detached = DetachedCriteria.forClass(entityClass);
		DetachedCriteria detachedPage = DetachedCriteria.forClass(entityClass);
		for (Map.Entry<String, String> en:map.entrySet()) {
			detached.add(Restrictions.like(en.getKey(),en.getValue(), MatchMode.ANYWHERE));
			detachedPage.add(Restrictions.like(en.getKey(),en.getValue(), MatchMode.ANYWHERE));
		}
		detached.add(Restrictions.between(propertyName, minObject, maxObject));
		detachedPage.add(Restrictions.between(propertyName, minObject, maxObject));
		pageInfo.setPageRow(queryByRowNumber(detachedPage));
		pageInfo.setData(this.getHibernateTemplate().findByCriteria(detached, 
				pageInfo.getCurrentPage() * pageInfo.getPageSize(), pageInfo.getPageSize()));
		return pageInfo;
	}


//外连接，别名
@Repository("organizationDao")
public class OrganizationDaoImpl extends BaseDaoImpl<Organization> implements IOrganizationDao {

	@Override
	public PageInfo<Organization> querySelfUser(PageInfo<Organization> pageInfo,
			Map<String, String> map, Map<String, Object> andEqual,
			Map<String, String> alias, String orKey1, Object value1,
			String orKey2, Object value2) {
		if (pageInfo == null) {
			pageInfo = new PageInfo<Organization>();
		}
		DetachedCriteria detached = DetachedCriteria.forClass(entityClass);
		DetachedCriteria detachedPage = DetachedCriteria.forClass(entityClass);
		if (alias != null) {
			for (Map.Entry<String,String> en:alias.entrySet()) {
				detached.createAlias(en.getKey(), en.getValue());
				detachedPage.createAlias(en.getKey(), en.getValue() ,Criteria.LEFT_JOIN);
			}
		}
		if (orKey1 != null) {
			detached.add(Restrictions.disjunction().add(Restrictions.or(
					Restrictions.eq(orKey1, value1), 
					Restrictions.eq(orKey2, value2)
					)));
			detachedPage.add(Restrictions.disjunction().add(Restrictions.or(
					Restrictions.eq(orKey1, value1), 
					Restrictions.eq(orKey2, value2)
					)));
		}
		for (Map.Entry<String, String> en:map.entrySet()) {
			detached.add(Restrictions.like(en.getKey(),en.getValue(), MatchMode.ANYWHERE));
			detachedPage.add(Restrictions.like(en.getKey(),en.getValue(), MatchMode.ANYWHERE));
		}
		for (Map.Entry<String, Object> en:andEqual.entrySet()) {
		  detached.add(Restrictions.eq(en.getKey(),en.getValue()));
		  detachedPage.add(Restrictions.eq(en.getKey(),en.getValue()));
		}
		//detached.addOrder(Order.asc("organizationId"));

		pageInfo.setPageRow(queryByRowNumber(detachedPage));
		pageInfo.setData(this.getHibernateTemplate().findByCriteria(detached, 
		pageInfo.getCurrentPage() * pageInfo.getPageSize(), pageInfo.getPageSize()));
		return pageInfo;

	}