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.huateng.commquery.dao.CommQueryDAO.java

License:Open Source License

public List<AgencyInfo> findBySQLQuery1(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("AGEN_ID", Hibernate.STRING)
                    .addScalar("AGEN_NAME", Hibernate.STRING).addScalar("AGEN_TYPE", Hibernate.STRING)
                    .addScalar("TRAN_TYPE", Hibernate.STRING).addScalar("CARD_HOME", Hibernate.STRING)
                    .addScalar("AGEN_REG_BODY", Hibernate.STRING)
                    .addScalar("AGEN_MECH_CAL_TYPE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_TYPE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_PRIN_CYCLE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_PRIN_MODE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_HAND_CYCLE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_HAND_MODE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_LUB_CYCLE", Hibernate.STRING)
                    .addScalar("AGEN_CAL_LUB_MODE", Hibernate.STRING)
                    .addScalar("AGEN_BRAND_RATIO", Hibernate.STRING)
                    .addScalar("AGEN_MIS_RATIO", Hibernate.STRING).addScalar("AGEN_BANK_NUM", Hibernate.STRING)
                    .addScalar("AGEN_ENTRY_MODE", Hibernate.STRING).addScalar("BANK_NAME", Hibernate.STRING)
                    .addScalar("AGEN_INCOME_ACCOUNT_NAME", Hibernate.STRING)
                    .addScalar("AGEN_INCOME_ACCOUNT", Hibernate.STRING)
                    .addScalar("AGEN_EXPENSES_ACCOUNT_NAME", Hibernate.STRING)
                    .addScalar("AGEN_EXPENSES_ACCOUNT", Hibernate.STRING)
                    .addScalar("AGEN_SETTLEMENT_DATE", Hibernate.STRING)
                    .addScalar("AGEN_CLEAR_DETAIL", Hibernate.STRING)
                    .addScalar("AGEN_PAYMENT_SYSTEM", Hibernate.STRING)
                    .addScalar("EXTENSION_FIELD1", Hibernate.STRING)
                    .addScalar("EXTENSION_FIELD2", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(AgencyInfo.class));

            List<AgencyInfo> list = query.list();
            return list;
        }/*w  w w .  j  a  va2s. co m*/
    });
}

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

License:Open Source License

public List<AgencyFeeLubTmp> findBySQLQuery4(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("FEE_ID", Hibernate.STRING)
                    .addScalar("AGEN_ID", Hibernate.STRING).addScalar("AGEN_TYPE", Hibernate.STRING)
                    .addScalar("TERM_ID", Hibernate.STRING).addScalar("MTCH_NO", Hibernate.STRING)
                    .addScalar("MCC_CODE", Hibernate.STRING).addScalar("TRADE_ACCEPT_REG", Hibernate.STRING)
                    .addScalar("AGEN_TARGET_BODY", Hibernate.STRING)
                    .addScalar("AGEN_CRE_CARD", Hibernate.STRING).addScalar("CARD_STYLE", Hibernate.STRING)
                    .addScalar("CARD_MEDIUM", Hibernate.STRING).addScalar("TRADE_CHANNEL", Hibernate.STRING)
                    .addScalar("BUSINESS_TYPE", Hibernate.STRING).addScalar("TRAN_TYPE", Hibernate.STRING)
                    .addScalar("RES", Hibernate.STRING).addScalar("MCHT_RATE_TYPE", Hibernate.STRING)
                    .addScalar("MCHT_RATE_METHOD", Hibernate.STRING).addScalar("AMOUNT_LIMIT", Hibernate.STRING)
                    .addScalar("MCHT_RATE_PARAM", Hibernate.STRING)
                    .addScalar("MCHT_PERCENT_LIMIT", Hibernate.STRING)
                    .addScalar("MCHT_PERCENT_MAX", Hibernate.STRING)
                    .addScalar("MCHT_LUB_TYPE", Hibernate.STRING).addScalar("MCHT_LUB_METHOD", Hibernate.STRING)
                    .addScalar("MCHT_LUB_PARAM", Hibernate.STRING)
                    .addScalar("MCHT_LUB_PERCENT_LIMIT", Hibernate.STRING)
                    .addScalar("MCHT_LUB_PERCENT_MAX", Hibernate.STRING)
                    .addScalar("RATE_PARAM1", Hibernate.STRING).addScalar("LUB_PARAM1", Hibernate.STRING)
                    .addScalar("RATE_PARAM2", Hibernate.STRING).addScalar("RATE_PARAM3", Hibernate.STRING)
                    .addScalar("RATE_PARAM4", Hibernate.STRING).addScalar("RATE_PARAM5", Hibernate.STRING)
                    .addScalar("RATE_PARAM6", Hibernate.STRING).addScalar("RATE_PARAM7", Hibernate.STRING)
                    .addScalar("RATE_PARAM8", Hibernate.STRING).addScalar("RATE_PARAM9", Hibernate.STRING)
                    .addScalar("LUB_PARAM2", Hibernate.STRING).addScalar("LUB_PARAM3", Hibernate.STRING)
                    .addScalar("LUB_PARAM4", Hibernate.STRING).addScalar("LUB_PARAM5", Hibernate.STRING)
                    .addScalar("LUB_PARAM6", Hibernate.STRING).addScalar("LUB_PARAM7", Hibernate.STRING)
                    .addScalar("LUB_PARAM8", Hibernate.STRING).addScalar("LUB_PARAM9", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(AgencyFeeLubTmp.class));

            List<AgencyFeeLubTmp> list = query.list();
            return list;
        }//from w w  w . j  a  va2s  .  co  m
    });
}

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

