Jquery+SpringMVC实现上传Excel文件，并批量导入

1.前端代码

function alertUploadFile(){

    //创建表单
    var formData = new FormData();
    var file = $("#upload").val();
    console.log(file);

    var arr=file.split('\\');//注split可以用字符或字符串分割
    var fileName=arr[arr.length-1];//这就是要取得的图片名称

	//var name = $("input").val();
	formData.append("file",$("#upload")[0].files[0]);
	//formData.append("name",name);

	if ($('#upload').val() == "") {
            alert("请选择所要上传的文件");
                				
        }else{
            var index = file.lastIndexOf(".");
            if(index < 0 ){
            	alert("上传的文件格式不正确，请选择Excel文件(*.xls)！");
            						
            }else{
            	var ext = file.substring(index + 1, file.length);
            	if(ext == "xls" || ext == "xlsx"){
                    //$.blockUI({ message: '<image src='image/loading.gif'></image><br><h3>正在加载中</h3>' });
            		startUploadFile(formData,fileName);
            	}else{
                    console.log("100");
            		alert("上传的文件格式不正确，请选择Excel文件(*.xls)！");
            							
            	}
            }


        }
}

function startUploadFile(formData,fileName){
     		$.blockUI.defaults.message = "<image src='image/loading.gif'></image><br><h3>正在加载中</h3>";//设置遮罩层样式
    //$(document).ajaxStart($.blockUI).ajaxStop($.unblockUI);
     $.blockUI();//开始遮罩

                            //开始上传
                            $.ajax({ 

                                    url : tokenUrl+"fileUpload2", 
                                    type : 'POST', 
                                    data : formData, 
                                    // 告诉jQuery不要去处理发送的数据
                                    processData : false, 
                                    // 告诉jQuery不要去设置Content-Type请求头
                                    contentType : false,
                                    beforeSend:function(request){
     
                                    request.setRequestHeader("token", token);
                                            console.log("正在进行，请稍候");

                                        }
                                    }).done(function(result) {
                                        $.unblockUI() ;//解除遮罩
                                        var reusltData = JSON.parse(result);
                                        console.log(reusltData);    
                                        //var staffList = ; 
                                        console.log(reusltData.msg);
                                        localStorage.setItem("fileName",fileName);
                                        localStorage.setItem("reusltData", JSON.stringify(reusltData));
                                        clearFileInput();
                                        //调用utils.js下的方法，打开新窗口
                                        //
                                        openNewWinByJs("uploadExcelResult.html?tag=1&fileName="+fileName+"");
                                       
                                        //openNewWin("uploadExcelResult.html?tag=1&fileName="+fileName+""); 
                                        //console.log(json);
                                        //alert("上传成功");
                                        /*layer.close(index); 
*/
                                
                                
                                    }, 'json').fail(function() {
                                        //网络错误
                                        $.unblockUI() 
                                        console.log("网络错误");
                                         localStorage.setItem("fileName",fileName);
                                        clearFileInput();

                                        openNewWinByJs("uploadExcelResult.html?tag=0&fileName="+fileName+"");
                                        
 
                                        //openNewWin("uploadExcelResult.html?tag=0&fileName="+fileName+""); 

                                      

                                        });

}

2.后端代码

@RequestMapping("fileUpload2")
    public void  fileUpload2(@RequestParam("file") CommonsMultipartFile file) throws IOException {
         long  startTime=System.currentTimeMillis();
        System.out.println("fileName："+file.getOriginalFilename());
        String path = "";
        SystemParameter systemParameter = new SystemParameterDao().load("企业端excel上传路径");
        if(systemParameter == null){
        	//path="C:\\Users\\fcr\\Desktop\\testupload";
        	path = "G:\\upload";
        	System.out.println("你好啊");
        }else{
        	path = systemParameter.getValue(); 
        	System.out.println("-------");
        }
 
        
        String filePath=path+"/"+new Date().getTime()+file.getOriginalFilename();
         
        File newFile=new File(filePath);
        System.out.println("准备了");
        //通过CommonsMultipartFile的方法直接写文件（注意这个时候）
        file.transferTo(newFile);
        System.out.println("要开始了");
        long  endTime=System.currentTimeMillis();
        System.out.println("方法二的运行时间："+String.valueOf(endTime-startTime)+"ms");
        Map<String, Object> resultMap = customerEmployeeService.batchImportStaff(getCustomer(),filePath);
		returnSuccessJson(resultMap, false);
       
    }