橙稚 2017-06-08 01:52 采纳率: 33.3%
浏览 752
已结题

数据类型转换问题,求帮忙

1----->数据库查询的数据。。。[{pjcj=161.0, CESHIRIQI=2011, SUOSHUQUYU=通州区}, {pjcj=166.0, CESHIRIQI=2012, SUOSHUQUYU=通州区}, {pjcj=159.5, CESHIRIQI=2014, SUOSHUQUYU=通州区}, {pjcj=180.0, CESHIRIQI=2015, SUOSHUQUYU=通州区}, {pjcj=140.5, CESHIRIQI=2016, SUOSHUQUYU=东城区}, {pjcj=167.94, CESHIRIQI=2016, SUOSHUQUYU=密云区}, {pjcj=169.45, CESHIRIQI=2016, SUOSHUQUYU=房山区}, {pjcj=161.91, CESHIRIQI=2016, SUOSHUQUYU=昌平区}, {pjcj=166.75, CESHIRIQI=2017, SUOSHUQUYU=亦庄经济开发区}, {pjcj=162.63, CESHIRIQI=2017, SUOSHUQUYU=延庆}, {pjcj=163.21, CESHIRIQI=2017, SUOSHUQUYU=怀柔区}, {pjcj=166.43, CESHIRIQI=2017, SUOSHUQUYU=石景山区}, {pjcj=164.08, CESHIRIQI=2017, SUOSHUQUYU=通州区}, {pjcj=167.53, CESHIRIQI=2017, SUOSHUQUYU=门头沟区}, {pjcj=164.37, CESHIRIQI=2017, SUOSHUQUYU=顺义区}, {pjcj=166.58, CESHIRIQI=2017, SUOSHUQUYU=首都职工体质促进中心}]

2---> 第一次遍历转换的数据。。。{首都职工体质促进中心={[166.58]=[2017]}, 怀柔区={[163.21]=[2017]}, 房山区={[169.45]=[2016]}, 门头沟区={[167.53]=[2017]}, 石景山区={[166.43]=[2017]}, 东城区={[140.5]=[2016]}, 昌平区={[161.91]=[2016]}, 亦庄经济开发区={[166.75]=[2017]}, 延庆={[162.63]=[2017]}, 密云区={[167.94]=[2016]}, 顺义区={[164.37]=[2017]}, 通州区={[164.08]=[2017], [180.0]=[2015], [161.0]=[2011], [166.0]=[2012], [159.5]=[2014]}}

3---> 第2次遍历转换的数据。。。[{"data":166.58,"name":"首都职工体质促进中心","riqi":"2017"},{"data":163.21,"name":"怀柔区","riqi":"2017"},{"data":169.45,"name":"房山区","riqi":"2016"},{"data":167.53,"name":"门头沟区","riqi":"2017"},{"data":166.43,"name":"石景山区","riqi":"2017"},{"data":140.5,"name":"东城区","riqi":"2016"},{"data":161.91,"name":"昌平区","riqi":"2016"},{"data":166.75,"name":"亦庄经济开发区","riqi":"2017"},{"data":162.63,"name":"延庆","riqi":"2017"},{"data":167.94,"name":"密云区","riqi":"2016"},{"data":164.37,"name":"顺义区","riqi":"2017"},{"data":164.08,"name":"通州区","riqi":"2017"}]
第二次遍历的数据格式没错,但是最后一个“通州”。怎么就对应一个data,riqi,我想得到{"data":164.08,"riqi":"2017","name":"通州区","data":180.0,"riqi":"2015",data":161.0,"riqi":"2011",data":166.0,"riqi":"2012",data":159.50,"riqi":"2014"}

附上代码,图片说明
图片说明

  • 写回答

1条回答 默认 最新

  • Hefei19881002 2017-06-08 02:18
    关注

    map的key是唯一的,你把riqi放进map最后只有一个.我的思路是把查到的数据遍历之后直接转成json 同时判断一下你的name值如果相同的话就放进jsonArray的同一个元素中

    评论

报告相同问题?

悬赏问题

  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容