License:Open Source License

public List<TblTradeCode> findBySQLQuery5(final String sql) {

    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("TRADE_CODE", Hibernate.STRING)
                    .addScalar("TRADE_NAME", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(TblTradeCode.class));
            List<AgencyFeeLub> list = query.list();
            return list;
        }//from  w  w w  .  j  av a 2  s  .com
    });
}

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

License:Open Source License

public List<TblAuitStatus> findBySQLQuery2(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("STATUE_ID", Hibernate.STRING)
                    .addScalar("STATUE_NAME", Hibernate.STRING).addScalar("TYPE", Hibernate.STRING)
                    .addScalar("ID", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(TblAuitStatus.class));
            List<AgencyInfo> list = query.list();
            return list;
        }/*from w  w  w. j  ava2s  .  co m*/
    });
}

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

License:Open Source License

public List<TblCityCodeCode> findBySQLQuery3(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("CITY_CODE", Hibernate.STRING)
                    .addScalar("CITY_DES", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(TblCityCodeCode.class));
            List<AgencyInfo> list = query.list();
            return list;
        }/*from   w  w  w  .  j  a va  2 s  .c  om*/
    });
}

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

License:Open Source License

public List<CstSysParam> findBySQLQuery6(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("type", Hibernate.STRING)
                    .addScalar("value", Hibernate.STRING).addScalar("descr", Hibernate.STRING)
                    .addScalar("reserve", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(CstSysParam.class));
            List<CstSysParam> list = query.list();
            return list;
        }//  www.  j ava2 s  . c  o  m
    });
}

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

License:Open Source License

public List<RiskBefore> findBySQLQuery7(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("MCHT_NM", Hibernate.STRING)
                    .addScalar("LICENSE_NO", Hibernate.STRING).addScalar("ORG_CODE", Hibernate.STRING)
                    .addScalar("IDENTITY", Hibernate.STRING).addScalar("SCORE", Hibernate.STRING)
                    .addScalar("GRADE", Hibernate.STRING).addScalar("MCHT_TYPE", Hibernate.STRING)
                    .addScalar("MAIN_BUS_NUM", Hibernate.STRING).addScalar("RISK_INDUSTRY", Hibernate.STRING)
                    .addScalar("REG_FUND", Hibernate.STRING).addScalar("PREMISES", Hibernate.STRING)
                    .addScalar("PARAM1", Hibernate.STRING).addScalar("PARAM2", Hibernate.STRING)
                    .addScalar("PARAM3", Hibernate.STRING).addScalar("PARAM4", Hibernate.STRING)
                    .addScalar("PARAM5", Hibernate.STRING).addScalar("PARAM6", Hibernate.STRING)
                    .addScalar("PARAM7", Hibernate.STRING).addScalar("PARAM8", Hibernate.STRING)
                    .addScalar("PARAM9", Hibernate.STRING).addScalar("PARAM10", Hibernate.STRING)
                    .addScalar("PARAM11", Hibernate.STRING).addScalar("PARAM12", Hibernate.STRING)
                    .addScalar("PARAM13", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(RiskBefore.class));
            List<RiskBefore> list = query.list();
            return list;
        }/* w  ww  .  j a  v  a 2 s  .c o  m*/
    });
}

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

