中国地面气象站逐小时API Java国家气象信息中心API

未***

1.     public static void main(String[] args) throws IOException {
   
2.         List<String> num = new ArrayList<>();
   
3.         String filePath = "src/main/resources/China_SURF_Station.xlsx";
   
4.         File file = new File(filePath);
   
5.         XSSFWorkbook xssfWorkbook = new XSSFWorkbook(new FileInputStream(file));
   
6.         int tabIndex =0;
   
7.         Sheet sheet = xssfWorkbook.getSheetAt(tabIndex);
   
8.         Row row;
   
9.         Cell cell1;
   
10.         for (int i=0;i<sheet.getLastRowNum();i++){
    
11.             row = sheet.getRow(i+1);
    
12.             cell1 = row.getCell(0);
    
13.             cell1.setCellType(CellType.STRING);
    
14.             String cellValue0 = cell1.getStringCellValue();
    
15.             num.add(cellValue0);
    
16. 
    
17.         }
    
18.         System.out.println(num);
    
19. 
    
20. 
    
21. 
    
22.         String STATION_IdS=  StringUtils.join(Arrays.asList(num.stream().limit(30).toArray()),",");
    
23.         System.out.println(STATION_IdS);
    
24. 
    
25.         String request = "http://api.data.cma.cn:8090/api?userId=****&pwd=***&dataFormat=json&interfaceId=getSurfEleByTimeRangeAndStaID&dataCode=SURF_CHN_MUL_HOR&timeRange=[20221116000000,20221116000000]&staIDs="+STATION_IdS+"&elements=Station_Id_C,Year,Mon,Day,Hour,PRS,PRS_Sea,PRS_Max,PRS_Min,RHU,RHU_Min,VAP,PRE_1h,TEM,TEM_Max,TEM_Min,&dataCode=SURF_CHN_MUL_HOR";
    
26.         URL url = new URL(request);
    
27.         StringBuilder document = new StringBuilder();
    
28.         URLConnection conn = url.openConnection();//URL请求
    
29.         BufferedReader reader = new BufferedReader(new InputStreamReader(conn.getInputStream(), "utf-8"));//获取数据流
    
30.         String line = null;
    
31.         while ((line = reader.readLine()) != null) {
    
32.             document.append(line);
    
33.         }
    
34.         reader.close();
    
35.         JSONObject json = JSONObject.parseObject(document.toString());
    
36.         System.out.println(json);
    
37. 
    
38. 
    
39.     }

复制代码

国家气象信息中心-中国气象数据网 (cma.cn)

未***

66666666666