Example usage for org.hibernate.criterion Restrictions disjunction

Introduction

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

Prototype

public static Disjunction disjunction() 

Source Link

Document

Group expressions together in a single disjunction (A or B or C...).

Usage

From source file:jp.go.nict.langrid.dao.hibernate.HibernateAccessLimitDao.java

License:Open Source License

/**
 * //from  w w w.  java  2 s . c o m
 * 
 */
private static void addSearchAccessLimitsCriterion(Criteria c, String userGridId, String userId,
        String serviceGridId, String[] serviceIds) {
    if (userGridId.length() > 0) {
        c.add(Property.forName("userGridId").eq(userGridId));
        if (userId.length() > 0) {
            c.add(Property.forName("userId").eq(userId));
        }
    }
    if (serviceGridId.length() > 0) {
        c.add(Property.forName("serviceGridId").eq(serviceGridId));
        if (serviceIds.length > 0) {
            Disjunction dj = Restrictions.disjunction();
            for (String id : serviceIds) {
                dj.add(Property.forName("serviceId").eq(id));
            }
            c.add(dj);
        }
    }
}

---

From source file:jp.go.nict.langrid.dao.hibernate.HibernateAccessLogDao.java

License:Open Source License

private static void addSearchCriterion(Criteria c, String userGridId, String userId, String serviceGridId,
        String[] serviceIds, Calendar startDateTime, Calendar endDateTime, MatchingCondition[] conditions) {
    c.add(Property.forName("dateTime").ge(startDateTime));
    c.add(Property.forName("dateTime").le(endDateTime));
    if (userGridId.length() > 0) {
        c.add(Property.forName("userGridId").eq(userGridId));
        if (userId.length() > 0) {
            c.add(Property.forName("userId").eq(userId));
        }/*from   w ww.  j a  v  a 2s.  c o  m*/
    }
    if (serviceGridId.length() > 0) {
        c.add(Property.forName("serviceAndNodeGridId").eq(serviceGridId));
        if (serviceIds.length > 0) {
            Disjunction dj = Restrictions.disjunction();
            for (String id : serviceIds) {
                dj.add(Property.forName("serviceId").eq(id));
            }
            c.add(dj);
        }
    }
    CriteriaUtil.addMatchingConditions(c, conditions);
}

---

From source file:jp.go.nict.langrid.dao.hibernate.HibernateAccessRightDao.java

License:Open Source License

/**
 * /* w  ww  .j  a v  a  2s.co m*/
 * 
 */
private static void addSearchAccessRightCriterion(Criteria c, String userGridId, String userId,
        String serviceGridId, String[] serviceIds) {
    if (userGridId.length() > 0 && userId.length() > 0) {
        c.add(Property.forName("userGridId").eq(userGridId));
        c.add(Property.forName("userId").eq(userId));
    }
    if (serviceGridId.length() > 0 && serviceIds.length > 0) {
        c.add(Property.forName("serviceGridId").eq(serviceGridId));
        Disjunction dj = Restrictions.disjunction();
        for (String id : serviceIds) {
            dj.add(Property.forName("serviceId").eq(id));
        }
        c.add(dj);
    }
}

---

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> listByName(String type, String name) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = new ArrayList();
    Transaction tx = null;//from  w w w . j  av  a  2s  .  c o  m
    try {

        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(AtmLocation.class);
        cr.addOrder(Order.asc("id"));
        cr.add(Restrictions.isNotNull("latd"));
        if (type.equals("1")) {
            cr.add(Restrictions.eq("bank", name).ignoreCase());
            list = cr.list();
        } else if (type.equals("2")) {
            BankInfoDAO bankInfoDAO = new BankInfoDAO();
            List<String> banks = bankInfoDAO.findByGroup(name);
            if (banks == null || banks.isEmpty()) {
                //                    cr.add(Restrictions.eq("bank", ""));
                //                    list = cr.list();
                return list;
            }
            Disjunction dis = Restrictions.disjunction();
            for (String s : banks) {
                dis.add(Restrictions.eq("bank", s).ignoreCase());
            }
            cr.add(dis);
            list = cr.list();
        }

        tx.commit();
    } catch (HibernateException he) {
        if (tx != null && tx.isActive()) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return list;
}

