🚀 go-pugleaf

Claire
Thanks a lot
Suchitha
In article <35DA840B.B194F27B@casecorp.com>,
  claire Lecarpentier <clecarpentier@casecorp.com> wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum