数据库、servlet、json、javascript和highchart饼图

database, servlet, json , javascript and highchart pie chart

本文关键字:highchart 饼图 json servlet 数据库 javascript      更新时间:2024-04-30

我需要使用servlet中的"json"数据生成一个动态的"highchart"饼图,数据库方法运行正常,但json部分没有向饼图传递任何数据。

"下面是我的servlet代码"

公共类SubCountyAjaxApplications扩展HttpServlet{

protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    PrintWriter out = response.getWriter();
    ArrayList<Applications> Rawpplications = AdminDB.sub_countyApplications();
    response.setContentType("text/html");
    response.setHeader("Cache-control", "no-cache, no-store");
    response.setHeader("Pragma", "no-cache");
    response.setHeader("Expires", "-1");
    response.setHeader("Access-Control-Allow-Origin", "*");
    response.setHeader("Access-Control-Allow-Methods", "POST");
    response.setHeader("Access-Control-Allow-Headers", "Content-Type");
    response.setHeader("Access-Control-Max-Age", "86400");
    Gson gson = new Gson();
    JsonArray results = new JsonArray();
    for (Applications application : Rawpplications) {
        JsonObject myObj = new JsonObject();
        myObj.addProperty("key",application.getSub_county());
        System.out.println(application.getSub_county()+":"+application.getAmount_applied());
        myObj.addProperty("value",application.getAmount_applied());
        results.add(myObj);
    }
    out.println(results.getAsJsonArray());
    out.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    doPost(request, response);
}

//下面是我的javascript文件,标题出现了,但没有图表

        var chart;
        $(document).ready(
                function () {
                    chart = new Highcharts.Chart({
                        chart: {
                            renderTo: 'chart',
                        },
                        title: {
                            text: 'County Application Distribution'
                        },
                        tooltip: {
                            formatter: function () {
                                var s;
                                if (this.point.name) { // the pie chart
                                    s = '' + this.point.name + ': ' + this.y
                                            + ' Bugs';
                                } else {
                                    s = '' + this.x + ': ' + this.y;
                                }
                                return s;
                            }
                        },
                        labels: {
                            items: [{
                                    html: '',
                                    style: {
                                        left: '40px',
                                        top: '8px',
                                        color: 'black'
                                    }
                                }]
                        },
                        series: [{
                                type: 'pie',
                                name: 'Total Bugs',
                                data: [],
                                center: [70, 50],
                                size: 50,
                                showInLegend: false,
                                dataLabels: {
                                    enabled: false
                                },
                            }, ]
                    },function getdata(chart) {
                        var tmp = "";
                        var receivedData = "";
                        $.ajax({
                            url: 'SubCountyAjaxApplications',
                            dataType: 'json',
                            error: function () {
                                alert("error occured!!!");
                            },
                            success: function (data) {
                                var chartData = [];
                                $.each(data.jsonArray, function (index)
                                {
                                    $.each(data.jsonArray[index],
                                            function (key, value) {
                                                var point = [];
                                                point.push(key);
                                                point.push(value);
                                                chartData.push(point);
                                            });
                                });
                                chart.series[0].setData(chartData);
                            }
                        });
                    });
                });

我在哪里犯了错误

假设ajax调用返回的数据是上面指定的格式:

[{"key":"CHANGAMWE","label":"20,000"},{"key":"JOMVU","label":"55,000"},{"key":"Kathiani","label":"42,000"},{"key":"KISAUNI","label":"60,000"},{"key":"LIKONI","label":"20,000"},{"key":"Machakos Town","label":"15,000"},{"key":"MVITA","label":"15,000"},{"key":"NYALI","label":"35,000"}]

你可以像这样改变你的解析循环,为Highcharts:返回一个合适的数据数组

var chartData = [];
$.each(data, function (i, node) {
    chartData.push( [ node.key, parseFloat(node.label) ] );
});

示例:

  • http://jsfiddle.net/jlbriggs/3d3fuhbb/134/