Example usage for org.hibernate Query setBoolean

Introduction

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

Prototype

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

Source Link

Document

Bind a named boolean-valued parameter.

Usage

From source file:com.square.core.dao.implementations.CaisseDaoImplementation.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from ww w. ja v a  2s .  com*/
public List<Caisse> rechercherCaisseParCriteres(DimensionCriteresRechercheCaisseDto criteresRecherche) {
    final StringBuffer requete = new StringBuffer("SELECT c FROM Caisse c ");
    if (criteresRecherche.getIdDepartement() != null) {
        // On n'effectue la jointure que si le critre sur le dpartement est spcifi
        // afin de ne pas retourner plusieurs fois la mme caisse associe  plusieurs dpartements
        requete.append(" LEFT JOIN c.departements d ");
    }
    requete.append(" WHERE 1=1 ");

    // Critre sur l'identifiant
    if (criteresRecherche.getDimensionCriteres() != null) {
        if (criteresRecherche.getDimensionCriteres().getId() != null) {
            requete.append("AND c.id = :id ");
        }
        // Critre sur le libelle
        if (!StringUtils.isBlank(criteresRecherche.getDimensionCriteres().getLibelle())) {
            requete.append("AND (lower(c.nom) like lower(:libelle) ");
            requete.append("OR lower(c.code) like lower(:libelle) ");
            requete.append("OR lower(c.code||'.'||c.centre||'.'||c.nom) like lower(:libelle)) ");
        }
        // Critre sur la visibilit
        if (criteresRecherche.getDimensionCriteres().getVisible() != null) {
            requete.append("AND c.visible = :visible ");
        }
    }
    // Critere sur le rgime
    if (criteresRecherche.getIdRegime() != null) {
        requete.append("AND c.regime.id = :idRegime ");
    }
    // Critere sur le departement
    if (criteresRecherche.getIdDepartement() != null) {
        requete.append("AND d.id = :idDepartement ");
    }
    if (criteresRecherche.getCode() != null) {
        requete.append("AND c.code = :code ");
    }
    if (criteresRecherche.getCentre() != null) {
        requete.append("AND c.centre = :centre ");
    }
    requete.append("ORDER BY c.ordre, c.code, c.centre, c.nom ");

    final Query query = createQuery(requete.toString());
    if (criteresRecherche.getDimensionCriteres() != null) {
        if (criteresRecherche.getDimensionCriteres().getId() != null) {
            query.setLong("id", criteresRecherche.getDimensionCriteres().getId());
        }
        // Critre sur le libelle
        if (criteresRecherche.getDimensionCriteres().getLibelle() != null
                && !criteresRecherche.getDimensionCriteres().getLibelle().equals("")) {
            query.setString("libelle", criteresRecherche.getDimensionCriteres().getLibelle() + "%");
        }
        // Critre sur la visibilit
        if (criteresRecherche.getDimensionCriteres().getVisible() != null) {
            query.setBoolean("visible", criteresRecherche.getDimensionCriteres().getVisible());
        }
        // Maxresults
        if (criteresRecherche.getDimensionCriteres().getMaxResults() != null) {
            query.setFirstResult(0);
            query.setMaxResults(criteresRecherche.getDimensionCriteres().getMaxResults());
        }
    }
    // Critere sur le rgime
    if (criteresRecherche.getIdRegime() != null) {
        query.setLong("idRegime", criteresRecherche.getIdRegime());
    }
    // Critere sur le departement
    if (criteresRecherche.getIdDepartement() != null) {
        query.setLong("idDepartement", criteresRecherche.getIdDepartement());
    }
    if (criteresRecherche.getCode() != null) {
        query.setString("code", criteresRecherche.getCode());
    }
    if (criteresRecherche.getCentre() != null) {
        query.setString("centre", criteresRecherche.getCentre());
    }

    return query.list();
}

---

From source file:de.fhdo.terminologie.helper.HQLParameterHelper.java

License:Apache License

