Condition d'une requete dynamique

Salut.

Je genere une requete EBJQL dynamiquement pour les conditions mais c'est un peu lourd.

Il n'existe pas une autre facon plus classe?

Un exemple:

Code:

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
32
33
 
	public List<Project> getDataGridProject() {
		String SQLCondition = "";
		if (selectedInstitution != null)
			SQLCondition = " WHERE institution=:institution";
 
		if (selectedArs != null)
			if (SQLCondition.equals(""))
				SQLCondition = " WHERE institution.ars=:ars";
			else
				SQLCondition += " AND institution.ars=:ars";
 
		if (selectedPlan != null)
			if (SQLCondition.equals(""))
				SQLCondition = " WHERE plan=:plan";
			else
				SQLCondition += " AND plan=:plan";
 
		List<Project> listProject = new ArrayList<Project>();
		String sql = "SELECT p FROM Project p" + SQLCondition;
		System.out.println("sql: " + sql);
		Query q = entityManager.createQuery(sql);
 
		if (selectedInstitution != null)
			q.setParameter("institution", selectedInstitution);
		if (selectedPlan != null)
			q.setParameter("plan", selectedPlan);
		if (selectedArs != null)
			q.setParameter("ars", selectedArs);
 
		listProject = q.getResultList();
		return listProject;
	}

merci

public class ProjectQueryBean extends EntityQuery<Project> { private static final long serialVersionUID = 4351918511208372535L; private static final String[] RESTRICTIONS = { "p.plan.id = #{searchAction.selectedPlan.id}", "p.institution.id = #{searchAction.selectedInstitution.id}", "p.institution.ars.id = #{searchAction.selectedArs.id}", }; private Integer pageSize = 20; private Integer firstResult = 0; public ProjectQueryBean() { setEjbql("select p from Project p"); setMaxResults(pageSize); setFirstResult(firstResult); getOrderKeyFieldMap().put("id", "p.id"); getOrderKeyFieldMap().put("code", "p.code"); getOrderKeyFieldMap().put("shortDescription", "p.shortDescription"); getOrderKeyFieldMap().put("ars", "p.institution.ars.name"); getOrderKeyFieldMap().put("institution", "p.institution.name"); getOrderKeyFieldMap().put("plan", "p.plan.name"); setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS)); }