Example usage for org.hibernate SQLQuery uniqueResult

Introduction

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

Prototype

R uniqueResult();

Source Link

Document

Convenience method to return a single instance that matches the query, or null if the query returns no results.

Usage

From source file:com.viettel.hqmc.DAOHE.FilesNoClobDAOHE.java

/**
 * ho so cho tra//from  ww  w .ja  v  a2 s.c  om
 *
 * @return
 */
public int getCountSelectGiveBackHomePage() {
    try {
        String sql = "select count(f.file_id) from Files f " + "where f.is_active = 1 "
                + "and (f.is_temp is null or f.is_temp = 0) " + "and (f.status = "
                + Constants.FILE_STATUS.GIVE_BACK + ") ";
        SQLQuery countQuery = (SQLQuery) getSession().createSQLQuery(sql);
        int total = Integer.parseInt(countQuery.uniqueResult().toString());
        return total;
    } catch (NumberFormatException | HibernateException ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        return 0;
    }
}

---

From source file:com.wm.framework.sh.dao.impl.BaseDaoImpl.java

License:Open Source License

private void sqlGetTotalCount(String sql, Pagination<?> pagination, Object... params) {
    StringBuilder hqlCount = new StringBuilder("select count(*) from (");
    hqlCount.append(sql).append(") as allData");

    SQLQuery sqlQuery = this.getHibernateTemplate().getSessionFactory().getCurrentSession()
            .createSQLQuery(hqlCount.toString());
    this.queryAttachParams(sqlQuery, params);
    Object ur = sqlQuery.uniqueResult();
    pagination.setTotalCount(Long.parseLong(ur.toString()));
    //      List<?> totals = sqlQuery.list();
    //      if (totals.size() > 0) {
    //         long total = Long.parseLong(totals.get(0).toString());
    //         pagination.setRecordTotal(total);
    //      }/*from   ww  w  . j a va2  s  .c  o  m*/
}

---

From source file:com.yougou.api.service.impl.ApiKeyServiceImpl.java

