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:lk.bhanuka.biometric.DAO.DatabaseService.java

public static List search(Class type, Map restrictions, Float margin) {
    Session session = DatabaseService.getSession();
    Criteria criteria = session.createCriteria(type);
    for (Object o : restrictions.keySet()) {
        criteria.add(Restrictions.between((String) o,
                (Float) restrictions.get(o) - (Float) restrictions.get(o) * margin,
                (Float) restrictions.get(o) + (Float) restrictions.get(o) * margin));
    }/* ww  w .  j ava2  s.  co m*/
    return criteria.list();
}

From source file:love.sola.netsupport.api.stuff.ToolsCheck.java

License:Open Source License

private Object query(HttpServletRequest req, WxSession session) {
    int status = Integer.valueOf(getParameterWithDefault(req.getParameter("status"), "0"));
    Date after = getDay(getParameterAsDate(req.getParameter("after"), getToday()));
    Date before = getDay(getParameterAsDate(req.getParameter("before"), getToday()));
    before = DateUtils.addDays(before, 1);
    int block = Integer.valueOf(getParameterWithDefault(req.getParameter("block"), "0"));
    try (Session s = SQLCore.sf.openSession()) {
        Criteria query = s.createCriteria(love.sola.netsupport.pojo.ToolsCheck.class);
        query.add(Restrictions.sqlRestriction("{alias}.status & ? = ?", new Object[] { status, status },
                new Type[] { IntegerType.INSTANCE, IntegerType.INSTANCE }));
        query.add(Restrictions.between("checkTime", after, before));
        if (block != 0)
            query.add(Restrictions.eq("block", block));
        return query.list();
    }// w  w  w.  j  a  va 2 s  . c  o m
}

From source file:love.sola.netsupport.api.user.TicketQuery.java

License:Open Source License

@Override
protected Object process(HttpServletRequest req, WxSession session) throws Exception {
    try (Session s = SQLCore.sf.openSession()) {
        User u = session.getAttribute(Attribute.USER);
        Criteria c = s.createCriteria(Ticket.class);
        int first = req.getParameter("offset") == null ? 0 : Integer.parseInt(req.getParameter("offset"));
        int limit = req.getParameter("limit") == null ? 5 : Integer.parseInt(req.getParameter("limit"));
        c.setFirstResult(first);//  w w w  . ja  va  2s .  c o m
        c.setMaxResults(limit);
        c.addOrder(Order.desc(Ticket.PROPERTY_SUBMIT_TIME));
        c.add(Restrictions.eq(Ticket.PROPERTY_USER, u));
        if (req.getParameter("status") != null) {
            c.add(Restrictions.eq(Ticket.PROPERTY_STATUS, Integer.parseInt(req.getParameter("status"))));
        } else if (req.getParameter("statusl") != null && req.getParameter("statush") != null) {
            c.add(Restrictions.between(Ticket.PROPERTY_STATUS, Integer.parseInt(req.getParameter("statusl")),
                    Integer.parseInt(req.getParameter("statush"))));
        }
        return c.list();
    }
}

From source file:love.sola.netsupport.sql.TableTicket.java

License:Open Source License

@SuppressWarnings("unchecked")
public static List<Ticket> unsolvedByBlock(int b) {
    if (b == 0)//from w w w.  j a  va2 s  .c o m
        return unsolved();
    try (Session s = SQLCore.sf.openSession()) {
        return s.createCriteria(Ticket.class).addOrder(Order.desc(Ticket.PROPERTY_SUBMIT_TIME))
                .add(Restrictions.ne(Ticket.PROPERTY_STATUS, Status.SOLVED))
                .createCriteria(Ticket.PROPERTY_USER)
                .add(Restrictions.between(User.PROPERTY_BLOCK, b * 10, (b + 1) * 10 - 1)).list();
    }
}

From source file:mx.edu.um.mateo.rh.dao.impl.EmpleadoDaoHibernate.java

