package com.sysn.mysql.download;
import cn.hutool.core.util.StrUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.collections4.MapUtils;
import java.util.*;
/**
* @Author: WeiZJ
* @Date: 2023/8/23 16:23
* @Description:
*/
public class DownloadFileExcel {
public static final String OUT_PATH = "E:\\test";
public static void main(String[] args) {
DownUtil downUtil = new DownUtil();
ExcelReader reader = ExcelUtil.getReader("C:\\Users\\admin\\Desktop\\111\\play.xlsx");
List<Map<String, Object>> readAll = reader.readAll();
Iterator<Map<String, Object>> iterator = readAll.iterator();
Map<String, List<String>> mapHashMap = new HashMap<>();
while (iterator.hasNext()) {
Map<String, Object> next = iterator.next();
String uName = (String) next.get("姓名");
uName = uName.trim();
//附件集合
ArrayList<String> fileUrl = new ArrayList<>();
if (StrUtil.isNotBlank(next.get("上传简历").toString())) {
fileUrl.add(next.get("上传简历").toString());
}
if (StrUtil.isNotBlank(next.get("报名表格").toString())) {
fileUrl.add(next.get("报名表格").toString());
}
if (StrUtil.isNotBlank(next.get("身份证正面").toString())) {
fileUrl.add(next.get("身份证正面").toString());
}
if (StrUtil.isNotBlank(next.get("身份证反面").toString())) {
fileUrl.add(next.get("身份证反面").toString());
}
if (StrUtil.isNotBlank(next.get("户口簿").toString())) {
fileUrl.add(next.get("户口簿").toString());
}
if (StrUtil.isNotBlank(next.get("学历证书").toString())) {
fileUrl.add(next.get("学历证书").toString());
}
if (StrUtil.isNotBlank(next.get("学位证书").toString())) {
fileUrl.add(next.get("学位证书").toString());
}
if (StrUtil.isNotBlank(next.get("专业技术资格证书").toString())) {
fileUrl.add(next.get("专业技术资格证书").toString());
}
if (StrUtil.isNotBlank(next.get("工作经验证明").toString())) {
fileUrl.add(next.get("工作经验证明").toString());
}
if (StrUtil.isNotBlank(next.get("电子照片").toString())) {
fileUrl.add(next.get("电子照片").toString());
}
List<String> list = mapHashMap.get(uName);
if (CollectionUtils.isEmpty(list)) {
mapHashMap.put(uName, fileUrl);
}
}
List<Map<String, String>> list = new ArrayList<>();
mapHashMap.forEach((k, v) -> {
Map<String, String> fileMap = new HashMap<>();
String fileFinalPath = downUtil.downloadPicture(v, OUT_PATH);
System.out.println(fileFinalPath);
fileMap.put("姓名", k);
fileMap.put("附件文件路径", fileFinalPath);
list.add(fileMap);
});
ExcelWriter writer = ExcelUtil.getWriter("E:\\rcsjfj.xlsx");
writer.passCurrentRow();
writer.write(list, true);
writer.close();
}
}
package com.sysn.mysql.download;
import cn.hutool.core.util.StrUtil;
import org.apache.poi.util.StringUtil;
import java.io.FileOutputStream;
import java.io.DataInputStream;
import java.io.File;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.List;
import java.util.UUID;
/**
* @Author: WeiZJ
* @Date: 2023/8/23 16:15
* @Description:
*/
public class DownUtil {
public String downloadPicture(List<String> picUrls, String outPath) {
String outUrl = outPath + "\\" + UUID.randomUUID().toString() + "\\";
File outPathFile = new File(outPath);
File outFile = new File(outUrl);
//判断文件路劲存不存在
if (!outPathFile.exists()) {
outPathFile.mkdir();
}
if (!outFile.exists()) {
outFile.mkdir();
}
String msg = "下载完成!!";
picUrls.forEach(x -> {
try {
String suf = "";
String[] split = x.split("\\.");
if (split.length > 0) {
suf = split[split.length - 1];
}
URL url = new URL(x);
HttpURLConnection conn = (HttpURLConnection) url.openConnection();
conn.setRequestProperty("User-Agent", "Mozilla/5.0");
DataInputStream dataInputStream = new DataInputStream(conn.getInputStream());
String imageName = UUID.randomUUID().toString() + StrUtil.DOT + suf;
FileOutputStream fileOutputStream = new FileOutputStream(new File(outUrl + imageName));
byte[] buffer = new byte[10240];
int length;
while ((length = dataInputStream.read(buffer)) > 0) {
// System.out.println("正在下载: " + imageName);
fileOutputStream.write(buffer, 0, length);
}
dataInputStream.close();
fileOutputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
});
return outUrl;
}
}