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.aan.girsang.server.service.impl.ReportServiceImpl.java

@Override
public JasperPrint testReport() {
    try {/*  w ww.  j  av  a2s .  c o m*/
        List<ReportBarang> reportBarang = sessionFactory.getCurrentSession()
                .createQuery("select b.plu as plu," + " b.namaBarang as namaBarang, "
                        + " b.hargaBeli as hargaBeli from Barang b order by b.namaBarang")
                .setResultTransformer(Transformers.aliasToBean(ReportBarang.class)).list();
        InputStream is = ReportServiceImpl.class
                .getResourceAsStream("/com/aan/girsang/server/report/testBarangReport.jasper");
        Map<String, Object> parameters = new HashMap<String, Object>();
        System.out.println("Report Tampil");
        return JasperFillManager.fillReport(is, parameters, new JRBeanCollectionDataSource(reportBarang));
    } catch (JRException ex) {
        log.error("error generate DailySalesReport", ex);
        ex.printStackTrace();
    }
    return null;
}

From source file:com.aan.girsang.server.service.impl.ReportServiceImpl.java

@Override
public JasperPrint penjualanBarang() {
    try {/*from ww  w  .jav  a 2 s  . com*/
        List<ReportPenjualanBarang> reportPenjualanBarang = sessionFactory.getCurrentSession()
                .createQuery("select p.barang.namaBarang as namaBarang, " + "sum(p.kuantitas) as jumlah, "
                        + "sum(p.subTotal) as subTotal, " + "p.hargaJual as hargaJual "
                        + "from PenjualanDetail p "
                        + "group by p.barang.namaBarang order by p.barang.namaBarang")
                .setResultTransformer(Transformers.aliasToBean(ReportPenjualanBarang.class)).list();

        InputStream is = ReportServiceImpl.class
                .getResourceAsStream("/com/aan/girsang/server/report/PenjualanBarang.jasper");
        Map<String, Object> parameters = new HashMap<>();

        return JasperFillManager.fillReport(is, parameters,
                new JRBeanCollectionDataSource(reportPenjualanBarang));
    } catch (JRException ex) {
        log.error("error generate DailySalesReport", ex);
        ex.printStackTrace();
    }
    return null;
}

From source file:com.abssh.util.GenericDao.java

License:Apache License

/**
 * SQL.//w w w.j av a2 s  .  c  o  m
 * 
 * @author zhirong
 * @param page
 *            ??null
 * @param sql
 *            sql?.
 * @param values
 *            ???,??.
 * 
 * @return , ??.
 */
@SuppressWarnings("unchecked")
public Page<T> findPageSQLNonHibernateEntity(final Page<T> page, final String sql,
        final Map<String, Object> values) {
    Assert.notNull(page, "page should not be null!");

    String order = getOrderClause(page, sql);
    String selectSQL = sql + order;
    Query q = createSQLQuery(selectSQL, values).setResultTransformer(Transformers.aliasToBean(entityClass));

    if (page.getPageSize() > 0 && page.isAutoCount()) {
        long totalCount = countSqlResult(sql, values);
        page.setTotalCount(totalCount);
    }
    if (page != null && page.getPageSize() > 0 && page.getTotalPages() < page.getPageNo()) {
        page.setPageNo(1L);
    }

    setPageParameter(q, page);

    List result = q.list();
    page.setResult(result);
    return page;
}

From source file:com.abssh.util.GenericDao.java

License:Apache License

/**
 * ?sql// w  w w  .j  a  va  2 s  . c o  m
 */
@SuppressWarnings("unchecked")
public T findSQLNonHibernateEntity(final String sql, final Map<String, Object> values) {
    Query query = createSQLQuery(sql, values).setResultTransformer(Transformers.aliasToBean(entityClass));
    query.setMaxResults(1);
    return (T) query.uniqueResult();
}

From source file:com.ar.dev.tierra.api.dao.impl.ProductoDAOImpl.java

