load data from database to create fusion chart in java?

Question

How can i add database values to maps to create fusion charts in java

// datas get from database
 "trendlines": [
    {
        "line": [
            {
                "startvalue": "175000",
                "color": "#8cbb2c",
                "thickness": "4",
                "alpha": "60",
                "displayvalue": "Target - $175K"
            }
        ]
    }
]

Did you look into this link :http://www.fusioncharts.com/dev/using-with-server-side-languages/java/creating-charts-with-data-from-a-database.html As you already visit fusioncharts site. — Abu Sufian, Feb 21 '17 at 07:01
I got its output. Now, i am trying to add a target line with it. — Harikrishnan, Feb 21 '17 at 07:14
"trendlines": [ { "line": [ { "startvalue": "175000", "color": "#1aaf5d", "valueOnRight": "1", "tooltext": "Quarterly sales target was $startDataValue", "displayvalue": "Target - $175K" } ] } ] — Harikrishnan, Feb 21 '17 at 07:16

Zapdos13 · Accepted Answer · 2017-02-22T06:19:44.890

In order to add the trendlines object you have to create a array list which will prepare the trendline object and will call a method to build the internal structure of the trendline object, inside the method you will have to create a hashmap which will add as key value pairs, inside that hashmap you need to create a arraylist which store the data of the line objects, inside the line object the data shuld be in key value pairs so in order to do that you will have to create a hashmap for it, finally you need to add this hashmap with the line arraylist object, and finally this arraylist object will be added to the primary hashmap and will return it.

Please refer this Dropbox for a sample using database https://www.dropbox.com/s/04dwugo4unw5uin/Fusioncharts_trendline_sample.zip?dl=0

You will get the sql table from the project inside the sql folder.

Also you can check the code snippet below

    <%

      //prepare trendlines
       ArrayList trendlines= new ArrayList();
       trendlines.add(buildTrendlines("startvalue","color","displayvalue",gson));

        //close the connection.
        result.close();


        //create 'dataMap' map object to make a complete FusionCharts datasource.
         Map<String, String> dataMap = new LinkedHashMap<String, String>();  
    /*
        gson.toJson() the data to retrieve the string containing the
        JSON representation of the data in the array.
    */
         dataMap.put("chart", gson.toJson(chartobj));
         dataMap.put("categories", gson.toJson(categories));
         dataMap.put("dataset", gson.toJson(dataset));
         dataMap.put("trendlines",gson.toJson(trendlines));
        FusionCharts mslineChart= new FusionCharts(
        "msline",// chartType
                    "chart1",// chartId
                    "600","400",// chartWidth, chartHeight
                    "chart",// chartContainer
                    "json",// dataFormat
                    gson.toJson(dataMap) //dataSource
                );

        %>


        <%!


        public Map buildTrendlines(String startvalue, String color, String displayvalue, Gson gson){

               Map<String, String> trendlineinner = new HashMap<String, String>();
                 ArrayList lines = new ArrayList();
                    Map<String, String> linesdata = new HashMap<String, String>();  
                  linesdata.put("startvalue", "17022");
                  linesdata.put("color","#6baa01");
                   linesdata.put("displayvalue","Average");
                  lines.add(linesdata);  
                trendlineinner.put("line", gson.toJson(lines));
                return trendlineinner;
                 }
                 %>

    <%= mslineChart.render() %>

load data from database to create fusion chart in java?

1 Answers1