Example usage for org.hibernate Criteria uniqueResult

Introduction

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

Prototype

public Object uniqueResult() throws HibernateException;

Source Link

Document

Convenience method to return a single instance that matches the query, or null if the query returns no results.

Usage

From source file:abid.password.swing.dao.hibernate.UserDaoImpl.java

License:Apache License

public User getUser(String username) {
    Session session = getSessionFactory().openSession();
    try {/*from  w w w  . j a v a 2  s .co m*/
        session.beginTransaction();
        Criteria criteria = session.createCriteria(User.class);
        criteria.add(Restrictions.eq("username", username));
        User user = (User) criteria.uniqueResult();
        // Query query = session.createQuery("from User u where u.username = ?");
        // query.setString(0, username);
        // User user = (User) query.uniqueResult();
        return user;
    } catch (HibernateException e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return null;
}

From source file:abid.password.wicket.dao.UserDaoHibernateImpl.java

License:Apache License

@Transactional(type = TransactionType.READ_ONLY)
public User getUser(String username) {
    Criteria criteria = getSession().get().createCriteria(User.class);
    criteria.add(Restrictions.eq("username", username));
    User user = (User) criteria.uniqueResult();
    // Query query = session.createQuery("from User u where u.username = ?");
    // query.setString(0, username);
    // User user = (User) query.uniqueResult();
    return user;/* w  ww.j  a  v  a2 s .  c  o m*/
}

From source file:akvelon.domain.dao.UsersDAOImpl.java

@Override
public Users getById(int id) {
    Session session = HibernateUtil.getSessionFactory().openSession();

    Criteria crit = session.createCriteria(Users.class).add(Restrictions.eq("id", id));
    Users u = (Users) crit.uniqueResult();
    session.close();//from  www  .j  a v a 2 s.  co m
    return u;
}

From source file:analysers.MarketValueAnalyser.java

License:Open Source License

public static void main(String[] args) throws ParseException {

    HibernateSupport.beginTransaction();
    Criteria cr = HibernateSupport.getCurrentSession().createCriteria(News.class);
    cr.createAlias("news_details", "details");
    cr.add(Restrictions.ge("details.total_objectivity", 0.5));
    cr.add(Restrictions.le("details.total_objectivity", 1.0));
    cr.setProjection(Projections.rowCount());
    long size = (long) cr.uniqueResult();
    HibernateSupport.commitTransaction();

    System.out.println("size = " + size);

    MarketValueAnalyser mva = new MarketValueAnalyser();
    //mva.createDistributionTable(40, 1, MarketValueAnalyser.Analyse.AFTER, false);
    mva.createDistributionTable(40, 3, MarketValueAnalyser.Analyse.AFTER, false);
    mva.createDistributionTable(40, 5, MarketValueAnalyser.Analyse.AFTER, false);
    mva.createDistributionTable(40, 7, MarketValueAnalyser.Analyse.AFTER, false);

    mva.createDistributionTable(40, 1, MarketValueAnalyser.Analyse.BEFORE, false);
    mva.createDistributionTable(40, 3, MarketValueAnalyser.Analyse.BEFORE, false);
    mva.createDistributionTable(40, 5, MarketValueAnalyser.Analyse.BEFORE, false);
    mva.createDistributionTable(40, 7, MarketValueAnalyser.Analyse.BEFORE, false);

}

From source file:apm.common.core.DaoImpl.java

License:Open Source License

/**
 * /*w w  w  . ja v  a2s  .  c om*/
 * @param detachedCriteria
 * @return
 */
@SuppressWarnings("rawtypes")
public long count(DetachedCriteria detachedCriteria) {
    Criteria criteria = detachedCriteria.getExecutableCriteria(getSession());
    long totalCount = 0;
    try {
        // Get orders
        Field field = CriteriaImpl.class.getDeclaredField("orderEntries");
        field.setAccessible(true);
        List orderEntrys = (List) field.get(criteria);
        // Remove orders
        field.set(criteria, new ArrayList());
        // Get count
        criteria.setProjection(Projections.rowCount());
        totalCount = Long.valueOf(criteria.uniqueResult().toString());
        // Clean count
        criteria.setProjection(null);
        // Restore orders
        field.set(criteria, orderEntrys);
    } catch (NoSuchFieldException e) {
        e.printStackTrace();
    } catch (IllegalAccessException e) {
        e.printStackTrace();
    }
    return totalCount;
}

From source file:at.ac.tuwien.ifs.tita.dao.GenericHibernateDao.java

License:Apache License

/** {@inheritDoc} */
@SuppressWarnings("unchecked")
public T findById(ID id, String... joinProps) {
    T myEntity = null;/* w w  w . j  av  a  2 s .  c om*/
    Criteria criteria = null;

    try {
        criteria = getSession().createCriteria(this.persistenceClass);
        criteria.add(Restrictions.idEq(id));
        for (String prop : joinProps) {
            criteria.setFetchMode(prop, FetchMode.JOIN);
        }
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
        myEntity = (T) criteria.uniqueResult();
    } catch (Exception e) {
        throw new PersistenceException("Fehler beim lesen eines Entities: Class="
                + this.persistenceClass.getSimpleName() + " Key=" + id.toString() + "\n" + e.getMessage(), e);
    }

    return myEntity;

}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.RequestCapabilitiesDao.java

License:Open Source License

/**
 * Find the request capabilities entity which match the specified capabilities.
 * <code>null</code> is returned if none is found.
 *  /*www.ja v a 2  s .com*/
 * @param capabilities capabilities to find 
 * @return capabilities or null
 */
public RequestCapabilities findCapabilites(String capabilities) {
    Criteria cri = this.session.createCriteria(RequestCapabilities.class);
    cri.add(Restrictions.eq("capabilities", new Capabilities(capabilities).asCapabilitiesString()));
    return (RequestCapabilities) cri.uniqueResult();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.RigCapabilitiesDao.java

License:Open Source License

/**
 * Find the rig capabilities entity which match the specified capabilities.
 * <code>null</code> is returned if none is found.
 *  //from   w ww.  j  a v a2 s  . co m
 * @param capabilities capabilities to find 
 * @return capabilities or null
 */
public RigCapabilities findCapabilites(String capabilities) {
    Criteria cri = this.session.createCriteria(RigCapabilities.class);
    cri.add(Restrictions.eq("capabilities", new Capabilities(capabilities).asCapabilitiesString()));
    return (RigCapabilities) cri.uniqueResult();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.RigDao.java

License:Open Source License

/**
 * Finds the rig with the specified name or <code>null</code> if not
 * found.//from   w  w w  .ja v a  2s.  c o m
 * 
 * @param name rig name
 * @return rig or null if not found
 */
public Rig findByName(String name) {
    Criteria cri = this.session.createCriteria(Rig.class);
    cri.add(Restrictions.eq("name", name));
    return (Rig) cri.uniqueResult();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.RigTypeDao.java

License:Open Source License

/**
 * Returns the rig type with the specified name. If non exist, 
 * <code>null</code> is returned.
 * //from w w w .  j  a  v  a2s  .  co m
 * @param name rig type name
 * @return rig type or null if not found
 */
public RigType findByName(String name) {
    Criteria cri = this.session.createCriteria(this.clazz);
    cri.add(Restrictions.eq("name", name));
    return (RigType) cri.uniqueResult();
}