Example usage for org.springframework.dao.support DataAccessUtils uniqueResult

List of usage examples for org.springframework.dao.support DataAccessUtils uniqueResult

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.dao.support.*
  5. DataAccessUtils
  6. uniqueResult

Introduction

In this page you can find the example usage for org.springframework.dao.support DataAccessUtils uniqueResult.

Prototype

@Nullable
public static <T> T uniqueResult(@Nullable Collection<T> results)
        throws IncorrectResultSizeDataAccessException

Source Link

Document

Return a unique result object from the given Collection.

Usage

From source file:pe.gob.mef.gescon.hibernate.impl.ArchivoConocimientoDaoImpl.java

@Override
public TarchivoConocimiento getLastTarchivoByTconocimiento(Tconocimiento tconocimiento) throws Exception {
    DetachedCriteria proj = DetachedCriteria.forClass(TarchivoConocimiento.class);
    proj.setProjection(Projections.max("nversion"));
    DetachedCriteria criteria = DetachedCriteria.forClass(TarchivoConocimiento.class);
    criteria.add(Restrictions.eq("tconocimiento.nconocimientoid", tconocimiento.getNconocimientoid()));
    criteria.add(Property.forName("nversion").eq(proj));
    return (TarchivoConocimiento) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecGroupDAOImpl.java

@SuppressWarnings("unchecked")
@Override/*from  w  w w .  j a  v  a 2s  .  co  m*/
public SecGroup getGroupByRolegroup(SecRolegroup secRolegroup) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);
    // Aliases are working only on properties
    criteria.createAlias("secRolegroups", "rg");
    criteria.add(Restrictions.eq("rg.id", Long.valueOf(secRolegroup.getId())));

    return (SecGroup) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

@SuppressWarnings("unchecked")
@Override//from   w  w  w  . java 2  s.c om
public SecLoginlog getLoginlogById(long id) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.add(Restrictions.eq("id", Long.valueOf(id)));
    criteria.addOrder(Order.desc("lglLogtime"));

    return (SecLoginlog) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:pe.gob.mef.gescon.hibernate.impl.BaseLegalDaoImpl.java

@Override
public Tbaselegal getTbaselegalById(BigDecimal id) throws Exception {
    DetachedCriteria criteria = DetachedCriteria.forClass(Tbaselegal.class);
    criteria.add(Restrictions.eq("nbaselegalid", id));
    return (Tbaselegal) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:pe.gob.mef.gescon.hibernate.impl.ArchivoHistorialDaoImpl.java

@Override
public TarchivoHist getLastTarchivoHistByTbaselegalHist(TbaselegalHist tbaselegal) throws Exception {
    DetachedCriteria proj = DetachedCriteria.forClass(TarchivoHist.class);
    proj.setProjection(Projections.max("nversion"));
    DetachedCriteria criteria = DetachedCriteria.forClass(TarchivoHist.class);
    criteria.add(Restrictions.eq("nhistorialid", tbaselegal.getNhistorialid()));
    criteria.add(Restrictions.eq("nbaselegalid", tbaselegal.getNbaselegalid()));
    criteria.add(Property.forName("nversion").eq(proj));
    return (TarchivoHist) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecGrouprightDAOImpl.java

@SuppressWarnings("unchecked")
@Override/*from w  ww .  j  av a2 s .c o  m*/
public SecGroupright getGroupRightByGroupAndRight(SecGroup group, SecRight right) {

    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroupright.class);
    criteria.add(Restrictions.eq("secGroup", group));
    criteria.add(Restrictions.eq("secRight", right));

    return (SecGroupright) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:com.apress.progwt.server.dao.hibernate.UserDAOHibernateImpl.java

public User getUserForId(long id) {
    log.debug("DAOhere user for id " + id);
    return (User) DataAccessUtils
            .uniqueResult(getHibernateTemplate().findByNamedParam("from User where id = :id", "id", id));
}

From source file:pe.gob.mef.gescon.hibernate.impl.PreguntaDaoImpl.java

@Override
public Tpregunta getTpreguntaById(BigDecimal id) throws Exception {
    DetachedCriteria criteria = DetachedCriteria.forClass(Tpregunta.class);
    criteria.add(Restrictions.eq("npreguntaid", id));
    return (Tpregunta) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.YoutubeLinkDAOImpl.java

@SuppressWarnings("unchecked")
@Override//from  www . j ava 2s .c  o  m
public YoutubeLink getRandomYoutubeLink() {
    DetachedCriteria criteria = DetachedCriteria.forClass(YoutubeLink.class);

    try {
        int recCount = getCountAllYoutubeLinks();
        if (recCount > 0) {
            Random random = new Random();
            int selRecord = random.nextInt(recCount);

            return (YoutubeLink) DataAccessUtils
                    .uniqueResult(getHibernateTemplate().findByCriteria(criteria, selRecord, 1));
        }
    } catch (Exception e) {
        // TODO: handle exception
        e.printStackTrace();
    }
    return null;
}

From source file:no.dusken.aranea.service.IssueServiceImpl.java

public Issue getIssue(int year, int issue) {
    Issue i = null;/*from  w ww.  j  a  v a2  s.c o m*/
    try {
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("fromDate", new GregorianCalendar(year, 0, 1));
        map.put("toDate", new GregorianCalendar(year + 1, 0, 1));
        map.put("issue", issue);
        List<Issue> list = genericDao.getByNamedQuery("issues_byyear_and_issue", map);
        Object o = DataAccessUtils.uniqueResult(list);
        if (o != null && o instanceof Issue) {
            i = (Issue) o;
        }
    } catch (DataAccessException dae) {
        log.warn("Unable to get Issue", dae);
    }
    return i;
}