🚀 go-pugleaf

Suchitha,

You can use the JCChart. It is a KL Group bean that is filled from an array.

Here is the code of the array class :

     import jclass.chart.Chartable;
     import java.util.Vector;
     public class ArrayData implements Chartable{
       public double rawData[][]= new double[2][50];
       Vector data = new Vector();
       public ArrayData() {
         makeData(rawData);}
       public ArrayData(double data[][]) {
         makeData(data);}
       private void makeData(double array[][]) {
         for (int i=0; i<array.length;i++){
           Vector row = new Vector();
           for (int j=0; j<array[i].length;j++){
             row.addElement(new Double(array[i][j]));}
           data.addElement(row);}}
       public Object getDataItem(int row, int column){
         Object rval = null;
         try {rval = ((Vector)data.elementAt(row)).elementAt(column);}
         catch (Exception ex){}
         return rval;}
       public Vector getRow(int row){
         Vector rval = null;
         try {rval = (Vector)data.elementAt(row);}
         catch (Exception ex){}
         return rval;}
       public int getDataInterpretation(){
         return ARRAY;}
       public int getNumRows(){
         if (data == null) return 0;
         return data.size();}
       public String[] getPointLabels(){
         return null;}
       public String getSeriesName(int row){
         return null;}
       public String getSeriesLabel(int row){
         return getSeriesName(row);}
       public String getName(){
         return new String("Array Data");}
     }

And here is the code for filling the array with the data countained in your
database :

         int nb_rows=0;
     It is what you will put in the array :
         Variant v1=new Variant();
         Variant v2=new Variant();
         try {
     I define the parameter row I need for the query :
           pRow.setString("C_CompanyID",S_CompetitorID);
     I execute the query :
           qds_Chart1.executeQuery();
     I store the number of records in the query :
           nb_rows = qds_Chart1.getRowCount();
           double tab_chart[][]=new double[2][nb_rows];
     And I fill the array with the value of the fields :
           if (nb_rows != 0){
             for (int i=0;i<nb_rows;i++){
     The fields are define as float in the database and as double in the
     queryDataSet:
               qds_Chart1.getVariant("year_fin",i,v1);
               qds_Chart1.getVariant("net_sales",i,v2);
               tab_chart[0][i]=v1.getAsDouble();
               tab_chart[1][i]=v2.getAsDouble();
             }
           }
           jCChart_Financial.getDataView(0).setDataSource(new
     ArrayData(tab_chart));

I hope it will help you, good luck, Claire.

Suchitha Madapoosi a �crit:

> I am trying to create  a chart  using data from some database.I am using
> Jbuilder tool. I am open to any other tool if jbuilder doesn't support
> this. Help will be appreciated. I know you could do this using KLgroup.
> Please help me.
> Thanks
> Suchitha