Example usage for org.hibernate.criterion Restrictions 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.qfix.vms.dao.impl.AnnualLicenseDaoImpl.java

@Override
public List<AnnualLicense> findAnnualLicenses(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;// ww w. jav a2  s. c o  m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(AnnualLicense.class);

    cr.add(Restrictions.between("date", from, to));
    List annualLicenses = cr.list();
    return annualLicenses;

}

From source file:com.qfix.vms.dao.impl.AnnualLicenseDaoImpl.java

@Override
public List<AnnualLicense> vehicleReport(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//from   w w  w .  jav  a  2s.c om

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(AnnualLicense.class);

    cr.add(Restrictions.between("date", from, to));
    List annualLicenses = cr.list();
    return annualLicenses;
}

From source file:com.qfix.vms.dao.impl.PaymentsDaoImpl.java

@Override
public List<Payments> findPayments(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//from   w ww  . j  a  v  a 2s  . c o m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Payments.class);

    cr.add(Restrictions.between("date", from, to));
    List payments = cr.list();
    return payments;
}

From source file:com.qfix.vms.dao.impl.PaymentsDaoImpl.java

@Override
public List<Payments> vehicleReport(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;/*  ww w. ja v  a 2  s.co m*/

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Payments.class);

    cr.add(Restrictions.between("date", from, to));
    List payments = cr.list();
    return payments;
}

From source file:com.qfix.vms.dao.impl.RepairDaoImpl.java

@Override
public List<Repair> findRepairs(Date frome, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;/*from   www.  j  a v a 2 s . c o  m*/

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Repair.class);

    cr.add(Restrictions.between("date", frome, to));
    List repairs = cr.list();
    return repairs;
}

From source file:com.qfix.vms.dao.impl.RepairDaoImpl.java

@Override
public int getsum(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//  www. j  a  v a 2 s  .  c  o m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Repair.class);

    cr.add(Restrictions.between("date", from, to));
    cr.setProjection(Projections.sum("repairCost"));
    int repairs = cr.hashCode();
    return repairs;
}

From source file:com.qfix.vms.dao.impl.RepairDaoImpl.java

@Override
public List<Repair> vehicleReport(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//from www.j  a va2s.  c o m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Repair.class);

    cr.add(Restrictions.between("date", from, to));
    List repairs = cr.list();
    return repairs;
}

From source file:com.qfix.vms.dao.impl.SurvicingDaoImpl.java

@Override
public List<Survicing> findSurvicings(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//from   w w w . ja  va 2 s  .c o  m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Survicing.class);

    cr.add(Restrictions.between("date", from, to));
    List survicings = cr.list();
    return survicings;
}

From source file:com.qfix.vms.dao.impl.SurvicingDaoImpl.java

@Override
public List<Survicing> vehicleReport(Date from, Date to) {
    Session session = sessionFactory.openSession();
    Transaction tx = null;//from w w w  . j a  v  a2 s . c o  m

    tx = session.beginTransaction();
    Criteria cr = session.createCriteria(Survicing.class);

    cr.add(Restrictions.between("date", from, to));
    List survicings = cr.list();
    return survicings;
}

From source file:com.quakearts.webapp.hibernate.HibernateBean.java

License:Open Source License

private Criterion createCriterion(String key, Serializable value, QueryContext context) {
    key = handleKey(key, context);// ww  w . j  a v a 2  s  .  co m
    if (value instanceof Range) {
        Range range = (Range) value;
        if (range.getFrom() != null && range.getTo() == null)
            return Restrictions.ge(key, ((Range) value).getFrom());
        else if (range.getFrom() == null && range.getTo() != null)
            return Restrictions.le(key, ((Range) value).getTo());

        return Restrictions.between(key, range.getFrom(), range.getTo());
    } else if (value instanceof VariableString) {
        return Restrictions.ilike(key, ((VariableString) value).getValue());
    } else {
        return Restrictions.eq(key, value);
    }
}