Example usage for org.hibernate.transform Transformers aliasToBean

Introduction

In this page you can find the example usage for org.hibernate.transform Transformers aliasToBean.

Prototype

public static ResultTransformer aliasToBean(Class target) 

Source Link

Document

Creates a resulttransformer that will inject aliased values into instances of Class via property methods or fields.

Usage

From source file:com.griffinslogistics.db.helpers.BooksHelper.java

public List<BookExtendedModel> getAllBooksByTransportation(Transportation transportation) {
    logger.log(Level.SEVERE, "{0}: getAllBooksByTransportation started", CLASS_NAME);

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    List<BookExtendedModel> result = new ArrayList<BookExtendedModel>();

    try {//from  www .ja  va 2s .  c  om
        Query query = this.session.createQuery(QUERY_BOOK_EXTENDED_MODEL_BY_TRANSPORTATION);
        query.setParameter("transportation", transportation);
        query.setResultTransformer(Transformers.aliasToBean(BookExtendedModel.class));
        result = (List<BookExtendedModel>) query.list();

    } catch (HibernateException e) {
        transaction.rollback();
        logger.log(Level.SEVERE, e.getMessage());
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: getAllBooksByTransportation finished", CLASS_NAME);
    }

    return result;
}

---

From source file:com.griffinslogistics.db.helpers.BooksHelper.java

public List<BookBoxModel> getAllBookBoxModelsByPackage(Bookspackage bookspackage) {

    logger.log(Level.SEVERE, "{0}: getAllBookBoxModelsByPackage started", CLASS_NAME);

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    List<BookBoxModel> result = new ArrayList<BookBoxModel>();

    try {/*from   w w  w.  j  a v  a  2  s  .com*/
        Query query = this.session.createQuery(QUERY_BOOK_BOX_MODELS_BY_PACKAGE);

        query.setParameter("bookspackage", bookspackage);
        query.setResultTransformer(Transformers.aliasToBean(BookBoxModel.class));
        result = (List<BookBoxModel>) query.list();

        for (BookBoxModel bookBoxModel : result) {
            bookBoxModel.setClient(bookspackage.getClient());
            bookBoxModel.setDeliveryAddress(bookspackage.getDeliveryAddress());
        }
    } catch (HibernateException e) {
        transaction.rollback();
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: getAllBookBoxModelsByPackage finished", CLASS_NAME);

    }

    return result;
}

---

From source file:com.griffinslogistics.db.helpers.BooksHelper.java

public Map<String, List<BookBoxModel>> getAllBookBoxModelsByTransportation(Transportation transportation) {
    logger.log(Level.SEVERE, "{0}: getAllBookBoxModelsByTransportation started", CLASS_NAME);

    Map<String, List<BookBoxModel>> result = new HashMap<String, List<BookBoxModel>>();

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    try {/*from   ww w  .j a  va 2 s.  com*/
        //            transportation = (Transportation) this.session.merge(transportation);
        transportation = (Transportation) this.session.get(Transportation.class, transportation.getId());

        for (Bookspackage bookspackage : transportation.getBookspackages()) {

            Query query = this.session.createQuery(QUERY_BOOK_BOX_MODELS_BY_PACKAGE);

            query.setParameter("bookspackage", bookspackage);
            query.setResultTransformer(Transformers.aliasToBean(BookBoxModel.class));
            List<BookBoxModel> bookBoxModels = (List<BookBoxModel>) query.list();

            for (BookBoxModel bookBoxModel : bookBoxModels) {
                bookBoxModel.setClient(bookspackage.getClient());
                bookBoxModel.setDeliveryAddress(bookspackage.getDeliveryAddress());
            }

            if (bookBoxModels.size() > 0) {
                result.put(bookspackage.getPackageNumber(), bookBoxModels);
            }
        }

        transaction.commit();
    } catch (HibernateException e) {
        transaction.rollback();
        logger.log(Level.SEVERE, e.getMessage());
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: getAllBookBoxModelsByTransportation finished", CLASS_NAME);
    }

    return result;
}

---

From source file:com.griffinslogistics.db.helpers.BooksHelper.java

