Affecter la somme d'une colonne dans une liste

**zikyoubi** · 17/04/2018, 00h56

Bonjour, j'ai un petit souci que je n'arrive pas à corriger, je travaille avec Hibernate, JSF et prime faces, je souhaite, dans ma requête afficher les différentes saisons et la somme d'attributions de chacune de ces saisons comme montrer ci-dessous (Phpmyadmin) :

Nom : szas.PNG
Affichages : 261
Taille : 21,5 Ko

Nom : szas.PNG
Affichages : 261
Taille : 21,5 Ko

Par la suite , j'affecte cette requête au niveau de mon managedBean pour créer un BarChart avec Primefaces , du coup quand je fait une requete du genre :

Code :

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

session.createQuery("select p from Prelevement_saisons p").list();

je n'ai pas de problème les saisons s'affichent correctement puisque je n'utilise pas les SUM , AVG ...

je vous met le code source de chaqu'unes de mes classes :

PrelevementDAOImpl.java

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
package com.sybaway.gestionprojet.dao;
*
import java.util.List;
*
import org.hibernate.Session;
*
import com.sybaway.gestionprojet.dao.entity.Prelevement_saisons;
import com.sybaway.gestionprojet.util.HibernateUtil;
*
public class PrelevementDAOImpl implements PrelevementDAO{
*
****Session session = HibernateUtil.openSession();
*****
*****
****@Override
****public List<Prelevement_saisons> findAllPrelevement() {
*********
********return session.createQuery("select p from Prelevement_saisons p").list();
****}
*
*****
*
****@Override
****public List<Prelevement_saisons> attributionsBarChart() {
*********
********return* session.createQuery("SELECT a.saison,sum(a.attributions) FROM Prelevement_saisons a GROUP BY a.saison").list();
****}
*
}

ChartView.java (ManagedBean) :

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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
package com.sybaway.gestionprojet.presentation;
*
import javax.annotation.PostConstruct;
import java.io.Serializable;
import java.util.List;
*
import javax.faces.bean.ManagedBean;
*
*
import org.primefaces.model.chart.Axis;
import org.primefaces.model.chart.AxisType;
import org.primefaces.model.chart.BarChartModel;
import org.primefaces.model.chart.HorizontalBarChartModel;
*
import com.sybaway.gestionprojet.dao.entity.Prelevement_saisons;
import com.sybaway.gestionprojet.service.PrelevementServices;
import com.sybaway.gestionprojet.service.PrelevementServicesImpl;
*
import org.primefaces.model.chart.ChartSeries;
**
@ManagedBean
public class ChartView implements Serializable {
**
****/**
******
******/
****private static final long serialVersionUID = 1L;
*****
****private BarChartModel barModel;
****private HorizontalBarChartModel horizontalBarModel;
*****
****private PrelevementServices prelevServ = new PrelevementServicesImpl();
**
****@PostConstruct
****public void init() {
********createBarModels();
****}
**
****public BarChartModel getBarModel() {
********return barModel;
****}
******
****public HorizontalBarChartModel getHorizontalBarModel() {
********return horizontalBarModel;
****}
**
****
*****
****private BarChartModel initBarModel() {
*********
*
********BarChartModel model = new BarChartModel();
**
********ChartSeries boys = new ChartSeries();
*********
********boys.setLabel("Attributions");
*********
********List<Prelevement_saisons> listParcourir = prelevServ.attributionsBarChart();
*********
*
************for (Prelevement_saisons prelevement_saisons : listParcourir) {
*****************
****************boys.set(prelevement_saisons.getSaison(),prelevement_saisons.getAttributions());
*****************
****************System.out.println(prelevement_saisons.getSaison()+"et "+prelevement_saisons.getAttributions());
*****************
************}
*********
*model.addSeries(boys);
*
*return model;
****}
}

L'erreur :

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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
avr. 17, 2018 12:43:51 AM com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
 
GRAVE: Error Rendering View[/index.xhtml]
 
com.sun.faces.mgbean.ManagedBeanCreationException: Erreur lors de l’injection de ressources dans le bean géré «chartView»
 
at com.sun.faces.mgbean.BeanBuilder.invokePostConstruct(Unknown Source)
 
at com.sun.faces.mgbean.BeanBuilder.build(Unknown Source)
 
at com.sun.faces.mgbean.BeanManager.createAndPush(Unknown Source)
 
at com.sun.faces.mgbean.BeanManager.create(Unknown Source)
 
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(Unknown Source)
 
at com.sun.faces.el.ManagedBeanELResolver.getValue(Unknown Source)
 
at com.sun.faces.el.DemuxCompositeELResolver._getValue(Unknown Source)
 
at com.sun.faces.el.DemuxCompositeELResolver.getValue(Unknown Source)
 
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:94)
 
at org.apache.el.parser.AstValue.getValue(AstValue.java:137)
 
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:184)
 
at com.sun.faces.facelets.el.TagValueExpression.getValue(Unknown Source)
 
at javax.faces.component.ComponentStateHelper.eval(Unknown Source)
 
at org.primefaces.component.chart.Chart.getModel(Chart.java:104)
 
at org.primefaces.component.chart.renderer.BarRenderer.encodeData(BarRenderer.java:33)
 
at org.primefaces.component.chart.renderer.BasePlotRenderer.render(BasePlotRenderer.java:29)
 
