spring:
\n servlet:
\n multipart:
\n # \u8bbe\u7f6e\u6587\u4ef6\u6700\u5927\u5927\u5c0f
\n max-file-size: 100MB
\n # \u8bbe\u7f6e\u8bf7\u6c42\u6700\u5927\u5927\u5c0f
\n max-request-size: 100MB<\/p>\n
\u8fd9\u91cc\u4f7f\u7528\u672c\u5730\u6587\u4ef6\u8def\u5f84\u6a21\u62df\u6587\u4ef6\u670d\u52a1\u5668<\/p>\n
# \u6587\u4ef6\u4e0a\u4f20\u4f4d\u7f6e
\nupload-path:
\n url: http:\/\/localhost:8080\/
\n face: D:\/community\/upload\/face\/
\n file: D:\/community\/upload\/file\/<\/p>\n
\u81ea\u5b9a\u4e49\u914d\u7f6e\u524d\u7f00（\u4e0d\u662f Spring Boot \u81ea\u5e26\u7684），\u901a\u8fc7\u00a0@ConfigurationProperties\u00a0\u6216\u00a0@Value\u00a0\u6ce8\u89e3\u6ce8\u5165\u5230 Java \u7c7b\u4e2d\u3002<\/p>\n
http:\/\/localhost:8080\/face\/abc.jpg<\/p>\n
package com.qcby.config;<\/p>\n
import org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.beans.factory.annotation.Value;
\nimport org.springframework.context.annotation.Configuration;
\nimport org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
\nimport org.springframework.web.servlet.config.annotation.WebMvcConfigurer;<\/p>\n
@Configuration
\npublic class WebMVCConfiguration implements WebMvcConfigurer {
\n @Value("${upload-path.face}")
\n private String face;
\n @Value("${upload-path.file}")
\n private String file;
\n @Override
\n public void addResourceHandlers(ResourceHandlerRegistry registry) {
\n registry.addResourceHandler("\/community\/upload\/face\/**")
\n .addResourceLocations("file:"+face);
\n registry.addResourceHandler("\/community\/upload\/file\/**")
\n .addResourceLocations("file:"+file);
\n }
\n}<\/p>\n
\u5c06 URL \u8bf7\u6c42\u8def\u5f84（\/community\/upload\/face\/**）\u548c\u78c1\u76d8\u8def\u5f84（D:\/community\/upload\/face\/）\u7ed1\u5b9a，\u8ba9\u6d4f\u89c8\u5668\u53ef\u4ee5\u76f4\u63a5\u8bbf\u95ee\u78c1\u76d8\u4e0a\u7684\u6587\u4ef6\u3002<\/p>\n
\u5f53\u7528\u6237\u8bbf\u95ee\u00a0http:\/\/localhost:8080\/community\/upload\/face\/abc.jpg<\/p>\n
Spring Boot \u4f1a\u53bb\u00a0D:\/community\/upload\/face\/abc.jpg\u00a0\u627e\u8fd9\u4e2a\u6587\u4ef6，\u5e76\u76f4\u63a5\u8fd4\u56de\u7ed9\u6d4f\u89c8\u5668<\/p>\n
\u524d\u7aef\u8bbf\u95eehttp:\/\/localhost:8080\/community\/upload\/face\/123.jpg\u65f6，Springboot\u4f1a\u6620\u5c04\u5230file:D:\/community\/upload\/face\/123.jpg，\u534f\u8bae\u7684\u5207\u6362\u548clocalhost:8080\u7684\u53d8\u52a8\u662f\u5982\u4f55\u5b9e\u73b0\u7684<\/p>\n
\u8fd9\u662fSpring MVC \u63d0\u4f9b\u7684\u00a0\u9759\u6001\u8d44\u6e90\u5904\u7406\u673a\u5236\u00a0\u5728\u5de5\u4f5c<\/p>\n
Spring Boot（\u5e95\u5c42\u662f Spring MVC）\u5728\u542f\u52a8\u65f6，\u4f1a\u626b\u63cf\u914d\u7f6e\u7684\u9759\u6001\u8d44\u6e90\u5904\u7406\u5668（ResourceHttpRequestHandler)，\u8fd9\u4e2a\u5904\u7406\u5668\u6709\u4e24\u4e2a\u5173\u952e\u70b9：<\/p>\n
\u5f53\u6d4f\u89c8\u5668\u8bbf\u95ee\u7684 URL\u00a0\u8def\u5f84\u90e8\u5206（\u4e0d\u5305\u62ec\u534f\u8bae\u3001\u57df\u540d\u3001\u7aef\u53e3）\u7b26\u5408\u8fd9\u4e2a\u6a21\u5f0f\u65f6，\u8fd9\u4e2a\u5904\u7406\u5668\u4f1a\u63a5\u7ba1\u8bf7\u6c42\u3002<\/p>\n
http:\/\/localhost:8080\/community\/upload\/face\/123.jpg\u00a0\u2192 \u5339\u914d\u8def\u5f84\u00a0\/community\/upload\/face\/123.jpg\u3002<\/p>\n
file:\u00a0\u534f\u8bae\u544a\u8bc9 Spring MVC：\u8d44\u6e90\u5728\u672c\u5730\u6587\u4ef6\u7cfb\u7edf，\u4e0d\u662f\u5728 classpath \u91cc\u3002<\/p>\n
\u628a URL \u8def\u5f84\u4e2d\u7684\u5339\u914d\u90e8\u5206\u53bb\u6389，\u62fc\u5230\u7269\u7406\u8def\u5f84\u540e\u9762：<\/p>\n
D:\/community\/upload\/face\/ + 123.jpg<\/p>\n
\u7136\u540e\u8bfb\u53d6\u6587\u4ef6\u5e76\u901a\u8fc7 HTTP \u54cd\u5e94\u6d41\u8fd4\u56de\u7ed9\u6d4f\u89c8\u5668\u3002<\/p>\n
\u5f88\u591a\u4eba\u4f1a\u4ee5\u4e3a\u00a0localhost:8080\u00a0\u88ab\u66ff\u6362\u6210\u00a0file:\u00a0\u8def\u5f84，\u5176\u5b9e\u4e0d\u662f\u3002<\/p>\n
\u5b9e\u9645\u8fc7\u7a0b\u662f\u8fd9\u6837\u7684：<\/p>\n
1. \u6d4f\u89c8\u5668\u8bf7\u6c42<\/p>\n
GET http:\/\/localhost:8080\/community\/upload\/face\/123.jpg<\/p>\n
2. Tomcat \u63a5\u6536\u8bf7\u6c42<\/p>\n
Spring Boot \u5185\u7f6e Tomcat \u76d1\u542c\u00a08080\u00a0\u7aef\u53e3，\u63a5\u6536\u5230\u00a0\/community\/upload\/face\/123.jpg\u00a0\u8fd9\u4e2a\u8def\u5f84\u7684\u8bf7\u6c42\u3002<\/p>\n
3.Spring MVC \u5339\u914d\u5904\u7406\u5668<\/p>\n
\u5b83\u53d1\u73b0\u00a0\/community\/upload\/face\/**\u00a0\u7684\u89c4\u5219\u88ab\u547d\u4e2d，\u5c31\u4ea4\u7ed9\u00a0ResourceHttpRequestHandler\u3002<\/p>\n
4.\u5904\u7406\u5668\u8bfb\u53d6\u672c\u5730\u6587\u4ef6<\/p>\n
\u6839\u636e\u00a0file:D:\/community\/upload\/face\/\u00a0\u8fd9\u4e2a\u914d\u7f6e，\u628a URL \u91cc\u5269\u4e0b\u7684\u90e8\u5206\u00a0123.jpg\u00a0\u62fc\u5230\u8def\u5f84\u672b\u5c3e，\u5f97\u5230：<\/p>\n
D:\/community\/upload\/face\/123.jpg<\/p>\n
\u6253\u5f00\u6587\u4ef6，\u628a\u4e8c\u8fdb\u5236\u5185\u5bb9\u5199\u5230 HTTP \u54cd\u5e94\u4e2d\u3002<\/p>\n
5.\u6d4f\u89c8\u5668\u663e\u793a\u56fe\u7247<\/p>\n
\u5bf9\u6d4f\u89c8\u5668\u6765\u8bf4，\u5b83\u4ecd\u7136\u662f\u6536\u5230\u4e86\u00a0http:\/\/localhost:8080\/…\u00a0\u7684\u54cd\u5e94，\u53ea\u4e0d\u8fc7\u5185\u5bb9\u662f JPG \u56fe\u7247\u3002<\/p>\n
\u6d4f\u89c8\u5668\u770b\u5230\u7684\u59cb\u7ec8\u662f\u00a0http:\/\/localhost:8080\/…，HTTP \u534f\u8bae\u548c\u7aef\u53e3\u00a08080\u00a0\u6ca1\u53d8\u3002<\/p>\n
\u53ea\u662f\u5728\u670d\u52a1\u7aef\u5185\u90e8，Spring MVC \u628a\u8fd9\u4e2a HTTP \u8bf7\u6c42\u6620\u5c04\u5230\u4e86\u672c\u5730\u6587\u4ef6\u7cfb\u7edf，\u5e76\u8bfb\u53d6\u4e86\u6587\u4ef6\u5185\u5bb9\u4f5c\u4e3a HTTP \u54cd\u5e94\u3002<\/p>\n
\u6362\u53e5\u8bdd\u8bf4：<\/p>\n
\u5bf9\u5ba2\u6237\u7aef \u2192 \u5b83\u662f\u5728\u8bbf\u95ee HTTP URL<\/p>\n
\u5bf9\u670d\u52a1\u7aef \u2192 \u5b83\u662f\u5728\u8bfb\u786c\u76d8\u6587\u4ef6\u5e76\u901a\u8fc7 HTTP \u8fd4\u56de<\/p>\n
@Autowired
\nprivate ICommunityService communityService;
\n@Autowired
\nprivate IPersonService personService;
\n@Value("${upload-path.url}")
\nprivate String uploadUrlPath;
\n@Value("${upload-path.face}")
\nprivate String faceLocalPath;
\n@Autowired
\nprivate ApiConfiguration apiConfiguration;
\n\/**
\n * \u5f55\u5165\u5c45\u6c11\u4eba\u8138\u4fe1\u606f
\n * @return
\n *\/
\n@PostMapping("\/addPerson")
\npublic Result addPersonImg(@RequestBody FaceForm faceForm){
\n System.out.println("\u8fdb\u5165\u5230addPerson");
\n System.out.println(faceForm.getExtName());
\n Person person = personService.getById(faceForm.getPersonId());
\n \/\/ \u4e25\u8c28\u6027\u5224\u65ad，\u53c2\u6570\u662f\u5426\u4e3a\u7a7a
\n if(faceForm.getFileBase64()== null || faceForm.getFileBase64().equals("")){
\n return Result.error("\u8bf7\u4e0a\u4f20\u4eba\u8138\u56fe\u7247");
\n }
\n \/\/ \u5224\u65ad\u662f\u5426\u662f\u4eba\u8138，\u5982\u679c\u4e0d\u662f，\u76f4\u63a5\u8fd4\u56de
\n if(apiConfiguration.isUsed()){
\n String faceId = newPerson(faceForm,person.getUserName());
\n if(faceId == null){
\n return Result.error("\u4eba\u8138\u8bc6\u522b\u5931\u8d25");
\n }else{
\n String fileName = faceId + "." + faceForm.getExtName();
\n String faceUrl = uploadUrlPath + faceLocalPath.substring(3) + fileName;
\n person.setFaceUrl(faceUrl);
\n person.setState(2);
\n personService.updateById(person);
\n return Result.ok();
\n }
\n }else{
\n return Result.error("\u4eba\u8138\u8bc6\u522b\u5f00\u542f\u5931\u8d25");
\n }
\n}<\/p>\n
\/**
\n * \u521b\u5efa\u4eba\u8138\u4fe1\u606f，\u8c03\u7528\u4eba\u8138\u8bc6\u522bAPI，\u8fdb\u884c\u4eba\u8138\u6bd4\u5bf9
\n * @param faceForm
\n * @param userName
\n * @return
\n *\/
\nprivate String newPerson(FaceForm faceForm, String userName) {
\n String faceId = null;
\n String fileBase64 = faceForm.getFileBase64();
\n String extName = faceForm.getExtName();
\n String personId = faceForm.getPersonId()+"";
\n String savePath = faceLocalPath;
\n if(fileBase64 != null && !fileBase64.equals("")){
\n FaceApi faceApi = new FaceApi();
\n RootResp newperson = faceApi.newperson(apiConfiguration, personId, userName, fileBase64);
\n if(newperson.getRet()==0){
\n JSONObject jsonObject = JSON.parseObject(newperson.getData().toString());
\n faceId = jsonObject.getString("FaceId");
\n if(faceId!=null){
\n savePath = savePath + faceId + "."+extName;
\n try {
\n Base64Util.decoderBase64File(fileBase64,savePath);
\n } catch (Exception e) {
\n e.printStackTrace();
\n }
\n }
\n } else{
\n return faceId;
\n }
\n }
\n return faceId;
\n}<\/p>\n
@Value("${upload-path.url}") private String uploadUrlPath;\u6765\u81ea yml \u7684\u201c\u5bf9\u5916\u57fa\u7840 URL\u201d，\u4f8b\u5982\u00a0http:\/\/localhost:8080\/\u3002<\/p>\n
@Value("${upload-path.face}") private String faceLocalPath;\u6765\u81ea yml \u7684\u201c\u4eba\u8138\u56fe\u7247\u672c\u5730\u76ee\u5f55\u201d，\u4f8b\u5982\u00a0D:\/community\/upload\/face\/\u3002<\/p>\n
\u540c\u65f6\u4f60\u5728\u00a0WebMVCConfiguration\u00a0\u91cc\u628a：<\/p>\n
"\/community\/upload\/face\/**" \u2194 "file:D:\/community\/upload\/face\/"<\/p>\n
\u505a\u4e86\u9759\u6001\u8d44\u6e90\u6620\u5c04\u3002\u8fd9\u610f\u5473\u7740\u6d4f\u89c8\u5668\u8bbf\u95eehttp:\/\/localhost:8080\/community\/upload\/face\/xxx.jpg \u65f6，Spring \u4f1a\u4ece\u00a0D:\/community\/upload\/face\/xxx.jpg\u00a0\u8bfb\u6587\u4ef6\u5e76\u8fd4\u56de\u3002<\/p>\n
\u628a Base64 \u53d1\u7ed9\u7b2c\u4e09\u65b9\u4eba\u8138 API（faceApi.newperson(…)）<\/p>\n<\/li>\n
\u6210\u529f\u8fd4\u56de\u540e\u4ece\u54cd\u5e94\u91cc\u62ff\u5230\u00a0FaceId<\/p>\n<\/li>\n
\u7528\u00a0FaceId + "." + extName\u00a0\u4f5c\u4e3a\u6587\u4ef6\u540d，\u62fc\u6210：savePath = faceLocalPath + faceId + "." + extName\u6bd4\u5982：D:\/community\/upload\/face\/ab12cd34.jpg<\/p>\n<\/li>\n
\u7528\u00a0Base64Util.decoderBase64File(fileBase64, savePath)\u00a0\u628a Base64 \u89e3\u7801\u5199\u5165\u78c1\u76d8<\/p>\n<\/li>\n<\/li>\n
\u751f\u6210\u53ef\u8bbf\u95ee URL + \u66f4\u65b0\u5e93<\/p>\n
\u6784\u9020\u00a0fileName = faceId + "." + extName<\/p>\n<\/li>\n
\u7ec4\u88c5\u00a0faceUrl，\u7136\u540e\u00a0person.setFaceUrl(faceUrl)，\u5e76\u00a0updateById<\/p>\n<\/li>\n<\/li>\n
\/**
\n * \u6570\u636e\u7684\u5bfc\u51fa\u529f\u80fd\u5b9e\u73b0
\n * @param personListForm
\n * @return
\n *\/
\n @GetMapping("\/exportExcel")
\n public Result exportExcel(PersonListForm personListForm){
\n \/\/1.\u83b7\u53d6\u6ee1\u8db3\u6761\u4ef6\u7684\u6570\u636e
\n PageVO pageVO = personService.personList(personListForm);
\n \/\/2.\u53ea\u9700\u8981\u6ee1\u8db3\u6761\u4ef6\u7684\u6570\u636e\u5373\u53ef
\n List list = pageVO.getList();
\n \/\/3.\u5904\u7406\u6570\u636e\u653e\u5165\u5230EXcel\u8868\u683c\u5f53\u4e2d
\n String path = excel;
\n path=ExcelUtil.ExpPersonInfo(list, path);
\n return Result.ok().put("data", path);
\n }<\/p>\n
\/**
\n * \u6587\u4ef6\u4e0a\u4f20
\n * @param file
\n * @return
\n * @throws Exception
\n *\/
\n @PostMapping("\/excelUpload")
\n public Result excelUpload(@RequestParam("uploadExcel") MultipartFile file) throws Exception {
\n if(file.getOriginalFilename().equals("")){
\n return Result.error("\u6ca1\u6709\u9009\u4e2d\u8981\u4e0a\u4f20\u7684\u6587\u4ef6");
\n }else {
\n String picName = UUID.randomUUID().toString();
\n String oriName = file.getOriginalFilename();
\n String extName = oriName.substring(oriName.lastIndexOf("."));
\n String newFileName = picName + extName;
\n File targetFile = new File(excel, newFileName);
\n \/\/ \u4fdd\u5b58\u6587\u4ef6
\n file.transferTo(targetFile);
\n return Result.ok().put("data",newFileName);
\n }
\n }<\/p>\n
\/**
\n * \u5b9e\u73b0\u6570\u636e\u5e93\u65b0\u589e\u8868\u4e2d\u6570\u636e
\n * \u6570\u636e\u5bfc\u5165\u64cd\u4f5c
\n * @param fileName
\n * @param session
\n * @return
\n *\/
\n @PostMapping("\/parsefile\/{fileName}")
\n public Result parsefile(@PathVariable("fileName") String fileName,HttpSession session){
\n User user = (User) session.getAttribute("user");
\n \/\/POIFSFileSystem \u662f Apache POI \u5e93\u4e2d\u7684\u6838\u5fc3\u7c7b
\n \/\/\u4e13\u95e8\u7528\u4e8e\u5904\u7406 OLE 2 Compound Document Format（\u5fae\u8f6f\u590d\u5408\u6587\u6863\u683c\u5f0f）
\n \/\/\u662f Java \u5f00\u53d1\u4e2d\u5904\u7406\u4f20\u7edf Microsoft Office \u6587\u6863（\u5982 .xls, .doc, .ppt）\u7684\u57fa\u7840\u7ec4\u4ef6
\n POIFSFileSystem fs = null;
\n \/\/HSSFWorkbook \u662f Apache POI \u5e93\u4e2d\u5904\u7406 Microsoft Excel \u683c\u5f0f（.xls \u6587\u4ef6）\u7684\u6838\u5fc3\u7c7b
\n \/\/ \u4f5c\u4e3a Horrible SpreadSheet Format \u7684\u7f29\u5199，\u5b83\u63d0\u4f9b\u4e86\u5b8c\u6574\u7684 API \u6765\u521b\u5efa\u3001\u8bfb\u53d6\u548c\u4fee\u6539\u4f20\u7edf Excel
\n \/\/ \u4e8c\u8fdb\u5236\u6587\u4ef6\u3002
\n HSSFWorkbook wb = null;
\n try {
\n String basePath = excel + fileName;
\n fs = new POIFSFileSystem(new FileInputStream(basePath));
\n wb = new HSSFWorkbook(fs);
\n } catch (Exception e) {
\n e.printStackTrace();
\n }
\n \/\/\u8fd9\u6bb5\u4ee3\u7801\u7684\u6838\u5fc3\u529f\u80fd\u662f\u4eceExcel\u4e2d\u63d0\u53d6\u6570\u636e\u5230\u4e8c\u7ef4\u6570\u7ec4，\u7279\u522b\u5904\u7406\u4e86\u7b2c\u4e00\u5217\u7684\u6570\u503c\u8f6c\u6362\u3002
\n HSSFSheet sheet = wb.getSheetAt(0);\/\/ \u83b7\u53d6\u5de5\u4f5c\u7c3f\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868
\n Object[][] data = null;\/\/ \u58f0\u660e\u4e8c\u7ef4\u6570\u7ec4\u7528\u4e8e\u5b58\u50a8\u6570\u636e
\n int r = sheet.getLastRowNum()+1;\/\/ \u83b7\u53d6\u603b\u884c\u6570（\u7d22\u5f15\u4ece0\u5f00\u59cb）
\n int c = sheet.getRow(0).getLastCellNum();\/\/ \u83b7\u53d6\u7b2c\u4e00\u884c\u7684\u5217\u6570
\n int headRow = 2;\/\/ \u8868\u5934\u884c\u6570（\u8df3\u8fc7\u524d2\u884c）
\n data = new Object[r – headRow][c];\/\/ \u521b\u5efa\u4e8c\u7ef4\u6570\u7ec4（\u884c\u6570=\u603b\u884c\u6570-\u8868\u5934\u884c）
\n for (int i = headRow; i < r; i++) {\/\/ \u4ece\u7b2c3\u884c\u5f00\u59cb（\u8df3\u8fc7\u8868\u5934）
\n HSSFRow row = sheet.getRow(i); \/\/ \u83b7\u53d6\u5f53\u524d\u884c
\n for (int j = 0; j < c; j++) {\/\/ \u904d\u5386\u6bcf\u5217
\n HSSFCell cell = null;
\n try {
\n cell = row.getCell(j); \/\/ \u83b7\u53d6\u5355\u5143\u683c
\n try {
\n cell = row.getCell(j);
\n DataFormatter dataFormater = new DataFormatter();\/\/\u4f7f\u7528DataFormatter\u5c06\u5355\u5143\u683c\u503c\u7edf\u4e00\u8f6c\u4e3a\u5b57\u7b26\u4e32
\n String a = dataFormater.formatCellValue(cell); \/\/ \u683c\u5f0f\u5316\u5355\u5143\u683c\u503c\u4e3a\u5b57\u7b26\u4e32
\n data[i – headRow][j] = a;\/\/ \u5b58\u50a8\u5230\u6570\u7ec4
\n } catch (Exception e) {
\n \/\/ \u5f02\u5e38\u5904\u7406：\u5f53\u5355\u5143\u683c\u8bfb\u53d6\u5931\u8d25\u65f6
\n data[i-headRow][j] = ""; \/\/ \u5148\u8bbe\u7f6e\u4e3a\u7a7a\u5b57\u7b26\u4e32
\n \/\/ \u7279\u6b8a\u5904\u7406\u7b2c\u4e00\u5217（\u7d22\u5f150）
\n if(j==0){
\n try {
\n double d = cell.getNumericCellValue();\/\/ \u5c1d\u8bd5\u83b7\u53d6\u6570\u503c
\n data[i – headRow][j] = (int)d + "";\/\/ \u8f6c\u6362\u4e3a\u6574\u6570\u540e\u5b58\u50a8\u4e3a\u5b57\u7b26\u4e32
\n }catch(Exception ex){
\n data[i-headRow][j] = "";\/\/ \u5982\u679c\u8f6c\u6362\u5931\u8d25，\u4fdd\u6301\u4e3a\u7a7a
\n }
\n }
\n }
\n } catch (Exception e) {
\n System.out.println("i="+i+";j="+j+":"+e.getMessage());
\n }
\n }
\n }<\/p>\n
int row = data.length;
\n int col = 0;
\n String errinfo = "";
\n headRow = 3;
\n \/\/String[] stitle={"ID","\u5c0f\u533a\u540d\u79f0","\u6240\u5c5e\u697c\u680b","\u623f\u53f7","\u59d3\u540d","\u6027\u522b","\u624b\u673a\u53f7\u7801","\u5c45\u4f4f\u6027\u8d28","\u72b6\u6001","\u5907\u6ce8"};
\n errinfo = "";
\n for (int i = 0; i < row; i++) {
\n Person single = new Person();
\n single.setPersonId(0);
\n single.setState(1);
\n single.setFaceUrl("");
\n try {
\n col=1;
\n String communityName = data[i][col++].toString();
\n QueryWrapper<Community> queryWrapper = new QueryWrapper<>();
\n queryWrapper.eq("community_name", communityName);
\n Community community = this.communityService.getOne(queryWrapper);
\n if( community == null){
\n errinfo += "Excel\u6587\u4ef6\u7b2c" + (i + headRow) + "\u884c\u5c0f\u533a\u540d\u79f0\u4e0d\u5b58\u5728！";
\n return Result.ok().put("status", "fail").put("data", errinfo);
\n }
\n single.setCommunityId(community.getCommunityId());
\n single.setTermName(data[i][col++].toString());
\n single.setHouseNo(data[i][col++].toString());
\n single.setUserName(data[i][col++].toString());
\n single.setSex(data[i][col++].toString());
\n single.setMobile(data[i][col++].toString());
\n single.setPersonType(data[i][col++].toString());
\n single.setRemark(data[i][col++].toString());
\n single.setCreater(user.getUsername());
\n this.personService.save(single);
\n } catch (Exception e) {
\n e.printStackTrace();
\n }
\n }
\n return Result.ok().put("status", "success").put("data","\u6570\u636e\u5bfc\u5165\u5b8c\u6210！");
\n }<\/p>\n
@GetMapping("\/exportExcel")
\npublic Result exportExcel(PersonListForm personListForm)<\/p>\n
\u6267\u884c\u6d41\u7a0b：<\/p>\n
1.\u83b7\u53d6\u6570\u636e<\/p>\n
\u8c03\u7528\u00a0personService.personList(personListForm)\u00a0\u6309\u6761\u4ef6\u5206\u9875\u67e5\u8be2\u6570\u636e，\u5f97\u5230\u00a0PageVO\u3002<\/p>\n
\u4ece\u00a0PageVO\u00a0\u4e2d\u53d6\u51fa\u00a0list（\u8fd9\u5c31\u662f\u7b26\u5408\u6761\u4ef6\u7684\u4eba\u5458\u6570\u636e）\u3002<\/p>\n
2.\u751f\u6210 Excel \u6587\u4ef6<\/p>\n
ExcelUtil.ExpPersonInfo(list, path)\u00a0\u5c06\u6570\u636e\u5199\u5165 Excel，\u5e76\u8fd4\u56de Excel \u6587\u4ef6\u7684\u4fdd\u5b58\u8def\u5f84\u3002<\/p>\n
3.\u8fd4\u56de\u7ed3\u679c<\/p>\n
Result.ok().put("data", path)\u00a0\u628a\u6587\u4ef6\u8def\u5f84\u8fd4\u56de\u7ed9\u524d\u7aef\u3002\u524d\u7aef\u53ef\u4ee5\u7528\u8fd9\u4e2a\u8def\u5f84\u4e0b\u8f7d Excel \u6587\u4ef6\u3002<\/p>\n
@PostMapping("\/excelUpload")
\npublic Result excelUpload(@RequestParam("uploadExcel") MultipartFile file)<\/p>\n
\u6267\u884c\u6d41\u7a0b：<\/p>\n
1.\u68c0\u67e5\u6587\u4ef6\u662f\u5426\u9009\u62e9<\/p>\n
\u5982\u679c\u00a0file.getOriginalFilename()\u00a0\u662f\u7a7a\u5b57\u7b26\u4e32，\u5c31\u76f4\u63a5\u8fd4\u56de\u00a0"\u6ca1\u6709\u9009\u4e2d\u8981\u4e0a\u4f20\u7684\u6587\u4ef6"\u3002<\/p>\n
2.\u751f\u6210\u65b0\u6587\u4ef6\u540d<\/p>\n
\u7528\u00a0UUID.randomUUID().toString()\u00a0\u751f\u6210\u4e00\u4e2a\u4e0d\u91cd\u590d\u7684\u6587\u4ef6\u540d\u3002\u83b7\u53d6\u539f\u6587\u4ef6\u540e\u7f00（\u6bd4\u5982\u00a0.xls\u00a0\/\u00a0.xlsx），\u62fc\u63a5\u6210\u65b0\u7684\u6587\u4ef6\u540d\u3002<\/p>\n
3.\u4fdd\u5b58\u6587\u4ef6\u5230\u670d\u52a1\u5668<\/p>\n
File targetFile = new File(excel, newFileName)\u00a0\u521b\u5efa\u76ee\u6807\u6587\u4ef6\u5bf9\u8c61（excel\u00a0\u662f\u5b58\u653e\u76ee\u5f55）\u3002file.transferTo(targetFile)\u00a0\u628a\u4e0a\u4f20\u7684\u6587\u4ef6\u4fdd\u5b58\u5230\u6307\u5b9a\u76ee\u5f55\u3002<\/p>\n
4.\u8fd4\u56de\u7ed3\u679c<\/p>\n
\u628a\u65b0\u6587\u4ef6\u540d\u8fd4\u56de\u7ed9\u524d\u7aef，\u7528\u4e8e\u540e\u7eed\u89e3\u6790\u3002<\/p>\n
@PostMapping("\/parsefile\/{fileName}")
\npublic Result parsefile(@PathVariable("fileName") String fileName,HttpSession session)<\/p>\n
\u6267\u884c\u6d41\u7a0b：<\/p>\n
\u7528\u00a0DataFormatter\u00a0\u628a\u5355\u5143\u683c\u503c\u7edf\u4e00\u8f6c\u6210\u5b57\u7b26\u4e32<\/p>\n<\/li>\n
\u5982\u679c\u8bfb\u53d6\u5931\u8d25：<\/p>\n
\u5148\u7f6e\u4e3a\u7a7a\u5b57\u7b26\u4e32<\/p>\n<\/li>\n
\u5982\u679c\u662f\u7b2c\u4e00\u5217（\u53ef\u80fd\u662f\u6570\u5b57 ID），\u5c1d\u8bd5\u7528\u00a0getNumericCellValue()\u00a0\u8f6c\u6210\u6574\u6570，\u518d\u8f6c\u5b57\u7b26\u4e32<\/p>\n<\/li>\n<\/li>\n<\/li>\n
\u5982\u679c\u6240\u6709\u6570\u636e\u90fd\u6210\u529f\u5bfc\u5165，\u8fd4\u56de：<\/p>\n
{
\n "status": "success",
\n "data": "\u6570\u636e\u5bfc\u5165\u5b8c\u6210！"
\n}<\/p>\n
\u5982\u679c\u4e2d\u9014\u53d1\u73b0\u9519\u8bef（\u6bd4\u5982\u5c0f\u533a\u4e0d\u5b58\u5728），\u63d0\u524d\u8fd4\u56de\u00a0"status": "fail"\u00a0\u548c\u9519\u8bef\u4fe1\u606f<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb103\u6b21\uff0c\u70b9\u8d5e3\u6b21\uff0c\u6536\u85cf7\u6b21\u3002\u524d\u7aef\u8bbf\u95eehttp:\/\/localhost:8080\/community\/upload\/face\/123.jpg\u65f6\uff0cSpringboot\u4f1a\u6620\u5c04\u5230file:D:\/community\/upload\/face\/123.jpg\uff0c\u534f\u8bae\u7684\u5207\u6362\u548clocalhost:8080\u7684\u53d8\u52a8\u662f\u5982\u4f55\u5b9e\u73b0\u7684\u3002\u8fd9\u610f\u5473\u7740\u6d4f\u89c8\u5668\u8bbf\u95eehttp:\/\/localhost:8080\/community\/upload\/face\/xxx.jpg \u65f6\uff0cSpring \u4f1a\u4ece D:\/community\/upload\/face\/xxx.jpg \u8bfb\u6587\u4ef6\u5e76\u8fd4\u56de\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,98,292],"topic":[],"class_list":["post-51357","post","type-post","status-publish","format-standard","hentry","category-server","tag-java","tag-spring-boot","tag-292"],"yoast_head":"\n