Example usage for org.hibernate.criterion DetachedCriteria setProjection

Introduction

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

Prototype

public DetachedCriteria setProjection(Projection projection)

Source Link

Document

Set the projection to use.

Usage

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

public int findByCreateDateSpacingCount(Date startDate, Date endDate, int RiverSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(River.class);
    //        criteria.createAlias("riverSource8", "cs");
    //        if(0!=RiverSourceType){
    //            criteria.add(Expression.eq("cs.id", RiverSourceType));
    //        }/*www  .j a va 2s  .co m*/
    criteria.add(Expression.between("begindate", startDate, endDate));
    criteria.add(Restrictions.ne("id", 1));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.createAlias("village", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.vname"))
            .add(Projections.groupProperty("cs.vname")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@Override
public boolean existRiver(Integer id, String license) {
    // TODO Auto-generated method stub
    DetachedCriteria criteria = DetachedCriteria.forClass(River.class);
    criteria.add(Expression.eq("State", IRiverService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("rid", license));
    if (id != null) {
        criteria.add(Expression.ne("id", id));
    }/*  w  ww . ja va2 s  .co  m*/
    return ((Integer) getHibernateTemplate().findByCriteria(criteria).get(0)) > 0;
}

From source file:org.gaixie.micrite.security.dao.hibernate.AuthorityDAOImpl.java

License:Open Source License

public Integer findByNameVagueCount(String name) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Authority.class);
    criteria.add(Expression.like("name", "%" + name + "%"));
    criteria.add(Expression.eq("state", 0));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.security.dao.hibernate.RoleDAOImpl.java

License:Open Source License

public Integer findByAuthorityIdCount(int authorityId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Role.class);
    criteria.setProjection(Projections.rowCount()).createCriteria("authorities")
            .add(Expression.eq("id", authorityId));
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.security.dao.hibernate.RoleDAOImpl.java

License:Open Source License

public Integer findByNameVagueCount(String name) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Role.class);
    criteria.add(Expression.like("name", "%" + name + "%"));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.security.dao.hibernate.RoleDAOImpl.java

License:Open Source License

public Integer findByUserIdCount(int userId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Role.class);
    criteria.setProjection(Projections.rowCount()).createCriteria("users").add(Expression.eq("id", userId));
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.security.dao.hibernate.UserDAOImpl.java

License:Open Source License

public Integer findByFullnameVagueCount(String fullname) {
    DetachedCriteria criteria = DetachedCriteria.forClass(User.class);
    criteria.add(Expression.like("fullname", "%" + fullname + "%"));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.security.dao.hibernate.UserDAOImpl.java

License:Open Source License

public Integer findByRoleIdCount(int roleId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(User.class);
    criteria.setProjection(Projections.rowCount());
    DetachedCriteria subCriteria = criteria.createCriteria("roles");
    subCriteria.add(Expression.eq("id", roleId));
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
    //        List<User> list = getHibernateTemplate().find("select u from User u join u.roles as r where r.id=?",roleId );
    //        return list;
}

From source file:org.generationcp.middleware.dao.dms.DmsProjectDao.java

License:Open Source License

private Criteria buildCoreCriteria(final Map<StudyFilters, String> parameters, final Order orderBy) {
    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());
    criteria.add(Restrictions.isNotNull("studyType"));

    criteria.add(Restrictions.ne(DmsProjectDao.DELETED, true));

    if (parameters.containsKey(StudyFilters.PROGRAM_ID)) {
        criteria.add(Restrictions.eq(StudyFilters.PROGRAM_ID.getParameter(),
                parameters.get(StudyFilters.PROGRAM_ID)));
    } else {//from   ww w .  j a  v a  2 s .  c  o m
        criteria.add(Restrictions.isNotNull(StudyFilters.PROGRAM_ID.getParameter()));
    }

    if (parameters.containsKey(StudyFilters.LOCATION_ID)) {
        // Find environments with specified location (saved in GeolocationProperty)
        final DetachedCriteria locationCriteria = DetachedCriteria.forClass(ExperimentModel.class);
        locationCriteria.add(Restrictions.eq("typeId", TermId.TRIAL_ENVIRONMENT_EXPERIMENT.getId()));
        locationCriteria.createAlias("geoLocation", "g");
        locationCriteria.createAlias("g.properties", "gp");
        locationCriteria.createAlias("project", "p");
        locationCriteria.createAlias("p.study", "st");
        locationCriteria.add(Restrictions.and(Restrictions.eq("gp.typeId", DmsProjectDao.LOCATION_ID),
                Restrictions.eq("gp.value", parameters.get(StudyFilters.LOCATION_ID))));
        locationCriteria.setProjection(Projections.property("st.projectId"));
        criteria.add(Property.forName("projectId").in(locationCriteria));
    }

    criteria.addOrder(orderBy);
    return criteria;
}