public List<BookModel> getBookModelsByTransportation(Transportation transportation) {
    logger.log(Level.SEVERE, "{0}: getBookModelsByTransportation started", CLASS_NAME);

    List<BookModel> resultList = new ArrayList<BookModel>();

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    try {/*w w w .  ja  v a  2  s . c  om*/
        Criteria criteria = this.session.createCriteria(Book.class);
        criteria.add(Restrictions.eq("transportation", transportation));
        criteria.setProjection(
                Projections.projectionList().add(Projections.groupProperty("bookNumber"), "bookNumber")
                        .add(Projections.property("title"), "title"))
                .setResultTransformer(Transformers.aliasToBean(BookModel.class));

        resultList = criteria.list();
        Collections.reverse(resultList);
        transaction.commit();
    } catch (HibernateException e) {
        transaction.rollback();
        logger.log(Level.SEVERE, e.getMessage());
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: getBookModelsByTransportation finished", CLASS_NAME);
    }

    return resultList;
}

---

From source file:com.griffinslogistics.db.helpers.BookspackagesHelper.java

public List<BookspackageCMRModel> totalWeightForBookspackages(Transportation transportation) {
    logger.log(Level.SEVERE, "{0}: totalWeightForBookspackages started", CLASS_NAME);

    List<BookspackageCMRModel> result = new ArrayList<BookspackageCMRModel>();

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    try {/*  w ww.  jav a 2  s .  co  m*/
        Query query = this.session.createQuery(QUERY_TOTAL_WEIGHT_FOR_ALL_BOOKSPACKAGES);
        query.setResultTransformer(Transformers.aliasToBean(BookspackageCMRModel.class));
        query.setParameter("transportation", transportation);
        result = (List<BookspackageCMRModel>) query.list();
    } catch (HibernateException e) {
        transaction.rollback();
        BookspackagesHelper.logger.log(Level.SEVERE, e.getMessage());
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: totalWeightForBookspackages finished", CLASS_NAME);

    }

    return result;
}

---

From source file:com.griffinslogistics.db.helpers.BookspackagesHelper.java

public BookspackageCMRModel totalWeightForBookspackage(Bookspackage bookspackage) {
    logger.log(Level.SEVERE, "{0}: totalWeightForBookspackage started", CLASS_NAME);

    BookspackageCMRModel result = null;//ww w. j  a  v a 2  s.c o  m

    this.session = HibernateUtil.getSessionFactory().openSession();
    Transaction transaction = this.session.beginTransaction();

    try {
        Query query = this.session.createQuery(QUERY_TOTAL_WEIGHT_FOR_BOOKSPACKAGE);
        query.setResultTransformer(Transformers.aliasToBean(BookspackageCMRModel.class));
        query.setParameter("bookspackage", bookspackage);
        result = (BookspackageCMRModel) query.uniqueResult();
    } catch (HibernateException e) {
        transaction.rollback();
        BookspackagesHelper.logger.log(Level.SEVERE, e.getMessage());
    } finally {
        this.session.close();

        logger.log(Level.SEVERE, "{0}: totalWeightForBookspackage finished", CLASS_NAME);
    }

    return result;
}

---

From source file:com.heimaide.server.common.persistence.BaseDao.java

License:Open Source License

public <E> Page<E> queryBySqlFromDB(Page<E> page, String sqlString, Class<?> resultClass, List param) {
    // get count// w  w w.  j av  a2 s .  co  m
    if (!page.isDisabled() && !page.isNotCount()) {
        String countSqlString = "select count(*) from ( " + sqlString + ") k";// ?????
        // page.setCount(Long.valueOf(createSqlQuery(countSqlString,
        // parameter).uniqueResult().toString()));
        Query query = createSqlQuery(countSqlString, param);
        query.setCacheMode(CacheMode.REFRESH);
        List<Object> list = query.list();
        if (list.size() > 0) {
            page.setCount(Long.valueOf(list.get(0).toString()));
        } else {
            page.setCount(list.size());
        }
        if (page.getCount() < 1) {
            return page;
        }
    }
    // order by
    String sql = sqlString;
    if (StringUtils.isNotBlank(page.getOrderBy())) {
        sql += " order by " + page.getOrderBy();
    }
    SQLQuery query = createSqlQuery(sql, param);
    query.setCacheMode(CacheMode.REFRESH);
    // set page
    if (!page.isDisabled()) {
        query.setFirstResult(page.getFirstResult());
        query.setMaxResults(page.getMaxResults());
    }
    /*
     * Field[] fields = resultClass.getFields(); for (Field f : fields) {
    * query.addScalar(f.getName());// }
    */
    query.setResultTransformer(Transformers.aliasToBean(resultClass));
    page.setList(query.list());
    return page;
}

---

From source file:com.heimaide.server.common.persistence.BaseDao.java

License:Open Source License

public <E> Page<E> queryBySql(Page<E> page, String sqlString, Class<?> resultClass, List param) {
    // get count/*w  w w.  j av a 2 s . co m*/
    if (!page.isDisabled() && !page.isNotCount()) {
        String countSqlString = "select count(*) from ( " + sqlString + ") k";// ?????
        // page.setCount(Long.valueOf(createSqlQuery(countSqlString,
        // parameter).uniqueResult().toString()));
        Query query = createSqlQuery(countSqlString, param);
        List<Object> list = query.list();
        if (list.size() > 0) {
            page.setCount(Long.valueOf(list.get(0).toString()));
        } else {
            page.setCount(list.size());
        }
        if (page.getCount() < 1) {
            return page;
        }
    }
    // order by
    String sql = sqlString;
    if (StringUtils.isNotBlank(page.getOrderBy())) {
        sql += " order by " + page.getOrderBy();
    }
    SQLQuery query = createSqlQuery(sql, param);
    // set page
    if (!page.isDisabled()) {
        query.setFirstResult(page.getFirstResult());
        query.setMaxResults(page.getMaxResults());
    }
    /*
    * Field[] fields = resultClass.getFields(); for (Field f : fields) {
    * query.addScalar(f.getName());// }
    */
    query.setResultTransformer(Transformers.aliasToBean(resultClass));
    page.setList(query.list());
    return page;
}

---

From source file:com.huateng.commquery.dao.CommQueryDAO.java

License:Open Source License

public List<TxnModel> findBySQLQueryModel(final String sql, final int begin, final int count) {

    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("TERM_ID", Hibernate.STRING)
                    .addScalar("INST_DATE", Hibernate.STRING).addScalar("TXN_TYPE", Hibernate.STRING)
                    .addScalar("CUP_SSN", Hibernate.STRING).addScalar("REFE_NUM", Hibernate.STRING)
                    .addScalar("ORDER_TRSNUM", Hibernate.STRING).addScalar("TXN_STATE", Hibernate.STRING)
                    .addScalar("PAN", Hibernate.STRING).addScalar("TRS_AMOUNT", Hibernate.STRING)
                    .addScalar("IPS_MERCHT", Hibernate.STRING)

                    .setResultTransformer(Transformers.aliasToBean(TxnModel.class));
            if (begin >= 0) {
                query.setFirstResult(begin);
                query.setMaxResults(count);
            }/*  w  w w  .java  2 s .c o m*/
            List<TxnModel> list = query.list();

            return list;
        }
    });
}

---

From source file:com.huateng.commquery.dao.CommQueryDAO.java

License:Open Source License

public List<TxnModelOnly> findBySQLQueryModelAll(final String sql) {

    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("CARD_ACCP_ID", Hibernate.STRING)
                    .addScalar("TERM_ID", Hibernate.STRING).addScalar("INST_DATE", Hibernate.STRING)
                    .addScalar("UPDT_DATE", Hibernate.STRING).addScalar("TXN_TYPE", Hibernate.STRING)
                    .addScalar("CUP_SSN", Hibernate.STRING).addScalar("SYS_SEQ_NUM", Hibernate.STRING)
                    .addScalar("TERM_SSN", Hibernate.STRING).addScalar("REFE_NUM", Hibernate.STRING)
                    .addScalar("ORDER_TRSNUM", Hibernate.STRING).addScalar("TXN_STATE", Hibernate.STRING)
                    .addScalar("REVSAL_FLAG", Hibernate.STRING).addScalar("REVSAL_SSN", Hibernate.STRING)
                    .addScalar("CANCEL_FLAG", Hibernate.STRING).addScalar("CANCEL_SSN", Hibernate.STRING)
                    .addScalar("PAN", Hibernate.STRING).addScalar("TRS_AMOUNT", Hibernate.STRING)
                    .addScalar("DATE_SETTLE", Hibernate.STRING).addScalar("AUTHR_ID_RESP", Hibernate.STRING)
                    .addScalar("ISS_CODE", Hibernate.STRING).addScalar("TLR_NUM", Hibernate.STRING)

                    .setResultTransformer(Transformers.aliasToBean(TxnModelOnly.class));

            List<TxnModelOnly> list = query.list();

            return list;
        }/*  w w  w  .  j  a  va  2 s  . 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
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »