PiccActivity.java
2.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
package com.lhcredit.project.worldbox.domain;
import cn.hutool.http.HttpRequest;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import com.alibaba.fastjson.JSONObject;
import lombok.Data;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.*;
import java.util.ArrayList;
import java.util.List;
import java.util.stream.Collectors;
/**
* 经营活动
*/
@Data
public class PiccActivity {
private String mainActivity;//主营业务
private String activityAndProducts;//业务活动及产品
private String brandNames;//品牌名称
private String trademarks;//商标
public static void main(String[] args) {
String s = "北京煜邦电力技术股份有限公司、北京理工导航控制科技股份有限公司、北京广厦环能科技股份有限公司、北京赛科希德科技股份有限公司、北京松兰饮片有限公司";
List<JSONObject> list=new ArrayList<>();
try {
String[] split = s.split("、");
for (String string : split) {
for (int i = 1; i <=10 ; i++) {
String url="http://dnaapi.lhdna.com/api/V4.0/changeInfo?name={name}&pageNum={pageNum}&pageSize=20&key=dev";
url=url.replace("{name}",string);
url=url.replace("{pageNum}",i+"");
String body = HttpRequest.get(url).header("Token", "0926cd73-92e3-453c-9c64-3a1439f74e67").execute().body();
JSONObject jsonObject = JSONObject.parseObject(body);
if (jsonObject.getString("code").equals("2000")){
JSONArray jsonArray = jsonObject.getJSONObject("data").getJSONArray("items");
System.out.println(1);
List<JSONObject> ename = jsonArray.stream().map(m -> {
JSONObject jsonObject1 = (JSONObject) m;
jsonObject1.put("ename", string);
return jsonObject1;
}).collect(Collectors.toList());
list.addAll(ename);
}else {
continue;
}
}
}
ExcelWriter writer = ExcelUtil.getWriter("C:\\Users\\HASEE\\Desktop\\ssss.xlsx");
writer.write( list);
writer.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}