Example usage for org.hibernate.criterion Restrictions between

List of usage examples for org.hibernate.criterion Restrictions between

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. between

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions between.

Prototype

public static Criterion between(String propertyName, Object low, Object high)

Source Link

Document

Apply a "between" constraint to the named property

Usage

From source file:com.llaf.elementos.model.DAOUsuario.java

public String obtenerPorNOmbre(String nombre) throws Exception {
    SessionFactory factory = HIbernateUtilidades.getSessionFactory();
    Session sesion = factory.openSession();
    Transaction tranza = sesion.beginTransaction();

    Criteria cri = sesion.createCriteria(Usuarios.class).add(Restrictions.like("nombre", nombre + "%"));
    Criteria cri2 = sesion.createCriteria(Usuarios.class).add(Restrictions.eq("nombre", nombre));
    Criteria cri3 = sesion.createCriteria(Usuarios.class).add(Restrictions.between("edad", 18, 40))
            .addOrder(Order.asc("nombre"));
    Criteria cri4 = sesion.createCriteria(Usuarios.class).add(Restrictions.lt("sueldo", new Integer(4000)));
    Criteria cri5 = sesion.createCriteria(Usuarios.class).add(Restrictions.gt("sueldo", new Integer(4000)));

    ArrayList<Usuarios> usuarios = (ArrayList<Usuarios>) cri.list();

    ObjectMapper mapper = new ObjectMapper();

    Map<String, ArrayList<Usuarios>> singletonMap = Collections.singletonMap("usuarios", usuarios);

    tranza.commit();/*  ww w. j a  v  a2 s  .  c o m*/
    sesion.close();

    return mapper.writeValueAsString(singletonMap);
}

From source file:com.lm.lic.manager.hibernate.LicenseDAO.java

License:Open Source License

