Example usage for org.hibernate.criterion Restrictions eq

Introduction

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

Prototype

public static SimpleExpression eq(String propertyName, Object value)

Source Link

Document

Apply an "equal" constraint to the named property

Usage

From source file:$.GenericDaoHibernate.java

protected Criteria findByAttributes(Map<String, Object> attributes) {
        Criteria criteria = getSession().createCriteria(entityClass);
        for (Map.Entry<String, Object> entry : attributes.entrySet()) {
            criteria.add(Restrictions.eq(entry.getKey(), entry.getValue()));
        }/*from  w w  w  .  j a  v a  2  s.c  o  m*/
        return criteria;
    }

From source file:$.UserServiceImpl.java

License:Apache License

public List<User> listUser(User user) {
        DetachedCriteria detachedCriteria = DetachedCriteria.forClass(User.class);
        detachedCriteria.add(Restrictions.eq("user", user));
        detachedCriteria.addOrder(Order.asc("id"));
        return userDao.findByCriteria(detachedCriteria);
    }/*from  w  w  w.j av  a 2s. c om*/

From source file:$.$.java

License:Mozilla Public License

 public Item getItemByUuid(String uuid) {
   return (Item) getSession().createCriteria(Item.class).add(Restrictions.eq("uuid", uuid)).uniqueResult();
}

From source file:abid.password.springmvc.dao.UserDaoHibernateImpl.java

License:Apache License

@Transactional(readOnly = true)
public User getUser(String username) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(User.class);
    criteria.add(Restrictions.eq("username", username));
    User user = (User) criteria.uniqueResult();
    return user;//from  www.  j  a v a2 s . c  om
}

From source file:abid.password.swing.dao.hibernate.UserDaoImpl.java

License:Apache License

public User getUser(String username) {
    Session session = getSessionFactory().openSession();
    try {/*from  www . j  a  v a  2  s .c  o m*/
        session.beginTransaction();
        Criteria criteria = session.createCriteria(User.class);
        criteria.add(Restrictions.eq("username", username));
        User user = (User) criteria.uniqueResult();
        // Query query = session.createQuery("from User u where u.username = ?");
        // query.setString(0, username);
        // User user = (User) query.uniqueResult();
        return user;
    } catch (HibernateException e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return null;
}

From source file:abid.password.wicket.dao.UserDaoHibernateImpl.java

License:Apache License

@Transactional(type = TransactionType.READ_ONLY)
public User getUser(String username) {
    Criteria criteria = getSession().get().createCriteria(User.class);
    criteria.add(Restrictions.eq("username", username));
    User user = (User) criteria.uniqueResult();
    // Query query = session.createQuery("from User u where u.username = ?");
    // query.setString(0, username);
    // User user = (User) query.uniqueResult();
    return user;/*  w w  w .  jav  a2  s . com*/
}

From source file:Activity.activityGetter.java

public static Activity[] getActivitiesByCategoryId(int categoryId) {

    Session session;//from  w  ww. j  a  va2s. c o m
    //Criteria requires a transaction opened
    session = HibernateUtil.getSessionFactory().openSession();
    //create Criteria for Customer class
    Criteria criteria = session.createCriteria(Activity.class);
    criteria.add(Restrictions.eq("category.categoryId", categoryId));
    //add a Restriction which will be used for equality > state = MI

    //add an order for using customer_ID column
    //criteria.addOrder(Order.asc(customer_ID?));
    //return the resultset as a List
    List<Activity> Activityresult = criteria.list();

    //convert List to Array
    return Activityresult.toArray(new Activity[Activityresult.size()]);
}

From source file:Activity.activityGetter.java

public static ActivityReport[] getActivityReportsByCategoryId(int categoryId) {

    Session session;/*from  w  w  w. ja  v a  2  s  . c om*/
    //Criteria requires a transaction opened
    session = HibernateUtil.getSessionFactory().openSession();
    //create Criteria for Customer class
    Criteria criteria = session.createCriteria(ActivityReport.class);
    criteria.add(Restrictions.eq("activty.activityId.category", categoryId));
    //add a Restriction which will be used for equality > state = MI

    //add an order for using customer_ID column
    //criteria.addOrder(Order.asc(customer_ID?));
    //return the resultset as a List
    List<Activity> Activityresult = criteria.list();

    //convert List to Array
    return Activityresult.toArray(new ActivityReport[Activityresult.size()]);
}

From source file:AdminSystemClasses.AtmDB.java

public static BankATM addAtm(ATMaddmoddel atm) throws Exception {

    Session sf = DB.getSession();//from w  w w .  j  a  v  a2  s .  c  o m
    Transaction tx = sf.beginTransaction();

    Criteria cr = sf.createCriteria(BankATM.class);
    cr.add(Restrictions.eq("id", atm.getAtmId()));

    if (cr.list().isEmpty()) {
        BankBranch bb = (BankBranch) sf.load(BankBranch.class, atm.getBranchid());
        BankATM myatm = new BankATM();
        myatm.setId(atm.getAtmId());
        myatm.setBankbranch(bb);
        myatm.setTill(atm.getTill());
        sf.save(myatm);
        tx.commit();
        return myatm;
    }

    return null;
}

From source file:AdminSystemClasses.AtmDB.java

public static BankATM delete(DeleteATM atm) throws Exception {
    Session sf = DB.getSession();/*www . ja v  a2 s  . c  o m*/
    Transaction tx = sf.beginTransaction();

    Criteria cr = sf.createCriteria(BankATM.class);
    cr.add(Restrictions.eq("id", atm.getAtmId()));
    BankATM bank;
    if (!cr.list().isEmpty()) {
        bank = (BankATM) sf.load(BankATM.class, atm.getAtmId());
        sf.delete(bank);
        tx.commit();
    } else {
        return null;
    }

    return bank;
}