Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName) 

Source Link

Document

A property value projection

Usage

From source file:com.muslim.family.dao.impl.QuestionDAOImpl.java

public List<Question_tbl> getPaginatedQuestionsDao(int start, int length) {

    Criteria cr = sessionFactory.getCurrentSession().createCriteria(Question_tbl.class)
            .setProjection(Projections.projectionList().add(Projections.property("id"), "id")
                    .add(Projections.property("subject"), "Subject")
                    .add(Projections.property("views"), "Views"))
            .setResultTransformer(Transformers.aliasToBean(Question_tbl.class));
    cr.setFirstResult(start);//from  ww w .  j  a v a  2 s .  c  o  m
    cr.setMaxResults(length);

    return cr.list();

}

---

From source file:com.nec.harvest.service.impl.AccountServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override/*from  w ww .  j a  v  a  2s. c  om*/
public List<Account> findByIdoKbn(String idoKbn) throws ServiceException {
    if (StringUtils.isEmpty(idoKbn)) {
        throw new IllegalArgumentException("The Account's idoKbn to search must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<Account> accounts = new ArrayList<>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Account.class)
                .setProjection(Projections.projectionList().add(Projections.property("kmkCode").as("kmkCode"))
                        .add(Projections.property("kmkNameR").as("kmkNameR")))
                .add(Restrictions.eq("idoKbn", idoKbn)).add(Restrictions.eq("delKbn", Constants.STATUS_ACTIVE))
                .addOrder(Order.asc("kmkCode"));

        accounts = repository.findByCriteria(criteria);

        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(accounts)) {
            throw new ObjectNotFoundException("Could not find any account with idoKbn 1");
        }
        return accounts;
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("An exception occured while finding account list with idoKbn 1", ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
}

---

From source file:com.nec.harvest.service.impl.AccountServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override//from ww  w . j a va  2s .c  o  m
public List<Account> findByKoteiKbnAndDelKbn(String koteiKhKbn, String delKbn) throws ServiceException {
    if (StringUtils.isEmpty(koteiKhKbn)) {
        throw new IllegalArgumentException("The Account's koteiKhKbn to search must not be null or empty");
    }
    if (StringUtils.isEmpty(delKbn)) {
        throw new IllegalArgumentException("The Account's delKbn to search must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<Account> accounts = new ArrayList<>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Account.class)
                .setProjection(Projections.projectionList().add(Projections.property("kmkCode").as("kmkCode"))
                        .add(Projections.property("kmkNameR").as("kmkNameR")))
                .add(Restrictions.eq("koteiKhKbn", koteiKhKbn)).add(Restrictions.eq("delKbn", delKbn))
                .addOrder(Order.asc("kmkCode"));

        accounts = repository.findByCriteria(criteria);

        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(accounts)) {
            throw new ObjectNotFoundException("Could not find any account with idoKbn = 1");
        }
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("An exception occured while finding account list with idoKbn = 1", ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return accounts;
}

---

From source file:com.nec.harvest.service.impl.AccountServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override//  ww  w. j  ava2  s . c om
public List<Account> findByHelpKbn(String helpKbn) throws ServiceException {
    if (StringUtils.isEmpty(helpKbn)) {
        throw new IllegalArgumentException("The Account's idoKbn to search must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<Account> accounts = new ArrayList<>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Account.class)
                .setProjection(Projections.projectionList().add(Projections.property("kmkCode").as("kmkCode"))
                        .add(Projections.property("kmkNameR").as("kmkNameR")))
                .add(Restrictions.eq("helpKbn", helpKbn))
                .add(Restrictions.eq("delKbn", Constants.STATUS_ACTIVE)).addOrder(Order.asc("kmkCode"));

        accounts = repository.findByCriteria(criteria);
        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(accounts)) {
            throw new ObjectNotFoundException("Could not find any account with idoKbn = 1");
        }
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("An exception occured while finding account list with idoKbn = 1", ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return accounts;
}

---

From source file:com.nec.harvest.service.impl.DivisionServiceImpl.java

License:Open Source License

/** {@inheritDoc}*/
@Override//from ww  w. j  a v  a 2  s. c o  m
public List<Division> findByKbnId(String kbnId) throws ServiceException {
    if (StringUtils.isEmpty(kbnId)) {
        throw new IllegalArgumentException("Can not find division with kbnId empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<Division> divisions = new ArrayList<>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Division.class)
                .setProjection(Projections.projectionList().add(Projections.property("kbnCode").as("kbnCode"))
                        .add(Projections.property("kbnName").as("kbnName")))
                .add(Restrictions.eq("kbnID", kbnId)).add(Restrictions.eq("delKbn", Constants.STATUS_ACTIVE))
                .addOrder(Order.asc("kbnCode")).setResultTransformer(Transformers.aliasToBean(Division.class));

        //
        divisions = repository.findByCriteria(criteria);
        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(divisions)) {
            throw new ObjectNotFoundException("No division object found");
        }
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("Runtime exception occur when get list of division by kbnId " + kbnId, ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return divisions;
}

---

From source file:com.nec.harvest.service.impl.OrganizationServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override// w  ww.j  a v a  2  s .  c o m
public List<Organization> findByKaisoBango(String kaisoBango) throws ServiceException {
    if (StringUtils.isEmpty(kaisoBango)) {
        throw new IllegalArgumentException("The organization's code must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<Organization> organizations = new ArrayList<Organization>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Organization.class)
                .setProjection(Projections.projectionList().add(Projections.property("strCode").as("strCode"))
                        .add(Projections.property("strNameR").as("strNameR")))
                .add(Restrictions.eq("kaisoBango", kaisoBango))
                .add(Restrictions.eq("delKbn", Constants.STATUS_ACTIVE))
                .setResultTransformer(Transformers.aliasToBean(Organization.class));

        // 
        organizations = repository.findByCriteria(criteria);
        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(organizations)) {
            throw new ObjectNotFoundException("Could not find any Organization with kaisoBango " + kaisoBango);
        }
        // sort organizations by code value
        Collections.sort(organizations);
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException(
                "An exception occured while finding Organization list with kaisoBango " + kaisoBango, ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return organizations;
}

---

From source file:com.nec.harvest.service.impl.OrganizationServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override/* ww w  . j  a  v a  2s .  c  o  m*/
@SuppressWarnings("unchecked")
public List<OrganizationPaginationBean> findByStrCodeUp(String strCodeUp) throws ServiceException {
    if (StringUtils.isEmpty(strCodeUp)) {
        throw new IllegalArgumentException("The organization's code must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<OrganizationPaginationBean> organizations = new ArrayList<OrganizationPaginationBean>();
    try {
        tx = session.beginTransaction();
        Criteria criteria = repository.getCriteria(session, Organization.class)
                .setProjection(Projections.projectionList().add(Projections.property("strCode").as("strCode"))
                        .add(Projections.property("strNameR").as("strNameR"))
                        .add(Projections.property("comName").as("comName")))
                .add(Restrictions.eq("strCodeUp", strCodeUp))
                .add(Restrictions.eq("delKbn", Constants.STATUS_ACTIVE)).addOrder(Order.asc("strCode"))
                .setResultTransformer(new AliasToBeanResultTransformer(OrganizationPaginationBean.class));
        organizations = criteria.list();
        // Release transaction
        tx.commit();
        if (CollectionUtils.isEmpty(organizations)) {
            throw new ObjectNotFoundException("Could not find any Organization with strCodeUp " + strCodeUp);
        }
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException(
                "An exception occured while finding Organization list with strCodeUp " + strCodeUp, ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return organizations;
}

---

From source file:com.nitish.project.springfirst.entity.DAO.impl.FileUploadDAOImpl.java

@Override
public FileUpload getFile(String filename) {
    transaction = session.beginTransaction();
    String str_message = "The Requested File is Not found!!!";
    FileUpload message = new FileUpload(str_message);
    List<FileUpload> fileuploadlist = session.createQuery("From FileUpload").list();
    Criteria retrieve_filename = session.createCriteria(FileUpload.class);
    List<String> ret_filename = retrieve_filename.setProjection(Projections.property("filename")).list();
    for (int i = 0; i < ret_filename.size(); i++) {
        if (ret_filename.get(i).equals(filename)) {
            transaction.commit();/*from  w ww.  j  av a 2 s . com*/
            session.close();
            return fileuploadlist.get(i);
        }
    }
    transaction.commit();
    session.close();
    return message;
}

---

From source file:com.nitish.project.springfirst.entity.DAO.impl.FileUploadDAOImpl.java

@Override
public boolean checkFilename(String filename) {
    Criteria return_fileName = session.createCriteria(FileUpload.class);
    List<String> filename_List = return_fileName.setProjection(Projections.property("filename")).list();
    for (int i = 0; i < filename_List.size(); i++) {
        if (filename.equals(filename_List.get(i))) {
            return true;
        }/*w w  w .j  a va  2  s . c  o m*/
    }
    return false;
}

---

From source file:com.nitish.project.springfirst.entity.DAO.impl.UserLoginDAOImpl.java

@Override
public String CheckUser(String username, String password) {

    transaction = session.beginTransaction();
    Criteria retrieve_username = session.createCriteria(UserLogin.class);
    retrieve_username.setProjection(Projections.property("username"));
    Criteria retrieve_password = session.createCriteria(UserLogin.class);
    retrieve_password.setProjection(Projections.property("password"));
    List<String> user_List = retrieve_username.list();
    List<String> pass_List = retrieve_password.list();
    for (int i = 0; i < user_List.size(); i++) {
        if ((user_List.get(i).equals(username)) && (pass_List.get(i).equals(password))) {
            verdict = "passed";
        }//from w ww.j  a  v a2  s.  co  m
    }

    transaction.commit();
    session.close();
    return verdict;
}

---

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