---

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> find10NeareastATM(String lat1, String long1, String bank, char type) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = new ArrayList();
    Criteria cr = session.createCriteria(AtmLocation.class);
    cr.add(Restrictions.neOrIsNotNull("latd", ""));
    if (type == '0') {
        list = cr.list();/*from www .  j av  a2 s.  co m*/
        for (AtmLocation atm : list) {
            atm.setDistance(Utils.distance(Double.parseDouble(lat1), Double.parseDouble(long1),
                    Double.parseDouble(atm.getLatd()), Double.parseDouble(atm.getLongd())));
        }
        for (int i = 0; i < list.size() - 1; i++) {
            for (int j = i + 1; j < list.size(); j++) {
                if (list.get(i).getDistance() > list.get(j).getDistance()) {
                    AtmLocation temp = new AtmLocation();
                    temp.copy(list.get(i));
                    list.get(i).copy(list.get(j));
                    list.get(j).copy(temp);
                }
            }

        }
        return (list.size() > 20 ? list.subList(0, 19) : list);
    } else if (type == '1') {
        cr.add(Restrictions.eq("bank", bank.toLowerCase()));
        list = cr.list();
        for (AtmLocation atm : list) {
            atm.setDistance(Utils.distance(Double.parseDouble(lat1), Double.parseDouble(long1),
                    Double.parseDouble(atm.getLatd()), Double.parseDouble(atm.getLongd())));
        }
        for (int i = 0; i < list.size() - 1; i++) {
            for (int j = i + 1; j < list.size(); j++) {
                if (list.get(i).getDistance() > list.get(j).getDistance()) {
                    AtmLocation temp = new AtmLocation();
                    temp.copy(list.get(i));
                    list.get(i).copy(list.get(j));
                    list.get(j).copy(temp);
                }

            }

        }
        return (list.size() > 20 ? list.subList(0, 19) : list);
    } else if (type == '2') {
        BankInfoDAO bankInfoDAO = new BankInfoDAO();
        List<String> banks = bankInfoDAO.findByGroup(bank);
        if (banks == null || banks.isEmpty()) {
            //                cr.add(Restrictions.eq("bank", ""));
            //                list = cr.list();
            return list;
        }
        Disjunction dis = Restrictions.disjunction();
        for (String s : banks) {
            dis.add(Restrictions.eq("bank", s).ignoreCase());
        }
        cr.add(dis);
        list = cr.list();
        for (AtmLocation atm : list) {
            atm.setDistance(Utils.distance(Double.parseDouble(lat1), Double.parseDouble(long1),
                    Double.parseDouble(atm.getLatd()), Double.parseDouble(atm.getLongd())));
        }
        for (int i = 0; i < list.size() - 1; i++) {
            for (int j = i + 1; j < list.size(); j++) {
                if (list.get(i).getDistance() > list.get(j).getDistance()) {
                    AtmLocation temp = new AtmLocation();
                    temp.copy(list.get(i));
                    list.get(i).copy(list.get(j));
                    list.get(j).copy(temp);
                }

            }

        }
        return (list.size() > 20 ? list.subList(0, 19) : list);
    }
    cr.add(Restrictions.eq("bank", ""));
    list = cr.list();
    return list;
}

---

From source file:kr.debop4j.data.hibernate.tools.CriteriaTool.java

License:Apache License

/**
 *   ? ? ?      ?/*  w  w  w.j a  v a2  s . c om*/
 *
 * @param loPropertyName the lo property name
 * @param hiPropertyName the hi property name
 * @param lo             the lo
 * @param hi             the hi
 * @param includeLo      the include lo
 * @param includeHi      the include hi
 * @return the is overlap criterion
 */
public static Criterion getIsOverlapCriterion(String loPropertyName, String hiPropertyName, Object lo,
        Object hi, boolean includeLo, boolean includeHi) {
    if (lo == null && hi == null)
        throw new IllegalArgumentException(
                "lo, hi ? null ? ?   .");

    if (log.isDebugEnabled())
        log.debug("build getIsOverlapCriterion... "
                + "loPropertyName=[{}], hiPropertyName=[{}}] lo=[{}}], hi=[{}], includeLo=[{}}], includeHi=[{}]",
                loPropertyName, hiPropertyName, lo, hi, includeLo, includeHi);

    if (lo != null && hi != null) {
        return Restrictions.disjunction()
                .add(getIsInRangeCriterion(loPropertyName, hiPropertyName, lo, includeLo, includeHi))
                .add(getIsInRangeCriterion(loPropertyName, hiPropertyName, hi, includeLo, includeHi))
                .add(getIsBetweenCriterion(loPropertyName, lo, hi, includeLo, includeHi))
                .add(getIsBetweenCriterion(hiPropertyName, lo, hi, includeLo, includeHi));
    }

    if (lo != null) {
        return Restrictions.disjunction()
                .add(getIsInRangeCriterion(loPropertyName, hiPropertyName, lo, includeLo, includeHi))
                .add((includeLo) ? ge(loPropertyName, lo) : gt(loPropertyName, lo))
                .add((includeLo) ? ge(hiPropertyName, lo) : gt(hiPropertyName, lo));
    } else {
        return Restrictions.disjunction()
                .add(getIsInRangeCriterion(loPropertyName, hiPropertyName, hi, includeLo, includeHi))
                .add((includeHi) ? le(loPropertyName, hi) : lt(loPropertyName, hi))
                .add((includeHi) ? le(hiPropertyName, hi) : lt(hiPropertyName, hi));
    }
}

---

From source file:mitm.common.security.crlstore.dao.X509CRLStoreDAOHibernate.java

License:Open Source License

private void addSelectorCriterias(X509CRLSelector crlSelector, Criteria criteria) {
    Collection<X500Principal> crlSelectorIssuers = crlSelector.getIssuers();

    if (crlSelectorIssuers != null && crlSelectorIssuers.size() > 0) {
        Disjunction issuerCriteria = Restrictions.disjunction();

        for (X500Principal issuer : crlSelectorIssuers) {
            String issuerCanonical = X500PrincipalInspector.getCanonical(issuer);

            issuerCriteria.add(Restrictions.eq("crl.issuer", issuerCanonical));
        }//w  ww  . j av  a2  s . c o m

        criteria.add(issuerCriteria);
    }

    Date dateAndTime = crlSelector.getDateAndTime();

    if (dateAndTime != null) {
        criteria.add(Restrictions.lt("crl.thisUpdate", dateAndTime));
        criteria.add(Restrictions.gt("crl.nextUpdate", dateAndTime));
    }
}

---

From source file:model.dao.CustomerDAO.java

public List<Customer> findAll(String key) {
    Session s = HibernateUtil.getSessionFactory().getCurrentSession();
    List<Customer> lst = new ArrayList<Customer>();
    try {// ww w  .  j ava2  s  . c om
        s.getTransaction().begin();

        Criteria criteria = s.createCriteria(Customer.class);
        Disjunction disCriteria = Restrictions.disjunction();
        disCriteria.add(Restrictions.like("name", "%" + key + "%"));
        disCriteria.add(Restrictions.like("telNumber", "%" + key + "%"));
        criteria.add(disCriteria);
        lst = criteria.list();
        //xy ly truy van 
        s.getTransaction().commit();
        return lst;
    } catch (Exception ex) {
        ex.printStackTrace();
        s.getTransaction().rollback();
        return null;
    }

}

---

From source file:model.orders.OrdersDAO.java

public List<Orders> findAll(String key) {
    List<Orders> lst = new ArrayList<Orders>();
    try {/*w  w  w . j  a  v a  2 s . c  o m*/
        session.getTransaction().begin();
        Criteria criteria = session.createCriteria(Orders.class);
        Disjunction disCriteria = Restrictions.disjunction();
        disCriteria.add(Restrictions.eq("id", Integer.getInteger(key)));
        disCriteria.add(Restrictions.like("name", "%" + key + "%"));
        disCriteria.add(Restrictions.eq("price", Integer.getInteger(key)));
        criteria.add(disCriteria);
        session.getTransaction().commit();
        lst = criteria.list();
        return lst;
    } catch (Exception ex) {
        ex.printStackTrace();
        return lst;
    }
}

---

From source file:model.users.UsersDAO.java

public List<Users> findAll(String key) {
    List<Users> lst = new ArrayList<Users>();
    try {/*w  w  w . j  a  v a  2s . c  o  m*/
        session.getTransaction().begin();
        Criteria criteria = session.createCriteria(Users.class);
        Disjunction disCriteria = Restrictions.disjunction();
        disCriteria.add(Restrictions.eq("id", Integer.getInteger(key)));
        disCriteria.add(Restrictions.like("name", "%" + key + "%"));
        criteria.add(disCriteria);
        session.getTransaction().commit();
        lst = criteria.list();
        return lst;
    } catch (Exception ex) {
        ex.printStackTrace();
        return lst;
    }
}

---

• «
• 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
• 50
• »