at org.primefaces.component.chart.ChartRenderer.encodeScript(ChartRenderer.java:98)
 
at org.primefaces.component.chart.ChartRenderer.encodeEnd(ChartRenderer.java:67)
 
at javax.faces.component.UIComponentBase.encodeEnd(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(Unknown Source)
 
at com.sun.faces.application.view.MultiViewHandler.renderView(Unknown Source)
 
at com.sun.faces.lifecycle.RenderResponsePhase.execute(Unknown Source)
 
at com.sun.faces.lifecycle.Phase.doPhase(Unknown Source)
 
at com.sun.faces.lifecycle.LifecycleImpl.render(Unknown Source)
 
at javax.faces.webapp.FacesServlet.service(Unknown Source)
 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
 
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:417)
 
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
 
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
 
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 
at java.lang.Thread.run(Unknown Source)
 
Caused by: com.sun.faces.spi.InjectionProviderException
 
at com.sun.faces.vendor.WebContainerInjectionProvider.invokeAnnotatedMethod(Unknown Source)
 
at com.sun.faces.vendor.WebContainerInjectionProvider.invokePostConstruct(Unknown Source)
 
... 50 more
 
Caused by: java.lang.reflect.InvocationTargetException
 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 
at java.lang.reflect.Method.invoke(Unknown Source)
 
... 52 more
 
Caused by: java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.sybaway.gestionprojet.dao.entity.Prelevement_saisons
 
at com.sybaway.gestionprojet.presentation.ChartView.initBarModel(ChartView.java:61)
 
at com.sybaway.gestionprojet.presentation.ChartView.createBarModel(ChartView.java:91)
 
at com.sybaway.gestionprojet.presentation.ChartView.createBarModels(ChartView.java:86)
 
at com.sybaway.gestionprojet.presentation.ChartView.init(ChartView.java:36)
 
... 56 more
 
avr. 17, 2018 12:43:51 AM org.apache.catalina.core.StandardWrapperValve invoke
 
GRAVE: Servlet.service() for servlet [Faces Servlet] in context with path [/FRC] threw exception [Erreur lors de l’injection de ressources dans le bean géré «chartView»] with root cause
 
java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.sybaway.gestionprojet.dao.entity.Prelevement_saisons
 
at com.sybaway.gestionprojet.presentation.ChartView.initBarModel(ChartView.java:61)
 
at com.sybaway.gestionprojet.presentation.ChartView.createBarModel(ChartView.java:91)
 
at com.sybaway.gestionprojet.presentation.ChartView.createBarModels(ChartView.java:86)
 
at com.sybaway.gestionprojet.presentation.ChartView.init(ChartView.java:36)
 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 
at java.lang.reflect.Method.invoke(Unknown Source)
 
at com.sun.faces.vendor.WebContainerInjectionProvider.invokeAnnotatedMethod(Unknown Source)
 
at com.sun.faces.vendor.WebContainerInjectionProvider.invokePostConstruct(Unknown Source)
 
at com.sun.faces.mgbean.BeanBuilder.invokePostConstruct(Unknown Source)
 
at com.sun.faces.mgbean.BeanBuilder.build(Unknown Source)
 
at com.sun.faces.mgbean.BeanManager.createAndPush(Unknown Source)
 
at com.sun.faces.mgbean.BeanManager.create(Unknown Source)
 
at com.sun.faces.el.ManagedBeanELResolver.resolveBean(Unknown Source)
 
at com.sun.faces.el.ManagedBeanELResolver.getValue(Unknown Source)
 
at com.sun.faces.el.DemuxCompositeELResolver._getValue(Unknown Source)
 
at com.sun.faces.el.DemuxCompositeELResolver.getValue(Unknown Source)
 
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:94)
 
at org.apache.el.parser.AstValue.getValue(AstValue.java:137)
 
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:184)
 
at com.sun.faces.facelets.el.TagValueExpression.getValue(Unknown Source)
 
at javax.faces.component.ComponentStateHelper.eval(Unknown Source)
 
at org.primefaces.component.chart.Chart.getModel(Chart.java:104)
 
at org.primefaces.component.chart.renderer.BarRenderer.encodeData(BarRenderer.java:33)
 
at org.primefaces.component.chart.renderer.BasePlotRenderer.render(BasePlotRenderer.java:29)
 
at org.primefaces.component.chart.ChartRenderer.encodeScript(ChartRenderer.java:98)
 
at org.primefaces.component.chart.ChartRenderer.encodeEnd(ChartRenderer.java:67)
 
at javax.faces.component.UIComponentBase.encodeEnd(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at javax.faces.component.UIComponent.encodeAll(Unknown Source)
 
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(Unknown Source)
 
at com.sun.faces.application.view.MultiViewHandler.renderView(Unknown Source)
 
at com.sun.faces.lifecycle.RenderResponsePhase.execute(Unknown Source)
 
at com.sun.faces.lifecycle.Phase.doPhase(Unknown Source)
 
at com.sun.faces.lifecycle.LifecycleImpl.render(Unknown Source)
 
at javax.faces.webapp.FacesServlet.service(Unknown Source)
 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
 
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:417)
 
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
 
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
 
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 
at java.lang.Thread.run(Unknown Source)

en vous remerciant .

Affecter la somme d'une colonne dans une liste

Développement Web en Java

Mode arborescent

Discussions similaires

Partager

Partager