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:abm.jakaria.school.CommiteeDao.java

@SuppressWarnings("unchecked")
public List<Commitee> searchCommitee(String name) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Commitee.class);
    criteria.add(Restrictions.ilike("name", name + "%"));
    return criteria.list();
}

From source file:abm.jakaria.school.ContractusDao.java

@SuppressWarnings("unchecked")
public List<Contractus> searchContractus(String name) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Contractus.class);
    criteria.add(Restrictions.ilike("name", name + "%"));
    return criteria.list();
}

From source file:abm.jakaria.school.EmployeeDao.java

@SuppressWarnings("unchecked")
public List<Employee> searchEmployee(String name) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Employee.class);
    criteria.add(Restrictions.ilike("name", name + "%"));
    return criteria.list();
}

From source file:abm.jakaria.school.ResultDao.java

@SuppressWarnings("unchecked")
public List<Result> searchResult(String name) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Result.class);
    criteria.add(Restrictions.ilike("name", name + "%"));
    return criteria.list();
}

From source file:abm.jakaria.school.StudentDao.java

@SuppressWarnings("unchecked")
public List<Student> searchStudent(String name) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Student.class);
    criteria.add(Restrictions.ilike("name", name + "%"));
    return criteria.list();
}

From source file:Activity.activityGetter.java

public static Activity[] getActivitiesByCategoryId(int categoryId) {

    Session session;//from www .  j av a2s  .  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 .  j  ava2  s . co  m*/
    //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();//w  ww . ja va 2 s.  c  om
    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();/*from ww w  . ja v a 2 s. co 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;
}

From source file:AdminSystemClasses.CustomerInfoGenerator.java

/**
 * A thing that generates values for autofill info for a BankCustomer
 * /*from  www .  j  a v  a2s  . c o  m*/
 * @param cus BankCustomer to be autofilled
 * @return BankAccount generated and now associated to cus
 * @throws HibernateException 
 */
public static BankAccount generate(BankCustomer cus) throws HibernateException {
    Random rand = new Random(System.currentTimeMillis());
    Integer cusId;
    Session s = bank.DB.getSession();
    Criteria cr;
    List l;

    //cus.setId(1000);
    do {
        cusId = rand.nextInt(100000000);
        cr = s.createCriteria(BankCustomer.class);
        cr.add(Restrictions.eq("id", cusId));
        l = cr.list();
    } while (!l.isEmpty());

    cus.setId(cusId);

    return generateAccount(cus);
}