使用ajaxfileupload.js插件批量导入文件

你的名字 2021-04-27 15:16 475阅读 0赞

1.下载ajaxfileupload.js文件，并且修改其中的方法：

createUploadForm: function(id, fileElementId)
        {
            //create form
            var formId = 'jUploadForm' + id;
            var fileId = 'jUploadFile' + id;
            var form = $('<form  action="" method="POST" name="' + formId + '" id="' + formId + '" enctype="multipart/form-data"></form>');
    //        var oldElement = $('#' + fileElementId);
    //        var newElement = $(oldElement).clone();
    //        $(oldElement).attr('id', fileId);
    //        $(oldElement).before(newElement);
    //        $(oldElement).appendTo(form);
            //改版
            if(typeof(fileElementId) == 'string'){
                fileElementId = "["+fileElementId+"]";
            }
            var file_array = fileElementId.toString().split(",");
            $.each(file_array,function(i){
                var oldElement = jQuery('#' + file_array[i]);
                jQuery(oldElement).appendTo(form);
            });
            //set attributes
            $(form).css('position', 'absolute');
            $(form).css('top', '-1200px');
            $(form).css('left', '-1200px');
            $(form).appendTo('body');
            return form;
        },

2.前台添加

3.发送请求

$.ajaxFileUpload({
    	url : '../importExcelFile',
    	type:'post',
    	secureuri: false,
    	data:{
    		//region:regiontype.replace("CompareCom","Com60").replace("CompareBeta","Beta60") || '',
    		region:regiontype,
    		uid:sessionStorage.getItem("session_uid"),
    		worker:"createAndDelBatchServiceImpl",
    		param:JSON.stringify(param).replaceAll("\"", "|").replaceAll(/	/g,"")
    	},
    	fileElementId: fileId,
    	dataType: 'JSON',
    	success: function(data, status){
    		if(data.includes("fail")){
    			alert("批量插入条数请少于一百条");
    		}
    		if(data){
    			var res = data.slice(data.indexOf('>')+1,data.lastIndexOf('<'));
    			var resjr = JSON.parse(res);
    			batchId = resjr.data;
    		}
    	},
    	complete: function(){
    	}
    });

4.后台配置并且接受相关请求

@WebServlet("/importExcelFile")
    public class ImportExcelServlet extends HttpServlet {

protected void doPost(HttpServletRequest request,
    			HttpServletResponse response) throws ServletException, IOException {
    		// 获取前端上传到服务器临时文件中的excel文件内容并解析
    		List<Map<String, String>> sn1 = new ArrayList<Map<String, String>>();
    		List<Map<String, String>> sn2 = new ArrayList<Map<String, String>>();
    		List<Map<String, String>> excelContent = getExcelContent(request, sn1,
    				sn2);
    		// 获取前端参数
    		String uid = USER_ID;
    		String region = REGION;
    		String param = PARAM;
    		String str = "";
    		JSONObject result = new JSONObject();
    		PrintWriter out = response.getWriter();
    		// 批量上传超过100条友情提示 -fazhi 2018/5/31
    		// 向大数据接口发送数据
    		str = sendExcelToBigData(uid, region, excelContent, param, sn1, sn2);
    		result.put("data", str);
    		result.put("result", str);
    		// out.print(result);
    		out.write(result.toString());
    		out.flush();
    		out.close();
    
    	}

5.处理前台传送过来的文件

private List<Map<String, String>> getExcelContent(
    			HttpServletRequest request, List<Map<String, String>> sn1,
    			List<Map<String, String>> sn2) throws IOException {
    		List<Map<String, String>> excelContent = new ArrayList<Map<String, String>>();
    		// 创建工厂
    		DiskFileItemFactory factoy = new DiskFileItemFactory();
    
    		// 创建解析器
    		ServletFileUpload sfu = new ServletFileUpload(factoy);
    		// 解析request
    		try {
    			List<FileItem> list = sfu.parseRequest(request);
    			Integer count = 1;
    			for (FileItem fileItem : list) {
    
    				String fileType = fileItem.getFieldName();
    				String fileName = fileItem.getName();
    				// 文件遍历完成则获取前台参数
    				if (StringUtils.isNotEmpty(fileName)) {
    					InputStream is = fileItem.getInputStream();
    					// excel2003和2007解析内容不同
    					if (count == 1) {
    						if (fileName.toLowerCase().contains(".xlsx")) {
    							Workbook wbxslx = new XSSFWorkbook(is);
    							setSNExcelContent(wbxslx, sn1);
    						} else {
    							Workbook wbxsl = new HSSFWorkbook(is);
    							setSNExcelContent(wbxsl, sn1);
    						}
    					} else if (count == 2) {
    						if (fileName.toLowerCase().contains(".xlsx")) {
    							Workbook wbxslx = new XSSFWorkbook(is);
    							setSNExcelContent(wbxslx, sn2);
    						} else {
    							Workbook wbxsl = new HSSFWorkbook(is);
    							setSNExcelContent(wbxsl, sn2);
    						}
    					} 
    					count += 1;
    					// 资源的关闭 -fangzhi 2018/12/10
    					is.close();
    				} else {
    					if ("region".equals(fileType)) {
    						REGION = fileItem.getString();
    					} else if ("uid".equals(fileType)) {
    						USER_ID = fileItem.getString();
    					} else if ("param".equals(fileType)) {
    						PARAM = fileItem.getString();
    					}
    				}
    			}
    		} catch (FileUploadException e) {
    			LOG.error("error"+e);
    		}
    		return excelContent;
    	}

/**
    	 * 拼接
    	 */
    	private void setSNExcelContent(Workbook wb,
    			List<Map<String, String>> excelContent) {
    		// 不涉及多sheet因此直接引用第一sheet
    		Sheet sheet = wb.getSheetAt(0);
    		// 获取总行数
    		int rows = sheet.getPhysicalNumberOfRows();
    		for (int start = 1; start < rows; start++) {
    			// 获取信息每一行的信息
    			Row row = sheet.getRow(start);
    			if (row == null) {
    				continue;
    			}
    			int cellStart = row.getFirstCellNum();
    			int cellEnd = row.getLastCellNum();
    			// 将解析出的Excel信息存入
    			Map<String, String> map = new HashMap<String, String>();
    			for (int i = cellStart; i < cellEnd; i++) {
    				String cellValue = "";
    				Cell cell = row.getCell(i);
    				CellType type = cell.getCellTypeEnum();
    				// 判断是否为时间格式
    				if ("STRING".equals(type.name())) {
    					cellValue = cell.getStringCellValue();
    				} else if ("NUMERIC".equals(type.name())) {
    					Date d = cell.getDateCellValue();
    					DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
    					cellValue = formater.format(d);
    				}
    				// 设置值
    				if (i == 0) {
    					map.put("sn", cellValue);
    				}
    			}
    			excelContent.add(map);
    		}
    
    	}

这就是上传多个文件并且解析的方法，此插件还可以上传文件到服务器进行储存，我们以后再说。