public void applySQLParameter(Query q) {
    Iterator<String> it = parameterMap.keySet().iterator();

    while (it.hasNext()) {
        String key = it.next();/*from  ww w . j a  v a  2 s  .  c  o m*/
        HQLObject obj = parameterMap.get(key);

        String s = "";

        if (obj.obj instanceof String) {
            s = "%" + obj.obj.toString() + "%";
            q.setString("s_" + obj.fieldName, s);
        } else if (obj.obj instanceof java.util.Date) {
            //SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            //s = sdf.format(obj.obj);

            //q.setDate("s_" + obj.fieldName, (java.util.Date)obj.obj);
            q.setTimestamp("s_" + obj.fieldName, (java.util.Date) obj.obj);
            //logger.debug("SDF: " + sdf.format(obj.obj));
        } else if (obj.obj instanceof Boolean) {
            //s = Boolean.parseBoolean(obj.obj.toString()) ? "1" : "0";
            q.setBoolean("s_" + obj.fieldName, (Boolean) obj.obj);
            //logger.debug("Bool: " + s);
        } else if (obj.obj instanceof Integer) {
            //s = ((Integer)obj.obj).toString();
            q.setInteger("s_" + obj.fieldName, (Integer) obj.obj);
        } else if (obj.obj instanceof Long) {
            //s = ((Integer)obj.obj).toString();
            q.setLong("s_" + obj.fieldName, (Long) obj.obj);
        } else {
            s = obj.obj.toString();
            q.setString("s_" + obj.fieldName, s);

            logger.warn("Typ nicht gefunden: " + obj.obj.getClass().getCanonicalName());
        }

    }
}

---

From source file:dtx.oa.rbac.dao.NodeDao.java

@Override
public List<Node> getByStatus(boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();//  www.j  a  v a 2 s.  c  o m
    Query query = session.createQuery("FROM Node node WHERE node.status=:status");
    query.setBoolean("status", status);
    List<Node> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

From source file:dtx.oa.rbac.dao.NodeDao.java

@Override
public List<Node> getChilds(String parentId, boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();/* w  w w  .  ja  v  a 2 s .c om*/
    Query query = session.createQuery("FROM Node node WHERE node.parentId=:parent_id AND status=:status");
    query.setString("parent_id", parentId);
    query.setBoolean("status", status);
    List<Node> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

From source file:dtx.oa.rbac.dao.NodeDao.java

@Override
public List<Node> getChildsByType(String parentId, int nodeType, boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();//from w  w w. ja  v a2  s . c o m
    Query query = session.createQuery(
            "FROM Node node WHERE node.parentId=:parent_id AND node_type=:node_type AND status=:status");
    query.setString("parent_id", parentId);
    query.setInteger("node_type", nodeType);
    query.setBoolean("status", status);
    List<Node> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

From source file:dtx.oa.rbac.dao.NodeDao.java

@Override
public boolean updateStatus(Node node) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();//from   www  .  j  av  a  2  s  .  c o m
    Query query = session.createQuery("UPDATE Node node SET node.status=:status WHERE node.uuid=:id");
    query.setBoolean("status", node.getStatus());
    query.setString("id", node.getUuid());
    int result = query.executeUpdate();
    session.getTransaction().commit();
    return result > 0;
}

---

From source file:dtx.oa.rbac.dao.RoleDao.java

@Override
public List<Role> getByStatus(boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();// w  w w  . j a v a2  s.  c o  m
    Query query = session.createQuery("FROM Role role WHERE role.status=:status");
    query.setBoolean("status", status);
    List<Role> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

From source file:dtx.oa.rbac.dao.RoleDao.java

@Override
public List<Role> getChilds(String parentId, boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();//from   www.  j  a va2 s  .c o  m
    Query query = session.createQuery("FROM Role role WHERE role.parentId=:parent_id and role.status=:status");
    query.setString("parent_id", parentId);
    query.setBoolean("status", status);
    List<Role> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

From source file:dtx.oa.rbac.dao.RoleDao.java

@Override
public boolean updateStatus(Role role) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();//from www.jav  a  2 s .  c om
    Query query = session.createQuery("UPDATE Role role SET role.status=:status WHERE role.uuid=:id");
    query.setBoolean("status", role.getStatus());
    query.setString("id", role.getUuid());
    int result = query.executeUpdate();
    session.getTransaction().commit();
    return result > 0;
}

---

From source file:dtx.oa.rbac.dao.UserDao.java

@Override
public List<User> getUsersByStatus(boolean status) {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();// ww  w .  j  av  a  2s .  c o m
    Query query = session.createQuery("FROM User user WHERE user.status=:status");
    query.setBoolean("status", status);
    List<User> result = query.list();
    session.getTransaction().commit();
    return result;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• »