Example usage for org.hibernate Session createSQLQuery

Introduction

In this page you can find the example usage for org.hibernate Session createSQLQuery.

Prototype

@Override
    NativeQuery createSQLQuery(String queryString);

Source Link

Usage

From source file:br.com.proj.tasker.dao.impl.AtivacaoDAO.java

@Override
public int getFromChave(String chave) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    int id = (int) session.createSQLQuery("Select user_id from Ativacao where chave = :chave")
            .setParameter("chave", chave).uniqueResult();
    session.close();/* ww  w  . ja  v a2s  . c o m*/
    return id;
}

From source file:br.com.proj.tasker.dao.impl.AtivMembrosDAO.java

@Override
public Integer buscaAut(Integer idGru, Integer idPes) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Query query = session.createSQLQuery(
            "Select id_perfil From ativmembros WHERE id_membro = :idpes AND id_grupo = :idgrupo");
    query.setParameter("idpes", idPes);
    query.setParameter("idgrupo", idGru);
    Integer aut = (Integer) query.uniqueResult();
    session.close();//  w  w  w.  j  a  va 2  s.  c o  m
    return aut;
}

From source file:br.com.proj.tasker.dao.impl.AtivMembrosDAO.java

@Override
public Integer buscaCargo(Integer idGru, Integer idPes) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Query query = session.createSQLQuery(
            "Select id_cargo From ativmembros WHERE id_membro = :idpes AND id_grupo = :idgrupo");
    query.setParameter("idpes", idPes);
    query.setParameter("idgrupo", idGru);
    Integer cargo = (Integer) query.uniqueResult();
    if (cargo == null) {
        cargo = 0;//w  w w.  j  av  a2 s .  co  m
    }
    session.close();
    return cargo;
}

From source file:br.com.proj.tasker.dao.impl.GrupoDAO.java

@Override
public Integer getGrupoProjs(Integer id) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Integer cont = ((BigInteger) session
            .createSQLQuery(//from   w w w .j  a  v  a  2s.  c o  m
                    "SELECT count(ativo) from projeto WHERE projeto.id_grupo = :id AND projeto.ativo = TRUE")
            .setParameter("id", id).uniqueResult()).intValue();
    session.close();
    return cont;
}

From source file:br.com.proj.tasker.dao.impl.ProjetoDAO.java

@Override
public Integer getProjTars(Integer id) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    int cont = ((BigInteger) session.createSQLQuery(
            "SELECT count(status) from tarefa WHERE tarefa.id_proj = :id AND (tarefa.status = 'Pendente' OR tarefa.status = 'Em Andamento')")
            .setParameter("id", id).uniqueResult()).intValue();
    session.close();//from   w  w w  .  j  av  a 2s  .  c o  m
    return cont;
}

From source file:br.com.rhmanager.daoImpl.HibernateDAO.java

public Timestamp getHoraServer() {
    Session session = null;
    try {/*from   w  w w  .j  a  v a2 s .  c  o m*/
        session = HibernateUtil.getSession();
        session.beginTransaction();
        SQLQuery query = session.createSQLQuery("SELECT NOW()");
        Timestamp time = (Timestamp) query.uniqueResult();
        return time;
    } catch (HibernateException e) {
        e.printStackTrace();
        return null;
    } finally {
        session.close();
    }

}

From source file:br.com.utfpr.edu.br.agenda.Tarefa.AtivaEnvioEmail.java

@Override
public void execute() {
    Session sessao = this.factory.openSession();
    List<Object> qr = null;
    try {/*ww w .j a va 2 s .  c  om*/
        qr = sessao.createSQLQuery(
                "SELECT DISTINCT u.email FROM usuario u WHERE id in (SELECT v.dono FROM item i JOIN veiculo v WHERE v.id=i.carro AND ((v.km=i.proxmanut AND i.undmedida='Km')OR(v.ano=i.proxmanut AND i.undmedida='Ano')))")
                .list();
        sessao.beginTransaction().commit();
    } catch (HibernateException e) {
        System.out.println("Erro ao buscar usurios:");
        System.out.println(e.getCause());
    } finally {
        System.out.println("Fechando sesso de envio de email!");
        sessao.close();
    }
    if (qr != null) {
        this.servico.enviar("Agenda Motors - Aviso de Manuteno",
                "Constatamos que voc possui veculos com itens a serem mantidos. Verifique sua Agenda no Agenda Motors.",
                qr);
    }
}

From source file:br.sp.unifae.cris.comp7.model.dao.DAOEntradaProduto.java

public List listar(int entradaId) {
    Session session = DAOHibernateUtil.getSession();
    List listaEntradas = null;//w w  w  .  j ava2  s.  c o m
    try {
        session.beginTransaction();
        listaEntradas = session.createSQLQuery("Select * From EntradaProduto Where id_entrada = " + entradaId)
                .list();
    } catch (Exception ex) {
        JOptionPane.showMessageDialog(null, ex);
    } finally {
        session.close();
        return listaEntradas;
    }
}

From source file:br.sp.unifae.cris.comp7.model.dao.DAOGenerica.java

public List listar(String pesquisa) {
    Session session = DAOHibernateUtil.getSession();
    List lista = null;//from w  ww .j  av a 2 s  . c  o m
    try {
        session.beginTransaction();
        lista = session.createSQLQuery(pesquisa).list();
    } catch (Exception ex) {
        JOptionPane.showMessageDialog(null, ex);
    } finally {
        session.close();
        return lista;
    }
}

From source file:ca.myewb.frame.servlet.AjaxServlet.java

License:Open Source License

private void autocomplete(HttpServletRequest request, HttpSession httpSession, Session session,
        UserModel currentUser, Context ctx, Logger log) {
    String linktable = request.getParameter("area").equals("events") ? "tags2events" : "tags2posts";
    String input = request.getParameter("q").replace("'", "");
    String sql = "select t.uniquename from tags t, " + linktable + " x " + "where t.uniquename like '%" + input
            + "%' and t.id=x.tagid " + "group by t.uniquename "
            + "order by count(*) desc, t.uniquename limit 10";
    ctx.put("tags", session.createSQLQuery(sql).list());
}