Example usage for org.hibernate.criterion Restrictions and

Introduction

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

Prototype

public static LogicalExpression and(Criterion lhs, Criterion rhs) 

Source Link

Document

Return the conjuction of two expressions

Usage

From source file:com.bean.PropertyBean.java

public List<Property> getGenerateList() {
    Dao dao = new Dao();
    HibernateUtil.getInstance().clear();
    if (searchkey == null) {
        searchkey = "";
    }/*from  w  ww.j  a  va  2 s .c  o  m*/
    long idP = 0;
    try {
        idP = Long.parseLong(searchkey);
    } catch (Exception ex) {

    }
    Criterion cTitle = Restrictions.like("proTitle", "%" + searchkey + "%");
    Criterion cUser = Restrictions.eq("users", new Users(searchkey));
    LogicalExpression logic = Restrictions.or(cTitle, cUser);
    if (idP != 0) {
        Criterion cid = Restrictions.eq("proId", idP);
        logic = Restrictions.or(logic, cid);
    }

    Criterion cType = null;
    if (searchtype != null && !searchtype.equals("")) {
        int id = 0;
        try {
            id = Integer.parseInt(searchtype);
            cType = Restrictions.eq("exchangeType", new ExchangeType(id));
        } catch (Exception ex) {
            cType = Restrictions.isNotNull("exchangeType");
        }
    } else {
        cType = Restrictions.isNotNull("exchangeType");
    }
    logic = Restrictions.and(cType, logic);

    Criterion cCat = null;
    if (searchcat != null && !searchcat.equals("")) {
        int id = 0;
        try {
            id = Integer.parseInt(searchcat);
            cCat = Restrictions.eq("propertyType", new PropertyType(id));
            logic = Restrictions.and(logic, cCat);
        } catch (Exception ex) {

        }
    }
    Criterion cPub = null;
    if (searchpub != null && !searchpub.equals("")) {
        boolean id = false;
        try {
            id = Boolean.parseBoolean(searchpub);
            cPub = Restrictions.eq("proPublish", id);
            logic = Restrictions.and(logic, cPub);
        } catch (Exception ex) {
        }
    }
    Criterion cStt = null;
    if (searchStt != null && !searchStt.equals("")) {
        int id;
        try {
            id = Integer.parseInt(searchpub);
            cStt = Restrictions.eq("proStatus", id);
            logic = Restrictions.and(logic, cStt);
        } catch (Exception ex) {
        }
    }
    Order o = Order.desc("proPublishDate");
    listProperty = dao.getByCondition(Property.class, logic, o);
    return listProperty;
}

---

From source file:com.bean.PropertyOfUserBean.java

public List<Property> getGenerateList() {
    Dao dao = new Dao();
    HibernateUtil.getInstance().clear();
    Users u = (Users) dao.getById(Users.class, user);
    Criterion cUser = Restrictions.eq("users", u);
    if (searchkey == null) {
        searchkey = "";
    }/*  ww w .  j a v  a 2 s  .  c om*/
    Criterion cTitle = Restrictions.like("proTitle", "%" + searchkey + "%");
    LogicalExpression logic;

    Criterion cType = null;
    if (searchtype != null && !searchtype.equals("")) {
        int id = 0;
        try {
            id = Integer.parseInt(searchtype);
            cType = Restrictions.eq("exchangeType", new ExchangeType(id));
        } catch (Exception ex) {
            cType = Restrictions.isNotNull("exchangeType");
        }
    } else {
        cType = Restrictions.isNotNull("exchangeType");
    }
    logic = Restrictions.and(cType, cTitle);

    Criterion cCat = null;
    if (searchcat != null && !searchcat.equals("")) {
        int id = 0;
        try {
            id = Integer.parseInt(searchcat);
            cCat = Restrictions.eq("propertyType", new PropertyType(id));
            logic = Restrictions.and(logic, cCat);
        } catch (Exception ex) {

        }
    }
    Criterion cPub = null;
    if (searchpub != null && !searchpub.equals("")) {
        boolean id = false;
        try {
            id = Boolean.parseBoolean(searchpub);
            cPub = Restrictions.eq("proPublish", id);
            logic = Restrictions.and(logic, cPub);
        } catch (Exception ex) {
        }
    }
    Criterion cStt = null;
    if (searchStt != null && !searchStt.equals("")) {
        int id;
        try {
            id = Integer.parseInt(searchpub);
            cStt = Restrictions.eq("proStatus", id);
            logic = Restrictions.and(logic, cStt);
        } catch (Exception ex) {
        }
    }
    logic = Restrictions.and(logic, cUser);
    Order o = Order.desc("proPublishDate");
    listProperty = dao.getByCondition(Property.class, logic, o);
    return listProperty;
}

---

From source file:com.bean.PropertyUserBean.java