@SuppressWarnings("unchecked")
@Override//  w ww .  ja va  2s .  c  o  m
public List<Producto> getAll() {
    Criteria criteria = getSession().createCriteria(Producto.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idProducto"), "idProducto");
    projList.add(Projections.property("marcas"), "marcas");
    projList.add(Projections.property("descripcion"), "descripcion");
    projList.add(Projections.property("colorProducto"), "colorProducto");
    projList.add(Projections.property("cantidadTotal"), "cantidadTotal");
    projList.add(Projections.property("talla"), "talla");
    criteria.add(Restrictions.eq("estadoProducto", true));
    criteria.addOrder(Order.desc("idProducto"));
    criteria.setProjection(Projections.distinct(projList));
    criteria.setResultTransformer(Transformers.aliasToBean(Producto.class));
    List<Producto> list = criteria.list();
    return list;
}

From source file:com.ar.dev.tierra.api.dao.impl.UsuariosDAOImpl.java

@SuppressWarnings("unchecked")
@Override/* w w w.  j ava2  s . c  o  m*/
public List<Usuarios> allUsuarios() {
    Criteria criteria = getSession().createCriteria(Usuarios.class);
    criteria.addOrder(Order.asc("idUsuario"));
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idUsuario"), "idUsuario");
    projList.add(Projections.property("roles"), "roles");
    projList.add(Projections.property("nombre"), "nombre");
    projList.add(Projections.property("apellido"), "apellido");
    projList.add(Projections.property("dni"), "dni");
    projList.add(Projections.property("telefono"), "telefono");
    projList.add(Projections.property("email"), "email");
    projList.add(Projections.property("fechaNacimiento"), "fechaNacimiento");
    projList.add(Projections.property("domicilio"), "domicilio");
    projList.add(Projections.property("estado"), "estado");
    projList.add(Projections.property("ultimaConexion"), "ultimaConexion");
    projList.add(Projections.property("usuarioSucursal"), "usuarioSucursal");
    criteria.setProjection(Projections.distinct(projList));
    criteria.setResultTransformer(Transformers.aliasToBean(Usuarios.class));
    List<Usuarios> us = criteria.list();
    return us;
}

From source file:com.asecurity.eventslogdb.AccessEvents.java

private List<ApacseventsCha> getApacseventsCha(String hql, int resCnt, boolean useNativeSQL) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    List<ApacseventsCha> aeCha = null;
    Transaction tx = null;/*  w  ww . j  a  va2  s  .  c  om*/
    try {
        tx = session.beginTransaction();
        Query q;
        if (useNativeSQL) {
            q = session.createSQLQuery(hql);
            q.setResultTransformer(Transformers.aliasToBean(ApacseventsCha.class));
        } else {
            q = session.createQuery(hql);
        }
        q.setMaxResults(resCnt);
        aeCha = (List<ApacseventsCha>) q.list();
    } catch (Exception e) {
        System.out.println(e.toString());
    } finally {
        if (tx != null) {
            tx.rollback();
        }
        if (session.isOpen()) {
            session.close();
        }
    }
    return aeCha;
}

From source file:com.autentia.wuija.persistence.impl.hibernate.HibernateDao.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public <T> List<T> find(final String queryString, final int firstResult, final int maxResults,
        final List values, final Class<T> transformerClass) {
    final List<T> list = getHibernateTemplate().executeFind(new HibernateCallback() {

        @Override//from   w w  w . j av  a2  s  .c  om
        public Object doInHibernate(Session session) throws HibernateException {
            final Query query = session.createQuery(queryString);
            setPagination(query, firstResult, maxResults);
            setPositionalParameters(values, query);
            query.setResultTransformer(Transformers.aliasToBean(transformerClass));
            return query.list();
        }

    });
    traceResults(list);
    return list;
}

From source file:com.autentia.wuija.persistence.impl.hibernate.HibernateDao.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public <T> List<T> find(final String queryString, final int firstResult, final int maxResults, final Map values,
        final Class<T> transformerClass) {
    final List<T> list = getHibernateTemplate().executeFind(new HibernateCallback() {

        @Override//from   w w w  . j  a va 2 s  . co m
        public Object doInHibernate(Session session) throws HibernateException {
            final Query query = session.createQuery(queryString);
            setPagination(query, firstResult, maxResults);
            setNamedParameters(values, query);
            query.setResultTransformer(Transformers.aliasToBean(transformerClass));
            return query.list();
        }

    });
    traceResults(list);
    return list;
}

From source file:com.autentia.wuija.persistence.impl.hibernate.HibernateDao.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public <T> List<T> findByNativeQueryTransformer(final Class<T> transformerClass, final String queryString,
        final int firstResult, final int maxResults, final Map values) {
    final List<T> list = getHibernateTemplate().executeFind(new HibernateCallback() {

        @Override//from   ww  w  .  j a v  a  2  s. c o  m
        public Object doInHibernate(Session session) throws HibernateException {
            final SQLQuery query = session.createSQLQuery(queryString);
            query.setResultTransformer(Transformers.aliasToBean(transformerClass));
            setPagination(query, firstResult, maxResults);
            setNamedParameters(values, query);
            return query.list();
        }
    });
    traceResults(list);
    return list;
}