Example usage for org.hibernate SQLQuery list

Introduction

In this page you can find the example usage for org.hibernate SQLQuery list.

Prototype

List<R> list();

Source Link

Document

Return the query results as a List.

Usage

From source file:com.origen.hibernate.dao.general.DAOGeneral.java

public List<T> listarQueryNativo(String queryNativo) {
    Session session = this.sessionFactory.openSession();
    SQLQuery query = session.createSQLQuery(queryNativo);
    query.addEntity(referenciaEntidad);/*from   w  ww  .  ja  v  a  2s  .c o  m*/
    List<T> results = (List<T>) query.list();

    return results;
}

---

From source file:com.project.dao.Dao.java

@Override
public List<T> getEntitiesByQuery(String query) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();

    try {//  w  ww.j  a v  a  2  s . c  om
        session.getTransaction().begin();
        SQLQuery sql = session.createSQLQuery(query).addEntity(classe.getClass());
        // SQLQuery sql = session.createSQLQuery("select *, lower(convert(`disponibilidadeTrabalho` using utf8)) from tbl_usuario WHERE lower(disponibilidadeTrabalho)  like '%feira%'").addEntity(Usuario.class);

        return sql.list();
    } catch (Exception e) {

        return null;
    } finally {
        session.getTransaction().commit();
        if (session.isOpen()) {
            session.close();
        }
    }
}

---

From source file:com.proper.uip.common.core.dao.HibernateDao.java

License:Apache License

@SuppressWarnings("unchecked")
public <K> Page<K> pageSQLQuery(PageConfig pageConfig, SQLQuery sqlQuery, Object... values) {
    Page<K> page = new Page<K>(pageConfig);
    String totalSql = "select count(*) as total from(" + sqlQuery.getQueryString() + ")";
    Query countQuery = this.getSession().createSQLQuery(totalSql);
    setParams(countQuery, values);//from ww w. jav  a2s.  c om
    Number total = (Number) countQuery.uniqueResult();
    if (total != null) {
        page.setTotal(total.longValue());
        sqlQuery.setFirstResult(page.getOffset()).setMaxResults(page.getPageSize());
        setParams(sqlQuery, values);
        List<K> list = sqlQuery.list();
        page.setRows(list);
    } else {
        page.setTotal(0);
        page.setRows(new ArrayList<K>());
    }
    return page;
}

---

From source file:com.ps.dao.AulaDao.java

@Override
public List<Map<String, ?>> ListarAulaTutor(String idUsuario) {
    List<Map<String, ?>> lista = new ArrayList<>();
    sql = "SELECT * FROM PSV_AULA\n" + "WHERE IDAULA=(SELECT IDAULA \n" + "FROM DET_AULA_USUARIO\n"
            + "WHERE IDUSUARIO='" + idUsuario + "')" + "AND IDROL='RO-201500002'";
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    try {/*  w  w  w.  j  a  v  a 2s.c  o  m*/
        trans = session.beginTransaction();
        SQLQuery result = session.createSQLQuery(sql);
        result.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
        List data = result.list();
        for (Object obj : data) {
            Map<String, Object> a = (Map<String, Object>) obj;
            lista.add(a);
        }
        trans.commit();
    } catch (Exception e) {
        System.out.println("ERROR -----------" + e);
        trans.rollback();
    }

    return lista;
}

---

From source file:com.ps.dao.EventoDao.java

@Override
public List<Map<String, ?>> listarEventos(String idFacultad) {
    List<Map<String, ?>> Lista = new ArrayList<>();
    sql = "SELECT *FROM EVENTO WHERE ROWNUM='1'";
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    try {//from w  w w  .ja  v  a2 s.c o m
        trans = session.beginTransaction();
        SQLQuery result = session.createSQLQuery(sql);
        result.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
        List list = result.list();
        for (Object obj : list) {
            Map<String, Object> a = (Map<String, Object>) obj;
            Lista.add(a);
        }
        trans.commit();
    } catch (Exception e) {
        System.out.println(e);
        return null;
    }
    return Lista;
}

