EChart饼图数据的格式化问题

Question

EChartjavascriptjson

Answer 1

首先，map是无序的，你取的顺序都不对，给你看我的解决方法。希望对你有用。
public static List<Map<String, Object>> read(String sql) {

Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
         conn = DBUtil.getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
        ResultSetMetaData rsmd = rs.getMetaData();
        
        // 取得结果集列数
            int columnCount = rsmd.getColumnCount();
            
            // 构造泛型结果集
            List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
            Map<String, Object> data = null;
            
            // 循环结果集
            while(rs.next()){
             data = Collections.synchronizedMap(new LinkedHashMap<String, Object>());
             // 每循环一条将列名和列值存入Map
             for (int i = 1; i <= columnCount; i++) {
             String key = rsmd.getColumnLabel(i);
             Object value = rs.getObject(rsmd.getColumnLabel(i));
             data.put(key,value);
                }
             // 将整条数据的Map存入到List中
                list.add(data);
//                System.out.println(list);
                
            }
            return list;
            
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException();
}finally {
DBUtil.closeConnection();
}
        
}

Answer 2

JsonArray arr = new JsonArray();
JsonObject job = null;for(xx. xx. mapArr){
   job = new JsonObject();
   job.put("name",xx);
   job.put("value",xx);
   arr.add(job);
}
return arr.toString();

Answer 3

var result = {"8月":200,"6月":600,"7月":700,"1月":100,"5月":500,"3月":300,"2月":200,"11月":1100,"9月":900,"4月":400,"12月":1200,"10月":1000};
var arr = [];
for(var key in result){
   arr.push({
       name:key,
       value:result[key]
   });
}
console.log(arr); //"[{"name":"8月","value":200},{"name":"6月","value":600},{"name":"7月","value":700},{"name":"1月","value":100},{"name":"5月","value":500},{"name":"3月","value":300},{"name":"2月","value":200},{"name":"11月","value":1100},{"name":"9月","value":900},{"name":"4月","value":400},{"name":"12月","value":1200},{"name":"10月","value":1000}]"

Answer 4

var result = {"8月":200,"6月":600,"7月":700,"1月":100,"5月":500,"3月":300,"2月":200,"11月":1100,"9月":900,"4月":400,"12月":1200,"10月":1000};
var arr = [];
for(var key in result){
   arr.push({
       name:key,
       value:result[key]
   });
}
console.log(arr); //"[{"name":"8月","value":200},{"name":"6月","value":600},{"name":"7月","value":700},{"name":"1月","value":100},{"name":"5月","value":500},{"name":"3月","value":300},{"name":"2月","value":200},{"name":"11月","value":1100},{"name":"9月","value":900},{"name":"4月","value":400},{"name":"12月","value":1200},{"name":"10月","value":1000}]"