@Override
public PageFinder<ApiKey> queryApiKey(ApiKeyMetadata apiKeyMetadata, Query query) throws Exception {
    StringBuilder sqlPrefixBuilder = new StringBuilder();
    sqlPrefixBuilder.append(" select ");
    sqlPrefixBuilder.append(/* ww w .  jav a 2  s  . c o  m*/
            " t1.id, t1.app_key as appKey, t1.app_secret as appSecret, t1.status, t1.update_user as updateUser, t1.update_time as updateTime ");
    StringBuilder sqlSuffixBuilder = new StringBuilder();
    sqlSuffixBuilder.append(" from ");
    sqlSuffixBuilder.append(" tbl_merchant_api_key t1 ");
    sqlSuffixBuilder.append(" left join ");
    sqlSuffixBuilder.append(" tbl_merchant_api_key_metadata t2 ");
    sqlSuffixBuilder.append(" on(t1.id = t2.key_id) ");
    sqlSuffixBuilder.append(" left join ");
    sqlSuffixBuilder.append(" ( ");
    sqlSuffixBuilder.append(apiKeyDao.getApiKeyPotentialCustomersSqlStatement());
    sqlSuffixBuilder.append(" ) t3 ");
    sqlSuffixBuilder.append(" on (t2.metadata_val = t3.metadata_val) ");
    sqlSuffixBuilder.append(" where 1 = 1 ");

    // ?
    Map<String, Object> properties = new HashMap<String, Object>();
    if (apiKeyMetadata != null) {
        if (StringUtils.isNotBlank(apiKeyMetadata.getMetadataTag())) {
            sqlSuffixBuilder.append(" and t3.metadata_tag like :metadata_tag");
            properties.put("metadata_tag", '%' + apiKeyMetadata.getMetadataTag() + '%');
        }
        if (apiKeyMetadata.getMetadataKey() != null) {
            sqlSuffixBuilder.append(" and t2.metadata_key = :metadata_key ");
            properties.put("metadata_key", apiKeyMetadata.getMetadataKey().name());
        }
        if (StringUtils.isNotBlank(apiKeyMetadata.getMetadataVal())) {
            sqlSuffixBuilder.append(" and t2.metadata_val = :metadata_val ");
            properties.put("metadata_val", apiKeyMetadata.getMetadataVal());
        }
        if (apiKeyMetadata.getApiKey() != null) {
            if (apiKeyMetadata.getApiKey().getStatus() != null) {
                sqlSuffixBuilder.append(" and t1.status = :status ");
                properties.put("status", apiKeyMetadata.getApiKey().getStatus().ordinal());
            }
        }
    }

    Session session = null;
    PageFinder<ApiKey> pageFinder = null;
    try {
        session = apiKeyDao.getHibernateSession();
        SQLQuery sqlQuery = session.createSQLQuery("select count(1) " + sqlSuffixBuilder.toString());
        sqlQuery.setProperties(properties);
        int rowCount = ((Number) sqlQuery.uniqueResult()).intValue();
        pageFinder = new PageFinder<ApiKey>(query.getPage(), query.getPageSize(), rowCount);
        if (rowCount > 0) {
            // ?
            sqlSuffixBuilder.append(" group by ");
            sqlSuffixBuilder
                    .append(" t1.id, t1.app_key, t1.app_secret, t1.status, t1.update_user, t1.update_time ");
            sqlSuffixBuilder.append(" order by ");
            sqlSuffixBuilder.append(" t1.update_time desc ");
            // ?APP
            sqlQuery = session.createSQLQuery(sqlPrefixBuilder.append(sqlSuffixBuilder).toString());
            sqlQuery.setFirstResult(pageFinder.getStartOfPage());
            sqlQuery.setMaxResults(pageFinder.getPageSize());
            sqlQuery.setProperties(properties);
            sqlQuery.addScalar("id", Hibernate.STRING);
            sqlQuery.addScalar("appKey", Hibernate.STRING);
            sqlQuery.addScalar("appSecret", Hibernate.STRING);
            sqlQuery.addScalar("status", customApiKeyStatus);
            sqlQuery.addScalar("updateTime", Hibernate.STRING);
            sqlQuery.addScalar("updateUser", Hibernate.STRING);
            sqlQuery.setResultTransformer(Transformers.aliasToBean(ApiKey.class));
            List<ApiKey> merchantApiKeys = sqlQuery.list();
            // ?APP?
            sqlPrefixBuilder.setLength(0);
            sqlPrefixBuilder.append(" select ");
            sqlPrefixBuilder.append(
                    " t1.metadata_key as metadataKey, t1.metadata_val as metadataVal, t2.metadata_tag as metadataTag ");
            sqlPrefixBuilder.append(" from ");
            sqlPrefixBuilder.append(" tbl_merchant_api_key_metadata t1 ");
            sqlPrefixBuilder.append(" left join ");
            sqlPrefixBuilder.append(" ( ");
            sqlPrefixBuilder.append(apiKeyDao.getApiKeyPotentialCustomersSqlStatement());
            sqlPrefixBuilder.append(" ) t2 ");
            sqlPrefixBuilder.append(" on(t1.metadata_val = t2.metadata_val) ");
            sqlPrefixBuilder.append(" where ");
            sqlPrefixBuilder.append(" t1.key_id = ? ");
            sqlQuery = session.createSQLQuery(sqlPrefixBuilder.toString());
            sqlQuery.addScalar("metadataKey", customAppType);
            sqlQuery.addScalar("metadataVal", Hibernate.STRING);
            sqlQuery.addScalar("metadataTag", Hibernate.STRING);
            sqlQuery.setResultTransformer(Transformers.aliasToBean(ApiKeyMetadata.class));
            for (ApiKey merchantApiKey : merchantApiKeys) {
                sqlQuery.setParameter(0, merchantApiKey.getId());
                merchantApiKey.setApiKeyMetadatas(new HashSet<ApiKeyMetadata>(sqlQuery.list()));
            }
            pageFinder.setData(merchantApiKeys);
        }
    } finally {
        apiKeyDao.releaseHibernateSession(session);
    }
    return pageFinder;
}

---

From source file:CRUD.CRUD.java

