json数据插入数据库

lang1382080

数据格式如下：
[
  {
    "Indicator":"Life expectancy at birth (years)",
    "PUBLISH STATES":"Published",
    "Year":1990,
    "WHO region":"Europe",
    "World Bank income group":"High-income",
    "Country":"Andorra",
    "Sex":"Both sexes",
    "Display Value":77,
    "Numeric":77.00000,
    "Low":"",
    "High":"",
    "Comments":""
  },
  {
    "Indicator":"Life expectancy at birth (years)",
    "PUBLISH STATES":"Published",
    "Year":2000,
    "WHO region":"Europe",
    "World Bank income group":"High-income",
    "Country":"Andorra",
    "Sex":"Both sexes",
    "Display Value":80,
    "Numeric":80.00000,
    "Low":"",
    "High":"",
    "Comments":""
  },
  {
    "Indicator":"Life expectancy at age 60 (years)",
    "PUBLISH STATES":"Published",
    "Year":2012,
    "WHO region":"Europe",
    "World Bank income group":"High-income",
    "Country":"Andorra",
    "Sex":"Female",
    "Display Value":28,
    "Numeric":28.00000,
    "Low":"",
    "High":"",
    "Comments":""
  },
  {
    "Indicator":"Life expectancy at age 60 (years)",
    "PUBLISH STATES":"Published",
    "Year":2000,
    "WHO region":"Europe",
    "World Bank income group":"High-income",
    "Country":"Andorra",
    "Sex":"Both sexes",
    "Display Value":23,
    "Numeric":23.00000,
    "Low":"",
    "High":"",
    "Comments":""
  }
]

这些数据要定期插入到本地的sqlserver数据库里的一张表里面去，格式如下（字段基本和Json数据的Key一致）。
字段：Indicator    PUBLISHSTATES   Year   WHOregion"    WBIG   Country   Sex    Display   Numeric  Low   Comments
请帮忙怎么实现？

lang1382080

自己顶一下吧，居然还没有出现

q1208c

回复 2# lang1382080

并不复杂呀。

先用 json 把数据 load 进来。

然后再写个 sql 语句， 把这些 json数据做参数， 放进去就行了呀。

很复杂么？

lang1382080

回复 3# q1208c

初学Python，现在有项目要求，我这边想提前提取数据测试下。
   那请你这边帮忙给下个完整的代码吧

q1208c

回复 4# lang1382080

最近没这么多时间写代码。
你可参考一下官方的例子。