License:Open Source License

public List<TblHisDiscAlgo1Tmp> findBySQLQuery8(final String sql) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.createSQLQuery(sql).addScalar("DISC_ID", Hibernate.STRING)
                    .addScalar("TERM_ID", Hibernate.STRING).addScalar("MCHT_NO", Hibernate.STRING)
                    .addScalar("CITY_CODE", Hibernate.STRING).addScalar("TO_BRCH_NO", Hibernate.STRING)
                    .addScalar("FK_BRCH_NO", Hibernate.STRING).addScalar("CARD_TYPE", Hibernate.STRING)
                    .addScalar("CHANNEL_NO", Hibernate.STRING).addScalar("BUSINESS_TYPE", Hibernate.STRING)
                    .addScalar("TXN_NUM", Hibernate.STRING).addScalar("MIN_FEE", Hibernate.DOUBLE)
                    .addScalar("MAX_FEE", Hibernate.DOUBLE).addScalar("FLOOR_AMOUNT", Hibernate.DOUBLE)
                    .addScalar("FLAG", Hibernate.STRING).addScalar("FEE_VALUE", Hibernate.DOUBLE)
                    .addScalar("REC_UPD_USR_ID", Hibernate.STRING).addScalar("REC_UPD_TS", Hibernate.STRING)
                    .addScalar("REC_CRT_TS", Hibernate.STRING).addScalar("SA_SATUTE", Hibernate.STRING)
                    .setResultTransformer(Transformers.aliasToBean(TblHisDiscAlgo1Tmp.class));
            List<TblHisDiscAlgo1> list = query.list();
            return list;
        }//from w w  w. j a  v a2  s. co  m
    });
}

From source file:com.ibm.ioes.utilities.AjaxHelper.java

public ArrayList getUsersOfRole(String roleId) throws Exception {
    ArrayList employeeList = new ArrayList();
    Session hibernateSession = null;//from   w  ww. j ava 2 s  .  com

    try {
        hibernateSession = com.ibm.ioes.npd.hibernate.dao.CommonBaseDao.beginTrans();
        String sql = "SELECT   TM_EMPLOYEE.NPDEMPID,TM_EMPLOYEE.EMPNAME FROM   NPD.TM_ROLEEMPMAPPING TM_ROLEEMPMAPPING "
                + "INNER JOIN NPD.TM_ROLES TM_ROLES ON TM_ROLEEMPMAPPING.ROLEID = TM_ROLES.ROLEID"
                + "   INNER JOIN NPD.TM_EMPLOYEE TM_EMPLOYEE "
                + "ON TM_ROLEEMPMAPPING.NPDEMPID = TM_EMPLOYEE.NPDEMPID WHERE TM_ROLES.ROLEID=:roleId";
        SQLQuery query = hibernateSession.createSQLQuery(sql);

        query.setLong("roleId", Long.valueOf(roleId));

        query.addScalar("npdempid", Hibernate.LONG).addScalar("empname", Hibernate.STRING)
                .setResultTransformer(Transformers.aliasToBean(TmEmployee.class));

        employeeList = (ArrayList) query.list();

    } catch (Exception ex) {
        ex.printStackTrace();
        String msg = ex.getMessage() + " Exception occured in getUsersOfRole method of "
                + this.getClass().getSimpleName() + AppUtility.getStackTrace(ex);
        AppConstants.NPDLOGGER.error(msg);
        throw new NpdException(msg);
    } finally {
        hibernateSession.close();
    }
    return employeeList;
}

From source file:com.iluwatar.cqrs.queries.QueryServiceImpl.java

License:Open Source License

@Override
public Author getAuthorByUsername(String username) {
    Author authorDTo = null;/*from w w  w.  j a  v  a 2s . c  o m*/
    try (Session session = sessionFactory.openSession()) {
        SQLQuery sqlQuery = session
                .createSQLQuery("SELECT a.username as \"username\", a.name as \"name\", a.email as \"email\""
                        + "FROM Author a where a.username=:username");
        sqlQuery.setParameter("username", username);
        authorDTo = (Author) sqlQuery.setResultTransformer(Transformers.aliasToBean(Author.class))
                .uniqueResult();
    }
    return authorDTo;
}