public List<Property> getGenerateListProperty() {
    Dao dao = new Dao();
    Users u = (Users) SessionUtils.getSession().getAttribute("login");
    if (u != null) {
        LogicalExpression logic = null;// w  w w .  j a v  a 2s.  c  om
        Criterion cr = Restrictions.eq("users", u);

        if (publish != null && !publish.equals("")) {
            Criterion pub = Restrictions.eq("proPublish", Boolean.parseBoolean(publish));
            logic = Restrictions.and(cr, pub);
        } else {
            Criterion pub = Restrictions.isNotNull("proPublish");
            logic = Restrictions.and(cr, pub);
        }

        Order o = Order.desc("proPublishDate");
        if (fromDate != null) {
            Criterion from = Restrictions.gt("proCreateDate", fromDate);
            logic = Restrictions.and(logic, from);
        }
        if (toDate != null) {
            Criterion to = Restrictions.lt("proCreateDate", toDate);
            logic = Restrictions.and(logic, to);
        }
        if (cat != 0) {
            PropertyType t = new PropertyType(cat);
            Criterion ca = Restrictions.eq("propertyType", t);
            logic = Restrictions.and(logic, ca);
        }
        listProperty = dao.getByCondition(Property.class, logic, o);
    }
    return listProperty;
}

---

From source file:com.bean.RegisterAdmin.java

public List<Users> getAllUsers() {
    Dao dao = new Dao();
    List<Users> list1 = null;
    HibernateUtil.getInstance().clear();
    if (usersearh == null || usersearh.equals(null) || usersearh.equals("")) {
        Criterion admin = Restrictions.eq("UIsAdmin", true);
        list1 = dao.getByCondition(Users.class, admin);
    } else {//from w w  w  . ja  v  a2  s  . c  o  m
        Criterion admin = Restrictions.eq("UIsAdmin", true);
        Criterion name = Restrictions.like("UUsername", "%" + usersearh + "%");
        Criterion fname = Restrictions.like("UFullname", "%" + usersearh + "%");
        Criterion phone = Restrictions.like("UPhone", "%" + usersearh + "%");
        Criterion mail = Restrictions.like("UEmail", "%" + usersearh + "%");
        LogicalExpression orExp = Restrictions.or(fname, name);
        orExp = Restrictions.or(orExp, phone);
        orExp = Restrictions.or(orExp, mail);
        orExp = Restrictions.and(orExp, admin);
        list1 = dao.getByCondition(Users.class, orExp);
    }
    return list1;
}

---

From source file:com.bean.RegisterEmployees.java

public List<Users> getAllUsers() {
    Dao dao = new Dao();
    List<Users> list = null;
    //HibernateUtil.getInstance().clear();
    if (userview == null || userview.equals(null) || userview.equals("")) {
        Criterion admin = Restrictions.eq("UIsAdmin", false);
        list = dao.getByCondition(Users.class, admin);
    } else {//w w  w.ja  va  2 s  .  com
        Criterion admin = Restrictions.eq("UIsAdmin", false);
        Criterion name = Restrictions.like("UUsername", "%" + userview + "%");
        Criterion fname = Restrictions.like("UFullname", "%" + userview + "%");
        Criterion phone = Restrictions.like("UPhone", "%" + userview + "%");
        Criterion mail = Restrictions.like("UEmail", "%" + userview + "%");
        LogicalExpression orExp = Restrictions.or(fname, name);
        orExp = Restrictions.or(orExp, phone);
        orExp = Restrictions.or(orExp, mail);
        orExp = Restrictions.and(orExp, admin);
        list = dao.getByCondition(Users.class, orExp);
    }
    return list;
}

---

From source file:com.bean.SearchBean.java

