Get started
Loading...
Important Notice - Forums is archived

To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Product icon
TUTORIAL

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

Where to include a web components css file when integrating a third party w by Martin Vyšný, 1 week ago
Recent Posts
Vaadin Forum1. Vaadin Flow - Java

Invient chart - Adding values from DB to pie chart ?

syed mohamed
10 years ago Feb 21, 2012 4:48am

Hi ,

I am working with invient pie chart, I need to set the values for pie chart from DB.

XYSeries series = new XYSeries("Browser Share");
	        LinkedHashSet<DecimalPoint> points = new LinkedHashSet<DecimalPoint>();
	        points.add(new DecimalPoint(series, "Firefox", [b]45.0[/b]));
	        points.add(new DecimalPoint(series, "IE", [b]26.8[/b]));

In the above code I need to set the values 45.0 and 26.8 from DB (thru sql query or any).The values are in 'double' so it must be something like 

double firefox = ..........?.........  ;      //the place where I need your suggestion for getting value from DB
XYSeries series = new XYSeries("Browser Share");
LinkedHashSet<DecimalPoint> points = new LinkedHashSet<DecimalPoint>();
points.add(new DecimalPoint(series, "Firefox", [b]firefox[/b]));
points.add(new DecimalPoint(series, "IE", [b]26.8[/b]));

Please provide a suggestion.

Thank you.

Last updated on Feb, 21st 2012
Hugo Hanisch
9 years ago Jul 11, 2012 2:25am

syed mohamed: Hi ,

I am working with invient pie chart, I need to set the values for pie chart from DB.

XYSeries series = new XYSeries("Browser Share");
	        LinkedHashSet<DecimalPoint> points = new LinkedHashSet<DecimalPoint>();
	        points.add(new DecimalPoint(series, "Firefox", [b]45.0[/b]));
	        points.add(new DecimalPoint(series, "IE", [b]26.8[/b]));

In the above code I need to set the values 45.0 and 26.8 from DB (thru sql query or any).The values are in 'double' so it must be something like 

double firefox = ..........?.........  ;      //the place where I need your suggestion for getting value from DB
XYSeries series = new XYSeries("Browser Share");
LinkedHashSet<DecimalPoint> points = new LinkedHashSet<DecimalPoint>();
points.add(new DecimalPoint(series, "Firefox", [b]firefox[/b]));
points.add(new DecimalPoint(series, "IE", [b]26.8[/b]));

Please provide a suggestion.

Thank you.

Here, create a list<String> with the items you need names and a double[] array with the values serie (make sure they are the same size) from your DB table, and use the following code...

XYSeries series = new XYSeries("Browser Share");
        LinkedHashSet<DecimalPoint> points = new LinkedHashSet<DecimalPoint>();
                
        for (int i=0;i<names.size();i++){
        	points.add(new DecimalPoint(series,names.get(i),serie[i]));
        }

        series.setSeriesPoints(points);
        chart.addSeries(series);

Cheers,

Hugo