49,926
社区成员




String sql = "insert into sys_districts " +
"(id,adcode, citycode , name, p_id,center,level )" +
"values ";
try {
List<NameValuePair> parametersBody = new ArrayList();
parametersBody.add(new BasicNameValuePair("key", "xxxxxxxxxxxxxxxxxxxx"));
parametersBody.add(new BasicNameValuePair("subdistrict", "4"));
parametersBody.add(new BasicNameValuePair("extensions", "all"));
String result = HttpUtils.getRequest("https://restapi.amap.com/v3/config/district",parametersBody);
JSONArray arr1 = JSON.parseObject(result).getJSONArray("districts");
//第一层,取出国家
for(int i=0;i<arr1.size();i++) {
//第二层 取出省
JSONArray arr2 = arr1.getJSONObject(i).getJSONArray("districts");
for(int j=0;j<arr2.size();j++){
String citycode = "0";
String adcode = arr2.getJSONObject(j).getString("adcode");
String name = arr2.getJSONObject(j).getString("name");
String center = arr2.getJSONObject(j).getString("center");
String level = arr2.getJSONObject(j).getString("level");
//拼接sql
String pId = adcode + "p" + j;
sql += "('"+pId+"','"+adcode+"','"+citycode+"','"+name+"','0','"+center+"','"+level+"'),";
//第三层 取出市
JSONArray arr3 = arr2.getJSONObject(j).getJSONArray("districts");
for(int k=0;k<arr3.size();k++){
String citycode3 = arr3.getJSONObject(k).getString("citycode");
String adcode3 = arr3.getJSONObject(k).getString("adcode");
String name3 = arr3.getJSONObject(k).getString("name");
String center3 = arr3.getJSONObject(k).getString("center");
String level3 = arr3.getJSONObject(k).getString("level");
String cId = adcode3 + "c" + k;
sql += "('"+cId+"','"+adcode3+"','"+citycode3+"','"+name3+"','"+pId+"','"+center3+"','"+level3+"'),";
//第4层 取出区
JSONArray arr4 = arr3.getJSONObject(k).getJSONArray("districts");
for(int l=0;l<arr4.size();l++){
String citycode4 = arr4.getJSONObject(l).getString("citycode");
String adcode4 = arr4.getJSONObject(l).getString("adcode");
String name4 = arr4.getJSONObject(l).getString("name");
String center4 = arr4.getJSONObject(l).getString("center");
String level4 = arr4.getJSONObject(l).getString("level");
String dId = adcode4 + "d" + l;
sql += "('"+dId+"','"+adcode4+"','"+citycode4+"','"+name4+"','"+cId+"','"+center4+"','"+level4+"'),";
//第5层 取出街道
JSONArray arr5 = arr4.getJSONObject(l).getJSONArray("districts");
for(int m=0;m<arr5.size();m++){
String citycode5 = arr5.getJSONObject(m).getString("citycode");
String adcode5 = arr5.getJSONObject(m).getString("adcode");
String name5 = arr5.getJSONObject(m).getString("name");
String center5 = arr5.getJSONObject(m).getString("center");
String level5 = arr5.getJSONObject(m).getString("level");
String sId = adcode5 + "s" + m;
sql += "('"+sId+"','"+adcode5+"','"+citycode5+"','"+name5+"','"+dId+"','"+center5+"','"+level5+"'),";
}
}
}
System.out.println((j+1)+"/"+arr2.size());
}
}
} catch (Exception e) {
e.printStackTrace();
}
return sql;