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.koylubaevnt.library.db.DataHelper.java

private void runBookListCriteria() {
    Criteria criteria = bookListCriteria.getExecutableCriteria(getSession());
    criteria.addOrder(Order.asc("b.name")).setProjection(bookProjectionList)
            .setResultTransformer(Transformers.aliasToBean(Book.class));
    criteria.setFirstResult(pager.getFrom()).setMaxResults(pager.getTo());
    pager.setList(criteria.list());/*  w  w  w .ja  v  a 2  s. co m*/
}

From source file:com.ksa.myanmarlottery.repository.ResultRepositoryImpl.java

License:Open Source License

@Override
public Result findLatestResultSummary(int type) {
    log.info("findByNumberOfTimes..");
    return (Result) getSession().getNamedQuery("result.findLatestResultSummary").setInteger("type", type)
            .setResultTransformer(Transformers.aliasToBean(Result.class)).uniqueResult();
}

From source file:com.library.Database.DataHelper.java

public List<Book> getAllBooks(int firstNote, int notesNumber) {
    getSession().beginTransaction();//from  w ww .  j a  v a  2  s  .co  m
    totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id")).list()
            .size();
    List<Book> books = getCriteriaWithProjection().setFirstResult(firstNote).setMaxResults(notesNumber)
            .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
    getSession().getTransaction().commit();
    return books;
}

From source file:com.library.Database.DataHelper.java

public List<Book> getBooksByGenre(Long genreId, int firstNote, int notesNumber) {
    getSession().beginTransaction();/*from ww w .j  a va2s. co  m*/
    totalBooksNumber = getSession().createCriteria(Book.class).add(Restrictions.eq("genre.id", genreId))
            .setProjection(Projections.property("id")).list().size();
    List<Book> books = getCriteriaWithProjection().add(Restrictions.eq("genre.id", genreId))
            .setFirstResult(firstNote).setMaxResults(notesNumber)
            .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
    getSession().getTransaction().commit();
    return books;

}

From source file:com.library.Database.DataHelper.java

public List<Book> getBookByAuthor(String authorName, int firstNote, int notesNumber) {
    getSession().beginTransaction();/* ww  w  .j  av  a  2  s . c o m*/
    totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id"))
            .createCriteria("author").add(Restrictions.ilike("fio", authorName, MatchMode.ANYWHERE)).list()
            .size();
    List<Book> books = getCriteriaWithProjection().createCriteria("author")
            .add(Restrictions.ilike("fio", authorName, MatchMode.ANYWHERE)).setFirstResult(firstNote)
            .setMaxResults(notesNumber).setResultTransformer(Transformers.aliasToBean(Book.class)).list();
    getSession().getTransaction().commit();
    return books;
}

From source file:com.library.Database.DataHelper.java

private List<Book> getBookList(String field, String value, MatchMode matchMode, int firstNote,
        int notesNumber) {
    getSession().beginTransaction();/*from   w  ww  .jav a 2 s.  c o  m*/
    totalBooksNumber = getSession().createCriteria(Book.class).setProjection(Projections.property("id"))
            .add(Restrictions.ilike(field, value, matchMode)).list().size();
    List<Book> books = getCriteriaWithProjection().add(Restrictions.ilike(field, value, matchMode))
            .setFirstResult(firstNote).setMaxResults(notesNumber)
            .setResultTransformer(Transformers.aliasToBean(Book.class)).list();
    getSession().getTransaction().commit();
    return books;

}

From source file:com.lighting.platform.base.dao.HibernateDao.java

License:Apache License

public <K> Page<K> findPage(PageConfig pageConfig, SqlEso eso, Class<K> clazz) {
    Page<K> page = new Page<K>(pageConfig);
    Query q = createQuery(eso.getSql(), eso.getParam());
    long totalCount = countHqlResult(eso.getSql(), eso.getParam());
    page.setTotal(totalCount);/*from  w  w  w  .j  a va 2 s.c  o m*/
    setPageParameterToQuery(q, page);
    q.setResultTransformer(Transformers.aliasToBean(clazz));
    List result = q.list();
    page.setRows(result);
    return page;
}

From source file:com.lighting.platform.base.dao.SimpleHibernateDao.java

License:Apache License

/**
 * HQL.//from  www  . jav  a2s . c om
 * @param <X>
 * @param hql 
 * @param clazz ?
 * @param values
 * @return
 */

public <X> List<X> find(final String hql, Class<X> clazz, final Object... values) {
    return createQuery(hql, values).setResultTransformer(Transformers.aliasToBean(clazz)).list();
}

From source file:com.mec.DAO.POF2.GeoDAO.java

public Geoposicion getByCueAnexo(int cue, int anexo) {
    Query query = getSessionPof2().createSQLQuery("exec [mapa].[paEntidadGetByCueAnexo] :CueAnexo");
    //System.out.println("anexo: "+anexo);
    int aux;//from   www. ja  v a  2s  .c o m
    if (String.valueOf(anexo).length() == 1) {
        aux = Integer.parseInt(cue + "0" + anexo);
    } else if (String.valueOf(anexo).length() > 1) {
        aux = Integer.parseInt("" + cue + anexo + "0");
    } else {
        aux = Integer.parseInt(cue + "00");//anexo null
    }
    //System.out.println("CueAnexo: "+aux);
    query.setParameter("CueAnexo", aux);
    query.setResultTransformer(Transformers.aliasToBean(Geoposicion.class));
    List<Geoposicion> g = query.list();
    return (g.isEmpty() ? null : g.get(0));
}

From source file:com.metropolitan.formulasport727.dao.KorpaArtikalDAOImpl.java

@Override
public List<KorpaArtikal> getListaSvihJedinstvenihKorpaArtikalaKorpe(Korpa korpa) {
    return session.createCriteria(KorpaArtikal.class).add(Restrictions.eq("korId", korpa))
            .setProjection(Projections.projectionList().add(Projections.property("id").as("id"))
                    .add(Projections.property("korId").as("korId"))
                    .add(Projections.groupProperty("artId").as("artId")))
            .setResultTransformer(Transformers.aliasToBean(KorpaArtikal.class)).list();
}