License:Open Source License

private Criterion getQueryByMonth(Calendar gc) {
    Criterion cr = null;//www .j  a va2s  . c o m

    gc.add(Calendar.YEAR, 1);

    gc.set(Calendar.DAY_OF_MONTH, 1);
    Date fechaI = gc.getTime();

    gc.set(Calendar.DAY_OF_MONTH, gc.getMaximum(Calendar.DAY_OF_MONTH));
    Date fechaF = gc.getTime();

    cr = Restrictions.between("fechaNacimiento", fechaI, fechaF);

    Calendar tmp = (Calendar) gc.clone();
    tmp.clear();
    tmp.setTime(new Date());
    tmp.add(Calendar.YEAR, -17);

    if (gc.compareTo(tmp) <= 0) {
        return Restrictions.or(cr, getQueryByMonth(gc));
    } else {
        return cr;
    }
}

From source file:mx.edu.um.mateo.rh.dao.impl.SolicitudVacacionesDaoHibernate.java

License:Open Source License

/**
 * @see//from  ww  w  .j  av  a 2 s. c  o  m
 * mx.edu.um.rh.dao.SolicitudVacacionesDao#getSolicitudesSalida(mx.edu.um.rh.model.SolicitudVacaciones,
 * mx.edu.um.rh.model.SolicitudVacaciones)
 */
@SuppressWarnings("unchecked")
@Override
@Transactional(readOnly = true)
public List<SolicitudVacaciones> getSolicitudesSalida(SolicitudVacaciones ssalidaInicial,
        SolicitudVacaciones ssalidaFinal) throws Exception {
    Criteria sql = getSession().createCriteria(SolicitudVacaciones.class);
    sql.add(Restrictions.eq("empleado", ssalidaInicial.getEmpleado()));
    sql.add(Restrictions.or(
            Restrictions.between("fechaInicial", ssalidaInicial.getFechaInicial(),
                    ssalidaFinal.getFechaInicial()),
            Restrictions.between("fechaFinal", ssalidaInicial.getFechaInicial(),
                    ssalidaFinal.getFechaInicial())));
    sql.add(Restrictions.or(Restrictions.eq("status", Constantes.SOLICITUDSALIDA_STATUS_AUTORIZADO),
            Restrictions.eq("status", Constantes.SOLICITUDSALIDA_STATUS_PRIMA_VACACIONAL)));
    sql.addOrder(Order.asc("fechaInicial"));
    return sql.list();
}

From source file:mx.ipn.escom.repositorios.impl.AlumnoRepositorioImpl.java

@Override
public List<Alumno> buscarPorEdad(String edadmin, String edadmax) {
    return (List<Alumno>) sessionFactory.getCurrentSession().createCriteria(Alumno.class)
            .add(Restrictions.between("edad", edadmin, edadmax)).list();
}

From source file:mx.ipn.escom.repositorios.impl.VisitanteRepositorioImpl.java

@Override
public List<Visitante> buscarPorEdad(String edadmin, String edadmax) {
    return (List<Visitante>) sessionFactory.getCurrentSession().createCriteria(Visitante.class)
            .add(Restrictions.between("edad", edadmin, edadmax)).list();
}

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public List<Release> findReleasesByNameAndDateRange(String relName, Date startDate, Date endDate) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);
    criteria.add(Restrictions.eq("searchName", relName));
    criteria.add(Restrictions.between("postDate", startDate, endDate));
    criteria.setFetchMode("category", FetchMode.JOIN);

    return criteria.list();
}

From source file:net.purnama.pureff.dao.DeliveryDao.java

public List getDeliveryList(Calendar begin, Calendar end, WarehouseEntity warehouse, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(DeliveryEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("warehouse", warehouse));
    }/*from ww w.  j a va2  s  .  c  om*/
    c.add(Restrictions.eq("status", status));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();
    return ls;
}