Example usage for org.hibernate.criterion DetachedCriteria forClass

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria forClass.

Prototype

public static DetachedCriteria forClass(Class clazz)

Source Link

Document

Static builder to create a DetachedCriteria for the given entity, by its Class.

Usage

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Option.class);

    if (condition == null) {
        return criteria;
    }//from   w ww .  ja  v  a2 s  .  co m

    if (condition.containsKey("option_name")) {
        criteria.add(
                Restrictions.ilike("optionName", condition.get("option_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

@Override
public List<Option> getRootOptionsByCidAndVer(int cid, int ver) {
    DetachedCriteria criteria = DetachedCriteria.forClass(OptionMapping.class);

    criteria.createAlias("course", "c");
    criteria.createAlias("option", "o");
    criteria.createAlias("parentOption", "p");

    criteria.add(Restrictions.isNull("p"));
    criteria.add(Restrictions.eq("c.id", cid));
    criteria.add(Restrictions.eq("optionVer", ver));

    //        criteria.setProjection(Projections.groupProperty("o.optionGroupId"));
    //        criteria.setProjection(Projections.max("optionVer"));
    List<OptionMapping> oms = optionMappingDAO.search(0, Integer.MAX_VALUE, criteria);
    List<Option> options = new ArrayList<>();
    for (OptionMapping om : oms) {
        options.add(om.getOption());//from  ww  w. ja v  a 2s . c o  m
    }
    return options;
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

@Override
public List<Option> getOptionsByCidAndVer(int cid, int ver) {
    DetachedCriteria criteria = DetachedCriteria.forClass(OptionMapping.class);

    criteria.createAlias("course", "c");
    criteria.createAlias("option", "o");

    criteria.add(Restrictions.eq("c.id", cid));
    criteria.add(Restrictions.eq("optionVer", ver));

    //        criteria.setProjection(Projections.groupProperty("o.optionGroupId"));
    //        criteria.setProjection(Projections.max("optionVer"));
    List<OptionMapping> oms = optionMappingDAO.search(0, Integer.MAX_VALUE, criteria);
    List<Option> options = new ArrayList<>();
    for (OptionMapping om : oms) {
        options.add(om.getOption());/* w  w w.ja  va2  s.co m*/
    }
    return options;
}

From source file:chiron.maxscore.service.impl.RoleServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Role.class);

    if (condition == null) {
        return criteria;
    }/*from   w w  w.ja  v a2s  .  c o  m*/

    if (condition.containsKey("role_name")) {
        criteria.add(Restrictions.ilike("roleName", condition.get("role_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.SpecialtyServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Specialty.class);

    if (condition == null) {
        return criteria;
    }//from  w w w  . j a va 2s.  co m

    if (condition.containsKey("college_id")) {
        criteria.createAlias("college", "c").add(Restrictions.eq("c.id", condition.get("college_id")));
    }

    if (condition.containsKey("specialty_name")) {
        criteria.add(Restrictions.ilike("specialtyName", condition.get("specialty_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.TeacherServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Teacher.class);

    if (condition == null) {
        return criteria;
    }/*from   w w w . j  a v  a 2  s .c om*/

    if (condition.containsKey("teacher_name")) {
        criteria.add(Restrictions.ilike("teacherName", condition.get("teacher_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:cn.trymore.core.dao.impl.DAOGenericImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<T> getAll(final boolean filter) throws DAOException {
    return (List<T>) getHibernateTemplate().execute(new HibernateCallback() {
        @Override/* w ww .j a  v a2  s. c  o  m*/
        public Object doInHibernate(Session paramSession) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(DAOGenericImpl.this.entityClass);

            if (filter && UtilString.isNotEmpty(DAOGenericImpl.this.getQueryFilter())) {
                criteria.add(Restrictions.sqlRestriction(DAOGenericImpl.this.getQueryFilter()));
                DAOGenericImpl.this.setQueryFilter(null);
            }

            return getHibernateTemplate().findByCriteria(criteria);

            // String str = "from " + DAOGenericImpl.this.entityClass.getName();
            //return paramSession.createQuery(str).list();
        }
    });
}

From source file:cn.trymore.core.dao.impl.DAOGenericImpl.java

License:Open Source License

public PaginationSupport<T> queryFieldsListForPaging(final Class<?> objectClass,
        Map<String, List<Object>> params, int pageSize, int startIndex) throws DAOException {

    DetachedCriteria criteria = DetachedCriteria.forClass(objectClass);

    if (params != null && params.size() > 0) {
        for (Map.Entry<String, List<Object>> entry : params.entrySet()) {
            String keyName = entry.getKey();
            List<Object> keyValues = entry.getValue();
            criteria.add(Restrictions.in(keyName, keyValues));
        }/*from  www  . jav a  2  s  . c o m*/
    }

    return findPageByCriteria(criteria, pageSize, startIndex);
}

From source file:cn.trymore.core.service.impl.ServiceGenericImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//  w  w w  .  jav  a  2 s . c o  m
public PaginationSupport<T> getByQuery(final String nativeSql, final PagingBean pagingBean)
        throws ServiceException {
    try {
        Class<T> entityClass = (Class<T>) ((ParameterizedType) getClass().getGenericSuperclass())
                .getActualTypeArguments()[0];

        DetachedCriteria criteria = DetachedCriteria.forClass(entityClass);

        if (UtilString.isNotEmpty(nativeSql)) {
            if (nativeSql.trim().toLowerCase().startsWith("and")) {
                criteria.add(Restrictions.sqlRestriction(nativeSql.toLowerCase().replaceFirst("and", "")));
            } else {
                criteria.add(Restrictions.sqlRestriction(nativeSql));
            }
        }

        return dao.findPageByCriteria(criteria, pagingBean);
    } catch (Exception e) {
        throw new ServiceException(e);
    }
}

From source file:cn.trymore.oa.service.system.impl.ServiceSystemLogImpl.java

License:Open Source License

@Override
public PaginationSupport<ModelSystemLog> getPaginationByEntity(ModelSystemLog entity, PagingBean pagingBean)
        throws ServiceException {
    DetachedCriteria criteria = DetachedCriteria.forClass(ModelSystemLog.class);

    if (entity != null) {
        if (UtilString.isNotEmpty(entity.getExeOperation())) {
            criteria.add(Restrictions.eq("exeOperation", entity.getExeOperation()));
        }/*w  w  w  .  ja v a2s.  co  m*/

        if (entity.getDistrictId() != null && UtilString.isNotEmpty(entity.getDistrictId())) {
            criteria.createCriteria("user").createCriteria("district")
                    .add(Restrictions.eq("id", entity.getDistrictId()));
        }

        if (entity.getStartTime() != null && UtilString.isNotEmpty(entity.getStartTime())) {
            criteria.add(Restrictions.ge("createtime", entity.getStartTime()));
        }

        if (entity.getEndTime() != null && UtilString.isNotEmpty(entity.getEndTime())) {
            criteria.add(Restrictions.le("createtime", entity.getEndTime()));
        }
    }

    // added by Jeccy.Zhao on 14/10/2012
    criteria.addOrder(Order.desc("createtime"));

    return this.getAll(criteria, pagingBean);
}