Example usage for org.hibernate.query Query getSingleResult

Introduction

In this page you can find the example usage for org.hibernate.query Query getSingleResult.

Prototype

default R getSingleResult() 

Source Link

Usage

From source file:com.imos.sample.database.repository.HibernateRepository.java

public List<O> executeQuery(String queryStr, Class<O> cls, boolean uniqueResult) throws RepositoryException {
    List<O> result = new ArrayList<>();
    try {//from  w w w  .j  a v  a 2s .com
        open();
        session.getTransaction().begin();
        Query<O> query = session.createQuery(queryStr, cls);
        if (uniqueResult) {
            result.add(query.getSingleResult());
        } else {
            result = query.getResultList();
        }
        session.getTransaction().commit();
        log.info("Hibernate database event {} succeed", EventType.JPA_QUERY.name());
    } catch (Exception e) {
        log.info("Hibernate database event {} failed", EventType.JPA_QUERY.name());
        session.getTransaction().rollback();
        throw new RepositoryException(e);
    } finally {
        close();
    }
    return result;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

@Override
public ManageNumber getNumber(String number, String username) throws Exception {
    Session session = getSession();//from w  w w.  j  ava  2 s . c  om
    ManageNumber userNumber = null;

    try {
        StringBuilder hqlQueryBuilder = new StringBuilder();
        hqlQueryBuilder.append("from ManageNumber where Number = :number ");
        hqlQueryBuilder.append(" and user.userName=:userName");

        Query query = session.createQuery(hqlQueryBuilder.toString());

        query.setParameter("number", number);
        query.setParameter("userName", username);

        userNumber = (ManageNumber) query.getSingleResult();

    } catch (NoResultException e) {
        return null;
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getNumber", ex);
        throw ex;
    }

    return userNumber;

}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

@Override
public ProvisionAllService getProvisionService(String serviceCode, String ServiceName, User user)
        throws Exception {
    Session session = getSession();//from   w  w  w.  ja  v  a2  s .  c  o  m
    ProvisionAllService provisionService = null;
    Map<String, String> parameterMap = new HashMap<>();

    try {
        StringBuilder hqlQueryBuilder = new StringBuilder();
        hqlQueryBuilder.append("from ProvisionAllService service where ");
        hqlQueryBuilder.append(" service.user = :user");
        hqlQueryBuilder.append(" and ");

        if (serviceCode != null) {
            hqlQueryBuilder.append("lower(service.serviceCode) = :serviceCode");
            parameterMap.put("serviceCode", serviceCode.toLowerCase());
        }

        if (serviceCode != null && ServiceName != null) {
            hqlQueryBuilder.append(" and");
            hqlQueryBuilder.append(" lower(service.serviceName) = :serviceName");
            parameterMap.put("serviceName", ServiceName.toLowerCase());
        } else if (ServiceName != null) {
            hqlQueryBuilder.append(" lower(service.serviceName) = :serviceName");
            parameterMap.put("serviceName", ServiceName.toLowerCase());
        }

        Query query = session.createQuery(hqlQueryBuilder.toString());

        Set<Entry<String, String>> entrySet = parameterMap.entrySet();

        for (Entry<String, String> entry : entrySet) {
            query.setParameter(entry.getKey(), entry.getValue());
        }

        query.setParameter("user", user);

        provisionService = (ProvisionAllService) query.getSingleResult();
    } catch (NoResultException e) {
        return null;
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getProvisionService", ex);
        throw ex;
    }

    return provisionService;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

@Override
public ProvisionedServices getAlreadyProvisionedService(User user, List<String> statusCodes,
        ProvisionAllService provisionService, String phoneNumber) throws Exception {
    Session session = getSession();/*from ww w.  j  a  v  a  2s  . c om*/
    ProvisionedServices provisionedService = null;

    try {
        StringBuilder hqlQueryBuilder = new StringBuilder();
        hqlQueryBuilder.append("select provisionedService ");
        hqlQueryBuilder.append(" from ProvisionedServices provisionedService,");
        hqlQueryBuilder.append(" Status status,");
        hqlQueryBuilder.append(" ProvisionMSISDNServicesMap map,");
        hqlQueryBuilder.append(" ManageNumber AS number,");
        hqlQueryBuilder.append(" ProvisionAllService provisionServices,");
        hqlQueryBuilder.append(" User user ");
        hqlQueryBuilder.append(" where ");
        hqlQueryBuilder.append(" provisionedService.status.id = status.id");
        hqlQueryBuilder.append(" AND provisionedService.msisdnServiceMap.id = map.id");
        hqlQueryBuilder.append(" AND map.msisdnId.id = number.id");
        hqlQueryBuilder.append(" AND map.servicesId.id = provisionServices.id");
        hqlQueryBuilder.append(" AND number.user.id = user.id");
        hqlQueryBuilder.append(" AND number.user = :spUser");
        hqlQueryBuilder.append(" AND status.code in (:statusCodeList)");
        hqlQueryBuilder.append(" AND number.Number = :phoneNumber");
        hqlQueryBuilder.append(" AND provisionServices.id = :provisionServiceId");

        Query query = session.createQuery(hqlQueryBuilder.toString());

        query.setParameter("spUser", user);
        query.setParameterList("statusCodeList", statusCodes);
        query.setParameter("phoneNumber", phoneNumber);
        query.setParameter("provisionServiceId", provisionService.getId());

        provisionedService = (ProvisionedServices) query.getSingleResult();
    } catch (NoResultException e) {
        return null;
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getAlreadyProvisionedService", ex);
        throw ex;
    }

    return provisionedService;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

public Status getStatusFromStatusCode(ProvisioningStatusCodes statusCode) throws Exception {
    Session session = getSession();// w  w w .ja va2  s.  co  m
    Status status = null;

    try {
        StringBuilder hqlQueryBuilder = new StringBuilder();
        hqlQueryBuilder.append("from Status where code = :statusCode");

        Query query = session.createQuery(hqlQueryBuilder.toString());
        query.setParameter("statusCode", statusCode.toString());

        status = (Status) query.getSingleResult();
    } catch (NoResultException e) {
        return null;
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getStatusFromStatusCode", ex);
        throw ex;
    }

    return status;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

@Override
public ProvisionMSISDNServicesMap getProvisionMsisdnService(ManageNumber number, ProvisionAllService service)
        throws Exception {
    Session session = getSession();/*  w w w  . j av  a2  s.  c  om*/
    ProvisionMSISDNServicesMap serviceMapEntry = null;

    try {
        StringBuilder hqlQueryBuilder = new StringBuilder();

        hqlQueryBuilder.append("from ProvisionMSISDNServicesMap serviceMap");
        hqlQueryBuilder.append(" where ");
        hqlQueryBuilder.append(" serviceMap.msisdnId = :number ");
        hqlQueryBuilder.append(" and serviceMap.servicesId = :service ");
        hqlQueryBuilder.append(" and serviceMap.msisdnId.status = '1'");

        Query query = session.createQuery(hqlQueryBuilder.toString());

        query.setParameter("number", number);
        query.setParameter("service", service);

        serviceMapEntry = (ProvisionMSISDNServicesMap) query.getSingleResult();

    } catch (NoResultException e) {
        return null;
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getProvisionMsisdnService", ex);
        throw ex;
    }

    return serviceMapEntry;
}

---

From source file:DAO.ArticleDAO.java

@Override
public Long sumArticlesByCar(Car car) {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "SELECT COUNT(*) FROM Article AS a JOIN a.fixings AS f WHERE f.car.immatriculation =:immat";
    Query query = session.createQuery(hql);
    query.setString("immat", car.getImmatriculation());

    Long articles = (Long) query.getSingleResult();

    session.close();/*  ww w  .j  a v a2  s . c o  m*/

    return articles;

}

---

From source file:DAO.CarDAO.java

@Override
public Long findBonneCarCount() {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    HashMap<String, Integer> stats = new HashMap<>();

    Long bonneNumber;//w  w  w .j  a  va2  s .  com
    try {

        String hql = "SELECT COUNT(*) FROM Car WHERE etat =:Bonne";
        Query query = session.createQuery(hql);
        query.setString("Bonne", "Bonne");
        bonneNumber = (Long) query.getSingleResult();

    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return bonneNumber;

}

---

From source file:DAO.CarDAO.java

@Override
public Long findMoyenneCarCount() {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    HashMap<String, Integer> stats = new HashMap<>();

    Long bonneNumber;/*from   w w  w  .  j  ava 2 s.  c o  m*/
    try {

        String hql = "SELECT COUNT(*) FROM Car WHERE etat =:Moyenne";
        Query query = session.createQuery(hql);
        query.setString("Moyenne", "Moyenne");
        bonneNumber = (Long) query.getSingleResult();

    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return bonneNumber;
}

---

From source file:DAO.CarDAO.java

@Override
public Long findMauvaiseCarCount() {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    HashMap<String, Integer> stats = new HashMap<>();

    Long bonneNumber;// w  w w  .  j a v  a  2  s  .co m
    try {

        String hql = "SELECT COUNT(*) FROM Car WHERE etat =:Mauvaise";
        Query query = session.createQuery(hql);
        query.setString("Mauvaise", "Mauvaise");
        bonneNumber = (Long) query.getSingleResult();

    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return bonneNumber;

}

---

• «
• 1
• 2
• »