Example usage for org.hibernate Criteria add

Introduction

In this page you can find the example usage for org.hibernate Criteria add.

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

From source file:biomart.DAO.SalesmanDAO.java

public String getSalesmanId(String userName) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("userName", userName));
    PersonalDetailsBean personalDetailsBean = null;
    if (!criteria.list().isEmpty()) {
        personalDetailsBean = (PersonalDetailsBean) criteria.list().get(0);
        session.close();//ww  w. jav a2 s . c om
        return personalDetailsBean.getUserId();
    }
    session.close();
    return null;

}

From source file:biomart.DAO.SalesmanDAO.java

public String getSalesmanId(String userName, long phoneNo) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("userName", userName));
    criteria.add(Restrictions.eq("phoneNo", phoneNo));
    PersonalDetailsBean personalDetailsBeans = (PersonalDetailsBean) criteria.list().get(0);
    session.close();//from w w w  .  java  2 s. c  o m
    return personalDetailsBeans.getUserId();

}

From source file:bo.com.kibo.dal.impl.DAOGenericoHibernate.java

@Override
public List<T> buscarPorEjemplo(T exampleInstance, String... excludeProperty) {
    Criteria crit = getSession().createCriteria(getPersistentClass());
    Example example = Example.create(exampleInstance);
    for (String exclude : excludeProperty) {
        example.excludeProperty(exclude);
    }/*from   w  ww  .  j  a va2  s.  c om*/
    crit.add(example);
    return crit.list();
}

From source file:bo.com.kibo.dal.impl.DAOGenericoHibernate.java

/**
 * Use this inside subclasses as a convenience method.
 *
 * @param criterion// w  ww.  ja v  a 2 s. co m
 * @return
 */
protected List<T> findByCriteria(Criterion... criterion) {
    Criteria crit = getSession().createCriteria(getPersistentClass());
    for (Criterion c : criterion) {
        crit.add(c);
    }
    return crit.list();
}

From source file:br.al.contractmanager.dao.UsuarioDao.java

@Transactional(readOnly = true)
public int count(String termo) {
    Session session = sessionFactory.getCurrentSession();
    try {/*from  www.  j  a  v a  2 s. co  m*/
        Criteria criteria = session.createCriteria(Usuario.class);
        criteria.add(Restrictions.or(Restrictions.eq("matricula", termo),
                Restrictions.like("nomeUsuario", termo, MatchMode.ANYWHERE).ignoreCase(),
                Restrictions.like("nomeCompleto", termo, MatchMode.ANYWHERE).ignoreCase()))
                .setProjection(Projections.distinct(Projections.id()));
        return ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
    } catch (HibernateException e) {
        System.out.println(e.getMessage());
        return 0;
    }
}

From source file:br.com.arsmachina.authentication.dao.hibernate.PermissionDAOImpl.java

License:Apache License

/**
 * @see br.com.arsmachina.authentication.dao.PermissionDAO#findByName(java.lang.String)
 *//*from   w w  w .j  av a 2 s . c om*/
public Permission findByName(String name) {

    final Criteria criteria = createCriteria();
    criteria.add(Restrictions.eq("name", name));

    return (Permission) criteria.uniqueResult();

}

From source file:br.com.arsmachina.authentication.dao.hibernate.PermissionGroupDAOImpl.java

License:Apache License

/**
 * @see br.com.arsmachina.authentication.dao.PermissionGroupDAO#findByName(java.lang.String)
 *//*  w ww .  j  a  va 2  s .c o m*/
public PermissionGroup findByName(String name) {

    final Criteria criteria = createCriteria();
    criteria.add(Restrictions.eq("name", name));

    return (PermissionGroup) criteria.uniqueResult();

}

From source file:br.com.arsmachina.dao.hibernate.ReadableDAOImpl.java

License:Apache License

/**
 * @see br.com.arsmachina.dao.ReadableDAO#findByIds(K[])
 *//* w w w  . ja  va 2  s  . c o  m*/
@SuppressWarnings("unchecked")
public List<T> findByIds(K... ids) {

    Criteria criteria = createCriteria();
    criteria.add(Restrictions.in(getPrimaryKeyPropertyName(), ids));
    return criteria.list();

}

From source file:br.com.arsmachina.dao.hibernate.ReadableDAOImpl.java

License:Apache License

/**
 * @see br.com.arsmachina.dao.ReadableDAO#findByExample(java.lang.Object)
 *//*from  w w w. j av a  2  s . c om*/
@SuppressWarnings("unchecked")
public List<T> findByExample(T example) {

    Criteria criteria = createCriteria();

    if (example != null) {
        criteria.add(createExample(example));
    }

    return criteria.list();

}