HTML
<div class="buttons">
<div class="layui-upload">
<a class="btn btn-primary fa fa-search search-link" href="javascript:void(0);" ><span>搜索</span></a>
<a type="button" class=" btn btn-primary fa " id="upExcel"><i class="layui-icon"></i>上传文件</a>
</div>
</div>
JS
/**
* 上传excel
*/
upExcel:function () {
var me=this;
layui.use('upload', function () {
var upload = layui.upload;
upload.render({
elem: '#upExcel'
,url: __ctx+'/platform/data/uemiReport/upExcel'
,accept: 'file' //普通文件
,exts: 'xls|xlsx' //允许上传的文件后缀
,done: function(res){
//如果上传成功
if (res.result==1) {
//追加图片成功追加文件名至图片容器
DialogUtil.alert(res.message);
}else {
//提示信息
DialogUtil.alert(res.message);
}
}
});
});
},
controller
@RequestMapping("upExcel")
public ResultMessage upExcel(MultipartHttpServletRequest request, HttpServletResponse response) throws Exception {
ResultMessage message=null;
MultipartFile file = request.getFile("file");
String fileName = file.getOriginalFilename();
String filePath = "D:/excel";
File dest = new File(filePath + fileName);
file.transferTo(dest);
Long userId = ContextUtil.getLoginUserId();
message = cemsDataService.importData(dest,userId);
dest.delete();
return message;
}
service