Discussion :

[SiX-P4cK]

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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

[SiX-P4cK]

Finalement j'ai utilisé EntityQuery
ce qui donne qqch comme ca:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
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));
	}