---

From source file:com.ps.dao.UsuarioDao.java

@Override
public List<Map<String, ?>> listaPrivilegios(String idRol) {
    List<Map<String, ?>> Lista = new ArrayList<>();
    sql = "SELECT * FROM PSV_LINKS WHERE IDROL='" + idRol + "'";
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    try {/*  ww  w.  j a v a2 s .  c  o m*/
        trans = session.beginTransaction();
        SQLQuery result = session.createSQLQuery(sql);
        result.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
        List list = result.list();
        for (Object obj : list) {
            Map<String, Object> a = (Map<String, Object>) obj;
            Lista.add(a);
        }
        trans.commit();
    } catch (Exception e) {
        System.out.println(e);
        return null;
    }
    return Lista;
}

---

From source file:com.quix.aia.cn.imo.utilities.ImoUtilityData.java

License:Open Source License

public void insertScript() {

    log.log(Level.SEVERE,//from w  w w .j  a  v a2 s  .co m
            "*************************************************************************************");
    log.log(Level.SEVERE,
            "********************************* REFRESH AAM DATA SCRIPT RUN   *********************");
    log.log(Level.SEVERE,
            "*************************************************************************************");

    Session session = null;
    Transaction tx;
    ArrayList list = null;
    try {

        session = HibernateFactory.openSession();
        tx = session.beginTransaction();
        int count = 0;

        /*   FOR CITY */

        SQLQuery query = session.createSQLQuery(
                "SELECT DISTINCT A.CITYCODE as city,B.BRANCH_CODE as branchcode FROM AGENTER A join T_BRANCH B on A.CO=B.BRANCH_NAME")
                .addScalar("city", new StringType()).addScalar("branchcode", new StringType());
        List<Object[]> entities = query.list();
        for (Object[] obj : entities) {

            Criteria criteria = session.createCriteria(City.class);
            criteria.add(Restrictions.eq("cityName", obj[0] + ""));
            criteria.add(Restrictions.eq("branchCode", Integer.parseInt(obj[1] + "")));

            list = (ArrayList) criteria.list();

            if (list.size() <= 0) {
                City city = new City();
                city.setCityName((String) obj[0]);
                city.setBranchCode(Integer.parseInt(obj[1] + ""));
                city.setCityFullName((String) obj[0]);
                city.setCreatedBy("Admin");
                city.setCreationDate(new Date());
                city.setModifiedBy("Admin");
                city.setModificationDate(new Date());
                city.setOrderCode(0);
                city.setToken("");
                city.setStatus(true);

                session.save(city);
            }

        }
        tx.commit();

        /*   FOR SSC   */

        query = session.createSQLQuery(
                "SELECT DISTINCT A.SSC as ssc,C.CITY_CODE as citycode FROM AGENTER A inner JOIN T_CITY C  ON A.CITYCODE=C.CITY_NAME INNER JOIN T_BRANCH B on A.CO=B.BRANCH_NAME")
                .addScalar("ssc", new StringType()).addScalar("citycode", new StringType());

        List<Object[]> entities2 = query.list();
        for (Object[] obj : entities2) {

            Criteria criteria = session.createCriteria(Ssc.class);
            criteria.add(Restrictions.eq("sscName", obj[0] + ""));
            criteria.add(Restrictions.eq("cityCode", Integer.parseInt(obj[1] + "")));
            list = (ArrayList) criteria.list();

            if (list.size() <= 0) {
                Ssc ssc = new Ssc();
                ssc.setSscName((String) obj[0]);
                ssc.setCityCode(Integer.parseInt(obj[1] + ""));
                ssc.setSscFullName((String) obj[0]);
                ssc.setCreatedBy("Admin");
                ssc.setCreationDate(new Date());
                ssc.setModifiedBy("Admin");
                ssc.setModificationDate(new Date());
                ssc.setOrderCode(0);
                ssc.setToken("");
                ssc.setStatus(true);
                session.save(ssc);

            }

        }
        tx.commit();

        /*  For office    */

        query = session.createSQLQuery(
                "SELECT DISTINCT A.OFFCOD as office,S.SSC_CODE as ssccode  FROM AGENTER A INNER join T_SSC S ON A.SSC=S.SSC_FULLNAME inner JOIN T_CITY C  ON A.CITYCODE=C.CITY_NAME INNER JOIN T_BRANCH B on A.CO=B.BRANCH_NAME")
                .addScalar("office", new StringType()).addScalar("ssccode", new StringType());

        List<Object[]> entities3 = query.list();
        for (Object[] obj : entities3) {

            Criteria criteria = session.createCriteria(Office.class);
            criteria.add(Restrictions.eq("officeName", obj[0] + ""));
            criteria.add(Restrictions.eq("sscCode", Integer.parseInt(obj[1] + "")));
            list = (ArrayList) criteria.list();
            if (list.size() <= 0) {
                Office office = new Office();
                office.setOfficeName((String) obj[0]);
                office.setSscCode(Integer.parseInt(obj[1] + ""));
                office.setOfficeFullName((String) obj[0]);
                office.setCreatedBy("Admin");
                office.setCreationDate(new Date());
                office.setModifiedBy("Admin");
                office.setModificationDate(new Date());
                office.setOrderCode(0);
                office.setToken("");
                office.setStatus(true);

                session.save(office);
            }
        }
        tx.commit();

    } catch (Exception e) {
        log.log(Level.SEVERE, e.getMessage());
        e.printStackTrace();
        LogsMaintenance logsMain = new LogsMaintenance();
        StringWriter errors = new StringWriter();
        e.printStackTrace(new PrintWriter(errors));
        logsMain.insertLogs("IMOUtilityData", Level.SEVERE + "", errors.toString());
    } finally {
        try {
            HibernateFactory.close(session);

        } catch (Exception e) {
            log.log(Level.SEVERE, e.getMessage());
            e.printStackTrace();
        }
    }

    log.log(Level.SEVERE,
            "*************************************************************************************");
    log.log(Level.SEVERE,
            "********************************* REFRESH AAM DATA SCRIPT FINISHED    *********************");
    log.log(Level.SEVERE,
            "*************************************************************************************");

}

