Example usage for org.hibernate Criteria add

Introduction

In this page you can find the example usage for org.hibernate Criteria add.

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

From source file:benedict.zhang.addon.persistence.PersistenceManager.java

public List querySounds(String soundName, String actor) {
    session = sessionFactory.openSession();
    session.beginTransaction();/*from  w w w.j a  va 2 s  .  co m*/
    Criteria criteria = session.createCriteria(Sound.class);
    if (soundName != null || !"".equals(soundName)) {
        criteria.add(Restrictions.like("soundName", "%" + soundName + "%"));
    }
    if (actor != null || !"".equals(actor)) {
        criteria.add(Restrictions.like("actor", "%" + actor + "%"));
    }
    List sounds = criteria.list();
    session.getTransaction().commit();
    session.close();
    return sounds;
}

From source file:biomart.DAO.AdminDAO.java

public List<OrderBean> viewOrderDetails(String orderStatus) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(OrderBean.class);
    criteria.add(Restrictions.eq("Order_status", orderStatus));
    List<OrderBean> orderBeans = criteria.list();
    session.close();/* www .ja  v  a  2  s  .co  m*/
    return orderBeans;
}

From source file:biomart.DAO.AdminDAO.java

public List<ReferenceBean> viewReferenceBean(String status) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(ReferenceBean.class);
    criteria.add(Restrictions.eq("Status", status));
    List<ReferenceBean> referenceBeans = criteria.list();
    session.close();/*  ww  w  . ja  va2  s . c  o m*/
    return referenceBeans;

}

From source file:biomart.DAO.LoginDAO.java

public String login(String userId, String password) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(LoginBean.class);
    criteria.add(Restrictions.eq("userId", userId));
    criteria.add(Restrictions.eq("password", password));
    if (criteria.list().isEmpty()) {
        return null;
    } else {/* ww w  .jav  a  2s. co m*/
        LoginBean loginBean = (LoginBean) criteria.list().get(0);
        if (loginBean.getStatus() == null) {
            loginBean.setStatus("noactive");
        }
        if (loginBean.getStatus().equalsIgnoreCase("active")) {
            return "already active";
        }
        loginBean.setLoginTime(new Date());
        loginBean.setLogoutTime(null);
        loginBean.setStatus("active");
        if (updateLoginDetails(loginBean).equals("success")) {
            return loginBean.getType();
        } else {
            return "fail";
        }
    }
}

From source file:biomart.DAO.LoginDAO.java

public String logout(String userId) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(LoginBean.class);
    criteria.add(Restrictions.eq("userId", userId));
    if (criteria.list().isEmpty()) {
        return null;
    } else {//from   w ww .j  a va  2  s.c o m

        LoginBean loginBean = (LoginBean) criteria.list().get(0);
        loginBean.setLogoutTime(new Date());
        loginBean.setStatus("noactive");
        if (updateLoginDetails(loginBean).equals("success")) {
            return "success";
        } else {
            return "fail";
        }
    }

}

From source file:biomart.DAO.LoginDAO.java

public String changePassword(String userId, String newPassword) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(LoginBean.class);
    criteria.add(Restrictions.eq("userId", userId));
    if (criteria.list().isEmpty()) {
        return "fail";
    }/*from w w w  .  j  ava  2  s . com*/
    LoginBean loginBean = (LoginBean) criteria.list().get(0);
    loginBean.setPassword(newPassword);
    if (new CommonDAO().addOrUpdateDetails(loginBean).equals("success")) {
        return loginBean.getType();
    }
    return "fail";
}

From source file:biomart.DAO.RetailerDAO.java

public List<PersonalDetailsBean> getAllRetailers() {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("type", "R"));
    List<PersonalDetailsBean> personalDetailsBeans = criteria.list();
    session.close();//  w  ww .  j  av  a2s  .  c  om
    return personalDetailsBeans;
}

From source file:biomart.DAO.RetailerDAO.java

public String getRetailerId(String storeName) {

    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("storeName", storeName));
    PersonalDetailsBean personalDetailsBean = null;
    if (!criteria.list().isEmpty()) {
        personalDetailsBean = (PersonalDetailsBean) criteria.list().get(0);
        session.close();//from w  w w  .ja  v a2s. c  o m
        return personalDetailsBean.getUserId();
    }
    session.close();
    return null;
}

From source file:biomart.DAO.SalesmanDAO.java

public List<PersonalDetailsBean> viewPendingAmountDetails(String district) {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("District", district));
    criteria.add(Restrictions.eq("type", "R"));
    List<PersonalDetailsBean> personalDetailsBeans = criteria.list();
    session.close();/*from   w  w w  .ja v  a2s. co m*/
    return personalDetailsBeans;
}

From source file:biomart.DAO.SalesmanDAO.java

public List<PersonalDetailsBean> getAllSalesman() {
    Session session = Util.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
    criteria.add(Restrictions.eq("type", 'S' + ""));
    List<PersonalDetailsBean> personalDetailsBeans = criteria.list();
    session.close();/* ww  w . j a v  a 2  s. c  o m*/
    return personalDetailsBeans;
}