Example usage for org.hibernate.transform Transformers aliasToBean

List of usage examples for org.hibernate.transform Transformers aliasToBean

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.transform.*
  5. Transformers
  6. 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.dungnv.streetfood.business.RestaurantDishDetailBusiness.java

License:Open Source License

@Override
public List<RestaurantDTO> getListRestaurantByDish(String userName, String localeCode, String countryCode,
        String token, String id) {
    SQLQuery query = gettDAO().getSession().createSQLQuery("select c.id, c.name from restaurant c "
            + " inner join restaurant_dish_detail l on c.id = l.restaurant_id" + " where l.dish_id = ? ");
    query.addScalar("id", StringType.INSTANCE);
    query.addScalar("name", StringType.INSTANCE);
    query.setLong(0, Long.valueOf(id));
    query.setResultTransformer(Transformers.aliasToBean(RestaurantDTO.class));
    return query.list();
}

From source file:com.dungnv.streetfood.business.RestaurantDishDetailBusiness.java

License:Open Source License

@Override
public List<DishDTO> getListDishByRestaurant(String userName, String localeCode, String countryCode,
        String token, String id) {
    SQLQuery query = gettDAO().getSession().createSQLQuery("select c.id, c.name from dish c "
            + " inner join restaurant_dish_detail l on c.id =l.dish_id" + " where l.restaurant_id = ? ");
    query.addScalar("id", StringType.INSTANCE);
    query.addScalar("name", StringType.INSTANCE);
    query.setLong(0, Long.valueOf(id));
    query.setResultTransformer(Transformers.aliasToBean(DishDTO.class));
    return query.list();
}

From source file:com.dungnv.streetfood.business.SlideShowBusiness.java

License:Open Source License

