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:com.iqtb.validacion.managedbean.MbSociosComerciales.java

@PostConstruct
public void init() {
    socioDataList = new LazyDataModel<SociosComerciales>() {
        private static final long serialVersionUID = 1L;

        @Override//from  w ww .  j a va 2s. c  o m
        public List<SociosComerciales> load(int first, int pageSize, String sortField, SortOrder sortOrder,
                Map<String, String> filters) {
            listaSocios = new ArrayList<SociosComerciales>();
            session = HibernateUtil.getSessionFactory().openSession();
            tx = session.beginTransaction();

            Criteria cr = session.createCriteria(SociosComerciales.class);
            Criteria crCount = session.createCriteria(SociosComerciales.class);
            crCount.setProjection(Projections.rowCount());
            cr.add(Restrictions.eq("idEmpresa", empresa.getIdEmpresa()));
            crCount.add(Restrictions.eq("idEmpresa", empresa.getIdEmpresa()));

            if (sortField != null && !sortField.isEmpty()) {
                if (sortOrder.equals(SortOrder.ASCENDING)) {
                    cr.addOrder(Order.asc(sortField));
                } else {
                    cr.addOrder(Order.desc(sortField));
                }
            } else {
                cr.addOrder(Order.desc("idSocioComercial"));
            }

            if (!filters.isEmpty()) {
                Iterator it = filters.keySet().iterator();
                while (it.hasNext()) {
                    String key = (String) it.next();
                    cr.add(Restrictions.like(key, "" + filters.get(key) + "%"));
                    crCount.add(Restrictions.like(key, "" + filters.get(key) + "%"));
                }
            }
            Integer num = ((Long) crCount.uniqueResult()).intValue();
            this.setRowCount(num);
            cr.setFirstResult(first);
            cr.setMaxResults(pageSize + first);
            listaSocios = cr.list();
            if (session.isOpen()) {
                session.clear();
                session.close();
            }
            return listaSocios;
        }
    };
}

From source file:com.isotrol.impe3.hib.query.PageSupport.java

License:Open Source License

/**
 * Page support for criteria queries./*from w ww. j a v  a 2  s.  co  m*/
 * @param <E> Query output type.
 * @param <D> DTO type.
 * @param count Count criteria (optional).
 * @param select Selection criteria (required).
 * @param pag Pagination (optional).
 * @param transformer Transformer (required).
 * @return
 */
public static <E, D> PageDTO<D> getPage(Criteria count, Criteria select, PaginationDTO pag,
        Function<? super E, ? extends D> transformer) {
    checkNotNull(select, "A selection query must be provided");
    final PageDTO<D> page = new PageDTO<D>();
    if (count != null) {
        count.setProjection(Projections.rowCount());
        page.setTotal(((Number) count.uniqueResult()).intValue());
    }
    if (pag != null) {
        page.setFirst(pag.getFirst());
        page.setSize(pag.getSize());
        select.setFirstResult(pag.getFirst());
        select.setMaxResults(pag.getSize());
    }
    @SuppressWarnings("unchecked")
    final List<E> list = select.list();
    page.setElements(Lists.newArrayList(Iterables.transform(list, transformer)));
    return page;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkEmail(String email, int id) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("email", email))
            .add(Restrictions.ne("id", id)).setProjection(Projections.rowCount()).uniqueResult();
    System.out.println("checkEmail " + count);
    return count == 0;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkUsername(String username, int id) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("username", username))
            .add(Restrictions.ne("id", id)).setProjection(Projections.rowCount()).uniqueResult();

    System.out.println("checkUsername " + count);
    return count == 0;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkEmail(String email) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("email", email))
            .setProjection(Projections.rowCount()).uniqueResult();
    return count == 0;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkUsername(String username) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("username", username))
            .setProjection(Projections.rowCount()).uniqueResult();
    return count == 0;
}

From source file:com.it355.filip.dao.impl.BrandDaoImpl.java

@Override
public int getCount() {

    Session session = this.sessionFactory.getCurrentSession();
    return (int) (Number) session.createCriteria("brand").setProjection(Projections.rowCount()).uniqueResult();
    /*String sql = "SELECT COUNT(*) FROM brand";
    int count = jdbcTemplate.queryForObject(sql, Integer.class);
    return count;*//*from ww  w  .j ava2s.  com*/
}

From source file:com.it355.filip.dao.impl.DisplayDaoImpl.java

@Override
public int getCount() {
    Session session = this.sessionFactory.getCurrentSession();
    return (int) (Number) session.createCriteria("display").setProjection(Projections.rowCount())
            .uniqueResult();/*from w  w  w  .j  av a2  s .  c om*/

    /*String sql = "SELECT COUNT(*) FROM display";
    int count = jdbcTemplate.queryForObject(sql, Integer.class);
    return count;*/
}

From source file:com.it355.filip.dao.impl.PicturesDaoImpl.java

@Override
public int getCount() {
    Session session = this.sessionFactory.getCurrentSession();
    return (int) (Number) session.createCriteria("pictures").setProjection(Projections.rowCount())
            .uniqueResult();/* w w  w .j ava  2  s  . com*/

    /*String sql = "SELECT COUNT(*) FROM pictures"; 
    int count = jdbcTemplate.queryForObject(sql, Integer.class); 
    return count; */
}

From source file:com.it355.filip.dao.impl.StrapDaoImpl.java

@Override
public int getCount() {
    Session session = this.sessionFactory.getCurrentSession();
    return (int) (Number) session.createCriteria("strap").setProjection(Projections.rowCount()).uniqueResult();

    /*String sql = "SELECT COUNT(*) FROM strap"; 
    int count = jdbcTemplate.queryForObject(sql, Integer.class); 
    return count; *//*from w w  w .  j a  v a2s.  c o  m*/
}