Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

Introduction

In this page you can find the example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Prototype

ResultTransformer DISTINCT_ROOT_ENTITY

To view the source code for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Click Source Link

Document

Each row of results is a distinct instance of the root entity

Usage

From source file:edu.utah.further.ds.impl.executor.db.hibernate.criteria.HibernateDistinctRootExecutor.java

License:Apache License

/**
 * @param request/*from  ww  w. ja  v a 2  s  . c o m*/
 * @return
 * @see edu.utah.further.core.chain.AbstractRequestHandler#process(edu.utah.further.core.api.chain.ChainRequest)
 */
@Override
public boolean process(final ChainRequest request) {
    final HibernateExecReq execReq = new HibernateExecReq(request);
    final GenericCriteria criteria = execReq.getResult();
    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    execReq.setResult(criteria);
    return false;
}

---

From source file:ejportal.dao.hibernate.BestellerDaoHibernate.java

License:Apache License

public List<Besteller> findBySearchTO(final BestellerSearchTO bestellerSearchTO, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;//from ww w  .  j  a  v a 2  s  .com
    try {
        final Criteria criteria = session.createCriteria(Besteller.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!bestellerSearchTO.getBestellerName().equals("")) {
            criteria.add(Restrictions.like("bestellerName", "%" + bestellerSearchTO.getBestellerName() + "%")
                    .ignoreCase());
        }

        if (!bestellerSearchTO.getProjekt().equals("")) {
            criteria.add(Restrictions.like("projekt", "%" + bestellerSearchTO.getProjekt() + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
}

---

From source file:ejportal.dao.hibernate.BibliotheksmitarbeiterDaoHibernate.java

License:Apache License

public List<Bibliotheksmitarbeiter> findBySearchTO(
        final BibliotheksmitarbeiterSearchTO bibliotheksmitarbeiterSearchTO, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;// ww  w  . ja  v  a  2  s . co  m
    try {
        final Criteria criteria = session.createCriteria(Bibliotheksmitarbeiter.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!bibliotheksmitarbeiterSearchTO.getName().equals("")) {
            criteria.add(Restrictions.like("name", "%" + bibliotheksmitarbeiterSearchTO.getName() + "%")
                    .ignoreCase());
        }
        if (!bibliotheksmitarbeiterSearchTO.getAbteilungsHauptstelle().equals("")) {
            criteria.add(Restrictions
                    .like("abteilungsHauptstelle",
                            "%" + bibliotheksmitarbeiterSearchTO.getAbteilungsHauptstelle() + "%")
                    .ignoreCase());
        }
        if (!bibliotheksmitarbeiterSearchTO.getEmailanschrift().equals("")) {
            criteria.add(Restrictions
                    .like("emailanschrift", "%" + bibliotheksmitarbeiterSearchTO.getEmailanschrift() + "%")
                    .ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
}

---

From source file:ejportal.dao.hibernate.EzbDatenDaoHibernate.java

License:Apache License

public List<EzbDaten> findBySearchTO(final EzbDatenSearchTO ezbDatenSearchTO, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;/*from w w  w.  ja  v  a 2 s  .  com*/
    try {
        final Criteria criteria = session.createCriteria(EzbDaten.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!ezbDatenSearchTO.getEzbId().equals("")) {
            try {
                final long ezbId = Long.parseLong(ezbDatenSearchTO.getEzbId());
                criteria.add(Restrictions.eq("ezbId", ezbId));
            } catch (final NumberFormatException e) {
                // das war wohl nix
                e.printStackTrace();
            }
        }

        if (!ezbDatenSearchTO.getTitel().equals("")) {
            criteria.add(Restrictions.like("titel", "%" + ezbDatenSearchTO.getTitel() + "%").ignoreCase());
        }
        if (!ezbDatenSearchTO.getZdbNummer().equals("")) {
            criteria.add(
                    Restrictions.like("zdbNummer", "%" + ezbDatenSearchTO.getZdbNummer() + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
}

---

From source file:ejportal.dao.hibernate.FachDaoHibernate.java

License:Apache License

public List<Fach> findByFachName(final String fachName, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;/*from www  .jav  a 2  s.  c o  m*/
    try {
        final Criteria criteria = session.createCriteria(Fach.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!fachName.equals("")) {
            criteria.add(Restrictions.like("fachName", "%" + fachName + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;

    // return getHibernateTemplate().find("from Fach where fachName=?",
    // fachName);
}

---

From source file:ejportal.dao.hibernate.InstitutionDaoHibernate.java

License:Apache License

public List<Institution> findBySearchTO(final InstitutionSearchTO institutionSearchTO,
        final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;//from ww w . j a  va2 s .c  o m
    try {
        final Criteria criteria = session.createCriteria(Institution.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!institutionSearchTO.getName().equals("")) {
            criteria.add(Restrictions.like("name", "%" + institutionSearchTO.getName() + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
}

---

From source file:ejportal.dao.hibernate.JournalDaoHibernate.java

License:Apache License

public List<Journal> findBySearchTO(final JournalSearchTO journalSearchTO, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;//  www . ja v a2 s .c  o m
    try {
        final Criteria criteria = session.createCriteria(Journal.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!journalSearchTO.getTitel().equals("")) {
            criteria.add(Restrictions.like("titel", "%" + journalSearchTO.getTitel() + "%").ignoreCase());
        }
        if (!journalSearchTO.getKurztitel().equals("")) {
            criteria.add(
                    Restrictions.like("kurztitel", "%" + journalSearchTO.getKurztitel() + "%").ignoreCase());
        }
        if (!journalSearchTO.getVerlag().equals("")) {
            criteria.createAlias("verlag", "vl")
                    .add(Restrictions.like("vl.name", "%" + journalSearchTO.getVerlag() + "%").ignoreCase());
        }
        if (!journalSearchTO.getProvider().equals("")) {
            criteria.createAlias("provider", "pr")
                    .add(Restrictions.like("pr.name", "%" + journalSearchTO.getProvider() + "%").ignoreCase());
        }
        if (!journalSearchTO.getKonsortium().equals("")) {
            criteria.createAlias("konsortium", "ko").add(Restrictions
                    .like("ko.konsortiumName", "%" + journalSearchTO.getKonsortium() + "%").ignoreCase());
        }
        if (!journalSearchTO.getPaket().equals("")) {
            criteria.createAlias("paket", "pk").add(
                    Restrictions.like("pk.paketName", "%" + journalSearchTO.getPaket() + "%").ignoreCase());
        }
        if (!journalSearchTO.getZugangUeber().equals("")) {
            criteria.add(Restrictions.like("zugangUeber", "%" + journalSearchTO.getZugangUeber() + "%")
                    .ignoreCase());
        }
        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
    // return getHibernateTemplate().find("from Journal where kurztitel=?",
    // journalSearchTO.getKurztitel());
    // return null; //To change body of implemented methods use File |
    // Settings | File Templates.
}

---

From source file:ejportal.dao.hibernate.KonsortiumDaoHibernate.java

License:Apache License

public List<Konsortium> findByKonsortiumName(final String konsortiumName, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;/*from w  ww  . j  av a  2 s .  c o m*/
    try {
        final Criteria criteria = session.createCriteria(Konsortium.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!konsortiumName.equals("")) {
            criteria.add(Restrictions.like("konsortiumName", "%" + konsortiumName + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;

    // return
    // getHibernateTemplate().find("from Konsortium where konsortiumName=?",
    // konsortiumName);
}

---

From source file:ejportal.dao.hibernate.PaketDaoHibernate.java

License:Apache License

public List<Paket> findByPaketName(final String paketName, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;/*from w  w  w .j  av  a 2  s.  c  o m*/
    try {
        final Criteria criteria = session.createCriteria(Paket.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!paketName.equals("")) {
            criteria.add(Restrictions.like("paketName", "%" + paketName + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;

    // return getHibernateTemplate().find("from Paket where paketName=?",
    // paketName);
}

---

From source file:ejportal.dao.hibernate.SigelDaoHibernate.java

License:Apache License

public List<Sigel> findBySearchTO(final SigelSearchTO sigelSearchTO, final Integer maxResults) {
    final Session session = this.getSessionFactory().openSession();
    List searchResult = null;/*  w w w  .  jav  a2 s . c om*/
    try {
        final Criteria criteria = session.createCriteria(Sigel.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        criteria.setFirstResult(0);
        if (maxResults != null) {
            criteria.setMaxResults(maxResults);
        }

        if (!sigelSearchTO.getName().equals("")) {
            criteria.add(Restrictions.like("name", "%" + sigelSearchTO.getName() + "%").ignoreCase());
        }
        if (!sigelSearchTO.getBibliothek().equals("")) {
            criteria.add(
                    Restrictions.like("bibliothek", "%" + sigelSearchTO.getBibliothek() + "%").ignoreCase());
        }
        if (!sigelSearchTO.getFakultaet().equals("")) {
            criteria.add(Restrictions.like("fakultaet", "%" + sigelSearchTO.getFakultaet() + "%").ignoreCase());
        }

        searchResult = criteria.list();
    } catch (final Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return searchResult;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• »