API tools faq
paste
Guest User

Untitled

a guest
Aug 29th, 2018
140
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.00 KB | None | 0 0
raw download clone embed print report
  1. How Can use one connection in all my beans?
  2. **1/Class Connectionx**
  3. public class Connectionx implements java.io.Serializable{
  4. public Connection cx=null;
  5. public Statement st;
  6. public Connectionx() {}
  7. public Connection Connx()
  8. {
  9. System.out.println("enregister le driver");
  10. try {
  11. Class.forName("com.mysql.jdbc.Driver");
  12.  
  13. }
  14. catch( Exception ex )
  15. {
  16. System.err.println("Erreur lors du chargement du driver"+ex.getMessage() );
  17.  
  18. }
  19. try {
  20. /** Connection */
  21. cx = (Connection) DriverManager.getConnection( "jdbc:mysql://localhost/jiradb","root","root" );
  22.  
  23. System.out.println("conexion reussite ");
  24.  
  25. }
  26. catch( SQLException ex )
  27. {
  28. System. err. println( "Erreur lors de la connexion à la baseeeeee" );
  29.  
  30. }
  31. return cx;
  32. }
  33. public void deConnx(Connection cx) throws SQLException{
  34.  
  35. cx.close();
  36. System. err. println( "deconnection");
  37. }
  38. }
  39.  
  40. public class BeanTools implements java.io.Serializable {
  41.  
  42. /***************selectonemenu***********************/
  43. private List<SelectItem> mesElements;
  44. private String maValeur;
  45. public String[] favNumber1 ; //checkbox
  46. public PreparedStatement st;
  47. public Connectionx cx = new Connectionx();
  48. public Connection con = (Connection)cx.Connx();
  49.  
  50. /**************checkbox***************/
  51. public BeanTools() {
  52. }
  53.  
  54. public String getMaValeur() {
  55. return maValeur;
  56. }
  57.  
  58. public void setMaValeur(String maValeur) {
  59. this.maValeur = maValeur;
  60. }
  61.  
  62. public String[] getFavNumber1() {
  63. return favNumber1;
  64. }
  65.  
  66. public void setFavNumber1(String[] favNumber1) {
  67. this.favNumber1 = favNumber1;
  68. }
  69.  
  70. public String getFavNumber1InString() {
  71.  
  72. return Arrays.toString(favNumber1);
  73. }
  74.  
  75.  
  76. public String getFavNumber1onebyone()
  77. { String Val =null;
  78. for(int i=0;i<favNumber1.length;i++)
  79. {
  80. if (favNumber1[i].equals("1"))
  81. System.out.println("priority checked");
  82. if (favNumber1[i].equals("2"))
  83. System.out.println("project checked");
  84. if (favNumber1[i].equals("3"))
  85. System.out.println("Month checked");
  86.  
  87. }
  88.  
  89. return Val;
  90. }
  91.  
  92.  
  93. public Iterable<String> remplireItem() throws ClassNotFoundException, SQLException
  94. {
  95.  
  96. String sql;
  97. sql ="select issuestatus.pname from issuestatus;";
  98. System.out.println("sql");
  99. st=(PreparedStatement) con.prepareStatement(sql);
  100. ResultSet rs1 = st.executeQuery();System.out.println("execute");
  101.  
  102. String val;
  103. ArrayList<String> list = new ArrayList<String>();
  104. while(rs1.next())
  105. {
  106. val= rs1.getString("pname");
  107. System.out.println(val);
  108. list.add(nbb);
  109. System.out.println("list"+list.toString());
  110. }
  111. return list;
  112. }
  113.  
  114.  
  115. public List<SelectItem> getMesElements() throws SQLException,ClassNotFoundException {
  116.  
  117. if (mesElements == null) {
  118. mesElements = new ArrayList<SelectItem>();
  119. for (String val : remplireItem()) {
  120. mesElements.add(new SelectItem(val));
  121. }
  122. }
  123. return mesElements;
  124. }
  125.  
  126. public class NumberOfIssue implements java.io.Serializable{
  127.  
  128. public String numberIssue;
  129. private String maValeur;
  130. public Connectionx cx = new Connectionx();
  131. public Connection con = (Connection)cx.Connx();
  132. public PreparedStatement st;
  133.  
  134.  
  135. public NumberOfIssue() {
  136. }
  137.  
  138.  
  139. public String getMaValeur() {
  140. return maValeur;
  141. }
  142.  
  143. public void setMaValeur(String maValeur) {
  144. this.maValeur = maValeur;
  145. }
  146.  
  147. public String getNumberIssue() throws SQLException
  148. {
  149. //Connection con
  150. BeanTools beTools=new BeanTools();
  151. System.out.println("beTools.maValeur");
  152. String sql;
  153. sql ="select count(OS_CURRENTSTEP.entry_id) as nbissue ,project.pname,priority.pname,issuetype.pname from OS_CURRENTSTEP,jiraissue,issuestatus,issuetype,project,resolution,customfield ,customfieldvalue,priority where OS_CURRENTSTEP.entry_id = jiraissue.id and jiraissue.priority=priority.id and jiraissue.issuestatus=issuestatus.id and issuestatus.pname="+maValeur+" and jiraissue.issuetype=issuetype.id and jiraissue.project=project.id and resolution.id=jiraissue.resolution and resolution.pname='Fixed' Group By project.pname,priority.pname,issuetype.pname;";
  154.  
  155. st= (PreparedStatement) con.prepareStatement(sql);
  156.  
  157. ResultSet rs1 = st.executeQuery();
  158.  
  159. while(rs1.next())
  160. {
  161. numberIssue= rs1.getString(1);
  162. String strissue2= rs1.getString(2);
  163. String strissue3= rs1.getString(3);
  164. System.out.println("nb issue "+numberIssue.toString()+" ||project "+strissue2.toString()+" ||proiority "+strissue3.toString());
  165.  
  166. }
  167. return numberIssue;
  168. }
  169.  
  170. <managed-bean>
  171. <managed-bean-name>Connectionx</managed-bean-name>
  172. <managed-bean-class>KPIs.Connectionx</managed-bean-class>
  173. <managed-bean-scope>session</managed-bean-scope>
  174. </managed-bean>
  175.  
  176. <managed-bean>
  177. <managed-bean-name>BeanTools</managed-bean-name>
  178. <managed-bean-class>KPIs.BeanTools</managed-bean-class>
  179. <managed-bean-scope>session</managed-bean-scope>
  180. <managed-property>
  181. <property-name>cx</property-name>
  182. <property-class>java.sql.Connection</property-class>
  183. <value>#{Connectionx.cx}</value>
  184. </managed-property>
  185. </managed-bean>
  186.  
  187. <managed-bean>
  188. <managed-bean-name>NumberOfIssue</managed-bean-name>
  189. <managed-bean-class>KPIs.NumberOfIssue</managed-bean-class>
  190. <managed-bean-scope>session</managed-bean-scope>
  191. <managed-property>
  192. <property-name>maValeur</property-name>
  193. <property-class>java.lang.String</property-class>
  194. <value>#{BeanTools.maValeur}</value>
  195. </managed-property>
  196. <managed-property>
  197. <property-name>cx</property-name>
  198. <property-class>java.sql.Connection</property-class>
  199. <value>#{Connectionx.cx}</value>
  200. </managed-property>
  201. </managed-bean>
  202.  
  203. <navigation-rule>
  204. <from-view-id>/welcomeJSF.jsp</from-view-id>
  205. <navigation-case>
  206. <from-outcome>submit</from-outcome>
  207. <to-view-id>/Result.jsp</to-view-id>
  208. </navigation-case>
  209. </navigation-rule>
  210. </faces-config>
  211.  
  212. com.sun.faces.mgbean.ManagedBeanCreationException: Impossible de créer le bean géré BeanTools. Les problèmes suivants ont été détectés :
  213. - La propriété cx du bean géré BeanTools nexiste pas.
  214. at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:265)
  215. at com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:244)
  216. at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:116)
  217. at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
  218. at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
  219. at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:71)
  220. at org.apache.el.parser.AstValue.getValue(AstValue.java:147)
  221. at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
  222. at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:106)
  223. at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:193)
  224. at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:181)
  225. at javax.faces.component.UIOutput.getValue(UIOutput.java:169)
  226. at com.sun.faces.renderkit.html_basic.MenuRenderer.getCurrentSelectedValues(MenuRenderer.java:648)
  227. at com.sun.faces.renderkit.html_basic.MenuRenderer.renderOptions(MenuRenderer.java:749)
  228. at com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:844)
  229. at com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:298)
  230. at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:883)
  231. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1659)
  232. at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
  233. at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:853)
  234. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1652)
  235. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1655)
  236. at com.sun.faces.application.view.JspViewHandlingStrategy.doRenderView(JspViewHandlingStrategy.java:431)
  237. at com.sun.faces.application.view.JspViewHandlingStrategy.renderView(JspViewHandlingStrategy.java:233)
  238. at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
  239. at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
  240. at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
  241. at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
  242. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:313)
  243. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
  244. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  245. at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
  246. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  247. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  248. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
  249. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
  250. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
  251. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
  252. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  253. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
  254. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  255. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
  256. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
  257. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
  258. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
  259. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
  260. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
  261. at java.lang.Thread.run(Thread.java:662)
  262.  
  263. "select count(OS_CURRENTSTEP.entry_id) as nbissue [.. snip ...]
  264. and issuestatus.pname="+maValeur+" and jiraissue.issuetype=issuetype.id
  265. [... snip ...] and resolution.pname='Fixed' Group By
  266. project.pname,priority.pname,issuetype.pname;";
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!