public void init() {
    Dao dao = new Dao();

    long pMin = 0, pMax = 0, aMin = 0, aMax = 0;
    try {//from  w  w w .  j a  v  a2 s.co m
        pMin = Long.parseLong(this.priceMin);
    } catch (Exception ex) {

    }
    try {
        pMax = Long.parseLong(this.priceMax);
    } catch (Exception ex) {

    }
    try {
        aMin = Long.parseLong(this.areaMin);
    } catch (Exception ex) {

    }
    try {
        aMax = Long.parseLong(this.areaMax);
    } catch (Exception ex) {

    }

    LogicalExpression logic;
    Criterion district = null;
    Criterion province;
    Criterion propertyType = null;
    Criterion exchange = null;
    Criterion priceMin;
    Criterion priceMax;
    Criterion areaMin;
    Criterion areaMax;

    if (this.propertyType != 0) {
        PropertyType p = new PropertyType(this.propertyType);
        propertyType = Restrictions.eq("propertyType", p);
    } else {
        propertyType = Restrictions.isNotNull("propertyType");
    }

    if (this.exchangeType != 0) {
        ExchangeType e = new ExchangeType(this.exchangeType);
        exchange = Restrictions.eq("exchangeType", e);
    } else {
        exchange = Restrictions.isNotNull("exchangeType");
    }

    if (districtId != 0) {
        District d = new District(districtId);
        district = Restrictions.eq("district", d);
    } else {
        if (provinceId != 0) {
            Province p = (Province) dao.getById1(Province.class, provinceId);
            //Set<District> list = p.getDistricts();
            if (p != null && p.getDistricts().size() > 0) {
                district = Restrictions.in("district", p.getDistricts());
            } else {
                district = Restrictions.isNull("district");
            }
        }
    }
    Criterion cpub = Restrictions.eq("proPublish", true);
    Criterion stt = Restrictions.eq("proStatus", 0);
    logic = Restrictions.and(propertyType, exchange);
    logic = Restrictions.and(logic, stt);
    logic = Restrictions.and(logic, cpub);
    if (district != null) {
        logic = Restrictions.and(logic, district);
    }

    if (pMax > 0) {
        priceMax = Restrictions.between("proPrice", pMin, pMax);
        logic = Restrictions.and(logic, priceMax);
    } else {
        priceMin = Restrictions.gt("proPrice", pMin);
        logic = Restrictions.and(logic, priceMin);
    }

    if (aMax > 0) {
        areaMax = Restrictions.between("proArea", aMin, aMax);
        logic = Restrictions.and(logic, areaMax);
    } else {
        areaMin = Restrictions.gt("proArea", aMin);
        logic = Restrictions.and(logic, areaMin);
    }

    Order o = Order.desc("proPublishDate");

    listSearch = dao.getByCondition(Property.class, logic, o);

}

---

From source file:com.bookshop.dao.BookDAOImpl.java

@Override
public List<Book> listBooks(String bookNameCriteria, String isbnCriteria) {
    if (bookNameCriteria == null && isbnCriteria == null) {
        return new ArrayList<Book>();
    }//  w  w  w  .ja v  a 2s. c o  m

    /*
    Query query;
            
    if (isbnCriteria == null) 
    {
    query = session.createQuery("FROM Books WHERE BookName LIKE '%" + bookNameCriteria + "%'");
    } 
    else if(bookNameCriteria == null) 
    {
    query = session.createQuery("FROM Books WHERE ISBN LIKE '%" + isbnCriteria + "%'");
    }
    else // if(bookNameCriteria != null && isbnCriteria != null) 
    {
    query = session.createQuery("FROM Books WHERE ISBN LIKE '%" + isbnCriteria + "%' AND BookName LIKE '%" + bookNameCriteria + "%'");
    }
            
    return query.list();
    */

    Criteria criteria = session.createCriteria(Book.class);

    if (isbnCriteria == null) {
        Criterion bookNameCriterion = Restrictions.like("bookName", bookNameCriteria, MatchMode.ANYWHERE);
        criteria.add(bookNameCriterion);
    } else if (bookNameCriteria == null) {
        Criterion isbnCriterion = Restrictions.like("ISBN", isbnCriteria, MatchMode.ANYWHERE);
        criteria.add(isbnCriterion);
    } else // if(bookNameCriteria != null && isbnCriteria != null) 
    {
        Criterion bookNameCriterion = Restrictions.like("bookName", bookNameCriteria, MatchMode.ANYWHERE);
        Criterion isbnCriterion = Restrictions.like("ISBN", isbnCriteria, MatchMode.ANYWHERE);
        LogicalExpression orExp = Restrictions.and(bookNameCriterion, isbnCriterion);
        criteria.add(orExp);
    }

    return criteria.list();
}

---

From source file:com.cisco.ca.cstg.pdi.services.ConfigurationServiceImpl.java

@SuppressWarnings("unchecked")
@Override/*from ww w.ja  v a  2 s.c om*/
public List<UcsServerLogs> getUCSConfigLogs(ServerDetails serverDetails, Integer projectId) {
    Criterion whereClause = Restrictions.and(Restrictions.eq(Constants.PROJECTDETAILS_ID, projectId),
            Restrictions.eq("ipAddress", serverDetails.getUrl()));
    return (List<UcsServerLogs>) (List<?>) listAll(UcsServerLogs.class, whereClause);
}

---

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

private static Criterion convert(LogicalCriteria criteria) {
    Criterion criterion = null;//from w w  w  .  j  a v a2s . c  o m
    Criteria lhs = criteria.getLhs();
    Criteria rhs = criteria.getRhs();

    if (criteria.getLogicalOp().equals("or")) {
        criterion = Restrictions.or(convert(lhs), convert(rhs));
    } else if (criteria.getLogicalOp().equals("and")) {
        criterion = Restrictions.and(convert(lhs), convert(rhs));
    }
    return criterion;
}

---

From source file:com.coroptis.coidi.op.view.dao.impl.UserDaoImpl.java

License:Apache License

@Override
public User login(final String name, final String password) {
    return (User) session.createCriteria(User.class)
            .add(Restrictions.and(Restrictions.eq("name", name), Restrictions.eq("password", password)))
            .uniqueResult();//from ww w .ja  v a  2s.c om
}

---

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