public Integer findNumInUseLicenses(String isvId, String prodId, String prodDefId, String storeId,
        String platformId, Date startDate, Date endDate) {
    Integer numLics = 0;/* ww w .  j ava2  s  . c  o m*/
    try {

        Long lisvid = null;
        if (StringUtils.hasText(isvId))
            lisvid = Long.parseLong(isvId);

        Long lpid = null;
        if (StringUtils.hasText(prodId))
            lpid = Long.parseLong(prodId);

        Long lppid = null;
        if (StringUtils.hasText(prodDefId))
            lppid = Long.parseLong(prodDefId);

        Long lsid = null;
        if (StringUtils.hasText(storeId))
            lsid = Long.parseLong(storeId);

        Long lfid = null;
        if (StringUtils.hasText(platformId))
            lfid = Long.parseLong(platformId);

        Criteria criteria = getSession().createCriteria(License.class);

        criteria.add(Restrictions.eq("isv.id", lisvid));

        Criteria prodCriteria = criteria.createCriteria("product");

        // If the child product is specified, this supercedes the wider selection of the product
        // definition.
        // Only check for htye product definition if the child product was not selected.
        if (lpid != null)
            criteria.add(Restrictions.eq("product.id", lpid));
        else if (lppid != null)
            prodCriteria.add(Restrictions.eq("productDef.id", lppid));

        if (lsid != null)
            prodCriteria.add(Restrictions.eq("listingStore.id", lsid));

        if (lfid != null)
            prodCriteria.add(Restrictions.eq("platform.id", lfid));

        criteria.add(Restrictions.eq("inUse", true));
        criteria.add(Restrictions.eq("decom", false));

        if (startDate != null && endDate != null)
            criteria.add(Restrictions.between(TIME_ACTIVATED, startDate, endDate));
        else {
            if (startDate != null)
                criteria.add(Restrictions.gt(TIME_ACTIVATED, startDate));
            if (endDate != null)
                criteria.add(Restrictions.lt(TIME_ACTIVATED, endDate));
        }

        criteria.setProjection(Projections.rowCount());
        numLics = (Integer) criteria.list().get(0);
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return numLics;
}

From source file:com.lm.lic.manager.hibernate.LicenseDAO.java

License:Open Source License

public Integer findNumIssuedLicenses(String isvId, String prodId, String prodDefId, String storeId,
        String platformId, Date startDate, Date endDate) {
    Integer numLics = 0;/*from w  ww  .jav a  2 s  .co  m*/
    try {

        Long lisvid = null;
        if (StringUtils.hasText(isvId))
            lisvid = Long.parseLong(isvId);

        Long lpid = null;
        if (StringUtils.hasText(prodId))
            lpid = Long.parseLong(prodId);

        Long lppid = null;
        if (StringUtils.hasText(prodDefId))
            lppid = Long.parseLong(prodDefId);

        Long lsid = null;
        if (StringUtils.hasText(storeId))
            lsid = Long.parseLong(storeId);

        Long lfid = null;
        if (StringUtils.hasText(platformId))
            lfid = Long.parseLong(platformId);

        Criteria criteria = getSession().createCriteria(License.class);

        criteria.add(Restrictions.eq("isv.id", lisvid));

        Criteria prodCriteria = criteria.createCriteria("product");

        // If the child product is specified, this supercedes the wider selection of the product
        // definition.
        // Only check for htye product definition if the child product was not selected.
        if (lpid != null)
            criteria.add(Restrictions.eq("product.id", lpid));
        else if (lppid != null)
            prodCriteria.add(Restrictions.eq("productDef.id", lppid));

        if (lsid != null)
            prodCriteria.add(Restrictions.eq("listingStore.id", lsid));

        if (lfid != null)
            prodCriteria.add(Restrictions.eq("platform.id", lfid));

        criteria.add(Restrictions.eq("inUse", true));
        // criteria.add(Restrictions.eq("decom", false));

        if (startDate != null && endDate != null)
            criteria.add(Restrictions.between(TIME_ACTIVATED, startDate, endDate));
        else {
            if (startDate != null)
                criteria.add(Restrictions.gt(TIME_ACTIVATED, startDate));
            if (endDate != null)
                criteria.add(Restrictions.lt(TIME_ACTIVATED, endDate));
        }

        criteria.setProjection(Projections.rowCount());
        numLics = (Integer) criteria.list().get(0);
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return numLics;
}

From source file:com.lm.lic.manager.hibernate.LicenseDAO.java

License:Open Source License

public Integer findNumInUseIsvLicenses(String isvId, String storeId, String platformId, Date startDate,
        Date endDate) {/*from  w  w w .  j a  v a  2s  .com*/
    Integer numLics = 0;
    try {
        Long lisvid = Long.parseLong(isvId);

        Criteria criteria = getSession().createCriteria(License.class);
        criteria.add(Restrictions.eq("isv.id", lisvid));
        criteria.add(Restrictions.eq("inUse", true));
        criteria.add(Restrictions.eq("decom", false));

        Criteria prodCriteria = null;
        if (StringUtils.hasText(storeId)) {
            Long lsid = Long.parseLong(storeId);
            prodCriteria = criteria.createCriteria("product");
            prodCriteria.add(Restrictions.eq("listingStore.id", lsid));
        }

        if (StringUtils.hasText(platformId)) {
            Long lfid = Long.parseLong(platformId);
            if (prodCriteria == null)
                prodCriteria = criteria.createCriteria("product");
            prodCriteria.add(Restrictions.eq("platform.id", lfid));
        }

        if (startDate != null && endDate != null)
            criteria.add(Restrictions.between(TIME_ACTIVATED, startDate, endDate));
        else {
            if (startDate != null)
                criteria.add(Restrictions.gt(TIME_ACTIVATED, startDate));
            if (endDate != null)
                criteria.add(Restrictions.lt(TIME_ACTIVATED, endDate));
        }

        criteria.setProjection(Projections.rowCount());
        numLics = (Integer) criteria.list().get(0);
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return numLics;
}

From source file:com.lm.lic.manager.hibernate.LicenseVerifIncidentDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<LicenseVerifIncident> findIsvVerifs(Long isvId, String licType, String respType,
        Integer firstResult, Integer maxResults, String orderBy, String orderDir, Date startDate,
        Date endDate) {//  w ww. jav  a  2 s .  c o m
    List<LicenseVerifIncident> rfls = null;
    try {
        Criteria mainCriteria = getSession().createCriteria(LicenseVerifIncident.class);
        mainCriteria.add(Restrictions.eq("isv.id", isvId));
        Criteria prodCriteria = addEnabledUnDeletedProductCriteria(mainCriteria);

        addLicTypeRespTypeCrit(licType, respType, mainCriteria, prodCriteria);

        mainCriteria.setFirstResult(firstResult);
        mainCriteria.setMaxResults(maxResults);

        if (startDate != null && endDate != null)
            mainCriteria.add(Restrictions.between(TIME_REQUESTED, startDate, endDate));
        else {
            if (startDate != null)
                mainCriteria.add(Restrictions.gt(TIME_REQUESTED, startDate));
            if (endDate != null)
                mainCriteria.add(Restrictions.lt(TIME_REQUESTED, endDate));
        }
        createOrderByFieldAliasIfApplicable(orderBy, orderDir, mainCriteria, prodCriteria);
        rfls = mainCriteria.list();
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return rfls;
}

From source file:com.lm.lic.manager.hibernate.LicenseVerifIncidentDAO.java

License:Open Source License

public Integer findNumIsvVerifs(String isvId, String licType, String respType, Date startDate, Date endDate) {
    Integer numVerifs = 0;/*from ww  w. java  2 s . com*/
    try {
        Long lisvid = Long.parseLong(isvId);
        Criteria mainCriteria = getSession().createCriteria(LicenseVerifIncident.class);
        mainCriteria.add(Restrictions.eq("isv.id", lisvid));
        Criteria prodCriteria = mainCriteria.createCriteria("product");
        prodCriteria.add(Restrictions.eq("deleted", false));

        addLicTypeRespTypeCrit(licType, respType, mainCriteria, prodCriteria);

        if (startDate != null && endDate != null)
            mainCriteria.add(Restrictions.between(TIME_REQUESTED, startDate, endDate));
        else {
            if (startDate != null)
                mainCriteria.add(Restrictions.gt(TIME_REQUESTED, startDate));
            if (endDate != null)
                mainCriteria.add(Restrictions.lt(TIME_REQUESTED, endDate));
        }

        mainCriteria.setProjection(Projections.rowCount());
        numVerifs = (Integer) mainCriteria.list().get(0);
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return numVerifs;
}

From source file:com.lm.lic.manager.hibernate.LicenseVerifIncidentDAO.java

License:Open Source License

public Integer findNumProdVerifs(String prodId, String licType, String respType, Date startDate, Date endDate) {
    Integer numLics = 0;//  w  ww . j  a  v a 2 s  .  co  m
    try {
        Long lpid = Long.parseLong(prodId);
        Criteria mainCriteria = getSession().createCriteria(LicenseVerifIncident.class);
        mainCriteria.add(Restrictions.eq("product.id", lpid));
        Criteria prodCriteria = mainCriteria.createCriteria("product");
        prodCriteria.add(Restrictions.eq("deleted", false));

        addLicTypeRespTypeCrit(licType, respType, mainCriteria, prodCriteria);

        if (startDate != null && endDate != null)
            mainCriteria.add(Restrictions.between(TIME_REQUESTED, startDate, endDate));
        else {
            if (startDate != null)
                mainCriteria.add(Restrictions.gt(TIME_REQUESTED, startDate));
            if (endDate != null)
                mainCriteria.add(Restrictions.lt(TIME_REQUESTED, endDate));
        }

        mainCriteria.setProjection(Projections.rowCount());
        numLics = (Integer) mainCriteria.list().get(0);
    } catch (RuntimeException re) {
        log.error("find by property name failed", re);
        throw re;
    }
    return numLics;
}

From source file:com.lohika.alp.reporter.fe.dao.TestDAOImpl.java

License:Open Source License

private DetachedCriteria getFilteredCriteria(TestFilter filter) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Test.class);

    criteria.createAlias("suite", "suite");

    if (filter.getFrom() != null && filter.getTill() != null) {
        Calendar c = Calendar.getInstance();

        c.setTime(filter.getFrom());/*from   ww w.  java  2 s.com*/
        c.set(Calendar.HOUR_OF_DAY, c.getActualMinimum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMinimum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMinimum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMinimum(Calendar.MILLISECOND));
        Date from = c.getTime();

        c.setTime(filter.getTill());
        c.set(Calendar.HOUR_OF_DAY, c.getActualMaximum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMaximum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMaximum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMaximum(Calendar.MILLISECOND));
        Date till = c.getTime();

        criteria.add(Restrictions.between("startDate", from, till));
    }

    if (filter.getTest() != "" && filter.getTest() != null) {
        try {
            criteria.add(querytr.translate("name", filter.getTest()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    if (filter.getSuite() != "" && filter.getSuite() != null) {
        try {
            criteria.add(querytr.translate("suite.name", filter.getSuite()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }
    return criteria;
}

From source file:com.lohika.alp.reporter.fe.dao.TestMethodDAOImpl.java

License:Open Source License

private DetachedCriteria getFilteredCriteria(TestMethodFilter filter) {
    DetachedCriteria criteria = DetachedCriteria.forClass(TestMethod.class);

    criteria.createAlias("testInstance", "testInstance").createAlias("testInstance.testClass", "testClass")
            .createAlias("testInstance.test", "test");

    if (filter.getFrom() != null && filter.getTill() != null) {
        Calendar c = Calendar.getInstance();

        c.setTime(filter.getFrom());/*from w ww .  jav a  2 s .com*/
        c.set(Calendar.HOUR_OF_DAY, c.getActualMinimum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMinimum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMinimum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMinimum(Calendar.MILLISECOND));
        Date from = c.getTime();

        c.setTime(filter.getTill());
        c.set(Calendar.HOUR_OF_DAY, c.getActualMaximum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMaximum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMaximum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMaximum(Calendar.MILLISECOND));
        Date till = c.getTime();

        criteria.add(Restrictions.between("startDate", from.getTime(), till.getTime()));
    }

    if (filter.getCl() != "" && filter.getCl() != null) {
        try {
            criteria.add(querytr.translate("testClass.name", filter.getCl()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    if (filter.getGr() != "" && filter.getGr() != null) {
        criteria.createAlias("groups", "groups");

        try {
            criteria.add(querytr.translate("groups.name", filter.getGr()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    return criteria;
}

From source file:com.lp.server.anfrage.ejbfac.AnfrageReportFacBean.java

License:Open Source License

/**
 * Diese Methode liefert eine Liste von allen Lieferdaten der Anfragen eines
 * Mandanten, die nach den eingegebenen Kriterien des Benutzers
 * zusammengestellt wird. <br>//w  w  w .  ja v a  2s  . c o  m
 * Achtung: Hibernate verwendet lazy initialization, d.h. der Zugriff auf
 * Collections muss innerhalb der Session erfolgen.
 * 
 * @param kritDtoI
 *            die Kriterien des Benutzers
 * @param theClientDto
 *            der aktuelle Benutzer
 * @return ReportAnfrageLieferdatenuebersichtDto[] alle gewuenschten
 *         Lieferdaten
 * @throws EJBExceptionLP
 *             Ausnahme
 */
public ReportAnfrageLieferdatenuebersichtDto[] getListeReportAnfrageLiederdatenuebersicht(
        ReportAnfragelieferdatenuebersichtKriterienDto kritDtoI, TheClientDto theClientDto)
        throws EJBExceptionLP {
    ReportAnfrageLieferdatenuebersichtDto[] aResult = null;
    Session session = null;

    try {
        SessionFactory factory = FLRSessionFactory.getFactory();
        session = factory.openSession();

        // Criteria duerfen keine Texts oder Blobs enthalten!

        // Criteria anlegen fuer flranfragepositionlieferdatenreport >
        // flranfragepositionreport > flranfrage
        Criteria crit = session.createCriteria(FLRAnfragepositionlieferdatenReport.class);

        Criteria critAnfrageposition = crit.createCriteria(
                AnfragepositionFac.FLR_ANFRAGEPOSITIONLIEFERDATENREPORT_FLRANFRAGEPOSITIONREPORT);

        Criteria critAnfrage = critAnfrageposition
                .createCriteria(AnfragepositionFac.FLR_ANFRAGEPOSITION_FLRANFRAGE);

        // Einschraenken nach Mandant
        critAnfrage.add(Restrictions.eq("mandant_c_nr", theClientDto.getMandant()));

        // Einschraenken nach Status
        critAnfrage.add(Restrictions.ne(AnfrageFac.FLR_ANFRAGE_ANFRAGESTATUS_C_NR,
                AnfrageServiceFac.ANFRAGESTATUS_ANGELEGT));
        critAnfrage.add(Restrictions.ne(AnfrageFac.FLR_ANFRAGE_ANFRAGESTATUS_C_NR,
                AnfrageServiceFac.ANFRAGESTATUS_STORNIERT));

        // Einschraenken nach Anfrageart
        critAnfrage.add(Restrictions.ne(AnfrageFac.FLR_ANFRAGE_ANFRAGEART_C_NR,
                AnfrageServiceFac.ANFRAGEART_LIEFERGRUPPE));

        // Belegdatum von bis: flranfragepositionlieferdatenreport >
        // flranfragepositionreport > flranfrage.t_belegdatum
        if (kritDtoI.getDVon() != null) {
            critAnfrage.add(Restrictions.ge(AnfrageFac.FLR_ANFRAGE_T_BELEGDATUM, kritDtoI.getDVon()));
        }

        if (kritDtoI.getDBis() != null) {
            critAnfrage.add(Restrictions.le(AnfrageFac.FLR_ANFRAGE_T_BELEGDATUM, kritDtoI.getDBis()));
        }

        // SK: Sortierung nach Bezeichnung und Bezeichnung2
        critAnfrageposition.addOrder(Property.forName("c_bez").asc());
        critAnfrageposition.addOrder(Property.forName("c_zbez").asc());
        // Artikelcnr von bis: flranfragepositionlieferdaten >
        // flranfrageposition > flrartikel.c_nr
        Criteria critArtikel = critAnfrageposition
                .createCriteria(AnfragepositionFac.FLR_ANFRAGEPOSITION_FLRARTIKEL);

        if (kritDtoI.getArtikelCNrVon() != null || kritDtoI.getArtikelCNrBis() != null) {

            String cNrIdentvon = kritDtoI.getArtikelCNrVon();
            String cNrIdentbis = kritDtoI.getArtikelCNrBis();

            if (cNrIdentvon != null && cNrIdentvon.length() > 0 && cNrIdentbis != null
                    && cNrIdentbis.length() > 0) {
                critArtikel.add(Restrictions.between("c_nr", cNrIdentvon, cNrIdentbis));
            } else if (cNrIdentvon != null && cNrIdentvon.length() > 0) {
                critArtikel.add(Restrictions.ge("c_nr", cNrIdentvon));
            } else if (cNrIdentbis != null && cNrIdentbis.length() > 0) {
                critArtikel.add(Restrictions.le("c_nr", cNrIdentbis));
            }
        }

        // nur Projekt
        if (kritDtoI.getBNurProjekt()) {
            critAnfrage.add(Restrictions.eq("c_bez", kritDtoI.getProjektCBez()));
        }

        // inklusive Lieferdaten == null; Hibernate: per default null valued
        // properties are included
        // aber: aufgrund der Implementierung gilt: inklusive Lieferdaten ==
        // 0
        if (!kritDtoI.getBMitLiefermengenNull()) {
            crit.add(Restrictions.ne(AnfragepositionFac.FLR_ANFRAGEPOSITIONLIEFERDATEN_N_ANLIEFERMENGE,
                    new BigDecimal(0)));
        }

        // Sortierung nach Projekt
        if (kritDtoI.getBSortierungNachProjekt()) {
            critAnfrage.addOrder(Property.forName("c_bez").asc());
        } else {
            // per default wird nach der Artikelcnr sortiert
            critArtikel.addOrder(Property.forName("c_nr").asc());
        }

        List<?> list = crit.list();

        aResult = new ReportAnfrageLieferdatenuebersichtDto[list.size()];
        int iIndex = 0;
        Iterator<?> it = list.iterator();
        ReportAnfrageLieferdatenuebersichtDto reportDto = null;

        while (it.hasNext()) {
            FLRAnfragepositionlieferdatenReport flranfragepositionlieferdaten = (FLRAnfragepositionlieferdatenReport) it
                    .next();
            FLRAnfragepositionReport flranfrageposition = flranfragepositionlieferdaten
                    .getFlranfragepositionreport();
            FLRArtikel flrartikel = flranfrageposition.getFlrartikel();
            FLRAnfrage flranfrage = flranfrageposition.getFlranfrage();

            reportDto = new ReportAnfrageLieferdatenuebersichtDto();

            reportDto.setCNrArtikelcnr(flranfrageposition.getFlrartikel().getC_nr());
            reportDto.setNLiefermenge(flranfragepositionlieferdaten.getN_anliefermenge());
            reportDto.setEinheitCNr(flrartikel.getEinheit_c_nr().trim());
            reportDto.setArtikelIId(flrartikel.getI_id());
            reportDto.setNLieferpreisInAnfragewaehrung(
                    flranfragepositionlieferdaten.getN_nettogesamtpreisminusrabatt());
            reportDto.setAnfrageIId(flranfrage.getI_id());
            reportDto.setIAnlieferzeit(flranfragepositionlieferdaten.getI_anlieferzeit());
            reportDto.setLieferantName(
                    flranfrage.getFlrlieferant().getFlrpartner().getC_name1nachnamefirmazeile1());
            reportDto.setAnfrageCNr(flranfrage.getC_nr());
            reportDto.setAnfrageCBez(flranfrage.getC_bez());
            reportDto.setWaehrungCNr(flranfrage.getWaehrung_c_nr_anfragewaehrung());
            reportDto.setFWechselkursMandantwaehrungZuAnfragewaehrung(
                    flranfrage.getF_wechselkursmandantwaehrungzuanfragewaehrung());

            aResult[iIndex] = reportDto;
            iIndex++;
        }
    } finally {
        closeSession(session);
    }
    return aResult;
}