@Override
public List<SlideShowDTO> getListSlideShowDTOLess(String userName, String localeCode, String countryCode,
        String token, SlideShowDTO dto, int rowStart, int maxRow, boolean isCount, String sortType,
        String sortFieldList) {/* w w  w  .j a v  a 2  s  .co  m*/
    StringBuilder sbQuery = new StringBuilder();
    List<Object> listParam = new ArrayList<>();
    List<Type> listType = new ArrayList<>();

    if (isCount) {
        sbQuery.append(" select count(a.id) as id from slide_show a where 1=1 ");
    } else {
        sbQuery.append(" select a.id ");
        sbQuery.append(" , a.url");
        sbQuery.append(" , a.name");
        sbQuery.append(" , a.description");
        sbQuery.append(" , a.orders as 'order'");
        sbQuery.append(" , a.valid_from_gmt validFromGmt ");
        sbQuery.append(" , a.valid_to_gmt validToGmt");
        sbQuery.append(" , g.id imageId");
        sbQuery.append(" , g.url imageUrl");
        sbQuery.append(" from slide_show a left outer join img g on a.id = g.slide_show_id and g.orders = 1 ");
        sbQuery.append(" where 1=1");
    }

    if (dto != null) {
        StringUtils.trimString(dto, false);

        if (!StringUtils.isNullOrEmpty(dto.getId())) {
            sbQuery.append(" AND  a.id = ?");
            listParam.add(Long.valueOf(dto.getId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getName())) {
            sbQuery.append(" AND lower(a.name) like ? ");
            listParam.add("%" + dto.getName().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }
    }

    if (!isCount) {
        sbQuery.append(" order by a.orders DESC");
        if (maxRow != 0) {
            sbQuery.append(" limit ?, ?");
            listParam.add(rowStart);
            listType.add(IntegerType.INSTANCE);
            listParam.add(maxRow);
            listType.add(IntegerType.INSTANCE);
        }

    }

    SQLQuery query = gettDAO().getSession().createSQLQuery(sbQuery.toString());
    query.addScalar("id", StringType.INSTANCE);
    if (!isCount) {

        query.addScalar("url", StringType.INSTANCE);
        query.addScalar("name", StringType.INSTANCE);
        query.addScalar("description", StringType.INSTANCE);
        query.addScalar("order", StringType.INSTANCE);
        query.addScalar("validFromGmt", StringType.INSTANCE);
        query.addScalar("validToGmt", StringType.INSTANCE);
        query.addScalar("imageId", StringType.INSTANCE);
        query.addScalar("imageUrl", StringType.INSTANCE);
    }

    query.setResultTransformer(Transformers.aliasToBean(SlideShowDTO.class));

    for (int i = 0; i < listParam.size(); i++) {
        query.setParameter(i, listParam.get(i), listType.get(i));
    }

    List<SlideShowDTO> list = query.list();
    return list;
}

From source file:com.dungnv.streetfood.dao.CategoryDAO.java

License:Open Source License

public List<CategoryDTO> getListCategoryDTOLess(CategoryDTO categoryDTO, int rowStart, int maxRow,
        boolean isCount, String sortType, String sortFieldList) {
    StringBuilder sbQuery = new StringBuilder();
    List<Object> listParam = new ArrayList<>();
    List<Type> listType = new ArrayList<>();

    if (isCount) {
        sbQuery.append(" select count(c.id) as id from Category c where 1=1 ");
    } else {//  www. ja va 2s  .c  o  m
        sbQuery.append(" select c.id ");
        sbQuery.append(" , c.name");
        if (categoryDTO == null || !"1".equals(categoryDTO.getIsGetOnlyIdentified())) {
            sbQuery.append(" , c.description");
            sbQuery.append(" , c.category_status categoryStatus");
            sbQuery.append(" , g.id imageId");
            sbQuery.append(" , g.url imageUrl");
        }

        sbQuery.append(" from Category c ");
        sbQuery.append(" left outer join img g on c.id = g.dish_group_id and g.orders = 1  ");
        sbQuery.append(" where 1=1");
    }

    if (categoryDTO != null) {
        StringUtils.trimString(categoryDTO, false);

        if (!StringUtils.isNullOrEmpty(categoryDTO.getId())) {
            sbQuery.append(" AND  c.id = ?");
            listParam.add(Long.valueOf(categoryDTO.getId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(categoryDTO.getDishId())) {
            sbQuery.append(" AND c.id in ( select category_id from category_dish where dish_id = ? ) ");
            listParam.add(Long.valueOf(categoryDTO.getDishId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(categoryDTO.getNotDishId())) {
            sbQuery.append(" AND c.id not in ( select category_id from category_dish where dish_id = ? ) ");
            listParam.add(Long.valueOf(categoryDTO.getNotDishId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(categoryDTO.getName())) {
            sbQuery.append(" AND lower(c.name) like ? ");
            listParam.add("%" + categoryDTO.getName().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(categoryDTO.getCategoryStatus())) {
            sbQuery.append(" AND c.category_status = ? ");
            listParam.add(Long.valueOf(categoryDTO.getCategoryStatus()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(categoryDTO.getDescription())) {
            sbQuery.append(" AND lower(c.description) like ? ");
            listParam.add("%" + categoryDTO.getDescription().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }

        if (categoryDTO.getListTag() != null && !categoryDTO.getListTag().isEmpty()) {
            sbQuery.append(" AND  c.id in (select category_id from tag_category where tag_id in ");
            sbQuery.append(QueryUtil.getParameterHolderString(categoryDTO.getListTag().size()));
            sbQuery.append(" )");
            List<String> listTag = categoryDTO.getListTag();
            for (String tagId : listTag) {
                listParam.add(Long.valueOf(tagId));
                listType.add(LongType.INSTANCE);
            }
        }

        if (categoryDTO.getListNotLocale() != null && !categoryDTO.getListNotLocale().isEmpty()) {
            sbQuery.append(
                    " AND not exists (select l.dish_group_id from dish_group_langage l where l.language_code in ");
            sbQuery.append(QueryUtil.getParameterHolderString(categoryDTO.getListNotLocale().size()));
            sbQuery.append(" AND l.dish_group_id = c.id )");
            List<String> listNotLocale = categoryDTO.getListNotLocale();
            for (String notLocale : listNotLocale) {
                listParam.add(notLocale);
                listType.add(StringType.INSTANCE);
            }
        }
        if (categoryDTO.getListLocale() != null && !categoryDTO.getListLocale().isEmpty()) {

            for (String locale : categoryDTO.getListLocale()) {
                sbQuery.append(
                        " AND exists (select l.dish_group_id from dish_group_langage l where l.language_code = ? ");
                sbQuery.append(" AND l.dish_group_id = c.id )");
                listParam.add(locale);
                listType.add(StringType.INSTANCE);
            }
        }
    }

    if (!isCount) {
        sbQuery.append(" order by c.name DESC");
        if (maxRow != 0) {
            sbQuery.append(" limit ?, ?");
            listParam.add(rowStart);
            listType.add(IntegerType.INSTANCE);
            listParam.add(maxRow);
            listType.add(IntegerType.INSTANCE);
        }

    }

    SQLQuery query = getSession().createSQLQuery(sbQuery.toString());
    query.addScalar("id", StringType.INSTANCE);
    if (!isCount) {
        query.addScalar("name", StringType.INSTANCE);
        if (categoryDTO == null || !"1".equals(categoryDTO.getIsGetOnlyIdentified())) {
            query.addScalar("description", StringType.INSTANCE);
            query.addScalar("categoryStatus", StringType.INSTANCE);
            query.addScalar("imageId", StringType.INSTANCE);
            query.addScalar("imageUrl", StringType.INSTANCE);
        }
    }

    query.setResultTransformer(Transformers.aliasToBean(CategoryDTO.class));

    for (int i = 0; i < listParam.size(); i++) {
        query.setParameter(i, listParam.get(i), listType.get(i));
    }

    List<CategoryDTO> list = query.list();
    StringUtils.escapeHTMLString(list);
    return list;
}

From source file:com.ephesoft.dcma.performance.reporting.service.ReportDataServiceImpl.java

License:Open Source License

/**
 * Method to get Reports Per page for a WorkflowType for a specified time.
 * /* w w w .  j ava  2  s . co  m*/
 * @param batchClassIds List<{@link String}> Batch Class Ids for which the report data needs to be fetched
 * @param workflowType {@link WorkflowType}, One of Module , Plugin or Workflow specifying the type of filter
 * @param endTime {@link Date} upto which the reporting data needs to be fetched
 * @param startTime {@link Date} Starting Date from which the reporting data needs to be fetched
 * @param StartIndex int, Start Index for pagination
 * @param range int Number of records per page
 * @param order {@link Order} By field
 * @return List<{@link ReportDisplayData}> List of RepoertDisplayData DTOs
 * @throws DCMAException if error occurs in database creation
 */
@SuppressWarnings("unchecked")
public List<ReportDisplayData> getReportByWorkflow(List<String> batchClassIds, WorkflowType workflowType,
        Date endTime, Date startTime, int StartIndex, int range, Order order) throws DCMAException {
    Connection connection = null;
    Query qry = null;
    List<ReportDisplayData> displayDatas = null;
    try {
        connection = dynamicHibernateDao.getConnectionProvider().getConnection();

        StatelessSession session = dynamicHibernateDao.getStatelessSession(connection);
        qry = session.getNamedQuery(ReportingConstants.GET_REPORT_BY_WORKFLOW);
        qry.setResultTransformer(Transformers.aliasToBean(ReportDisplayData.class));

        // Adding 1 Day in the End Time to show all the records for that Day
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(endTime);
        calendar.add(Calendar.DATE, 1);

        qry.setParameter(ReportingConstants.END_TIME, new java.sql.Date(calendar.getTimeInMillis()));

        qry.setParameter(ReportingConstants.START_TIME, new java.sql.Date(startTime.getTime()));
        qry.setParameter(ReportingConstants.START_INDEX, StartIndex);
        qry.setParameter(ReportingConstants.RANGE, range);
        qry.setParameter(ReportingConstants.WORK_FLOW_TYPE, workflowType.name());
        qry.setParameterList(ReportingConstants.BATCH_CLASS_ID_LIST, batchClassIds);
        displayDatas = qry.list();
    } catch (SQLException e) {
        LOGGER.error(ERROR_CREATING_DATABASE_CONNECTION + e.getMessage(), e);
    } finally {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                LOGGER.error(ERROR_CLOSING_DATABASE_CONNECTION + e.getMessage(), e);
            }
        }
    }
    return displayDatas;
}

From source file:com.ephesoft.dcma.performance.reporting.service.ReportDataServiceImpl.java

License:Open Source License

/**
 * Method to get Reports Per page for a User for a specified time.
 * //from  w ww  .  j a va 2  s .c o m
 * @param batchClassIds List<{@link String}>, Batch Class Ids for which the report data needs to be fetched
 * @param userName {@link String}, User name for which the report are to be fetched
 * @param endTime {@link Date}, Date upto which the reporting data needs to be fetched
 * @param startTime {@link Date}, Starting Date from which the reporting data needs to be fetched
 * @param StartIndex int, Start Index for pagination
 * @param range int, Number of records per page
 * @param order {@link Order}, By field
 * @return List<{@link ReportDisplayData}>, List of RepoertDisplayData DTOs
 * @throws DCMAException if error occurs in database creation
 */
@SuppressWarnings("unchecked")
public List<ReportDisplayData> getReportByUser(List<String> batchClassIds, String userName, Date endTime,
        Date startTime, int StartIndex, int range, Order order) throws DCMAException {
    Connection connection = null;
    Query qry = null;
    List<ReportDisplayData> resultList = null;
    try {
        connection = dynamicHibernateDao.getConnectionProvider().getConnection();
        StatelessSession session = dynamicHibernateDao.getStatelessSession(connection);

        if (userName.equalsIgnoreCase(ReportingConstants.ALL)) {
            qry = session.getNamedQuery(ReportingConstants.GET_REPORT_FOR_ALL_USERS);
        } else {
            qry = session.getNamedQuery(ReportingConstants.GET_REPORT_BY_USER_NAME);
            qry.setParameter(ReportingConstants.USER_NAME, userName);
        }
        qry.setResultTransformer(Transformers.aliasToBean(ReportDisplayData.class));
        qry.setParameterList(ReportingConstants.BATCH_CLASS_ID_LIST, batchClassIds);

        // Adding 1 Day in the End Time to show all the records for that Day
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(endTime);
        calendar.add(Calendar.DATE, 1);

        qry.setParameter(ReportingConstants.END_TIME, new java.sql.Date(calendar.getTimeInMillis()));
        qry.setParameter(ReportingConstants.START_TIME, new java.sql.Date(startTime.getTime()));
        qry.setParameter(ReportingConstants.START_INDEX, StartIndex);
        qry.setParameter(ReportingConstants.RANGE, range);
        resultList = qry.list();
    } catch (SQLException e) {
        LOGGER.error(ERROR_CREATING_DATABASE_CONNECTION + e.getMessage(), e);
    } finally {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                LOGGER.error(ERROR_CLOSING_DATABASE_CONNECTION + e.getMessage(), e);
            }
        }
    }

    return resultList;
}

From source file:com.ett.drv.biz.DrvQueryHelperImp.java

public List<ComboxObject> getDict(String xtlb, String type) {
    List<ComboxObject> listTmp = new ArrayList<ComboxObject>();
    SessionFactory sessionFactory = this.getBaseDaoDrv().getHibernateSessionFactory();
    Session session = sessionFactory.openSession();
    Transaction tx = session.beginTransaction();

    String queryStr = MessageFormat.format(DictSql, xtlb, type);
    logger.debug("?" + queryStr.toString());
    SQLQuery query = session.createSQLQuery(queryStr.toString());
    query.addScalar("value", new org.hibernate.type.StringType());
    query.addScalar("text", new org.hibernate.type.StringType());

    query.setResultTransformer(Transformers.aliasToBean(ComboxObject.class));
    try {// w  w w.  j  a v a2  s .  co  m
        tx.begin();
        //query.uniqueResult()
        listTmp = query.list();

        if (logger.isInfoEnabled()) {
            logger.info("==" + listTmp.size());
        }
        if (listTmp.size() == 0) {
            throw new ObjectDontExistException("?");
        }
        session.flush();
        tx.commit();
    } catch (Exception e) {
        e.printStackTrace();
        logger.info(e);
        if (tx != null) {
            tx.rollback();
        }
        throw new ObjectDontExistException(e);
    } finally {
        session.close();
    }
    return listTmp;
}

From source file:com.ett.drv.biz.DrvQueryHelperImp.java

public DrvUser getDrvUser(String idcard, String glbm) {
    //System.out.println("Dao");
    logger.debug("DAO" + this.getBaseDaoDrv());
    logger.debug("??" + this.user);
    if (this.user != null) {

        return user;
    }//  w w w .j av a2  s  . c  om
    logger.debug("???" + idcard + "??" + glbm
            + "??");
    List lists = new ArrayList();
    SessionFactory sessionFactory = this.getBaseDaoDrv().getHibernateSessionFactory();
    Session session = sessionFactory.openSession();
    logger.debug("baseDaoDrv?");
    Transaction tx = session.beginTransaction();
    logger.debug("Sessionsql?");
    String queryStr = MessageFormat.format(getDrvUser, idcard, glbm);
    logger.debug("??" + queryStr.toString());
    SQLQuery query = session.createSQLQuery(queryStr.toString());
    query.addScalar("lsh", new org.hibernate.type.StringType());
    query.addScalar("sfzmhm", new org.hibernate.type.StringType());
    query.addScalar("xb", new org.hibernate.type.IntegerType());
    query.addScalar("xm", new org.hibernate.type.StringType());
    query.addScalar("csrq", new org.hibernate.type.DateType());
    query.addScalar("lxzsxxdz", new org.hibernate.type.StringType());
    query.addScalar("lxdh", new org.hibernate.type.StringType());
    query.addScalar("sjhm", new org.hibernate.type.StringType());

    query.setResultTransformer(Transformers.aliasToBean(DrvUser.class));
    try {
        tx.begin();
        //query.uniqueResult()
        lists = query.list();

        if (logger.isInfoEnabled()) {
            logger.info("??==" + lists.size());
        }
        if (lists.size() == 0) {
            return null;
            //throw new ObjectDontExistException("??");
        }

        session.flush();
        tx.commit();
    } catch (Exception e) {
        e.printStackTrace();

        logger.info(e);
        if (tx != null) {
            tx.rollback();
        }

        throw new ObjectDontExistException(e);
    } finally {
        session.close();
    }
    this.user = (DrvUser) lists.get(0);
    return this.user;
}

From source file:com.ett.drv.biz.DrvQueryHelperImp.java

public DrvUser getUserWithExamCard(DrvUser user) {
    DrvUser tmpuser = user;/*  w  ww  .j  a  va2  s  .  com*/
    List lists = new ArrayList();
    SessionFactory sessionFactory = this.getBaseDaoDrv().getHibernateSessionFactory();
    Session session = sessionFactory.openSession();
    Transaction tx = session.beginTransaction();

    String queryStr = MessageFormat.format(getExamCard, tmpuser.getSfzmhm());
    logger.debug("??" + queryStr.toString());
    SQLQuery query = session.createSQLQuery(queryStr.toString());
    query.addScalar("dabh", new org.hibernate.type.StringType());
    query.addScalar("zkzmbh", new org.hibernate.type.StringType());
    query.addScalar("zkcx", new org.hibernate.type.StringType());
    query.addScalar("cclzrq", new org.hibernate.type.TimestampType());
    query.addScalar("fzrq", new org.hibernate.type.TimestampType());
    query.addScalar("jxdm", new org.hibernate.type.StringType());

    //GregorianCalendar
    query.addScalar("yxqz", new org.hibernate.type.TimestampType());
    query.addScalar("yxqs", new org.hibernate.type.TimestampType());

    query.setResultTransformer(Transformers.aliasToBean(DrvUser.class));
    try {
        tx.begin();
        //query.uniqueResult()
        lists = query.list();

        if (logger.isInfoEnabled()) {
            logger.info("getUserWithExamCard?==" + lists.size());
        }
        if (lists.size() == 0) {
            return null;
            //throw new ObjectDontExistException("???");
        }

        session.flush();
        tx.commit();
    } catch (Exception e) {
        e.printStackTrace();

        logger.info(e);
        if (tx != null) {
            tx.rollback();
        }

        throw new ObjectDontExistException(e);
    } finally {
        session.close();
    }
    DrvUser tmp = (DrvUser) lists.get(0);
    tmpuser.setDabh(tmp.getDabh());
    tmpuser.setZkzmbh(tmp.getZkzmbh());
    tmpuser.setYxqs(tmp.getYxqs());
    tmpuser.setYxqz(tmp.getYxqz());
    tmpuser.setZkcx(tmp.getZkcx());
    tmpuser.setCclzrq(tmp.getCclzrq());
    tmpuser.setFzrq(tmp.getFzrq());
    tmpuser.setJxdm(tmp.getJxdm());
    return tmpuser;
}

From source file:com.ett.drv.biz.DrvQueryHelperImp.java

public DrvUser getUserWithLicense(DrvUser user) {
    DrvUser tmpuser = user;/*from w  ww  . j av a  2s.c  o  m*/
    List lists = new ArrayList();
    SessionFactory sessionFactory = this.getBaseDaoDrv().getHibernateSessionFactory();
    Session session = sessionFactory.openSession();
    Transaction tx = session.beginTransaction();

    String queryStr = MessageFormat.format(getLicense, tmpuser.getSfzmhm());
    logger.debug("getUserWithLicense?" + queryStr.toString());
    SQLQuery query = session.createSQLQuery(queryStr.toString());
    query.addScalar("zkcx", new org.hibernate.type.StringType());
    query.addScalar("dabh", new org.hibernate.type.StringType());
    query.addScalar("yxqz", new org.hibernate.type.TimestampType());
    query.addScalar("yxqs", new org.hibernate.type.TimestampType());
    query.addScalar("cclzrq", new org.hibernate.type.TimestampType());
    query.addScalar("syrq", new org.hibernate.type.TimestampType());
    query.addScalar("qfrq", new org.hibernate.type.TimestampType());
    query.addScalar("jxdm", new org.hibernate.type.StringType());

    query.setResultTransformer(Transformers.aliasToBean(DrvUser.class));
    try {
        tx.begin();
        //query.uniqueResult()
        lists = query.list();

        if (logger.isInfoEnabled()) {
            logger.info("getUserWithLicense==" + lists.size());
        }
        if (lists.size() == 0) {
            return null;
            //throw new ObjectDontExistException("???");
        }

        session.flush();
        tx.commit();
    } catch (Exception e) {
        e.printStackTrace();

        logger.info(e);
        if (tx != null) {
            tx.rollback();
        }

        throw new ObjectDontExistException(e);
    } finally {
        session.close();
    }
    DrvUser tmp = (DrvUser) lists.get(0);
    tmpuser.setDabh(tmp.getDabh());

    tmpuser.setYxqs(tmp.getYxqs());
    tmpuser.setYxqz(tmp.getYxqz());

    tmpuser.setCclzrq(tmp.getCclzrq());
    tmpuser.setQfrq(tmp.getQfrq());
    tmpuser.setSyrq(tmp.getSyrq());
    tmpuser.setJxdm(tmp.getJxdm());
    tmpuser.setZkcx(tmp.getZkcx());
    return tmpuser;
}