---

From source file:com.redprairie.moca.job.dao.hibernate.TU_JobDefinitionHibernateDAO.java

License:Open Source License

/**
 * This test is here to confirm that since job_definition can be a 
 * nvarchar that we are able to do a select for it using sql query.
 */// w w w  .  ja va  2s .  c  o m
@Test
public void testIsEntryAvailableHibernate() {
    Session hibernateSession = HibernateTools.getSession();

    SQLQuery query = hibernateSession
            .createSQLQuery("select job_id from job_definition" + "  where job_id = ?");

    query.setString(0, "NOT-PRESENT");

    Assert.assertTrue("There shouldn't be a NOT-PRESENT job in the db.", query.list().isEmpty());
}

---

From source file:com.redprairie.moca.task.dao.hibernate.TU_TaskDefinitionHibernateDAO.java

License:Open Source License

/**
 * This test is here to confirm that since task_definition can be a 
 * nvarchar that we are able to do a select for it using sql query.
 *//*from  ww  w. ja va  2  s.co  m*/
@Test
public void testIsEntryAvailableHibernate() {
    Session hibernateSession = HibernateTools.getSession();

    SQLQuery query = hibernateSession
            .createSQLQuery("select task_id from task_definition" + "  where task_id = ?");

    query.setString(0, "NOT-PRESENT");

    Assert.assertTrue("There shouldn't be a NOT-PRESENT task in the db.", query.list().isEmpty());
}

---

From source file:com.salesapp.logic.controller.ModuleQueryController.java

public static List findData(String queryHQL) {
    SessionApp.connect();/*ww w. ja  v  a2 s  .c o m*/
    Session session = SessionApp.getSession();
    SQLQuery query = session.createSQLQuery(queryHQL);
    query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
    //query.addEntity(String.class);
    List list = query.list();

    //query.addEntity(Branch.class);
    return list;
}

---

• «
• 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
• »