Are Dynamic Charts Possible?

[posthume]

Hi everyone,

 

I am new to this forum and I hope you can help me in that issue.

 

I am developing a web application with JSP/Tomcat and I have already created a complex project in java that allows to do statistic calculs on data taken from a text file and I have shown those results in multiple tables using displaytag library in a JSP file.

 

Now i would like to show the same results but in bar charts and I found FusionCharts which corresponds exactly to what I want. But I have a question as I couldn't really find the answer on the net. Is it possible to use dynamic data on those charts, like for example data taken from a HashMap that I coded in java?

 

The data I need to represent on a bar chart are in that loop :

  
for (String string : mapV.keySet()) {

                     // Name of the gene
                      String gene = string; // That's one of the data I need to represent on the top of each bar.

                 //Non-redundant sequences
                 int nbSeqNonRedG = 0;

                 //Redundant sequences
                 int nbSeqRedG = 0;

                 //Distinct sequences
                 int nbSeqDistinctG = 0;

                 //Parcours du tableau des gènes 
                 for (String string2 : table1.keySet()) { 
                    if (string.equals(string2)) {
                       Enumeration lesSeq2 = (table1.get(string2)).keys();
                       for (Entry<String, Integer> entryG : (table1.get(string2)).entrySet()) { 

                            String seq2 = (String)lesSeq2.nextElement();

                            int nbOcc2 = ((Integer)(table1.get(string2)).get(seq2)).intValue();   

                            if (nbOcc2 == 1) { nbSeqNonRedG = nbSeqNonRedG + 1;
                                             }

                            else { nbSeqRedG = nbSeqRedG + 1;

                       }

                             nbSeqDistinctG = nbSeqNonRedG + nbSeqRedG;  // that's one of the data I need to represent on the bar chart on the y  axis

                          try {
                          Class.forName(driverName);

                       } catch (ClassNotFoundException e1) {
                          System.out.println(e1.getMessage());
                       }   

                        Connection con = null;
                       try{
                           con = DriverManager.getConnection(url, username, pass);
                        }catch(SQLException e){
                              System.out.println(e.getMessage());
                        }

                           Statement st = null;
                        ResultSet rs = null;

                        try {
                          st = con.createStatement();
                           st.executeQuery("select name1, deb, fin from  genomicpositions g where (g.name1 like '%" + string +  "%') ");
                          rs = st.getResultSet();


                       } catch (SQLException e) {
                          System.out.println(e.getMessage());
                       }

                       try {
                          while (rs.next()) {

                                          int start = rs.getInt(2) //  That's the last data I need to represent on the bar chart on the x-axis


                            }


                       } catch (SQLException e) {
                          e.printStackTrace();
                       }


                       try {
                          rs.close();
                          st.close();
                          con.close();
                       } catch (SQLException e) {
                          e.printStackTrace();
                       }
                    }

                 }


                 }


             }

 

I need to represent a bar chart with (cf. the comments on my code):

-on the y axis: the number of distinct sequences for a gene --> int nbSeqDistinctG

-on the x-axis: the position of the gene in the locus (taken from a database) --> int start

-on the top of each bar, the name of the corresponding gene --> String gene

 

Is it possible to do this with that library? If so, can you give me some directions on how to get to start please or maybe just an example of how to do it?

 

Any help would be very appreciated.

 

Ps: sorry for my english, i am french.

[FusionCharts Support]

Hi,

 

This can absolutely be done.

 

All you need to do is to build an XML form your data (dynamic or statc) as per the schema supported by the chart and pass the XML to the chart when embedding it using the J2EE wrapper.