Example usage for org.hibernate.query Query setString

Introduction

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

Prototype

@Deprecated
@SuppressWarnings("unchecked")
default Query<R> setString(String name, String val) 

Source Link

Document

Bind a named String-valued parameter.

Usage

From source file:DAO.ArticleDAO.java

@Override
public List<Article> findArticleByDesignation(String designation) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "FROM Article WHERE designation = :designation ";
    Query query = session.createQuery(hql);
    query.setString("designation", designation);

    List<Article> articles = query.getResultList();

    session.close();//w  w  w .  java  2 s  .c  om

    return articles;

}

---

From source file:DAO.ArticleDAO.java

@Override
public List<Article> findArticleBySupplier(String provider) {

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

    String hql = "FROM Article WHERE provider = :provider ";
    Query query = session.createQuery(hql);
    query.setString("provider", provider);

    List<Article> articles = query.getResultList();

    session.close();/*from  w  w  w  . j av a2  s.  com*/

    return articles;

}

---

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();/*w w  w.  j  av a 2s.  c om*/

    return articles;

}

---

From source file:DAO.BonCarburantDAO.java

@Override
public List<BonDeCarburant> findBonCarburantByImmatriculation(String immatriculation) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "FROM BonDeCarburant WHERE car.immatriculation = :immatriculation ";
    Query query = session.createQuery(hql);
    query.setString("immatriculation", immatriculation);

    return query.getResultList();

}

---

From source file:DAO.BonCarburantDAO.java

@Override
public List<BonDeCarburant> findBonCarburantByUseType(String useType) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "FROM BonDeCarburant WHERE useType = :useType ";
    Query query = session.createQuery(hql);
    query.setString("useType", useType);

    return query.getResultList();

}

---

From source file:DAO.BonDeLavageDAO.java

@Override
public List<BonDeLavage> findBonLavageByImmatriculation(String immatriculation) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();

    transaction = session.getTransaction();

    List<BonDeLavage> bonLavages = new ArrayList<>();

    try {//from   www.  j  ava 2s  .c o  m
        String hql = "FROM BonDeLavage WHERE car.immatriculation = :immatriculation";
        Query query = session.createQuery(hql);
        query.setString("immatriculation", immatriculation);
        bonLavages.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return bonLavages;
}

---

From source file:DAO.CarDAO.java

@Override
public List<Car> getCarByCategory(String category) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    List<Car> cars = new ArrayList<>();

    try {/*  w  w  w . ja v  a  2  s. c om*/
        String hql = "FROM Car WHERE category = :category";
        Query query = session.createQuery(hql);
        query.setString("category", category);
        cars.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return cars;

}

---

From source file:DAO.CarDAO.java

@Override
public List<Car> getCarByUtilisation(String utilisation) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    List<Car> cars = new ArrayList<>();

    try {// w ww. j  ava2s .c  o m
        String hql = "FROM Car WHERE utilisation = :utilisation";
        Query query = session.createQuery(hql);
        query.setString("utilisation", utilisation);
        cars.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return cars;
}

---

From source file:DAO.CarDAO.java

@Override
public List<Car> getCarByDepartement(String departement) {

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

    List<Car> cars = new ArrayList<>();

    try {/*from www . j  av a  2  s  .c  om*/
        String hql = "FROM Car WHERE departement.nom = :departement";
        Query query = session.createQuery(hql);
        query.setString("departement", departement);
        cars.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return cars;
}

---

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;/*from  w  w  w . j a v a  2s. 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;

}

---

• «
• 1
• 2
• »