Example usage for org.hibernate SQLQuery addEntity

Introduction

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

Prototype

SQLQuery<T> addEntity(Class entityType);

Source Link

Document

Declare a "root" entity, without specifying an alias.

Usage

From source file:vn.webapp.dao.SpecializationKeywordDAOImpl.java

@Override
public List<SpecializationKeyword> loadStaffSpecializationKeywordList(String staffCode) {
    try {/*from www . j  a  va2  s .  c  om*/
        begin();
        SQLQuery q = getSession().createSQLQuery(
                "SELECT DISTINCT KW_ID,KW_Code,KW_EngName,KW_VNName,KW_ScientificFieldCode FROM `tblspecializationkeywords` AS t1 JOIN (SELECT * FROM `tblstaffspecializationkeywords` WHERE STFKW_StaffCode = '"
                        + staffCode + "') AS t2 ON t1.KW_Code = t2.STFKW_KeywordCode");
        q.addEntity(SpecializationKeyword.class);
        commit();
        return q.list();
    } catch (HibernateException e) {
        e.printStackTrace();
        rollback();
        close();
        return null;
    } finally {
        flush();
        close();
    }
}

From source file:vn.webapp.modules.mastermanagement.dao.mmSpecializationKeywordDAOImpl.java

@Override
public List<mmSpecializationKeyword> loadStaffSpecializationKeywordList(String staffCode) {
    try {/*  w w  w . java2s  . c  o m*/
        begin();
        SQLQuery q = getSession().createSQLQuery(
                "SELECT DISTINCT KW_ID,KW_Code,KW_EngName,KW_VNName,KW_ScientificFieldCode FROM `tblspecializationkeywords` AS t1 JOIN (SELECT * FROM `tblstaffspecializationkeywords` WHERE STFKW_StaffCode = '"
                        + staffCode + "') AS t2 ON t1.KW_Code = t2.STFKW_KeywordCode");
        q.addEntity(mmSpecializationKeyword.class);
        commit();
        return q.list();
    } catch (HibernateException e) {
        e.printStackTrace();
        rollback();
        close();
        return null;
    } finally {
        flush();
        close();
    }
}

From source file:vn.webapp.modules.mastermanagement.dao.mmSpecializationKeywordDAOImpl.java

@Override
public List<mmSpecializationKeyword> loadMasterThesisSpecializationKeywordList(String thesisCode) {
    try {/*from w w w  .  j  a va2  s . c o  m*/
        begin();
        SQLQuery q = getSession().createSQLQuery(
                "SELECT DISTINCT KW_ID,KW_Code,KW_EngName,KW_VNName,KW_ScientificFieldCode FROM `tblspecializationkeywords` AS t1 JOIN (SELECT * FROM `tblmasterthesisspecializationkeywords` WHERE MTKW_ThesisCode = '"
                        + thesisCode + "') AS t2 ON t1.KW_Code = t2.MTKW_KWCode");
        q.addEntity(mmSpecializationKeyword.class);
        commit();
        return q.list();
    } catch (HibernateException e) {
        e.printStackTrace();
        rollback();
        close();
        return null;
    } finally {
        flush();
        close();
    }
}