Example usage for org.hibernate.criterion Projections rowCount

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections rowCount.

Prototype

public static Projection rowCount()

Source Link

Document

The query row count, ie.

Usage

From source file:br.ufg.calendario.dao.InteressadoDao.java

@Transactional(readOnly = true)
public int rowCount() {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Interessado.class);
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.calendario.dao.InteressadoDao.java

@Transactional(readOnly = true)
public int rowCount(String termo) {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Interessado.class);
    if (termo != null && !termo.isEmpty()) {
        criteria.add(Restrictions.or(Restrictions.like("sigla", termo.trim(), MatchMode.ANYWHERE).ignoreCase(),
                Restrictions.like("nome", termo.trim(), MatchMode.ANYWHERE).ignoreCase()));
    }/*from   w  w  w .  ja v a  2 s.c  om*/
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.calendario.dao.RegionalDao.java

@Transactional(readOnly = true)
public int rowCount() {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Regional.class);
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.calendario.dao.RegionalDao.java

@Transactional(readOnly = true)
public int rowCount(String termo) {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Regional.class);
    if (termo != null && !termo.isEmpty()) {
        criteria.add(Restrictions.like("nome", termo.trim(), MatchMode.ANYWHERE).ignoreCase());
    }/*from   w  ww .ja va  2  s  .  c  o  m*/
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.calendario.dao.UsuarioDao.java

@Transactional(readOnly = true)
public int rowCount() {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Usuario.class);
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.calendario.dao.UsuarioDao.java

@Transactional(readOnly = true)
public int rowCount(Map<String, Object> filters) {
    Session session = sessionFactory.getCurrentSession();
    Criteria criteria = session.createCriteria(Usuario.class);
    for (String key : filters.keySet()) {
        if (key.equals("nome")) {
            criteria.add(/*from   w  w  w .  j  a  va 2  s.co m*/
                    Restrictions.like("nome", filters.get(key).toString(), MatchMode.ANYWHERE).ignoreCase());
        }

        if (key.equals("login")) {
            criteria.add(
                    Restrictions.like("login", filters.get(key).toString(), MatchMode.ANYWHERE).ignoreCase());
        }

        if (key.equals("perfil")) {
            PerfilEnum p = (PerfilEnum) filters.get(key);
            criteria.add(Restrictions.eq("perfil", p));
        }
    }
    return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
}

From source file:br.ufg.reqweb.dao.TurmaDao.java

@Transactional(readOnly = true)
public int count(Map<String, Object> filters) {
    if (filters == null) {
        filters = new HashMap();
    }//from  www . j  a v  a2 s .  c o m
    try {
        Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Turma.class);
        criteria.createAlias("disciplina", "d");
        for (String field : filters.keySet()) {
            if (field.equals("termo")) {
                criteria.add(Restrictions.and(Restrictions
                        .like("d.nome", filters.get(field).toString(), MatchMode.ANYWHERE).ignoreCase()));
            }
            if (field.equals("periodo")) {
                criteria.add(Restrictions.and(Restrictions.eq("periodo", filters.get(field))));
            }
            if (field.equals("curso")) {
                criteria.add(Restrictions.and(Restrictions.eq("d.curso", filters.get(field))));
            }
        }
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
        return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
    } catch (HibernateException e) {
        System.out.println("query error: " + e.getMessage());
        return 0;
    }

}

From source file:br.vschettino.forum.dao.DiscussaoDAOImpl.java

@Override
@Transactional//  w  w  w  . j a  v  a  2 s  .co m
public Long getCount() {
    return (Long) sessionFactory.getCurrentSession().createCriteria(Discussao.class)
            .setProjection(Projections.rowCount()).uniqueResult();
}

From source file:br.vschettino.forum.dao.RespostaDAOImpl.java

@Override
@Transactional//from w ww  .  j  a  v a2  s .c  om
public Long getCount() {
    return (Long) sessionFactory.getCurrentSession().createCriteria(Resposta.class)
            .setProjection(Projections.rowCount()).uniqueResult();
}

From source file:ca.qc.cegepoutaouais.tge.pige.server.ManagementServiceImpl.java

License:Open Source License

@Override
public PagingLoadResult<UserDetail> getAllUserDetail(PagingLoadConfig config) throws PigeException {

    PermissionHelper.checkUserManagementPermission(getThreadLocalRequest());

    logger.debug("Rcupration des dtails de tous les usagers " + "[Pagination: dpart=" + config.getOffset()
            + ", max=" + config.getLimit() + "] ...");

    BaseFilterPagingLoadConfig xConfig = null;
    if (config instanceof BaseFilterPagingLoadConfig) {
        xConfig = (BaseFilterPagingLoadConfig) config;
    }/*from  w  w w .ja v  a2s.  c  om*/

    Session session = null;
    Transaction tx = null;
    List<User> users = null;
    List<UserDetail> userDetailList = null;
    Integer userCount = 0;
    Integer start;
    Integer limit;

    try {

        session = PigeHibernateUtil.openSession();
        tx = session.beginTransaction();

        Criteria criteria = session.createCriteria(User.class);
        Criterion filterCriterion = PigeHibernateUtil.buildFilterCriterion(xConfig.getFilterConfigs());
        if (filterCriterion != null) {
            criteria.add(filterCriterion);
        }

        userCount = (Integer) session.createCriteria(User.class).setProjection(Projections.rowCount())
                .uniqueResult();

        start = config.getOffset();
        limit = userCount;
        if (limit > 0 && config.getLimit() > 0) {
            limit = Math.min(config.getLimit(), limit);
        }

        logger.debug("Paramtres d'extraction des donnes: dpart=" + start + ", max=" + limit + "] ...");

        criteria.setProjection(null);
        criteria.setResultTransformer(Criteria.ROOT_ENTITY);

        users = (List) criteria.setFirstResult(start).setMaxResults(limit).list();

        tx.commit();

        userDetailList = new ArrayList();
        for (User u : users) {
            userDetailList.add(u.getUserDetail());
        }

        logger.debug("Rcupration russie!");
    } catch (Exception hex) {
        logger.error(hex);
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return new BasePagingLoadResult(userDetailList, config.getOffset(), userCount);
}