Map <String, Float> mapWeek = new HashMap<String, Float>(); while(rs.next()) { String num = rs.getString(1); String week = rs.getString(2); Float value = Float.parseFloat(num); if (mapWeek.containsKey(week)) { value += mapWeek.get(week()); } mapWeek.put(week, value); } for (Entry<String, Float> e : mapWeek.entrySet()) { System.out.println(e.getKey() + ": " + e.getValue()); }
import java.util.Map.Entry;
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionfor (Entry <String, Float> e : mapWeek.entrySet()) { System.out.println(e.getKey() + ": " + e.getValue()); }
public ArrayList getData() throws ClassNotFoundException, SQLException { // TODO Auto-generated method stub ArrayList list = new ArrayList(); { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","SYSTEM","infohouda"); System.out.println("Driver Connected"); Statement st=con.createStatement(); //ResultSet rs=st.executeQuery("select * from KPI_NSN"); ResultSet rs=st.executeQuery("select n.TCONG_D,n.WEEK from KPI_NSN1 n order by n.WEEK"); LinkedHashMap <String, Float> mapWeek = new LinkedHashMap<String, Float>(); while(rs.next()) { String num = rs.getString(1); String week = rs.getString(2); Float value = Float.parseFloat(num); if (mapWeek.containsKey(week)) { value += mapWeek.get(week); } mapWeek.put(week, value); } for (Entry <String, Float> e : mapWeek.entrySet()) { System.out.println(e.getKey() + ": " + e.getValue()); list.add(e.getValue()); // Sum[j]=e.getValue(); } for (int i = 0; i < list.size(); i++) { Float str = (Float) list.get (i); System.out.println (str); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } return list ; } }
try { DefaultCategoryDataset dataset = new DefaultCategoryDataset(); TryTotalNWeekER T=new TryTotalNWeekER(); ArrayList NumTotal=new ArrayList(); NumTotal=T.getData(); for (int j=0;j<T.getData().size();j++) { dataset.addValue(Float.parseFloat(NumTotal.toString()), series1, "WEEK"+j); }