public int query2(VisitaEvento e) {
    Session sessione = factory.openSession();
    Transaction transazione = null;//from w w  w.  ja v  a2 s  .  c om
    SQLQuery query;
    try {
        transazione = sessione.beginTransaction();
        query = sessione.createSQLQuery("SELECT COUNT(*) from BIGLIETTI where visitaE = " + e.getId() + ";");
        transazione.commit();
        return ((Number) query.uniqueResult()).intValue();
    } catch (HibernateException i) {
        if (transazione != null)
            transazione.rollback();
    } finally {
        sessione.close();
    }
    return 0;
}

---

From source file:CRUD.CRUD.java

public double query3(VisitaEvento e) {
    Session sessione = factory.openSession();
    Transaction transazione = null;//from   w w w .  j a  v  a 2s.  c  o  m
    SQLQuery query;
    try {
        transazione = sessione.beginTransaction();
        query = sessione.createSQLQuery(
                "SELECT SUM(tariffa) FROM (SELECT (tariffa-((tariffa*sconto)/100)) AS tariffa FROM (BIGLIETTI  B INNER JOIN VISITE_EVENTO V ON B.visitaE = V.id) INNER JOIN CATEGORIE C ON B.categoria = C.codice WHERE visitaE = "
                        + e.getId() + ")AS tmp;");
        transazione.commit();
        return ((Number) query.uniqueResult()).doubleValue();
    } catch (HibernateException i) {
        if (transazione != null)
            transazione.rollback();
    } finally {
        sessione.close();
    }
    return 0;
}

---

From source file:dao.DrugDao.java

public Integer findWhetherDrugExist(String str) {
    SQLQuery sqlq = null;
    BigInteger aa = null;//w w  w. j  a v a  2 s.  co  m
    try {
        tx = session.beginTransaction();
        sqlq = session.createSQLQuery("SELECT COUNT(1) FROM Drug  WHERE drugNumber=:str");
        sqlq.setString("str", str);
        aa = (BigInteger) sqlq.uniqueResult();
        System.out.println(aa + "aaaaaaaa");
        tx.commit();

    } catch (HibernateException e) {
        tx.rollback();
    }
    return aa.intValue();

}

---

From source file:DAO.ValidatorDAO.java

public String validate(String user, String pass) {
    pass = DigestUtils.sha512Hex(pass);//  www .  j  a  va 2 s  .c  o m
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = sf.openSession();
    SQLQuery sQLQuery = session.createSQLQuery(sqlGeneratorLogin());
    sQLQuery.addEntity(Usuarios.class);
    sQLQuery.setString("user_id", user);
    sQLQuery.setString("pass", pass);
    Usuarios u = (Usuarios) sQLQuery.uniqueResult();
    if (u != null) {
        return u.getUsrToken();
    }
    return "Error";
}

---

From source file:daoImpl.GroupsDAOImpl.java

@Override
public String getSecretKey(String name) {
    Session session = sFac.openSession();
    SQLQuery getKey = session.createSQLQuery("Select key_value from secret_keys where key_name=:name");
    getKey.setParameter("name", name);
    String result = (String) getKey.uniqueResult();
    session.close();/* ww w .jav  a2 s.co m*/
    return result;
}

---

From source file:databaseUtility.Database.java

public Evento getEvento(String id) {
    Session session = factory.openSession();
    Transaction tx = session.beginTransaction();
    SQLQuery query = session.createSQLQuery("SELECT * FROM WA2P_EVENTI WHERE Id= :id").addEntity(Evento.class);
    query.setString("id", id);
    Evento v = (Evento) query.uniqueResult();
    tx.commit();//from w  w w . j av  a2  s  .  c o  m
    session.close();
    return v;
}

---

From source file:databaseUtility.Database.java

public Utente getUtente(String utente) {
    Session session = factory.openSession();
    Transaction tx = session.beginTransaction();
    SQLQuery query = session.createSQLQuery("SELECT * FROM WA2P_UTENTI WHERE nickname= :username")
            .addEntity(Utente.class);
    query.setString("username", utente);
    Utente u = (Utente) query.uniqueResult();
    tx.commit();/*w w  w  . jav  a 2s .c o m*/
    session.close();
    return u;
}

---

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